antinomia Posted July 3, 2003 Posted July 3, 2003 Hi all- I've been futsing with this for a little while now to no avail. I can place orders just fine as a customer, and I get the confirmation email, but when I go to the admin section to view them, they do not appear. Funny thing is, in the 'Orders Pending, Processing, Delivered' summary on the Admin home page, it shows that there are 5 orders pending. If I click on 'Pending', it takes me to the orders page but none of them show up. If I search for an order number (#1-5), the invoice will load and I can view the data, but why won't the list come up? I've tried reinstalling admin/orders.php but that didn't help. I mean, the data is in the database, obviously, but the orders.php page just doesn't seem to be parsing it correctly. Any ideas? -Matt
antinomia Posted July 3, 2003 Author Posted July 3, 2003 Oh sorry, I'm using the 6/30/03 snapshot and the urls are (not live yet) http://www.demochair.com/catalog/ http://www.demochair.com/catalog/admin Thanks, MK
Guest Posted July 5, 2003 Posted July 5, 2003 I'm having this issue as well, only I hve the Coupon Class and GV v5/03 mod installed.. Do you have that installed? If so, I've yet to get an answer.. The only thing I can tell you is to enter your own email address in the "send extra email to" field under Configuration/My Store At least that way, you are notified of the orders.. :cry:
Daemonj Posted July 5, 2003 Posted July 5, 2003 Using PHPMyAdmin (or a similar tool), look at the records in the orders table and verify that the orders_status is something other than 1 and let me know the results. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Daemonj Posted July 5, 2003 Posted July 5, 2003 That is the problem then. The order status has to be greater than 0 in order to appear in the list. Now the question is why are the statuses set to 0? In Admin ~ Localization ~ Orders status, what is set as the default status? Then (using PHPMyAdmin again) look in the orders_status table and see what the id of the default setting is. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
antinomia Posted July 5, 2003 Author Posted July 5, 2003 I don't have an order_status field in the orders table, I do have an orders_status table with an order_status_id set to 0. In localization, my default is set to 'pending' and the other two are still labeled 'processing' and 'delivered.' Can I change a variable in phpMyAdmin to correct this problem? Thanks, Matt
Guest Posted July 5, 2003 Posted July 5, 2003 The default status is Pending In PHPMyAdmin the order_status table the id of the default setting is also 0 I'm guessing that's the problem?
Daemonj Posted July 5, 2003 Posted July 5, 2003 Yes, the default setting must be 1. The order_status_id should be an auto_incrementing field so all of the statusus should run sequentially (i.e. 1, 2, 3, etc) and never be zero. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted July 5, 2003 Posted July 5, 2003 Ok, I changed that to 1, but it's still not working :( I really appreciate you taking the time to help!
Daemonj Posted July 5, 2003 Posted July 5, 2003 Did you also set the orders_status for all of the records in the orders table to 1 as well? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted July 5, 2003 Posted July 5, 2003 This is my orders_status table (when browsing) orders_status_id language_id orders_status_name Edit Delete 1 1 Pending Edit Delete 2 1 Processing Edit Delete 3 1 Shipped orders_status in the Orders Table - default is set to 1 Am I looking at the right thing? I'm a relative mysql newbie (i backed up the database before I started messing with it lol) thanks
Orphon Posted July 5, 2003 Posted July 5, 2003 I have this same exact problem!!! I looked in my DB and noticed my order had no order ID.... so I can't even pull it up by searching.... Any ideas? I changed the status default to 1 like already said.... Angela
antinomia Posted July 5, 2003 Author Posted July 5, 2003 Same here, I changed my orders_status_id default to '1', and no orders are showing up, even after placing a new order. There are 7 records in the orders table with orders_id from '1' to '7' and all with order_status of '1'. What is 'orders_date_finished'? These are all set to null.
Orphon Posted July 5, 2003 Posted July 5, 2003 ok, looking through orders_total I found the order ID which was zero for some reason.... but it was not connected to the order in the orders table... I put it in and now it shows up.... Now I need to know why that happened.... I can also only assume that is why I didn't get an email of the order even tho I have the send extra order emails too set to my email... Any ideas? Angela
Daemonj Posted July 5, 2003 Posted July 5, 2003 While in PHPMyAdmin, click the SQL tab and enter the following: update table orders set orders_status=1 where orders_status=0; Verify that records are updated (it tells you near the top). The look at your orders screen (be sure to press F5 when you get there to refresh the screen) and let me know if you have a listing. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
antinomia Posted July 6, 2003 Author Posted July 6, 2003 While in PHPMyAdmin, click the SQL tab and enter the following: update table orders set orders_status=1 where orders_status=0; Here is the result I receive: Error SQL-query?:? UPDATE TABLE orders SET orders_status = 1 WHERE orders_status = 0 MySQL said: You have an error in your SQL syntax near 'TABLE orders SET orders_status = 1 WHERE orders_status = 0' at line 1
Daemonj Posted July 7, 2003 Posted July 7, 2003 While in PHPMyAdmin, click the SQL tab and enter the following: update table orders set orders_status=1 where orders_status=0; Here is the result I receive: Error SQL-query?:? UPDATE TABLE orders SET orders_status = 1 WHERE orders_status = 0 MySQL said: You have an error in your SQL syntax near 'TABLE orders SET orders_status = 1 WHERE orders_status = 0' at line 1 I must have been tired and I apologize for the error. :oops: The proper sql statement is: update orders set orders_status=1 where orders_status=0; just remove table from the original statement. Jim "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
jrglass Posted July 7, 2003 Posted July 7, 2003 Hi all- I've been futsing with this for a little while now to no avail. I can place orders just fine as a customer, and I get the confirmation email, but when I go to the admin section to view them, they do not appear. Funny thing is, in the 'Orders Pending, Processing, Delivered' summary on the Admin home page, it shows that there are 5 orders pending. If I click on 'Pending', it takes me to the orders page but none of them show up. If I search for an order number (#1-5), the invoice will load and I can view the data, but why won't the list come up? I've tried reinstalling admin/orders.php but that didn't help. I mean, the data is in the database, obviously, but the orders.php page just doesn't seem to be parsing it correctly. Any ideas? -Matt To see another fix goto http://www.oscommerce.com/forums/viewtopic.php?t=41103 Jeff www.discountmagazinehouse.com
antinomia Posted July 7, 2003 Author Posted July 7, 2003 I must have been tired and I apologize for the error. :oops: The proper sql statement is: update orders set orders_status=1 where orders_status=0; just remove table from the original statement. Jim ...and the result: Affected rows:?0 SQL-query?:?[Edit]?[Create PHP Code] UPDATE orders SET orders_status = 1 WHERE orders_status = 0 However, I did try the hack as Purple Patch suggests (http://www.oscommerce.com/forums/viewtopic.php?t=41103) and it is seeming to work correctly... This is a very odd problem, does something need to be changed in the distribution so this doesn't happen to scores more people? Thank, Matt
Guest Posted July 9, 2003 Posted July 9, 2003 Happened to me on one of two stores both from MS1 - can't explain why! The MySQL method didn't work "0 row(s) affected".
Daemonj Posted July 9, 2003 Posted July 9, 2003 What is the value of the orders_status in the order table for your records then? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted July 9, 2003 Posted July 9, 2003 All 1, except paypal which is 99999 - both the saite that works and the one that oders don't appear in admin in.
Daemonj Posted July 9, 2003 Posted July 9, 2003 Is the orders_status_id for the Pending status in the orders_status table set to 1? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.