dynn
01-20-2007, 03:57 PM
I got this problem after install new esyndicat :
In the admin panel
Error: Unknown column 'sponsored' in 'where clause'
SELECT COUNT(`id`) FROM `dir_links` WHERE `sponsored` = '1'
and this error in the main page.
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`.`date` DESC LIMIT 0, 10
pls help.
In the admin panel
Error: Unknown column 'sponsored' in 'where clause'
SELECT COUNT(`id`) FROM `dir_links` WHERE `sponsored` = '1'
and this error in the main page.
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`.`date` DESC LIMIT 0, 10
pls help.