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

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

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

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