caparuni Posted April 10, 2009 Share Posted April 10, 2009 im using import to add product to db, about 400 product, all fine, but theres 2 product always error. i dunno why this line always error, it seems that only cant import to ps_product_lang, but other table will be fine. can someone show me why i cant import this 2 line/product.btw im make and convert to csv this with excel error_product.csv Link to comment Share on other sites More sharing options...
Hoodgrown Posted April 10, 2009 Share Posted April 10, 2009 I didn't check your file.. but at least for me I get errors with products that have..."#", "(" or "0" symbols in them. Link to comment Share on other sites More sharing options...
caparuni Posted April 10, 2009 Author Share Posted April 10, 2009 Hoodgrown in what field? name? desc? Link to comment Share on other sites More sharing options...
caparuni Posted April 11, 2009 Author Share Posted April 11, 2009 anyone??? Link to comment Share on other sites More sharing options...
Dr. Benway Posted April 14, 2009 Share Posted April 14, 2009 your csv contains a word ("Cascade") of the blacklist, import of these words is denied. Link to comment Share on other sites More sharing options...
caparuni Posted April 16, 2009 Author Share Posted April 16, 2009 hmmmm... icic.... ty for your info. l im searching the script and fount it on .../classes/Db.php private static $_blacklist = 'UNION|LOAD_FILE|OUTFILE|DUMPFILE|ESCAPED|TERMINATED|CASCADE|INFILE|X509|TRIGGER|REVOKE'; btw can someone explain to me what the purpose of this blacklist words... Link to comment Share on other sites More sharing options...
Recommended Posts