Big muck up need help

[kiwigurl]

I should've browsed this forum before installing the new version pro 2.0. Instead, I uploaded practically the whole thing without thinking I might lose things.....anyway I did a check at phpmyadmin & I haven't lost any content from my directory but I am having problems viewing my directory normally. I am getting the same error as this persons topic.....

http://www.esyndicat.com/forum/about7650.html

Error: Unknown column 't1.comments_total' in 'field list'
SELECT t1.*, `t1`.`comments_total` `comments`, t41.`id` id_category, t41.`title` category_title FROM `dir_links` t1 LEFT JOIN `dir_link_categories` t4 ON t4.`id_link` = t1.`id` AND t4.`crossed` = '0' LEFT JOIN `dir_categories` t41 ON t4.`id_category` = t41.`id` WHERE t1.`status` = 'approval' GROUP BY t1.`id` ORDER BY `date` DESC LIMIT 0, 10

or you can view the error here: http://www.letsgetwealthyonline.com/index.php. Don't go directly to letsgetwealthyonline.com because I have put a maintenance page up so ppl dont see the mess I made :wallbash:

After the 2.0 install I can log into my admin but it's showing a couple of errors

Error: Unknown column 'sponsored' in 'where clause'
SELECT COUNT(`id`) FROM `dir_links` WHERE `sponsored` = '1'

What to do?????

[redeye]

I know this might not be the time to ask, ...... but have you got a backup?

[Dave Baker]

Hello kiwigurl,
Please read this article
http://www.esyndicat.com/forum/about7611.html
It seems you have a similar problem:
http://www.esyndicat.com/forum/showthread.php?t=7642&highlight=t1.comments_active

[kiwigurl]

Nah too late for backup redeye....(I usually always do backups.....I guess I was over tired when I did this and wasn't thinking haha)

Dave....I'm too late for the first article and I can't view the other link for some reason....

[Dave Baker]

kiwigurl try to contact with Sergey Ten maybe he can help your link.

[Paul69]

any one like to share catagory dump for 2.0

i am using my directory as link exchange directory but the common dump on this site is not working for me any help

[kiwigurl]

Thanks....I submitted a support ticket hopefully will get my directory back to normal (wishes she kept left her directory alone LOL)