royalfunk Posted January 15, 2004 Share Posted January 15, 2004 I have almost finished our site but now a new error is popping up. I have not been able to pinpoint what is causing it. If you follow the direct link for the detailed invoice/order history like shown in order confirmation emails, the page loads correctly once you log in. If you log in at the site under "My Account" and click on the "Order History" button it says "You have not yet placed any orders". The orders are in the database and show up just fine. Anyone know what could be causing this? The database appears to be OK, but I really could use a little help. Thanks so much!!!! Aaron Link to comment Share on other sites More sharing options...
john77 Posted January 15, 2004 Share Posted January 15, 2004 I have a simular problem with my site when i check for orders in admin it doesnt show any but on the main page in admin where it shows all the stats of the site it tells me how many orders i have but when i check the orders under custromers it shows none when i go to my detabase there all there. i tried replacing the orders.php but still get the sme thing. Link to comment Share on other sites More sharing options...
royalfunk Posted January 15, 2004 Author Share Posted January 15, 2004 I noticed also that when I am in the ADMI section it shows that there are no orders, when the database is, at the same time, holding records of orders. All the info in the database appears to be correct so I am not sure where the error could be. It was working earlier today and now it's not for some reason. I emptied out the tables pertaining to orders and customers and started fresh but the same problems persist. PLEASE if anyone can help let me know. We need to go live with this site very soon. Thanks. Aaron Link to comment Share on other sites More sharing options...
royalfunk Posted January 16, 2004 Author Share Posted January 16, 2004 (BUMP) I know this is a fairly unique circumstance, but nobody has any advice? If not, I at least appreciate you taking the time to read this. Thanks. Aaron Link to comment Share on other sites More sharing options...
Alien-Tech Posted January 16, 2004 Share Posted January 16, 2004 ... hehe I can offer you only my simpathy, because I have a very same problem. Try to write the number of an order in admin orders section... In my case it shows ok, so the database is working, but I dont have a clue why it shows orders in main administration pages ( under pending ) but under Orders I can't see shit. Just 0, zero, nul, nada.... Link to comment Share on other sites More sharing options...
john77 Posted January 18, 2004 Share Posted January 18, 2004 well its not a very unusual problem its pretty common but no one seems to want to help no one helps here like they used too. i need this thing working as of yesterday. Link to comment Share on other sites More sharing options...
Alien-Tech Posted January 18, 2004 Share Posted January 18, 2004 ... I saw there was a bug #686 with similar problems, but has status closed... I have the newest version installed, but surrely I don't now how to fix it or how it was fixed... I have a part time solution, like: 1. Costumers can see their order online trough link provided in e-mail confirmation (like that: http://www.mikrom.si/account_history_info.php?order_id=9), still they can't see all the history..... because it's not working! 2. I can see the customer's order and print it out in admin section, if I type in the order number, which I recieved in e-mail when customer placed order. I am a newbe on php, but still I am trying to find a connection between account_history_info.php and orders showing in admin section! If nobody else will help, I'll pay to some programer to find out the error... but I'll sure post the solution for free..... count on it. Link to comment Share on other sites More sharing options...
Alien-Tech Posted January 18, 2004 Share Posted January 18, 2004 :D Me happy..... the post: http://www.oscommerce.com/forums/index.php?showtopic=41103&st=0 made sense to me, so I had give it a try... and you won't believe it.... The motherf#%)/ worked. So John77 and others with same problems try to do this: 1. Locate file /public_html/admin/orders.php 2. Open the file with editor (frontpage, notepad.. I used Frontpage) locate lines with: and ot.class = 'ot_total' tag in them. Those should be in three locations across the file, and remove them... remove just the caracters i marked as bold, nothing more. 3. In the same file (orders.php) find tag: } elseif (isset($HTTP_GET_VARS['status'])) { and replace it with } elseif (!empty($HTTP_GET_VARS['status'])) {. ... that is all.... It worked for me... tough if I click all orders in rolldown menu it doesn't work, but I don't need that function.... pending. delivered and processing works fine. Alltough Customer's history works for now. PS: And for fast searching of those tags I used option find that auto found them. Hope it works for u too. Link to comment Share on other sites More sharing options...
royalfunk Posted January 19, 2004 Author Share Posted January 19, 2004 Thanks! This solution seems to have fixed whatever was wrong with the admin/orders.php file, but unfortunately the link for ORDER HISTORY on account.php still does not work correctly. Does anyone have a way to fix this? That is what I really need. Thanks. Aaron Link to comment Share on other sites More sharing options...
Alien-Tech Posted January 19, 2004 Share Posted January 19, 2004 .. Did you check for blank spaces.... just a preposition, wihich costed me a lot of hours before.,.... LOTS OF TIMES! :D Link to comment Share on other sites More sharing options...
trendyfashion Posted January 19, 2004 Share Posted January 19, 2004 Alien, I posted this elsewhere this morning but I will say it again. DO NOT use notepad, word and for sure NOT frontpage to edit php files!!!!!!!!!!! Frontpage is just asking for trouble, big time. You will be causing yourself lots of trouble with blank spaces ect.... Use a text editor. I use an old favorite called pfe32. The Wiki Docs: Read them, live them and be thankful for them! Link to comment Share on other sites More sharing options...
Alien-Tech Posted January 19, 2004 Share Posted January 19, 2004 I'll give it a shot! THNX Link to comment Share on other sites More sharing options...
royalfunk Posted January 19, 2004 Author Share Posted January 19, 2004 I am only using DreamWevaer to edit PHP files and it works beautifully. All the code is color coded so you can easily see separations. I still have no answer for why the "Order History" is not working in the account.php page, but hopefully someone can figure it out. Most of my PHP knowledge comes from analyzing pre-written scripts and figuring out how to alter the code to get what I want. I am long way from writing the stuff from scratch! Thanks guys. Aaron Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.