Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sql 1064 insert and upload product


ammsimon

Recommended Posts

Hello

Small problem in the admin: sql error 1064 on the modifications and insertions of products or categories.
The movements are ok.
This post, because I checked and tested with original 2.3.4 osc tables, the original admin files file also ... same concern.
Version osc 2.3.4
Contribs: discount coupon, xsell products and headertag 2.2
Example of an error on an update product:

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 '=' 22 ', =' 50000295 ', = '68 .0000', = '49 .6300 ', = null, = null, =' 0.5 ',' at line 1

update products set = '22', = '50000295', = '68 .0000 ', = '49 .6300', = null, = null, = '0.5', = null, = '0', = null, = '2', = null, = '0', = null, = now () where products_id = '990'

I am under oscommerce for more than 10 years, but here I dry completely. My research is futile.

Thank you in advance if someone has a track.
 
 
 
 
 

Osc 2.3.4

mts template

Link to comment
Share on other sites

Rather than trying to upgrade something ancient like osC 2.3.4 to PHP 7, you should think about installing and transferring your data to osC 2.3.4.1BS Edge/CE/Frozen. It should be a lot less work and you'll be ahead with a mobile-friendly and PHP 7-ready site.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...