Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

New site uploaded! BUT BIG PROBLEM WITH IT! Please help


consolengames

Recommended Posts

Posted

I uploaded my site but I am getting an error:

On tax zones, it says:

"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 geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name limit -20, 20

 

[TEP STOP]"

I also get this error in tax classes, this happened when I deleted the defult info on them and attempted to add my own. This also happened when I deleted the defult customers but then got okay when I created an account.

What can I do to stop this?

Thanks

Posted

i suggest putting your error into google. You will find the answer there usually more quickly that asking here.

A great place for newbies to start

Road Map to oscommerce File Structure

DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways!

 

HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you

 

Proud Memeber of the CODE BREAKERS CLUB!!

Posted

I believe there is a patch for this problem that can be found by following the link in my signature block.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...