zeroxxorez

http://www.oscommerce.com/community/contributions,4269 as im looking through the discount_coupons_to_orders im seeing that its pulling in the coupons_id fine. but all orders_id are 0 could this be the problem?

well i just tried to do that to coupons_id and orders_id with no success...still the same problem

the suggestions from that link you gave me. The Fix: 1) Go to your phpmyadmin, and select the sessions table 2) Select sesskey 3) Click edit 4) It's probably set at the OSC default, which is varchar(32). This is a mistake! Change the type to INT, the length/values should stay at 32. 5) Scroll all the way across to where you see extras and select AUTOINCREMENT from the drop down box. 6) Hit save button All 1062 Duplicate Enty errors will not be resolved. You won't get 'em again! i tried that but it would not accept it and gave me this error when i ran the SQL query Error SQL query: ALTER TABLE `sessions` CHANGE `sesskey` `sesskey` INT( 32 ) NOT NULL AUTO_INCREMENT MySQL said: Documentation #1062 - Duplicate entry '2' for key 1 and i also tried this //trim off extra crap on key $key = substr($key, 0, 32);

please can anyone help me out with this? I need to get this fixed immediately. any help would be GREATLY appreciated.

just tried it....got this when i ran the SQL query Error SQL query: ALTER TABLE `sessions` CHANGE `sesskey` `sesskey` INT( 32 ) NOT NULL AUTO_INCREMENT MySQL said: Documentation #1062 - Duplicate entry '2' for key 1

Ive installed the Discount Coupon module on my site. sometimes it works fine then other time i get this error 1062 - Duplicate entry 'test-0' for key 1 insert into discount_coupons_to_orders (coupons_id, orders_id) values (test', '') [TEP STOP] on checkout_confirmation.php and it will stop loading the page.

ok well now it seems that firefox ocassionally will work...but IE never does...it throws the error every time and stops loading the page I really need help with this and I am also willing to pay for help. The store that is running this is SpiceWorld420.com It shouldn't be too hard of a fix but it seems like nobody ever answered it when other people asked the same question.

I'm having problems. I'm getting 1062 - Duplicate entry 'test-0' for key 1 insert into discount_coupons_to_orders (coupons_id, orders_id) values (test', '') [TEP STOP] on checkout_confirmation.php this is only happening with IE though. On firefox it works great. Any help? Thanks! EDIT: well now its doing it for firefox too....