• You are here:
  • Home Â»
  • No category Â»
  • Joomla JDatabaseMySQLi::query: 1054 – Unknown column ‘alias’ in ‘where clause’ SQL=SELECT id FROM j17_assets WHERE alias = ‘root’

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:

UPDATE `xxx_assets` SET `parent_id` =  '1' WHERE `parent_id` =  '0' AND `id` != 1;

Of course xxx is your tables prefix.

Error reason? Something with ACL… but if solution works… no time to more digging….

Leave a Comment:

Popular posts

Doctrine2 Netbeans IDE problems with code completion
 No category
Jan 28, 2013
How to block brute force attack automatically in DirectAdmin?
 No category
Sep 25, 2012
SSD freezing Windows 7 problem and fix
 No category
Apr 14, 2014
Symfony2, Doctrine2 Fatal error: Call to a member function getMetadataFactory() on a non-object in
 No category
May 13, 2012