Quote Originally Posted by moksha View Post
I made such an idiotic mistake... I first made the "uninstall" sql patch run (don't ask me why)!! After doing this I ran the "upgrade" sql patch and uploaded all the files included in the upgrade folder... but when refreshing my site's page half of the site was obviously gone! So I restored my backup file and everything went back into place... except for the category links... when clicking on them from the links box now I get this message:

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select count(l.links_id) as total from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '2'order by ]"

Running the uninstall sql patch first must have deleted something necessary for the upgrading process... I think. How can I fix this?

HELP!!

http://www.thequintessence.biz/index...ain_page=links

(MySQL server version: 5.0.51a; Zen Cart version: 1.3.8... don't know if this can help...)
Uninstall does exactly what it says - it will uninstall everything.

Since you restored a backup

Open the upgrade folder and run the update_links_manager.sql