Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error PaYpal 1064 - You have an error in your SQL syntax


modelmas

Recommended Posts

Error:

 

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 'and gzg.geo_zone_id=gz.geo_zone_id' at line 1

 

select gz.geo_zone_name from geo_zones gz, zones_to_geo_zones gzg where gzg.zone_country_id= and gzg.geo_zone_id=gz.geo_zone_id

Link to comment
Share on other sites

Don't know why the test

 

gzg.zone_country_id= and

 

is not actually testing against a value but would think that is what is causing the error, would expect it to be something like

 

gzg.zone_country_id= 143 and

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 ======>>>>>.

Link to comment
Share on other sites

gzg.zone_country_id= and

 

 

a blank for country_id.generally this will happen when a variable a used that is not recognised or set.

 

This is found most of the times with register globals switched off where as the code assume register globals is on.

 

Paste the sql query code as in the php file.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...