Hi hem,
Thank you sooooo much!
BUT
I have done what you said again and again. But it still doesn't work.
( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )
I installed the 'new.sql' and got this:
17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.
I clicked "Layout Box Controller" and got :
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 'SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Bookmarks