Davey Posted July 8, 2003 Share Posted July 8, 2003 Hi all, I have searched for over an hour in the forums for help with this but to no avail. If it's there I apoligise in advance. Last evening, three orders were placed (by new customers who's names appear in admin), payment was authorised by Credit/Debit card via SecPay but we cannot find the orders, checked admin and database. We have contacted these customers because we have their details returned by Secpay. 'Dear Customer thanks for your order and payment by the way - what is it?' :oops: Orders were accepted earlier that day and nothing has changed to my knowledge. Any advise please ? TIA The shop is at http://shop.scrimcity.co.uk Link to comment Share on other sites More sharing options...
Guest Posted July 9, 2003 Share Posted July 9, 2003 Hi, I too have a similar problem, A customer placed an order via credit card, the order was successfull, but no order registered in the orders section in Admin. Anyone got any ideas how to see what the credit card facility settings are? I'm going through the php under includes/module/payments/ and can't seem to figure out where the credit card details are getting sent to. cheers David Link to comment Share on other sites More sharing options...
Davey Posted July 9, 2003 Author Share Posted July 9, 2003 Last night we received some orders and payments, some just payments without the orders ... Tempted to get a re-install done :bomb: Link to comment Share on other sites More sharing options...
burt Posted July 9, 2003 Share Posted July 9, 2003 Use PHPMyAdmin to take a look at the orders table in database to see if the order exists. Or in admin > orders.php there is a text field search facility in the top right hand corner - try putting in an order number there to see if it appears. let us know. Link to comment Share on other sites More sharing options...
Hefty Posted July 9, 2003 Share Posted July 9, 2003 Having the same difficulties - we can find the orders in the DB however and the search facility works on the order ID (as above). It looks like the problem occurs from the code on the orders.php page - it runs this SQL query: select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit 0, 20; Messing with the last bit seems to get it to work (removing "and ot.class = 'ot_total'") but we're still looking as to why this might be. We have 2 copies of the site running on seperate boxes ('live' and 'dev') and for all intents and purposes they are identical - yet 'dev' works and 'live' does not.... More soon. :shock: Link to comment Share on other sites More sharing options...
burt Posted July 9, 2003 Share Posted July 9, 2003 What this means is that the order does not have a "status". Your orders are being written with a status that does not exist, probably a status of "0". So you need to find out where this is happening. A common mistake is when people add the Paypal IPN contribution, they do not load the .sql which creates a new status "paypal pending". Once you have found out why it is happening, it will be simple to fix. Start hunting. In the meantime, go to PHPMyAdmin and see what status's you have for each order: Table orders_status - please copy/paste to this thread. Then Table orders_status_history - again please copy paste to this thread. Then we can see what's going wrong, and attempt to fix. Link to comment Share on other sites More sharing options...
Davey Posted July 9, 2003 Author Share Posted July 9, 2003 Thank you. Not in database, not in admin. It was working fine for a couple of weeks then intermittant over that last few days some orders and payments, some just payments. Also email from customers today re visitors cart not merging with account cart, logging customers out after a time and droping items during order. As this was tested for many week before going live and worked fine I can only assume something is corrupted. Because of the need to get this resolved now (as the site is live) I am now paying someone to reinstall the lot (doing this PM)- but many thanks for your advise. Link to comment Share on other sites More sharing options...
Guest Posted July 9, 2003 Share Posted July 9, 2003 Thanks for the info, I did follow a transaction via the database and what happened was that it just simply disappeared after the order was confirmed. For some strange reason it's now working. Must have been a freaky phenomenon. I did however notice that it did not ask me to log into an account before it proceeded through to the checkout. Perhaps this is the reason why the orders did not go through. Any suggestions why a New User / Login screen wouldn't come up? cheers David Link to comment Share on other sites More sharing options...
Davey Posted July 10, 2003 Author Share Posted July 10, 2003 It appears that the problem is with the host doing an upgrade and setting the session cookies to delete 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.