lewisqic Posted December 8, 2006 Share Posted December 8, 2006 Hi all, I just installed the Links Manager For OSC v0.20 on my store and everything went fine during the installation. Everything looks great on my store now on the catalog side of things, the links link shows up and i can access it and even submit links. The problem i'm having is on the admin side of links manager. When i go the the links manager link on the admin side, it brings up this error 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 '-20, 20' at line 1 select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from links l left join links_description ld on l.links_id = ld.links_id order by ld.links_title limit -20, 20 [TEP STOP]" I'm not sure what this means, but it appears to be the onlyl problem i'm having, any help with this would be greatly appreciated. Quote lewisqic Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 9, 2006 Share Posted December 9, 2006 It's not a links manager problem. Download the latest oscommerce update (above menu->solutions->downloads) and install the part that deal with split page results (or all of it would be better). Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
lewisqic Posted December 9, 2006 Author Share Posted December 9, 2006 Okay, i downloaded the package and unzipped it but i'm not too sure which part i should install. I don't suppose that it is anything in the catalog or admin folder. do i run an sql query with the info contained in the update text document? Quote lewisqic Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 9, 2006 Share Posted December 9, 2006 Did you look up the part about split page results like I mentioned? Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
lewisqic Posted December 11, 2006 Author Share Posted December 11, 2006 Well, i tried, but i don't really know where to look for it or what it would be if i found it. any other direction? thanks. Quote lewisqic Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 11, 2006 Share Posted December 11, 2006 Download the file, unzip it, open the install file, search for split page results (or split_page_results). Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
lewisqic Posted December 11, 2006 Author Share Posted December 11, 2006 alright, i just uploaded the split_page_results.php file to my admin side and it seems to have fixed the problem, thank you! Quote lewisqic Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.