Quote Originally Posted by hem View Post
See the earlier post in this thread regarding the bug with the update.sql file. If this is the first time you've installed the mod then run new.sql not update.sql

Instructions to bypass this bug:

  1. Go to folder \admin\includes\functions\extra_functions\
  2. Rename reward_points_functions.php to reward_points_functions.xxx
  3. You can now access the Admin CP
  4. Go to Tools->Install SQL PAtch
  5. Enter the following SQL: RENAME TABLE reward_points_history TO reward_status_track
  6. Then rename reward_points_functions.xxx back to reward_points_functions.php


Note: This will not work if you use prefixes on your database. In this case either run new.sql or rename the table using phpmysql
I did what you said and I get 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 'SQL: RENAME TABLE reward_points_history TO reward_status_track' at line 1
in:
[SQL: RENAME TABLE reward_points_history TO reward_status_track ;]
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.

I am new to zencart so i could have done anything wrong