i can see that the uninstall did not remove the configuration group from the database, but i would rather have the uninstall sql do it than remove them manually - i do not know if there are other items that should be removed as well
Printable View
i can see that the uninstall did not remove the configuration group from the database, but i would rather have the uninstall sql do it than remove them manually - i do not know if there are other items that should be removed as well
hi hem,
all products price display in price inc on my site.
if the product price exc $100, tax 10%, price inc $110, 1$=1point
so, i need it to be:
on product description page : Price $110, 100 reward points
in shopping cart : 100 reward points
on total order page when check out : 100 reward points
but now, i have the tax problem, it shows:
on product description page : Price $110, 100 reward points
in shopping cart : 110 reward points
on total order page when check out : 110 reward points
any ideas?
i have a question, i'm not sure if it could be done with the current version RP mod.
if the product price is $10 with an attribute $3, then the customer get 13 points for this order. but i dont want it add the attribute price to the point, is it possible?
I'm having a similar problem. Though I managed to get missing areas back by using update.sql instead of new.sql after uninstall.sql, I had to reset up my reward points set-up, which I expected anyways after all that, but I too have multiple "Reward Points" sections with only one functional one in my configuration section. I remember reading something about it somewhere, but I'm too tired to try and find it again as I've literally read through the whole thread and did all the adjustments as needed along the way lol I remember having to go through my phpadmin once to change IDs for products, so I'm guessing I would have to do the same for this? I just can't seem to find the IDs for those "extra" pages in the phpadmin. But i'll try looking a little bit more before heading to bed. Otherwise any help or suggestion for this is appreciated. Btw, love this mod, once i got the hang of it, it wasn't as difficult. Thanks ^^
i set global reward point ratio to 1, its ok.
then i set one catagory reward point ratio to 50.
i go to the product page of this catagory, it showing correctly on the product description page. but in shopping cart, it still keep the ratio 1. and when check out, the ratio is also 1.
i dont know what's wrong with my rp mod?
OK, got the issue fixed. Took me a tad to remember how to get to the area I needed lol Although it's simple enough if ya got phpMyAdmin and are at least half way familiar in navigating it, if ya don't on either count, then this probably won't help much but here's how I did it.
Went into my phpMyAdmin in database and selected the zen_configuration_group and selected browse tab. I deleted the ID numbers of pages that were invalid till I got the functional page left. For example I had 33-36 ID with 36 being the functional page. When you're on that browse page on the phpmyadmin you'll see the list of all the links under the configuration of zen cart, including your dublicates. I found that trying to change the 36 ID to a 33 caused it to go blank and doing an "update" sql install again just repeated the earlier prob, so I deleted the newer ID since it wasn't functioning anyways and reset the ID number to 36 and voila, it works.
So all you really needed to do in this case was delete the "blank" pages, leaving the correct one alone. By finding the invalid's ID just mouse over the Reward Points link and look at the last bit that says gID="_" with "_" being the actual number. And of course you'll want to know which one is valid, so take note of which numbered link works properly. Then when ya go into deleteing stuff you won't delete the wrong one. Hope this helps some of ya'll ^^
well, got other issues work, but i dont know yet how to subtract the reward points of attribute.
1 point = $1,
for the products, price $10, attribute $50
i want only give 10 points to customer
but now, rp mod gives 60 points
where do i modify the set?
did the php my admin thing and removed them manually; will do fresh install; thanks for your guidance
This script will delete all empty multiples on the config menu just copy and paste it to SQL patch. However if you use a table prefix you will need to set `configuration_group_id` to `YOUR_PREFIX_configuration_group_id`
PHP Code:
#NEXT_X_ROWS_AS_ONE_COMMAND:2
DELETE FROM `configuration_group` WHERE NOT IN (
SELECT `configuration_group_id` FROM `configuration` WHERE 1);