Reward Point Mod beta now available

[Rasyr]

OKay -- I have a couple of problems

1) I have no item for Rewards Points listed under Admin|Configuration|Rewards Points (this last bit isn't there).

2) When I go to Customers|Reward Points and try to edit a customer, I am getting the following 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 'REWARD_POINTS_MAX_TRANSACTIONS' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM shop_reward_status_track WHERE customers_id=51 AND status=0 ORDER BY date DESC LIMIT REWARD_POINTS_MAX_TRANSACTIONS;]
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.

3) when I ran the New.sql code, it did not give the tables the prefix that I use for my store. I had to go in and rename the tables to add in the store prefix.

Note: this was the last beta update that you posted in the thread here

[pinetreecandles]

OKay -- I have a couple of problems

1) I have no item for Rewards Points listed under Admin|Configuration|Rewards Points (this last bit isn't there).

2) When I go to Customers|Reward Points and try to edit a customer, I am getting the following error:



3) when I ran the New.sql code, it did not give the tables the prefix that I use for my store. I had to go in and rename the tables to add in the store prefix.

Note: this was the last beta update that you posted in the thread here

If your not doing this on a live site, then you might find it easier to remove the tables and entries from the database for the mod. Then run the SQL file for a new install. If that is not an option, make sure all the tables are created and named properly, compare the sql file to what you have in your database under configuration Group and Configuration and make sure the fields are there. Then make sure all the files have been uploaded.

If your store uses an extention, like yours does, so does mine, then you have to add it.

[Rasyr]

okay, got it all working....

the sql file also does NOT deal with any store prefixes at all, so when I ran it, none of the configuration settings got ran

once I changed it to include the prefix, it installed and I can set options now

[hem]

okay, got it all working....

the sql file also does NOT deal with any store prefixes at all, so when I ran it, none of the configuration settings got ran

once I changed it to include the prefix, it installed and I can set options now

You need to run it under Tools->Install SQL Patch. That way ZenCart will handle the prefixes correctly.