hello
i.m having a trouble while importing data from csv file with easy populate
it always give me this 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 '5, manufacturers_id = 5, ' at line 11
UPDATE products SET products_price='0.51', products_image=NULL, products_price2='0.31',products_ordered='0',products_short_1='',products_short_2='',products_short_3='',products_short_4='',products_short_5='',products_date_featured='1899-12-31', products_weight='', products_tax_class_id='', products_date_available='0000-00-00 00:00:00', products_date_added='2014-06-26 00:00:00', products_last_modified='2008-09-26 12:29:32', products_quantity = 752,5, manufacturers_id = 5, products_status = 1 WHERE (products_id = 121) LIMIT 1
[TEP STOP]
and i dunno what does it means
my sets are:
Settings & Info
EP vers: 2.76g-MS2
osCommerce Online Merchant v2.2 RC2a
OS: Linux 2.6.24.2-grsec
HTTP: Apache
DB: MySQL 4.1.22-standard
PHP: 4.4.7 (Zend: 1.3.0)
Temp Directory:
/home/elpept/public_html/loja/temp/
Temp Dir is Writable
Magic Quotes is: off
register_globals is: on
Split files on: 300 records
Model Num Size: 50
Price with tax: false
Calc Precision: 2
Replace quotes: false
Field seperator: comma
Excel safe output: true
Preserve tab/cr/lf: false
Category depth: 2
Enable attributes: false
SEF Froogle URLS: false
More Pics: false
Unknown Pics: false
HTC: false
SPPC: false
Extra Fields: false
i checker line 11 at files easypopulate.php and functions and theres nothing on it that could be solved:/
i´m stuck at here
any help apreciated
tks in advance