Re:批量上传产品出错UPDATE PRODUCT FAILED! - Model: MG200MMS - SQL er ..
This can be fixed in one of two ways, but you may have to get your hosting company to do this for you.
Method 1: Open the "my.ini" file within the MySQL installation directory and look for something like...
# Set the SQL mode to strictsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# Set the SQL mode to strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
You may be able to run an SQL query within your database management tool such as phpMyAdmin which can normally be found from your web hosting control panel:
SET @@global.sql_mode= '';