Group Pricicing per Item Error -- Please help!

Hello,
I install the group pricing per item version 1.0 patch, but I am having an error.
I am currently running Zen Cart version 1.3.0.1

When I go and try to edit a product to set the Group A price, I get this error and the page does not display: :shocking:

1146 Table 'mxfimrk_testzen.group_pricing' doesn't exist
in:
[select group_name from group_pricing]
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.

after seeing this error, I decided to rename my table (using SQL) from testzen_group_pricing to group_pricing since this is what I thought was causing the error.

I got past this error, but when I tried to assign my customer to Group A, I got a error saying that it couldn't find table testzen_group_pricing which is the one that I just rename.

So obviously, is still needed.

So...:smartass: I decided that maybe I need to change the sql call. I look and found that the call is being called from this file:

MYZENSTORE/admin/includes/modules/product/collect_info.php

I tried editng the file to change:
$group_pricing = $db->Execute("select group_name from group_pricing");

to:
$group_pricing = $db->Execute("select group_name from testzen_group_pricing");

but it just doesn't let me...

any ideas, anybody? :shocking:

Thanks!

OK. I figure it out. :smartass:

Just posting the info incase anybody else run into the same problem.

In order to add my db prefix extension to my collect_info.php file, I basically copy the file to my home, added the extension, and rename the original file on my website to something else (e.g. collect_info_original.php) then I uploaded my modified file.

It worked. I also had to do this for these files because they were all missing the db prefix for the customers and group_pricing:

MYZENSTORE/includes/classes/shopping_cart.php
MYZENSTORE/includes/functions/functions_prices.php
MYZENSTORE/admin/includes/modules/product/collect_info.php

And now my greatest discovery:

I wanted to use this group pricing per item patch to allow my "Club Members" to download CERTAIN items for FREE from my web site, based on their membership status. The Memberships are good for one year at a time. But I noticed that if I put the Group A price of 0.00, the website ignores the Group A price and displays the original (non-member) price. To get around this, I priced the Group A items at: 0.0001. This Group A Price displays on the website as 0.00 and therefore as FREE. I added it to cart and is basically free.

So now I can start updating my LIVE site to support Club Memberships. This will make it much easier to manage membership.

Thanks everyone !!!