Guest Posted January 29, 2007 Share Posted January 29, 2007 Hi, I've been working on my shop and at somepoint in the last few days I broke it... :( Basically orders are not being added to the database. I added some debug code to the confirmation page and I can see the order details but I do not see any orders in the admin tool (or in the db via mysql) Can someone tell me the most likely place to look? I have probably removed some important code by accident. Cheers, Matt Link to comment Share on other sites More sharing options...
compuskill Posted January 29, 2007 Share Posted January 29, 2007 Hi, I have the same problem, so if you have solved your problem, please tell me! This is how this happened to me: I have moved a shop to another directory. Then I had a 1064 Mysql Error why I solved by upgrading my split_page_results.php. But now orders dont appear at all in the admin section. But if I enter an order number in the order search field and that order number is taken, it shows the order... :blink: :blink: Link to comment Share on other sites More sharing options...
davidinottawa Posted January 29, 2007 Share Posted January 29, 2007 Hi, I've been working on my shop and at somepoint in the last few days I broke it... :( Basically orders are not being added to the database. I added some debug code to the confirmation page and I can see the order details but I do not see any orders in the admin tool (or in the db via mysql) Can someone tell me the most likely place to look? I have probably removed some important code by accident. Cheers, Matt is the orders table *empty* when you do a Browse at it in phpMyAdmin ? what prints to the browser when you go into the orders section wihtin the admin tool. *Everything* except the orders listing ? Link to comment Share on other sites More sharing options...
compuskill Posted January 29, 2007 Share Posted January 29, 2007 Hi, I have the same problem, so if you have solved your problem, please tell me! This is how this happened to me: I have moved a shop to another directory. Then I had a 1064 Mysql Error why I solved by upgrading my split_page_results.php. But now orders dont appear at all in the admin section. But if I enter an order number in the order search field and that order number is taken, it shows the order... :blink: :blink: Hi, when I go to the admin section into orders, everything looks fine except for that the orders dont show up. In phpMyAdmin in the database, I see the orders.... Link to comment Share on other sites More sharing options...
davidinottawa Posted January 29, 2007 Share Posted January 29, 2007 Hi, when I go to the admin section into orders, everything looks fine except for that the orders dont show up. In phpMyAdmin in the database, I see the orders.... lol. Ok - so the orders are in the db, but not being printed to the browser. are the headings being printed : Customers Order Total Date Purchased Status Action Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2007 Share Posted January 29, 2007 is the orders table *empty* when you do a Browse at it in phpMyAdmin ? what prints to the browser when you go into the orders section wihtin the admin tool. *Everything* except the orders listing ? Hi David, I have see nothing in the orders section of the admin tool and have no data in the orders table when I view it manually using myPhpAdmin. Yes, the column headings are displayed in the orders section of the admin tool. Its like the order just isn't being saved to the database but I can't figure out where this is supposed to happen so its difficult to debug. I'm using PayPal IPN and the checkout process completes (address, price etc are) but there is no history of the order. Compuskill, your problem is different. I don't have data in the table or in the admin tool. Cheers, Matt Link to comment Share on other sites More sharing options...
davidinottawa Posted January 30, 2007 Share Posted January 30, 2007 Hi David, I have see nothing in the orders section of the admin tool and have no data in the orders table when I view it manually using myPhpAdmin. Yes, the column headings are displayed in the orders section of the admin tool. Its like the order just isn't being saved to the database but I can't figure out where this is supposed to happen so its difficult to debug. I'm using PayPal IPN and the checkout process completes (address, price etc are) but there is no history of the order. Compuskill, your problem is different. I don't have data in the table or in the admin tool. Cheers, Matt Hey Matt - I read this from another source : "I have just figured out that the Order Process email does NOT go out to anybody unless there is a return to merchant. Thus, if you have "Account Optional" turned on, NO order details are retained ANYWHERE. The customer can't review orders, and neither can you. I have just posted (in the config forum, which is evidently the wrong place - although this does seem to have to do with confguration rather than modules) my conclusion: all you can do, if you are using paypal this way, is plaster your shop with instructions for the customer to RETURN TO MERCHANT on the Thank you for your payment page." Yikes. http://www.oscommerce.com/community/contri...rch,held+orders and : http://www.oscommerce.com/community/contributions,2679 and : http://www.webpipe.net/howto/Oscommerce_missing_orders hth, david Link to comment Share on other sites More sharing options...
Guest Posted January 30, 2007 Share Posted January 30, 2007 Hi David, I found the problem. I removed some code from checkout_confirmation.php when i updated the template. It was something to do with the variable $confirmation. See code below. if ($confirmation = $payment_modules->confirmation()) { I didn't pay too much attention to the code in the body of the html when i was creating the new template but apparently i should have! Thanks for your help. Cheers, Matt Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.