Separate Pricing

[knopp]

Hi

I am quite new i OScommerce.

 

can I get some help with this problem:

 

when I add a new product, and add pricing in f.eks VIP, I get following mess:

 

1062 - Duplicate entry '1' for key 1

insert into products_groups (products_id, products_price, customers_group_id, customers_group_price) values ('28', '123.0000', '1', '11')

[TEP STOP]

 

when I opdate the product.

There is no problem, if I use a new pricingkeyword, witch not have been used in any products.

 

 

Poul Knopp

Denmark

[bka]

Hi Poul,

 

I have the same problem with this contrib. Perhaps the fault is in general.php.

 

Bye

 

Bernhard

[Jan Zonjee]

Better keep this in the Separate Pricing per Customer thread guys.

 

Actually, this has been solved. If you go to page 15 of the thread you should read in post 294 and 296 that the solution is to make the combination of two columns the primary key (products_id and customers_group_id).

[bka]

You can try to set the row "products_id" which is in the table "product_groups" as a primary key. Perhaps this will solve this problem.