PDA

View Full Version : error message on home page


kredit
01-16-2007, 03:39 PM
I just changed servers, exported my SQL< reinstalled the script and now I get this error on my home page and in admin panel:

Error: Unknown column 't1.comments_active' in 'field list'
SELECT `t1`.*, `t1`.`comments_active` `comments`, `t2`.`crossed`, `t3`.`path`, '0' `id_editor_edit` FROM `dir_link_categories` `t2` LEFT JOIN `dir_links` `t1` ON `t1`.`id` = `t2`.`id_link` LEFT JOIN `dir_categories` `t3` ON `t2`.`id_category` = `t3`.`id` LEFT JOIN `dir_editors` `t4` ON `t1`.`id_editor` = `t4`.`id` WHERE `t2`.`id_category` = '0' AND `t1`.`status` = 'active' GROUP BY `t1`.`id` ORDER BY `t1`.`featured` DESC, `t1`.`sponsored` DESC, `t1`.`rank` ASC LIMIT 0, 10

Anyone know how to fix this?

Dave Baker
01-16-2007, 06:38 PM
Hello kredit,
Please, check it:
http://www.esyndicat.com/forum/showthread.php?t=7495&highlight=comments_active

kredit
01-16-2007, 08:02 PM
It says I am not allowed in that thread.

Dave Baker
01-16-2007, 08:09 PM
Here information how to get access to Pro forum area: http://www.esyndicat.com/forum/about6327.html