购物车为空

MySQL charset converter (beta)


NOTE: DrByte recommends using a_berezin's script instead: http://www.zen-cart.com/downloads.php?do=file&id=1318




This PHP script can be used to convert your MySQL database tables from latin1-to-UTF8 while retaining the integrity of all internal multibyte characters.

Instructions:
0) BACKUP YOUR DATABASE!!!
a) unzip and upload the PHP file to your store's folder
b) edit the PHP file to set your database username, password, dbname, and prefix
c) use your browser to access the file
The conversion will show current progress as it proceeds, and statistics upon completion.
d) DELETE THE FILE FROM YOUR SERVER when finished.
e) Update your Zen Cart configure.php settings to use UTF8 for DB_CHARSET

CAUTION: If your database is NOT in UTF8 format but contains UTF8 characters, you may end up with unpredictable results. ALWAYS MAKE A DATABASE BACKUP FIRST!!!!


插件版本: 0.3

该商品加入分类的日期为 2015年 01月 03日

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'zencart.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from z138a_orders_products opa, z138a_orders_products opb, z138a_orders o, z138a_products p where opa.products_id = '13976' and opa.orders_id = opb.orders_id and opb.products_id != '13976' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]