Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error in your SQL syntax


pantufas_online

Recommended Posts

hello!

 

i've installed an add on to import excel, and it gives me this error when i try to import it, before i corrected many other php mistakes...

 

File uploaded (temp filename: C:\Program Files\EasyPHP-5.3.6.0\tmp\php45AD.tmp)
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 '0')' at line 1

insert into manufacturers(manufacturers_name,manufacturers_image,date_added) values('???ÿ}-}6ÿÿ_¬ _-}x}1ÿÿÌÿ_¬ _-²²²ÿ¥¥¥ÿ#0²²²ÿ???ÿ-;','²²²ÿ???ÿ?\','0')

[TEP STOP]

 

if anyone knows something, please tell me. i dont understand anything of sql... :(

 

thanks

Link to comment
Share on other sites

What text program did you use to update the php files?

 

Looks like you may have used something like Word which will produce non-standard characters.

 

Use a plain text editor.

My store is currently running Phoenix 1.0.3.0

I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 )

I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary

Link to comment
Share on other sites

The immediate problem is here:

,'²²²ÿ???ÿ?\','0')

See the \ ? That's escaping the ' right after it, so the second string is ²²²ÿ???ÿ?',. Then PHP encounters 0' and doesn't know what to do with it. The 64-dollar question is "Why is there a \ in there?" Was there supposed to be another character following it that was being escaped, before the closing quote?

 

Whatever did you use to create this data? Is it a cut and paste from something on your PC? It looks like there may also be a character encoding issue, at least a non-UTF-8 system on your end and a UTF-8 forum here.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...