Post by Balbaroy » Wed Feb 02, 2011 11:04 pm

Hi,

My problem just started happening. I have been using OpenCart since about August 2010. I was running version 1.4.9.2 and everything was working fine. Then sometime after January 24th my new orders stopped showing up in the Orders section of the Admin Panel and the store no longer sends me an email when an order is placed.

The orders are still going through though because when I check PayPal I have new payments and the PayPal references an Invoice ID.

I did an upgrade yesterday to 1.4.9.3 just to see if maybe it was some sort of bug which had been fixed but the issue persists. Any idea what I should try to figure out what is happening. I looked in the log file for errors, but there is nothing in there past 1-22-2011 so if it is through an error, its not showing up in the Logs. I will paste in all of the ones form 2011 just for reference.

Code: Select all

2011-01-04 4:09:32 - PHP Warning:  unlink(/home/content/27/6365627/html/store/system/cache/cache.category.0.1.0.1294141961) [<a href='function.unlink'>function.unlink</a>]: No such file or directory in /home/content/27/6365627/html/store/system/library/cache.php on line 54
2011-01-22 21:54:40 - PHP Warning:  fopen(/home/content/27/6365627/html/store/system/cache/cache.category.0.1.0.1295762080) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /home/content/27/6365627/html/store/system/library/cache.php on line 26
2011-01-22 21:54:40 - PHP Warning:  fread(): supplied argument is not a valid stream resource in /home/content/27/6365627/html/store/system/library/cache.php on line 27
2011-01-22 21:54:40 - PHP Warning:  fclose(): supplied argument is not a valid stream resource in /home/content/27/6365627/html/store/system/library/cache.php on line 29
2011-01-22 21:54:45 - PHP Warning:  fopen(/home/content/27/6365627/html/store/system/cache/cache.category.0.1.0.1295762085) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /home/content/27/6365627/html/store/system/library/cache.php on line 26
2011-01-22 21:54:45 - PHP Warning:  fread(): supplied argument is not a valid stream resource in /home/content/27/6365627/html/store/system/library/cache.php on line 27
2011-01-22 21:54:45 - PHP Warning:  fclose(): supplied argument is not a valid stream resource in /home/content/27/6365627/html/store/system/library/cache.php on line 29
2011-01-22 21:54:45 - PHP Warning:  filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /home/content/27/6365627/html/store/system/cache/cache.category.0.1.0.1295762085 in /home/content/27/6365627/html/store/system/library/cache.php on line 27
2011-01-22 21:54:45 - PHP Warning:  fread() [<a href='function.fread'>function.fread</a>]: Length parameter must be greater than 0 in /home/content/27/6365627/html/store/system/library/cache.php on line 27
Edit:
One thing to note though is the problem did not happen after an upgrade, it just started happening out of the blue while I was running 1.4.9.2. I then ran the upgrade to 1.4.9.3 just to see if it would fix it but the issue still remains.
Last edited by Balbaroy on Thu Feb 03, 2011 3:02 am, edited 3 times in total.

Newbie

Posts

Joined
Tue Aug 03, 2010 12:24 am

Post by rajarija1 » Wed Feb 02, 2011 11:10 pm

Something similar at our web store happened also....

Newbie

Posts

Joined
Wed Feb 02, 2011 11:00 pm

Post by Balbaroy » Wed Feb 02, 2011 11:31 pm

rajarija1 wrote:Something similar at our web store happened also....
I just checked the actual database table order_history and the new order_ids are not present in the database either. Not familiar enough with how the store works to figure out what part should be adding this information to the table.

Newbie

Posts

Joined
Tue Aug 03, 2010 12:24 am

Post by Balbaroy » Fri Feb 04, 2011 9:18 pm

Well, all of a sudden 2 or 3 of the orders that were missing just showed up in the system 5 or 6 days after they were completed. Seems pretty odd. I did some more digging and I think the problem may have been with PayPal. So I followed the guide to setting up PayPal Standard and I did have a couple of settings that were not correct so I am hoping now that I have everything set properly this will take care of the issue.

Newbie

Posts

Joined
Tue Aug 03, 2010 12:24 am

Post by rajarija1 » Mon Feb 07, 2011 4:38 am

nothing new at our store....i really don't know what to do....

Newbie

Posts

Joined
Wed Feb 02, 2011 11:00 pm

Post by openmycart.com » Tue Feb 08, 2011 2:53 am

just my suggestion.

check your hosting space limit.
delete all your cache files.

and then what next problems?

Find and get many various of opencart modules, themes, mods, etc for your opencart store at http://www.openmycart.com/oc/, OPENCART SITE customization and Maintenance supports at here


User avatar
Active Member

Posts

Joined
Tue Oct 12, 2010 4:47 am


Post by eyeweb » Fri Feb 18, 2011 10:40 pm

We are having this very same issue, and whilst digging around, have found some oddities...

Firstly, it appears that the reason for this is that once an order is completed, it isn't assigned a status name, hence the status_id field being 0.

When looking into this, the table that holds the various status fields, (oc_order_status) is empty!!!

So we added them from an older version of the store we are using, 1.4.8.

After placing a new order to test if this made a difference, although the order was processed, we received an error during the redirect, which indicated an issue in the file catalog/model/checkout/order.php on line 302 (The error was something along the lines of undefined value.

The actual error is:

Undefined index: name in /var/www/PATH-TO-OUR-SHOP/catalog/model/checkout/order.php on line 302

On looking into this, the iline in question does look like it could hold the key to solving this, the line is:

Code: Select all

$text .= $language->get('text_order_status') . ' ' . $order_status_query->row['name'] . "\n\n";
I think I am close, however I am approaching the extent of my knowledge with regards to what the CAUSE could be, especially as I now have got names in the order status table.

I hope this helps someone get a bit closer to fixing this, or finding a fix.

Incidentally, we are running 1.4.9.2

Newbie

Posts

Joined
Wed Jul 21, 2010 5:05 pm

Post by rajarija1 » Mon Mar 07, 2011 4:48 am

hmmmm..another problem....when ordering more than one item in cart only one item is shown....and at the end only one is charged on invoice....
can anybody solve this matter?

Newbie

Posts

Joined
Wed Feb 02, 2011 11:00 pm

Post by SXGuy » Mon Mar 07, 2011 6:14 am

I have noticed, in the past, sometimes, when transfering databases, or reinstalling an opencart installation, sometimes the order statuses get removed.

When this happens, paypal settings such as, which status to use when an order is processed, becomes missing, because like i said, the order statuses are missing.

This could cause your issue, if there are no statuses for orders created, and those are not linked to payment order statuses, then you would not see an order history under any status, nor would it appear in the database.

Therefore, go to system/localisation/order status, and make sure there are set, if not, create your own, i.e complete, pending, declined, charged back etc.

Then go into your payment module, whichever one you use, and set the payment status to complete.

This should fix all future issues. but if you want the previous orders to show, your probably gonna need to edit the database directly, and add the status id yourself.

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by rajarija1 » Tue Mar 08, 2011 5:34 am

hmmmm....still not working....when buying one item and then adding new one, the first one stays in shopping cart....the 2nd, 3rd,... hides somewhere, because when deleting the first item the second one pops up...and so on....when finishing order with all let's say 3 items, also invoice is made for only the first item.....

still in need for help...

Newbie

Posts

Joined
Wed Feb 02, 2011 11:00 pm
Who is online

Users browsing this forum: No registered users and 135 guests