Can't access orders page **SOLVED**

[Track]

Good afternoon everyone.

Out of nowhere I am now getting this error

Oops... looks like an unexpected error occurred.

Price specification not found for currency: ""

[PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException 0]

Nothing has been changed. Nothing has been touched. It was working fine earlier but now when I log in to check the orders, I'm confronted with this and no access to the order page.

Prestashop version 1.7.8.9

Classic Version 1.0.0

PHP version: 8.1.31

 

 

 

 

 

Edited March 27 by Track
Adding prestashop version, theme and PHP. (see edit history)

[Track]

I've got a little bit more information to assist with this.

You only get this error when you try and access the oldest page by pressing Orders - Orders.

You can still see the orders by clicking on the bell icon and accessing them that way.

You can also see the last 10 most recent orders when you Scroll down the dashboard page.

 

[Prestashop Addict]

Please can you specify PS, PHP and theme versions

[Track]

1 hour ago, Prestashop Addict said:

Please can you specify PS, PHP and theme versions

original post edited to contain relevant information.

 

 

[Track]

After doing a little bit of digging last night, I had a look in ps_orders and found that in id_currency, the first 5 listings had a value of zero, whereas everything from then on has a value of 1

Those first five listings seem to be sample data from the fresh install/ migration from prestashop 1.6

If I edit those first five listings within ps_orders, to have a value of 1, will it upset anything? 

 

[Prestashop Addict]

Your actual PHP version is not supported by your PS version. You should downgrade to PHP 7.4
 

[QuickUpdate.net]

"Those first five listings seem to be sample data from the fresh install/ migration from prestashop 1.6" - why not delete them if they cause problems?

Also if it is a migration then there are more issues that can popup.

[Track]

1 hour ago, Prestashop Addict said:

Your actual PHP version is not supported by your PS version. You should downgrade to PHP 7.4
 

Thanks for that.

For some reason there aren't any options within my C panel to downgrade from 8.0 so I'll have to get in touch with the hosting provider.

However, after changing the currency_id number for the sample orders that I found, from 0 to 1, I now have regained access to my orders page.

It just seems extremely weird that it's taken over two years for it to be upset by this.

Thanks again for pointing the PHP thing out.

 

[Track]

1 hour ago, QuickUpdate.net said:

"Those first five listings seem to be sample data from the fresh install/ migration from prestashop 1.6" - why not delete them if they cause problems?

Also if it is a migration then there are more issues that can popup.

Because I'm a reluctant enthusiast when it comes to this, I only do things when I really have to. The thought of deleting things gives me palpitations, haha.

I've just changed the currency_id number from 0 to 1 for those 5 listings and have regained access to the orders page.

[Track]

@Prestashop Addict If I ask my hosting provider to put us on PHP version 7.4, will it be as straightforward as that? 

Just to be clear -  I'm concerned that by asking them to do this, I'll put the shop offline, if other things need changing in Prestashop to suit PHP 7.4

 

 

[QuickUpdate.net]

"If I ask my hosting provider to put us on PHP version 7.4, will it be as straightforward as that? " - there are hosting providers that allow changing the PHP version even from the cPanel by the site owners.

Edited March 26 by QuickUpdate.net (see edit history)

[Track]

16 minutes ago, QuickUpdate.net said:

"If I ask my hosting provider to put us on PHP version 7.4, will it be as straightforward as that? " - there are hosting providers that allow changing the PHP version even from the cPanel by the site owners.

Thanks for the response. I've already been into my C panel but the only option available is native 8.0. 

The drop down box where you would usually find the versions preceding that is blank.

If it had just been a case of clicking on another version and giving it a try, then changing it back if it didn't work, I'd have already done it. But getting someone else involved, who may not be around to quickly click it back if it doesn't work could be problematic.

[Track]

For the benefit of the search function here's a summary-

The cause of the problem was sample data from when I installed prestashop 1.6 way back in 2016. 

I paid someone to migrate the site to 1.7 back in 2023 and this sample data was carried across. For whatever reason, about 20 months later, access to the orders page in the back office stopped working.

The sample orders data had a currency ID of 0. My shop currency has an ID of 1 and Prestashop took exception all this time later.

I went into C panel - phpmyadmin - ps_orders - id_currency and altered orders showing a currency ID value of 0 to 1. This restored access to the orders page in the back office. I'm probably going to go back in and delete the sample data, in the hope that it may solve other checkout problems that we're having.

Reference my PHP version - I was wrong. I went into C panel but mistakenly read the version of the server the I'm on. My version of PHP was in the multi PHP section. I also learned that if you put /info.php after your domain address, it will give you full details of your PHP and more. I was on PHP 7.4 after all.