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?
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?