Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

[loaner]

So right now I have them marked like this
Capture.PNG
and it isn't working. Should I have them marked in the other column? I think I've tried both and it didn't work for either one.

[loaner]

bumping this to see if I can get some help. It is still not working for me? See post above.

[countrycharm]

So right now I have them marked like this
Capture.PNG
and it isn't working. Should I have them marked in the other column? I think I've tried both and it didn't work for either one.

On a stock zen cart 1.5.4 with reward points installed. This is how I have the reward points configuration setup.

reward_config.jpg


The points transfer just fine from pending to earned when changing order status from processing or Delivered. Go back check your installation all I can tell you.

[loaner]

K, I changed to match yours. I'll see if that works. If not, I'll try installing it again myself and see if maybe he missed a file. Do you have any idea which file controls that so I can maybe just check that one?

[loaner]

Still not transferring for me. I downloaded the module again and checked all of the files that were installed back in February and it appears they are all there where they are supposed to be. I did notice this though. Do you think the one that is highlighted in blue may be causing a conflict? Can I delete it?
Capture.PNG

[izar74]

Hi again,

I've got this error:

[25-May-2015 15:22:01] PHP Fatal 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 '2') 
				OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id A' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
				FROM reward_master prp, products p, products_to_categories p2c
				WHERE p.products_id='101'"'
				AND p2c.products_id='101'"'
				AND ((prp.scope_id=p.products_id AND prp.scope='2') 
				OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
				OR (prp.scope='0'))
				ORDER BY prp.scope DESC LIMIT 1; ==> (as called by) /var/www/vhosts/.../httpdocs/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /var/www/vhosts/.../httpdocs/includes/classes/db/mysql/query_factory.php on line 155

Check the file but it seem all fine... the line 51 to 62 of reward_points_functions.php look like this:

if(zen_get_products_price_is_free($products_id)==false || REWARD_POINTS_ALLOW_ON_FREE=='1') // Allow RP on free items (Admin settable)
    {
        $sql = "SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
                FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c 
                WHERE p.products_id='" . $products_id . "'
                AND p2c.products_id='" . $products_id . "'
                AND ((prp.scope_id=p.products_id AND prp.scope='".SCOPE_PRODUCT."') 
                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='".SCOPE_CATEGORY."')
                OR (prp.scope='".SCOPE_GLOBAL."'))
                ORDER BY prp.scope DESC LIMIT 1;";

        $result=$db->Execute($sql); 

The specific of the server are:
Database: MySQL 5.1.73
Versione PHP: 5.3.3 (Zend: 2.3.0) PHP Memory Limit: 128M

I'm a little bit unsure of what that error could be... any guess would be helpful

[bigfoot6155]

I'm not sure if I'm blind but I cant find the installation directions for this mod. I love the mod and cant wait to install it.

[loaner]

I have reinstalled and made sure my screen matches yours on advanced and it is still not working. I'm still having to transfer points manually.

[nigelt74]

OK,

Tell me where i am going wrong here

Clean install of zen 1.5.4 with database imported from 1.39h which had reward points installed on it

Should i use the upgrade or the full version for this.

Because i looked in the upgrade version and there are only about 7 files, whereas in the new install version there are loads of files, Now as my zencart files are all new, there will be no reward point files already there, BUT as my database is imported from 1.39h it will still have the reward points data in it, which i don't want to lose.

So should i upload all files from "New install" versions and then run the "Upgrade SQL" or am i missing something, as i have read the instructions but they seem to be for either a completely new install or for an in place upgrade of an installed reward points module where the cart hasn't been upgraded since said module was installed

[countrycharm]

OK,

Tell me where i am going wrong here

Clean install of zen 1.5.4 with database imported from 1.39h which had reward points installed on it

Should i use the upgrade or the full version for this.

Because i looked in the upgrade version and there are only about 7 files, whereas in the new install version there are loads of files, Now as my zencart files are all new, there will be no reward point files already there, BUT as my database is imported from 1.39h it will still have the reward points data in it, which i don't want to lose.

So should i upload all files from "New install" versions and then run the "Upgrade SQL" or am i missing something, as i have read the instructions but they seem to be for either a completely new install or for an in place upgrade of an installed reward points module where the cart hasn't been upgraded since said module was installed

Since you are not upgrading but doing a fresh install of all files and keeping your old database, use the New_Installation and use the Upgrade-to-2.5a.sql statement. That should be all you need to do.