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: