RobiD Posted January 22, 2009 Share Posted January 22, 2009 Hi, Have migrated my working cart to a new server and have nearly worked out all the bugs except this one. When I have no pending orders, and Admin panel says I have 16. Any ideas? I can still function like this but I am setting this up for a client. Thanks for the help. David Link to comment Share on other sites More sharing options...
knipper Posted January 23, 2009 Share Posted January 23, 2009 I am having the same issue. I don't see another post of yours with an answer. What was the solution? Thanks in advance! Hi, Have migrated my working cart to a new server and have nearly worked out all the bugs except this one. When I have no pending orders, and Admin panel says I have 16. Any ideas? I can still function like this but I am setting this up for a client. Thanks for the help. David SORRY FOR THE DUPLICATION, PLEASE DELETE THIS POST Steve K AKA - Knipper - Link to comment Share on other sites More sharing options...
RobiD Posted January 25, 2009 Author Share Posted January 25, 2009 I am having the same issue. I don't see another post of yours with an answer. What was the solution? Thanks in advance! No, I accidently posted this question twice. The other has been deleted. You are the first to respond to my problem. I feel that the answer is in the database but I'm sure someone else would know far better than me, so please, anyone have an answer????? David Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 25, 2009 Share Posted January 25, 2009 Check the sql that brings up 16 and see what it is actually testing for. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
knipper Posted January 31, 2009 Share Posted January 31, 2009 Mine actually had to do with an incorrect https setting in the config file. Once I corrected that all other orders came in fine. I did have to manually delete that order from the database, as it never did show up even after the fix. all others had no problem. Check the sql that brings up 16 and see what it is actually testing for. Steve K AKA - Knipper - Link to comment Share on other sites More sharing options...
RobiD Posted January 31, 2009 Author Share Posted January 31, 2009 Mine actually had to do with an incorrect https setting in the config file. Once I corrected that all other orders came in fine. I did have to manually delete that order from the database, as it never did show up even after the fix. all others had no problem. Thanks for the replies guys. Knipper, can you detail the changes you made to the https setting in the config file? Geoffrey, can you explain how and what I am looking for the database ("Check the sql that brings up 16 and see what it is actually testing for".) Thanks again David Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 31, 2009 Share Posted January 31, 2009 Look in the orders table and see if there are any entries that you believe should be displayed. If there is nothing there to display osc is working correctly. Is the the sql checking for a status of 5 and you have changed pending to be status 8? It all depends on if you have stock osc or have installed some contributions that check for other values. Look in the code for the page you are using and see what the sql is trying to do. www.w3schools.com, the select section of sql tutorial. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
knipper Posted January 31, 2009 Share Posted January 31, 2009 In my case all the order info was writing to the database. It captured all the customer details, correct order info, etc. All database settings were correct. (It was duplicate of a site I had been using for 4 years) In the main admin page, you could see 1 pending order, but when you clicked on it you didn't see it. I checked the orders table in the database, and it was there... I then could search the order number by ID in the orders page and see the order. In the top section of the config file. It has http & https catalog domains, and cookie domains. I had accidentally included https info for the new site.... but HTTPS was not operational on the site. (i.e. No secure certificate) I Corrected that entry, and all subsequent orders showed up. I don't have any idea why it effected it, not allowing the orders to show up. It didn't really make sense to me! Steve K AKA - Knipper - 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.