Enzo_UK Posted July 12, 2005 Share Posted July 12, 2005 I deleted out all the countries from in Admin, so I could enter my own custom list, and now 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 '-20, 20' at line 1 select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from countries order by countries_name limit -20, 20 I am sure it never did this when I set up my other site, so dont know why it did it now! I have got phpMyAdmin but arent all that sure about what needs fixing. I desperately need some kind of assistance. Cheers in advance. Andrew Link to comment Share on other sites More sharing options...
♥14steve14 Posted July 12, 2005 Share Posted July 12, 2005 Have you tries restoring a back up of your data base. Thats always a good place to start. REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
♥Vger Posted July 12, 2005 Share Posted July 12, 2005 It's a good idea never to 'delete out' all of anything, be it countries, languages, or currencies - because you'll end up with a negative value and those errors. If you want to change the countries put a few of the ones you want in there first, then delete the rest, and then you won't have that error. If you have the original oscommerce.sql file you don't need to restore the whole of the database, just take the countries list and run that in as an sql query. Vger Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.