No status on orders!

[LayWay]

Hi

 

I just updated from version 1.5.3.1 to 1.5.4 and when i make a order on my page, i don´t receive any order confirmation and no "you have a new order" mail. I have not changed anything but updating to the new version, and everything was working fine before. The order does not get a status like all the rest, see attached image.

 

The order goes into my BO but does not get a status, and i think that´s why i don´t receive these 2 mail notifications.

 

Any suggestions about this status error?

 

 

Regards

Thomas

Edited August 16, 2013 by LayWay (see edit history)

[vekia]

you probably forgot about image, can you try to add it once again?

[LayWay]

Should be there now...:-)

 

Thomas

[swsindonesia]

Hi, best place to trace this is to look at the ps_order_history table in your database. In there you can find the order status id, whether it's really empty / null value, of just lost its reference.

[LayWay]

Where can i find that ps_order_history?

[vekia]

you should use some database manager like phpmyadmin, have you got an access to service like this? (it's usually available in the hosting control panel)

[LayWay]

Hmm i just looked at this order history, but i dont seem to find any orders, but maybe i´m looking he wrong place... I have 2 databases in the PHPmyadmin, my "normal" and the theme that i have on my page. The "normal" is all blank and the theme database only showing older orders. Just made a new order, and that is not showing anywhere in the PHPmyadmin?

[LayWay]

Okay i found the right PHPadmin, the other was incorrect. I can see now in the order_history that the orders a make on the site, does NOT go into this history overview.

 

As you can see on the image attached ID 45 is missing and i have 3 more orders with ID numbers 47, 48 and 49 which is not present here.

 

Any suggestions ?

 

Thomas

[swsindonesia]

Hi, I guess something went haywire during your upgrade.

*crossing-finger* Did you make a backup of your database before the upgrade? So you can do a comparison of your table

 

Does this only happen to newly created order after the upgrade?

One of the possibility is your new PS is referring to a different value in ps_state table, thus it creates the order, but not the proper order history.

Did you find anything weird (missing statuses / invalid state update) in your Orders -> Statutes ?

[LayWay]

Yes i made a backup of everything before upgrading. I made the upgrade through the auto update module, and it gave me 1 error (see attached image). I was told by another one in this forum to ignore the error, as it was not important.

 

Yes all new orders won't get a status or appear in the order_history in PHPmyadmin.

 

Everything seems to look fine in my statuses and no errors anywhere.

 

The option you refer to about the different value, is that an error only to be fixed in the code of my shop or?

 

Thomas

[swsindonesia]

Hi, are there any third party payment module you're using?

If not, I assume your initial orders should have "Awaiting bank wire payment" as their status, which is not happening here.

Another way is to try using different payment module (for testing purpose) and see whether the status appearing back or not.

The problem could be caused either by the order processing controller or the payment module here.

[LayWay]

Hi

 

I´m using the OPC module see link

http://addons.prestashop.com/en/checkout-modules/6841-one-page-checkout-for-ps-15.html

 

I´m using version 2.2.4 and the new version is called 2.2.7

 

For the payment i´m using Quickpay version 3.18

 

Should i try contacting them or maybe reinstall the modules again? (If i do that will my settings be reset)

[swsindonesia]

Hi,

In that case, you can try to use the "bank wire" module, and then do a test checkout.

If your order works well with the bank wire module, then there must be something wrong with the Quickpay.

Have you check its compatibility with PS 1.5.4 ?

[LayWay]

Everything is working JUST FINE with bank wire, so the problem must be the payment module. I have reinstalled the module again but still not working. Quickpay (3rd party payment module) says their module "should" be compatible with version 1.5.4.

 

On ALL my orders, also the once working in the old system i got an error in the order summary in BO, you can see the attachment. I don´t know if this problem could be related with this problem?

[swsindonesia]

Hi,

 

It seems that Quickpay is filtering your IP address. Did you also move to another server / hosting account when upgrading your PS?

You can contact Quickpay to add that IP address 77.66.30.230 to your merchant account, or you should be able to do it by yourself by logging in to your Quickpay merchant account, and set your correct IP.

 

cheers.

[LayWay]

The API is now working fine after i added the IP address but still same problem with the order status etc.

[swsindonesia]

Ok, we're making progress here.

First, we rule out any chance of problem in the order processing, since bank wire module processes the order properly.

 

1. This is could be a blind shooting, but you might wanna "force" the quickpay module to treat itself as a PS 1.5 compatible.

modules/quickpay.php line 11

   //$this->v14 = _PS_VERSION_ >= "1.4.0.0";
  // force disable backward comp with 1.4
 $this->v14 = false;

 

2. Can you view those blank status order in your Quickpay merchant account?

 

3. Best way is to contact Quickpay support, telling your situation how using bank wire module doesn't give you any problem.

[LayWay]

1. i tried to embed the code (i´m not sure i did it 100% correct) nothing happened though.

2. Yes the orders is shown in Quickpay merchant account.

3. Got word back from Quickpay support who says it is a generel Prestashop error they just located yesterday, and is working hard to solve as we speak.

Any idea if that is correct?

[swsindonesia]

So your problem is you got your order created (in ps_order), you got your order saved in your Quickpay Merchant, but you have absolutely nothing in order history.

What actually did they mean by "general Prestashop error"? Are they admitting there's something wrong with their PS module? Since we already ruled out possibility of PS error by using bank wire module.

[LayWay]

The does NOT go into ps_order_history in PHPmyadmin, but the order is present in Quickpay merchant AND in BO but without any status on it...

 

They say that Prestashop is working on a solution, but i think it sounds really weird. The danish guy who did the code to Quickpay says it should work just fine with 1.5.4 and is working in his shop. So the problem must be in my configuration somehow...

[LayWay]

I´m thinking it might be best to make a clean install and import everything again to the new shop. Do you know if there is any module who can make this export/import thing automatic, or do i have to do everything manually?

 

Thomas

[swsindonesia]

Hi,

 

I assume by "import" you mean importing products, orders, customers. You can try to migrate the tables related to those data manually through PHPMyAdmin.

 

But before doing that, maybe it's best to do a *really* clean install of PS and Quickpay Module (freshly downloaded from their site), use some sample data, and perform order. See if that works well. If not, there's no point of importing your data there.

If that works, then you can start migrating your products, orders, customers to that fresh site.

 

cheers.