Jump to content

[SOLVED] Bankwire Fatal error (OrderHistory -> id_order_state is empty)

GezaazY
 Share

Recommended Posts

GezaazY Newbie

GezaazY

Posted
Posted (edited)

Hi All,

 

When I try to check out an order, I get the Fatal error (OrderHistory -> id_order_state is empty) message when a select Bankwire as a payment method.

 

Some background:

I was one of the unlucky ones who got hacked. Applied the fix and got everything working, upgraded to the latest version 1.4.4.1 and since then I have trouble checking out orders.

 

I have been searching the internet and this forum for a day now and I seem to be the only one who has this problem with bankwire.

 

EDIT: I also tried to uninstall and reinstall, installed previous versions and nothing has helped so far.

 

EDIT 2: The orders are actually created and stored in the database, they are visible only under Customers -> Carts until I manually change the order status. Then, they are visible under orders also.

Edited by GezaazY (see edit history)
Link to comment
Share on other sites
dragonfly Newbie

dragonfly

Posted
Posted

Hi,

I have exactly the same problem, caused by the same shit... Same problem with other paymentmoduls.

 

Could there be a problem with the imported backup-data from the old version, have the statuses of the orders changed in 1.4.4.1? How can I see this and how do I fix it?

 

Any ideas anyone??

Link to comment
Share on other sites
GezaazY Newbie

GezaazY

Posted
  • Author
Posted

Hi,

I have exactly the same problem, caused by the same shit... Same problem with other paymentmoduls.

 

Could there be a problem with the imported backup-data from the old version, have the statuses of the orders changed in 1.4.4.1? How can I see this and how do I fix it?

 

Any ideas anyone??

 

 

Have you had any luck with solving your problem?

 

As this issue seems to be in different payment methods, we should start looking at other places, like the order process itself.

 

As I am not a coder and pretty much do not know anything about PHP, I cannot understand anything code related, but I can apply fixes, if someone should suggest one to me.

Link to comment
Share on other sites
  • 2 weeks later...
archipelklaus Newbie

archipelklaus

Posted
Posted
Hi all, Could you please check in your phpMyAdmin if there is the order state configuration variables : SELECT * FROM `ps_configuration` WHERE name LIKE '%_OS_%' If you don't know how to do it, could you send me your phpMyAdmin or ftp access by private message ? Best regards,

 

Bonjour

same problem Fatal error (OrderHistory -> id_order_state is empty)

 

 

answer SQL for SELECT * FROM `ps_configuration` WHERE name LIKE '%_OS_%'

MySQL n'a retourné aucun enregistrement.

 

Klaus

Link to comment
Share on other sites
Fabien Serny Newbie

Fabien Serny

Posted
Posted

Try this :

 

If your module PayPal is not install, please install it and uninstall it.

Then try again the request on PhpMyAdmin.

If there is still no results, please enter this in your phpMyAdmin :

 

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
('PS_OS_CHEQUE', '1', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_PAYMENT', '2', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_PREPARATION', '3', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_SHIPPING', '4', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_DELIVERED', '5', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_CANCELED', '6', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_REFUND', '7', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_ERROR', '8', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_OUTOFSTOCK', '9', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_BANKWIRE', '10', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_PAYPAL', '11', '2011-09-12 15:43:25', '2011-09-12 15:43:25'),
('PS_OS_WS_PAYMENT', '12', '2011-09-12 15:43:25', '2011-09-12 15:43:25');

 

 

But I'm curious, what version of PrestaShop do you have ? Is this an update or a fresh install ?

Did you update your bankwire module or was it the original one ?

 

 

Best regards,

Link to comment
Share on other sites
GezaazY Newbie

GezaazY

Posted
  • Author
Posted

Hi all,

 

Could you please check in your phpMyAdmin if there is the order state configuration variables :

SELECT * FROM `ps_configuration` WHERE name LIKE '%_OS_%'

 

If you don't know how to do it, could you send me your phpMyAdmin or ftp access by private message ?

 

Best regards,

 

 

I ran the query and there are 12 matching rows. The ones starting with PS_OS_ do not have values. The only one that has a value is paypal.

 

Thanks for showing the right direction.

 

Regards

Rauno

Link to comment
Share on other sites
Driven2a Newbie

Driven2a

Posted
Posted

Manually inserted values to the configuration rows and the shop is working again.

 

Thank you very much for pointing me to the right direction, Fabien.

 

 

Regards,

Rauno

 

 

Would anyone care to make a quick guide on how to do this for us newbies out there? Cheers

Link to comment
Share on other sites
superbikecoach Newbie

superbikecoach

Posted
Posted

Hello Fabien

 

thx for taking care.

 

I have the same problem/error after moving my shop to an other hoster, plus i installed the 1.4.4 version (1.4.1 before). Paypal seems to work, but bank and by check not.

i also noticed that all pics are gone. after i set on back up, i was looking like that: http://booking.superbike-coach.com/product.php?id_product=65

Link to comment
Share on other sites
Fabien Serny Newbie

Fabien Serny

Posted
Posted

Hi,

 

This is very strange. When you say that bankwire and cheque are still not working, is this still the same error "id_order_state is invalid" ?

 

When you say, your pictures are gone, do you mean pictures for this menu ?

Coached Tour, group

Youth Coaching

Setup Course

 

You should really contact the support team or search for a developer to help you.

Link to comment
Share on other sites
Fabien Serny Newbie

Fabien Serny

Posted
Posted

In the preferences tab in your back office you can change the quality of your pictures.

For your error, I think this is very strange. Did you take the last version of the module PayPal that I commit (even if PayPal works great on your shop, the version that I post on this topic might fix your problem with your bankwire).

Could you try it ?

 

Best regards,

Link to comment
Share on other sites
Fabien Serny Newbie

Fabien Serny

Posted
Posted

Security header is invalid means your credentials are incorrect.

Did you reinstall the module ? You did not have to do that. Check your credentials API it will solve your problem.

 

Could you send me your back office access by private message ? I don't understand why it did not fix your problem.

Link to comment
Share on other sites
  • 3 weeks later...
kingoftheworld_87 Newbie

kingoftheworld_87

Posted
Posted

Im using cardsave and I have this problem: Fatal error (OrderHistory -> id_order_state is empty)

 

Im no developer and dont really want to fiddle around with the database (theres lots of products loaded and my client wont be happy if Iose everything) is there anyway somebody can tell me how to fix this step by step or log into MyPHP for me? I would be very grateful.

 

Regards,

Alex

Link to comment
Share on other sites
  • 2 years later...
marco989 Newbie

marco989

Posted
Posted (edited)

Hi guys, Fabien,

I have exactly the same problem as originally described Fatal error (OrderHistory -> id_order_state is empty)

 

and here are the details

PS 1.3.6

 

want to:

duplicate the Cheque module and adapt it for other sorts of payments

 

did:

- copied all files from the original Cheque module into a new directory

- renamed the corresponding files and inside the files replaced the variable "Cheque" to the "Newname" 

- uploaded the files into the corresponding map of the modules dir online

- installed the module in back office

- set the new currency and country restrictions ok to correspond to teh new payment method

- inserted a new Order state with a fresh id# (this ID was not visible into teh databse so I had to use the

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES command

- new ID is visible in database now and looks like:

321    PS_OS_NEWPAYMENTMETHOD   26    2013-12-12 15:43:25    2013-12-12 15:43:25

- during cart creation and checkout all works fine

- when clicking on Confirm order (final step) the PS returns the message

Fatal error (OrderHistory -> id_order_state is empty) 

 

and that's it!

 

the product is taken out of the stock but the order is not  process din the back office nor any confirmation mails are sent

 

What do i do wrong????

 

PS: will not update to any new PS version 1.3.6 works just fine for my needs, so tips on "dude, upgrade your PS" will be disregarded.

 

 

 

Hi guys, Fabien,

 

I have exactly the same problem as originally described Fatal error (OrderHistory -> id_order_state is empty)

 

and here are the details

 

PS 1.3.6

 

want to:

duplicate the Cheque module and adapt it for other sorts of payments

 

 

did:

- copied all files from the original Cheque module into a new directory

- renamed the corresponding files and inside the files replaced the variable "Cheque" to the "Newname"

- uploaded the files into the corresponding map of the modules dir online

- installed the module in back office

- set the new currency and country restrictions ok to correspond to the new payment method

- inserted a new Order state with a fresh id# (this ID was not visible into the database so I had to use the

 

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES command

 

- new ID is visible in database now and looks like:

 

PS_OS_NEWPAYMENTMETHOD 26 2013-12-12 15:43:25 2013-12-12 15:43:25

 

- during cart creation and checkout all works fine

 

- when clicking on Confirm order (final step) the PS returns the message

 

Fatal error (OrderHistory -> id_order_state is empty)

 

 

 

and that's it!

 

 

 

the product is taken out of the stock but the order is not process din the back office nor any confirmation mails are sent

 

 

What do i do wrong????

 

 

 

after looking in cheque.php i see

 

 

...

if ($state == _PS_OS_NEWPAYMENTMETHOD_ OR $state == _PS_OS_OUTOFSTOCK_)

$smarty->assign(array(

'total_to_pay' => Tools::displayPrice($params['total_to_pay'], $params['currencyObj'], false, false),

'NEWPAYMENTMETHODName' => $this->NEWPAYMENTMETHODName,

'NEWPAYMENTMETHODAddress' => nl2br2($this->address),

'status' => 'ok',

'id_order' => $params['objOrder']->id

));

else 

$smarty->assign('status', 'failed');

return $this->display(__FILE__, 'payment_return.tpl');

}

....

 

Would changing anything in Orderhistory.php help?

In this file I see loads of id_order_state statements

 

PS: will not update to any new PS version 1.3.6 works just fine for my needs, so tips on "dude, upgrade your PS" will be disregarded.

 

 

 
Edited by marco989 (see edit history)
Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...