MySQL Query error: SELECT l.*, lc.name AS categoryName FROM tc_Links l LEFT JOIN tc_LinkCategories lc ON lc.blogid = l.blogid AND lc.id = l.category WHERE l.blogid = 1 ORDER BY lc.name, l.name
Error no. 1054 : Unknown column 'l.category' in 'on clause'
Fixed within myphpadmin,
Open tc_Links ( or your TextCube prefix with Links table),
Add a new row below the 'id' called 'category', type, INT, length 11, default 0
OR there is SQL commend,
ALTER TABLE `rc1_Links` ADD `category` INT( 11 ) NOT NULL DEFAULT '0' AFTER `id`;
Please check your textcube database prefix, thanks.
IF You want to re-build TextCube or install new one,
Open setup.php find line about 1270,
there are,
CREATE TABLE {$_POST['dbPrefix']}Links (
pid int(11) NOT NULL default '0',
blogid int(11) NOT NULL default '0',
id int(11) NOT NULL default '0',
name varchar(255) NOT NULL default '',
...etc.
add new line between id and name,
id int(11) NOT NULL default '0',
category int(11) NOT NULL default '0',
name varchar(255) NOT NULL default '',
re-setup the TC.
Posted by hina
