mystanky Posted December 15, 2005 Share Posted December 15, 2005 I installed a few contributions (about 3 dozen) and now my shopping cart is stuck with the products for customers but after the customer pays, what they bought is still in the cart and the order never updates? Has anyone had a similar problem, know what files to fix or does it sound like a database problem? Anyone please help if they experienced this before..... :huh: (I am puzzled) Link to comment Share on other sites More sharing options...
kgt Posted December 15, 2005 Share Posted December 15, 2005 Orders might not get inserted if an error occurs during the insert. Errors can occur if you try to insert too few fields, too many fields, etc. You'll need to list the contributions you installed, the changes made to the database, and at what point the problem began. More information means more people might be able to help. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
Guest Posted December 15, 2005 Share Posted December 15, 2005 Orders might not get inserted if an error occurs during the insert. Errors can occur if you try to insert too few fields, too many fields, etc. You'll need to list the contributions you installed, the changes made to the database, and at what point the problem began. More information means more people might be able to help. Hi I have a similar problem, just posted it above. Also no e-mail confirmations..! Did you fix yours? Link to comment Share on other sites More sharing options...
mystanky Posted December 16, 2005 Author Share Posted December 16, 2005 No still no fix.... Some add-ons: Better Products Purchased Report v1.0 Automatic notify admin via e-mail of new accounts Easy Populate & Products Attributes v2.76b Order Editor? downloaded v1.61b Quick Updates 2.7 Customer Registration Report v1.1 checkout button in cart (I removed since error) AutoBackup Database in Admin orderlist3.4 customers stats orders v1.2b Continue Shopping 'Fix' (I removed since error) Link to comment Share on other sites More sharing options...
mystanky Posted December 16, 2005 Author Share Posted December 16, 2005 the site is www.asapcustoms.com/catalog - if you do a test account you will see what I mean... <_< Link to comment Share on other sites More sharing options...
kgt Posted December 16, 2005 Share Posted December 16, 2005 No still no fix.... Some add-ons: Better Products Purchased Report v1.0 Automatic notify admin via e-mail of new accounts Easy Populate & Products Attributes v2.76b Order Editor? downloaded v1.61b Quick Updates 2.7 Customer Registration Report v1.1 checkout button in cart (I removed since error) AutoBackup Database in Admin orderlist3.4 customers stats orders v1.2b Continue Shopping 'Fix' (I removed since error) Yikes, that's a lot of them. Okay, you're going to have to do some research. You need to go through each contribution and find all the .sql that alters the orders table. You need to post that + the output of this: SHOW CREATE TABLE orders in the SQL tab of phpMyAdmin. Before you do all that, check the orders, orders_status, and orders_status_history, orders_totals, orders_products for an order that didn't get saved. Make sure no part of it exists in these tables. If it exists in some and not others, then post the results. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
mystanky Posted December 17, 2005 Author Share Posted December 17, 2005 KGT Thanks for the effort - it was customer_discount_v1.3 that killed the process...thx again :rolleyes: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.