Reward Points Module for ZC v13x

Quote:

---

Originally Posted by retched

An easy way to answer this would be to check configure.php file for your ZenCart installation.

Open includes/configure.php in a text editor and look for define('DB_PREFIX', 'zen_');

Anything with the value listed in the second set of quotes, in my example 'zen_' is the database for ZenCart.

As for which database, look for define('DB_DATABASE', 'betadata');. That will list your zencart database. In my example, that is 'betadata'.

---

I found the file, sorry, looking in the wrong place. I found this text:

Quote:

---

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'UNHere_zc01');
define('DB_SERVER_PASSWORD', 'Password here');
define('DB_DATABASE', 'UNHere_zc01');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');

---

The text in red was changed as to not give out sensitive information. But there is nothing next to DB_PREFIX but there is the zc01 that I saw once I was in the CPanel under databases. So I am assuming that is it. Thanks again. I will give this a try in the morning.

Quote:

---

Originally Posted by retched

While installing, did you make sure to make all of the changes in each folder?

---

If you mean change the folder names to my template then yes as can be seen here

http://nigel.geek.nz/sbo_shop/rpd.php

and as for the bits that show up in red, those bits all exist in the database, i checked

Quote:

---

Originally Posted by lauriesscraps

I found the file, sorry, looking in the wrong place. I found this text:


The text in red was changed as to not give out sensitive information. But there is nothing next to DB_PREFIX but there is the zc01 that I saw once I was in the CPanel under databases. So I am assuming that is it. Thanks again. I will give this a try in the morning.

---

What you were typing made me believe that you were referring to a prefix, this is a suffix you're talking about now.

Essentially use the name of the database that is given by the configure.php file. That is the database where zencart is installed.

Quote:

---

Originally Posted by nigelt74

Still can't get it to work

I turned on my error log and I have this error

[09-Aug-2010 14:38:22] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

This seems to happen when i place the order

---

Quote:

---

Originally Posted by nigelt74

If you mean change the folder names to my template then yes as can be seen here

http://nigel.geek.nz/sbo_shop/rpd.php

and as for the bits that show up in red, those bits all exist in the database, i checked

---

Ok. So you get those error messages you posted in your last message and then this one about SESSION[] not being stored...

Are you absolutely sure that you edited the files in the right manner?

In addition, when you created the tables and the modifications to the table, did you make sure that the datatypes of the table match those that rewards points are looking for?

Quote:

---

Originally Posted by retched

Ok. So you get those error messages you posted in your last message and then this one about SESSION[] not being stored...

Are you absolutely sure that you edited the files in the right manner?

In addition, when you created the tables and the modifications to the table, did you make sure that the datatypes of the table match those that rewards points are looking for?

---

according to the readme i have, there are no files to be edited.
There are 3 folders to be renamed which i have done
There is an sql script to be actioned, in my case it was new.sql
all of which i have done,

The sql script created the tables, so the datatypes should be correct, just no information is being put in them and the rpd file is showing those fields as being missing.

the datatypes appear correct to me looking at them through phpmyadmin

and yes my database uses a prefix zen_, but as you can see the rpd picks that up

-------------edit----------------------------

I'll state this now

It is working to a point, when i add products to my cart reward points are displayed in the left hand column, however when i check out, the reward points vanish they are not listed as pending nor are they applied, they are goneburger

Quote:

---

Originally Posted by nigelt74

I'll state this now

It is working to a point, when i add products to my cart reward points are displayed in the left hand column, however when i check out, the reward points vanish they are not listed as pending nor are they applied, they are goneburger

---

Is the order total modules installed and set to "True" in admin?

Quote:

---

Originally Posted by retched

Is the order total modules installed and set to "True" in admin?

---

you beat me to it

I just ticked the "reward points earned" and that fixed it, not sure how I missed that


I am still getting this in red though

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

and I know it is set to zero(against subtotal) in admin

Quote:

---

Originally Posted by nigelt74

you beat me to it

I just ticked the "reward points earned" and that fixed it, not sure how I missed that


I am still getting this in red though

Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

and I know it is set to zero(against subtotal) in admin

---

0 is generally interpreted as FALSE in php or "not there" in PHP. Try setting it to 1 and rerun it.

Quote:

---

Originally Posted by retched

0 is generally interpreted as FALSE in php or "not there" in PHP. Try setting it to 1 and rerun it.

---

makes no difference

Quote:

---

Originally Posted by nigelt74

makes no difference

---

Try to run your checkout again. If it works, this might one of those false positives.

If it doesn't, then you may want to check on the SQL you used to install.