peterbat Posted March 22, 2007 Posted March 22, 2007 Hi everyone, I'm having trouble with the checkout_process.php page, either that or one of it's included pages. When an order is passed through the page, I'm guessing it gets the orderID page through an integer that's generated through the auto increment in the orders table. It then uses this orderid as a reference and populates the rest of the orders_ tables. However for some reason it's stopped using or obtaining the auto increment integer (which is still being generated) and now all the other order_ tables are displaying 0 as their orderid. This results in orders not being displayed in admin because it can't find the rest of the information it needs. All ideas/input greatfully received :) Pete
chooch Posted March 23, 2007 Posted March 23, 2007 If it is a relative recent problem then re-trace any steps you took if you edited the store. Maybe you can find a fix by undoing any modifications you recently added. Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH
bayoupizzazz Posted March 23, 2007 Posted March 23, 2007 I believe I may be having this same problem. I have made absolutely no recent changes to my store, yet two days ago, I had 3 credit card charges go through for the same invoice. Then today, I had three orders with the same invoice number, the last two orders of which were the same (charged twice). I am at a loss here.
chooch Posted March 23, 2007 Posted March 23, 2007 In that case check if your host has upgraded their php from 4 to 5... they are under no obligation to tell you before they do but it is a common problem for some contributions not to work in php5 Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH
peterbat Posted March 23, 2007 Author Posted March 23, 2007 I don't think undoing what I've added will be possible :( I'm pretty sure I could find sort the problem if I knew where functions and classes were originating from, there's one called tep_db_prepare_input($order_id) within orders.php in the classes folder which I'm guessing is what takes the auto increment ID generated by orders table and uses it for the insert SQL statements for the rest of the tables. But I can't find the SQL statement for tep_db_prepare_input($order_id).
peterbat Posted March 25, 2007 Author Posted March 25, 2007 ok, been having a think about it. The oscomm store I've built is heavily modified with a mixture of contributions and my own code so to remove the customisations or start from fresh is going to be a huge task. So my next thought is to reinstall just the pages that are included or required by checkout_process.php as well as any other files that are used as part of that singular process. So my question is, can anyone tell me what files are used? I remember there being a flow diagram of oscommerce also of pages used at different stages anyone know where I can find it again? Cheers, Pete
Recommended Posts
Archived
This topic is now archived and is closed to further replies.