New install DirectAdmin on Debian 6.0 x64 OpenVZ, Spam Assassin, CSF and other – my notes

After another install DirectAdmin on VPS and loosing time to search in many place information how to do this or that I wrote this few notes to keep steps in one place. Maybe it will be useful for you. My system was Debian 6.0 x64, VPS on OpenVZ.Continue reading

How to clean dump Doctrine2 entity (entities) without print_r and crash Apache

Have you ever try print_r($entity)? Apache crash? Yes – exactly. Doctrine2 entity has massive recursion and trying dump by print_r give Apache crash. How to do this safely  and clean?Continue reading

Joomla JDatabaseMySQLi::query: 1054 – Unknown column ‘alias’ in ‘where clause’ SQL=SELECT id FROM j17_assets WHERE alias = ‘root’

Another day, another problem 🙂

Just install new component and after try change options I got:

JDatabaseMySQLi::query: 1054 - Unknown column 'alias' in 'where clause' SQL=SELECT id FROM j17_assets WHERE alias = 'root'

.

So I start digging… Solution is (as always) pretty simple just run in your Joomla database:Continue reading

Doctrine2 Netbeans IDE problems with code completion

Doctrine2/Symfony2 project? You write a code, press ctrl + space and… no all code completion… Why?

$em = $this->getDoctrine()->getManager();
$query = $em-> (should be createQuery, createBuilderQuery BUT nothing like that)

Solutions is simple (as usual…) but take some time to know how…Continue reading

How to block brute force attack automatically in DirectAdmin?

In modern version of DirectAdmin is Brute Force Monitor. Doing good job, make alert when brute force attack is carried out. But you must eventually manually block IP, from whose attack is coming.

Of course there are ways to make it automatic. I assume your server use CSF + LFD installed and working. In other cases particular script should looks different.Continue reading

Symfony 2.1 how to manage .less file by lessphp

After move to Symfony2.1 I was a little confused by using composer.phar. I want use less too – to easier write css code. After little research and test I see composer is a great tool! Some time after a figured out how to use lessphp. To save your time below it is my way:Continue reading

Symfony2, Doctrine2 Fatal error: Call to a member function getMetadataFactory() on a non-object in

This problem meets me after upload my Symfony2 app from my laptop to production server. Then, when I try run app I get:

Symfony2, Doctrine2 Fatal error: Call to a member function getMetadataFactory() on a non-object in…

After lot of searching I found solution. Continue reading

Debian install php_intl problem configure: error: Unable to detect ICU prefix

Problem with install php_intl on Debian?

Get: configure: error: Unable to detect ICU prefix or /usr/local/icu/bin/icu-config failed. Please verify ICU install prefix and make sure icu-config works.?

Easy solution – just:

apt-get install libicu-dev

Easy and visual explain SQL joins queries

Have you ever had a problem with coding JOIN queries in SQL? This is something which can help you. One picture = 1000 words 😉
Continue reading

PHP Warning: PHP Startup: apc: Unable to initialize module Module compiled with module API=20060613 PHP compiled with module API=20090626

Did you see that?

PHP Warning:  PHP Startup: apc: Unable to initialize module
Module compiled with module API=20060613
PHP    compiled with module API=20090626
These options need to match
in Unknown on line 0

It may happen with other pecl modules because those mostly was compiled for php 5.2.

My configuration DirectAdmin, Debian 5

Solution?Continue reading