Jezthomp Posted December 2, 2004 Share Posted December 2, 2004 Hello, hope someone can help In the admin home page, it says Orders>Pending 2 however, when i click on the pending button and it goes to orders nothing is there??? Whats going on. The orders are not showing. Not very good with mysql so hope its not a problem there? Will i be able to get them to appear or are they lost? Anyone help me please? Link to comment Share on other sites More sharing options...
Jezthomp Posted December 2, 2004 Author Share Posted December 2, 2004 Right am sorry for posting this, have seen that the same question has been asked many times. I can see the orders in myphpadmin and when i do a search for the order no in my admin it comes up just not in the orders page as i have said. So what am i doing wrong? If it does involve myphpadmin would someone mind talking me through it cause as i said i am not very good when it comes to that and dont want to mess anything up. Many thanks again:) Link to comment Share on other sites More sharing options...
Jezthomp Posted December 2, 2004 Author Share Posted December 2, 2004 Can anyone help me out. There are lots of threads but no particular answer, surley there must be? :( Link to comment Share on other sites More sharing options...
Jezthomp Posted December 3, 2004 Author Share Posted December 3, 2004 So my site is screwed then? There must be something i can do? Link to comment Share on other sites More sharing options...
Jezthomp Posted December 3, 2004 Author Share Posted December 3, 2004 Anyway to reply to my own post i think i have found the problem just need some help sorting it out now. When i go to myphpadmin and i click on the languages down the left hand side. Instead of the ussual info i just get a blank page and : Missing parameter: db: Missing parameter: table As i say dont have a clue about mysql, so can anyone help me out, uploading the language sql i assume that would work??? Many thanks :) Link to comment Share on other sites More sharing options...
Jezthomp Posted December 3, 2004 Author Share Posted December 3, 2004 Well sorted that and still no luck. order_status looks like INSERT INTO `orders_status` VALUES (1, 1, 'Pending'); INSERT INTO `orders_status` VALUES (2, 1, 'Processing'); INSERT INTO `orders_status` VALUES (5, 1, 'Canceled'); INSERT INTO `orders_status` VALUES (3, 1, 'Delivered'); INSERT INTO `orders_status` VALUES (4, 1, 'On Hold'); I'll keep posting to myself hopefully someone will see my pain :( ;) Link to comment Share on other sites More sharing options...
wizardsandwars Posted December 3, 2004 Share Posted December 3, 2004 What is the value stored in the order status column of the orders table for hte orders that are not showing up? ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Jezthomp Posted December 3, 2004 Author Share Posted December 3, 2004 Thankyou for your response. Order_status all say 3, have just done a new order and that states 1 none of them appear. This all started happening since i moved to a new host and setup my private ssl. I can see old orders when i just click on orders under customers but anything new. Cannot see at all? Thanks for having a look Link to comment Share on other sites More sharing options...
Jezthomp Posted December 5, 2004 Author Share Posted December 5, 2004 anyone :( Link to comment Share on other sites More sharing options...
sabotage Posted December 5, 2004 Share Posted December 5, 2004 anyone :( <{POST_SNAPBACK}> Dunno if this has anything to do with your problem, but I use Authorize.net. If someone attempts to pay with there CC, and the payment fails, the order never completly gets deleted. It creates the order before the info is sent to Authorize.net, so that an order number can be passed, and if the payment fails, the order doesn't get deleted completly. So I find that sometimes on the front page of Admin, it shows pending orders, when in fact there aren't any. Dunno if that helps. Link to comment Share on other sites More sharing options...
Jezthomp Posted December 6, 2004 Author Share Posted December 6, 2004 Decided to set-up another mysql and install it again and then change the settings in the configure.php's see if that will work. Hope so :( Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.