Post by francy88 » Mon Jan 26, 2009 10:44 pm

hi,
I found an error after paypal transaction, if I use opencart in Italian language.
After paypal redirect, this error appears:

Configuration error: Store owner needs to create an order status for "Paid Unconfirmed" for every installed language. The following sql statement returned no rows and must cease select `order_status_id` from `order_status` where `name` = 'order_status_paid_unconfirmed' and `language_id` = '1'

Then I opened the table "order_status", and I saw that there is no row with "order_status_paid_unconfirmed", but this order status is called "Paid Unconfirmed"!!
I edited this field, changing "Paid Unconfirmed" with "order_status_paid_unconfirmed", and then all works perfectly.
Under "admin-->configuration-->localisation-->order status", the name of payment status is changed in "order_status_paid_unconfirmed".
The real problem should be in the query in the page "paypal.php"?

thanks
Last edited by francy88 on Mon Jan 26, 2009 11:26 pm, edited 1 time in total.

Newbie

Posts

Joined
Wed Jan 21, 2009 12:10 am

Post by francy88 » Mon Jan 26, 2009 11:26 pm

OK, I resolve this issue!!
My opencart version is 0.7.9, I don't know if this is a version problem or not...

Then, you must open the file : "/catalog/language/YOUR-NOT-ENGLISH-LANGUAGE/extension/payment/paypal.php", and paste this code:

Code: Select all

$_['order_status_paid_unconfirmed'] = 'Paid Unconfirmed';
$_['order_status_pending'] = 'Pending';
after that, the redirect on your non-english language works perfectly!  ;)

ciao!!

Newbie

Posts

Joined
Wed Jan 21, 2009 12:10 am

Post by Qphoria » Mon Jan 26, 2009 11:32 pm

Configuration error: Store owner needs to create an order status for "Paid Unconfirmed" for every installed language.

You need to change "Paid Unconfirmed" back for english and then for Italian you need to:
- translate the english paypal language file to italian and place it in: catalog/language/italian/extension/payment/paypal.php
- Edit the order status of "Paid Unconfirmed" to add the italian version to the "italian" tab. This value should match what you translated to in the paypal language file.



There is probably a better way to do it in the paypal module so that this isn't an issue.. I'll think about it

-edit- I see you figured it out above.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bruce » Tue Jan 27, 2009 7:38 am

Qphoria wrote: There is probably a better way to do it in the paypal module so that this isn't an issue.. I'll think about it
There is.

I have attached it to this post. Have a look at the admin part which uses dropdowns to select the status values. They end up associated with the actual order status ID instead of using text and translations. There are people using this package but I never bothered to put it in the contributions section because you guys were planning so many changes.

Written for opencart 0.7.7 and not compatible with any other

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by Qphoria » Tue Jan 27, 2009 7:59 am

eh.. paypal's improved quite a bit since that version.
I think there is still a better way than that method

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 8 guests