Hey, Support staff where I got my directory script are not online at the mo and I really want to get these errors fixed.. I made a bit of a mistake and decided to upgrade my directory from one version to another, but instead of using the mod upgrade download I uploaded the whole new version that was released (oops!!!) Thankfully all my previous directory content is still there but I am getting the following errors. At http://letsgetwealthyonline.com/index.php (don't go directly to letsgetwealthyonline.com because I uploaded an index.html page while I try figure this mess out lol) 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`.`clicks` ASC LIMIT 0, 5 Code (markup): At my admin panel I am seeing the above code and: Error: Unknown column 'sponsored' in 'where clause' SELECT COUNT(`id`) FROM `dir_links` WHERE `sponsored` = '1' Code (markup): Anyone know what the prob is?
It looks like you have to do some changes to the database. You uploaded the new version but you're using the old database structure. You just need to upgrade your directory database.
Yeah, it seems you need to upgrade the database. I found the similar thread with Google: http://www.esyndicat.com/forum/showthread.php?p=50748 , may be it will be useful.
Hi, Thanks for your replies. I have sent an email to a technical support member so hopefully my directory will be up again soon. Thanks for letting me know that it's only the database structure that needs fixing.
Hi, I think it's the correct decision to post a ticket in our helpdesk. I think support stuff will fix this problem asap.