If i click orders - error 500. I set price - PL - polish zloty
Price specification not found for currency: "EUR"
PrestaShop\PrestaShop\Core\Localization\Exception\
LocalizationException
in src/Core/Localization/Locale.php (line 171)
public function getPriceSpecification($currencyCode) { $currencyCode = (string) $currencyCode; $priceSpec = $this->priceSpecifications->get($currencyCode); if (null === $priceSpec) { throw new LocalizationException( 'Price specification not found for currency: "' . $currencyCode . '"' ); } return $priceSpec;
Logs:
Level | Channel | Message
-- | -- | --
DEBUG17:12:35 | doctrine | SELECT name FROM ps_module WHERE active = 1
CRITICAL17:12:35 | php | Uncaught Exception: Price specification not found for currency: "EUR"
CRITICAL17:12:35 | request | Uncaught PHP Exception PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException: "Price specification not found for currency: "EUR"" at /home/sklep.tervel.pl/public_html/src/Core/Localization/Locale.php line 171
Screenshots
https://www.dropbox.com/s/c2msgc18ssvfemm/Zrzut%20ekranu%202019-07-11%2017.18.43.png?dl=0
Additional information
PrestaShop version: 1.7.6.0
PHP version: 7.2.15
Hi @attractive,
Thanks for your report.
What is the exact language/country did you used during the install PS1.7.6.0.
Did added a product to your order which has a specific price as an amount?
In my case, I did not manage to reproduce the issue with PS1.7.6.0
Thanks!
Hi @attractive,
Thanks for your report.
What is the exact language/country did you used during the install PS1.7.6.0.
Did added a product to your order which has a specific price as an amount?
In my case, I did not manage to reproduce the issue with PS1.7.6.0
Thanks!
Sorry, my mistake - if i clik orders in admin panel
@attractive, yes, your issue in the Back.
I need the exact steps to reproduce the issue.
We need more details to understand how we can reproduce your issue:
Thanks!
I have the exact same problem.
I upgraged Prestashop from 1.7.5 to 1.7.6 and everything was smooth, no error during the upgrade
The front end is working, the back end is working but except for the order tab
Each time I click on "Orders" I have an error 500
I put debug mode and now I have:
CRITICAL23:19:00 | php | Uncaught Exception: Price specification not found for currency: ""
-- | -- | --
CRITICAL23:19:00 | request | Uncaught PHP Exception PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException: "Price specification not found for currency: """ at /home/coeurtech/public_html/src/Core/Localization/Locale.php line 171
I have my website in French and using EUR currency
Hello @attractive
Is it a fresh install of PS 1.7.6 or did you make an upgrade ?
@crisnelyn, in my case, I did not manage to reproduce the issue after upgrade from PS1.7.5.2 to PS1.7.6.0 using the 1-click upgrade v4.9.0.
Thanks!
ping @marionf, I think, this issue could be related to this: https://github.com/PrestaShop/PrestaShop/issues/14608
What do you think?
@khouloudbelguith
@crisnelyn, could you please navigate to your BO => International => Localization page => Import the "France" pack, clear cache, check & feedback.
Thanks!
@khouloudbelguith thank you for trying to help me, I did what you asked and I cleared the cache but I am having the same problem
Screenshots with without debug mode:
@attractive, could you please check the table ps_currency
& feedback.
Thanks!
Im having the same issue with multistore - upgrade from 1.7.5.2 to 1.7.6
I can not switch to one store - error 500
@01park, could you please check you also the ps_currency table.
Thanks!
Hi khouloudbelguith,
I don't see anything strange with this
@01park, I think the issue is related to https://github.com/PrestaShop/PrestaShop/issues/14608
THanks!
Hi,
For me I have access to the store again, that gave the error 500. What I did was activate/deactivate EUR in currency. Problem solved
@01park, thanks!
@attractive, can you please try the solution proposed by @01park & check if the issue is solved?
Thanks!
@crisnelyn, could you please try to Disable/Enable the Euro currency & feedback.
And change precision to 2
@khouloudbelguith I cannot Disable/Enable the EUR currency because it is the default currency... What I can do it to add a new currency, make it the default one but then I need to manually edit the price of 6000 products... so it is not feasible
My problem is solved thanks to @01park - I didnt change precision to 2 but I got inspired
I added a new currency "USD" and I disabled it, now there is no error 500, everything is working... very weird, very strange... I keep it like this
I have tried to remove the USD currency but the error 500 comes back, I added another currency again and the error disappeared...
now it looks like that
@attractive, any news?
Thanks!
crisnelyn , the reason I changed the persion to 2 is in my dashboard and stats some numbers also had 6 decimals, by editing this to 2 this was solved.
I have a multistore with several subdomains
each subdomain has a separate currency and language
When I make an upgade from 1.7.5.2 to 1.7.6.0 I have an error
|
Uncaught Exception: Price specification not found for currency: ""
Uncaught PHP Exception PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException: "Price specification not found for currency: """ at /usr/home/xxx/domains/xxx/public_html/src/Core/Localization/Locale.php line 171
xxx - is my login and domain
Does anyone have a solution to this problem?
Hi @presciak,
Did you try to change the precision to 2
in your table ps_currency
?
Thanks!
Hi,
Delete all rows with id_currency
== 1 from ps_orders
Did you try to change the precision to
2
in your table
I try activate/deactivate currency
I also completed the iso code
unfortunately did not help
I returned to 1.7.5.2
he will try again on the weekend
@presciak, thanks
Waiting for your feedback.
Hi,
Delete all rows withid_currency
== 1 fromps_orders
This worked. Thank you @rednour
Hi @attractive,
Any news about your issue?
Thanks!
Did you try to change the precision to
2
in your table
I try activate/deactivate currency
I also completed the iso code
unfortunately did not help
I returned to 1.7.5.2
he will try again on the weekend
Hi,
Delete all rows withid_currency
== 1 fromps_orders
This worked. Thank you @rednour
If you'll do it then the currency will not remove the already existing orders?
@presciak, before deleting from the database, you need to make a backup.
Thanks!
Solución temporal: Se me presentaba el mismo problema descrito anteriormente, en mi caso la tienda solo usa la moneda COP y había eliminado todas las monedas. Después de validar encontré que en el carrito estaban los datos de demo que incluían carritos que habían sido llenados con la moneda USD: La solución temporal fue ir Internacional -> Localización -> Monedas y agregar la moneda que me generaba el error. Posteriormente pude acceder al carrito de compra en Pedidos y elimine los carritos con la moneda USD y pude volver a quitar la moneda y se soluciono el inconveniente.
Hi @geengome,
Please, send your request in English.
English is the norm on this bug tracker.
Thank you!
I'm not sure, but error "Price specification not found for currency: "EUR" shows when switching to multistore. I have to correct ps_currency_shop manually by adding currency to in my case second store... which helped
I changed the precision to 2 in ps_currency - it did not help
I changed all rows with id_currency = 1 to 9 in ps_orders - it did not help
I removed all rows with id_currency = 9 in ps_orders - it did not help
I still have the same problem.
Did someone solve this problem?
`
*CRITICAL 00:30:10 | php | Uncaught Exception: Price specification not found for currency: ""
-- | -- | --
CRITICAL 00:30:10 | request | Uncaught PHP Exception PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException: "Price specification not found for currency: """ at /usr/home/xxx/domains/xxx/public_html/src/Core/Localization/Locale.php line 171*
`
xxx - is my login and domain
@presciak, before deleting from the database, you need to make a backup.
Thanks!
Hi @presciak,
The only issue reproduced is this https://github.com/PrestaShop/PrestaShop/issues/14908 which is reported on the suppliers page.
Thanks to check & feedback.
@khouloudbelguith Hi, I have the same issue as described by @attractive - when I click on order tab, error like displayed above appears. I successful upgraded from ps 1.7.5.2 to 1.7.6 using 1-click v4.9.0. When i noticed the issue I contacted my webhost, but they couldn't find any problem. I searched for solution and saw your discussion on #14595, #14608, #14908. I tried the solutions provided but none of them could solve my issue. i don't know if you have other solution for that at this point. However, I just want to put it on the record that people like me are having the same issue.
Thanks
Hi @geengome,
Please, send your request in English.
English is the norm on this bug tracker.
Thank you!
Sorry, my English is not very good. Workaround: I was presented with the same problem described above, in my case the store only uses the COP currency and had eliminated all the coins. After validating I found that in the cart were demo data that included carts that had been filled with the USD currency: The temporary solution was to go International -> Location -> Coins and add the currency that generated the error. Later I was able to access the shopping cart in Orders and delete the carts with the USD currency and I could remove the currency again and the inconvenience was solved.
@geengome, thanks for your feedback.
In fact, In my case, before doing an upgrade from PS1.7.5.1 to PS1.7.6.0, I tried to create some orders with different currencies Euro & Dollar & I tried to add some products to the cart with a different currency.
I make the upgrade with the 1-click upgrade v4.9.0 => OK
I check the Order page & the Shopping cart page => OK.
https://drive.google.com/file/d/1dlZEdabX9wU3hGOaO--fXP7k4IJ6k6yv/view
Thanks!
Yes, I have 1-click upgrade v4.9.0
I turned off PayPal and other payment modules before upgrading
1-click upgrade v4.9.0 showed a correctly completed update
(screen)
when I try to log in to the store panel I have the message
"Oops! An Error Occurred
The server returned a "500 Internal Server Error".
In debug mode, I have the message:
CRITICAL 23:27:25 php Uncaught Exception: Price specification not found for currency: ""
CRITICAL 23:27:25 request Uncaught PHP Exception PrestaShop \ PrestaShop \ Core \ Localization \ Exception \ LocalizationException: "Price specification not found for currency:" "" at / usr / home / xxx / domains / xxx / public_html / src / Core /Localization/Locale.php line 171
xxx - is my login and domain
I also attach the update log
I have a multistore with 4 stores
each store has own domain and one currency
for example,
store 1 - PLN
store 2 - EUR
store 3 - GBP
store 4 - USD
my database after upgrading from 1.7.5.2 to 1.7.6.0
Hi
Have some problem!
Upgrade from 1.7.5 to 1.7.6 with 1-click upgrade - OK
Everything tested and working (offline mode)
When got live - Template monster theme - module 1clickorder show this error in BO (Front everything ok)
PHP any php version doesn´t work
DB print attached
Default currency EUR
Default language PT
Activate other languages and currency doens´t change or put it to work
Is this as something to do?
Customer default payment
Currency default store
They have no checkbox, and can´t find how to do (if possible)
@presciak
I had the same issue with a module from Templatemonster as explain above. (module is Jx 1 click order)
The issue is i have already ps_currency with precision=2 and still got error 500.
So, i inicialize the module again, delete var/cache/prod in file manager and seems problem solved
Hi @attractive,
Does your problem is solved?
@mariem-abid
Can you confirm this:
prestashop 1.7.6 not compatible with php 7.2 7.3
Because @attractive is using php 7.2
Maybe downgrade php version will solve no?
@Borgas, PrestaShop 1.7.0 to 1.7.3 is compatible with PHP 7.1 and PrestaShop 1.7.4 & 1.7.5 are compatible with PHP 7.2.
For more details, you can follow this link: http://build.prestashop.com/news/prestashop-1-7-is-moving-to-symfony-3-4-and-php-5-6/
Next minor release PS1.7.7 will be compatible with PHP7.3.
The error is on the default graphic template.
I removed cash from var / cache / prod - didn't help
I changed the php version to 7.1 - did not help
The front office is working properly.
I have the same issue: Price specification not found for currency: "GBP".
This is from a completely fresh 1.7.6 install, yesterday. Today I enabled multishop and on the BO dashboard I select to view 1 shop only and this I get this exception.
I've tried going into the database and changing the default currency to USD, this just changes the exception to: Price specification not found for currency: "USD".
I have now been able to delete the secondary store and normal service has resumed....
The problem is that the currency is not shared with other stores
@khouloudbelguith Could you try to reproduce it with the last informations provided ?
Hi @marionf,
Yes, when multistore is enabled & the currency is not shared with other stores => issue reproduced.
Steps to reproduce the issue:
EUR
GBP
EUR
is associated with the first shop onlyGBP
is associated with the second shop onlyWith PS1.7.5.2 => OK
Related to #15144.
Same error on ps 1.7.6 new install after enable new store.
ITs no possible, there is no way to have a working ps
[2019-08-23 13:53:19] request.CRITICAL: Uncaught PHP Exception PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException: "Price specification not found for currency: "EUR"" at /var/www/htdocs/www.pineappleitaly.com/store/src/Core/Localization/Locale.php line 171 {"exception":"[object] (PrestaShop\PrestaShop\Core\Localization\Exception\LocalizationException(code: 0): Price specification not found for currency: \"EUR\" at /var/www/htdocs/www.pineappleitaly.com/store/src/Core/Localization/Locale.php:171)"} []
@matteolavaggi, this issue is fixed in the PS1.7.6.1.
Thanks!
I've just ask , but where is explained a secure way to update 1.7.6.0 to
1.7.6.1 ?
Il giorno ven 23 ago 2019 alle ore 14:02 khouloudbelguith <
[email protected]> ha scritto:
@matteolavaggi https://github.com/matteolavaggi, this issue is fixed in
the PS1.7.6.1.
Thanks!—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/PrestaShop/PrestaShop/issues/14595?email_source=notifications&email_token=AF5GL3YMJVNBNX7VDT55VT3QF7GTVA5CNFSM4IBKK76KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5AAJTY#issuecomment-524289231,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AF5GL36NGR4K6RKNUOJZFK3QF7GTVANCNFSM4IBKK76A
.
--
cordialmente,
FATTURAZIONE ELETTRONICA B2B
Il nostro codice destinatario (alcuni lo chiamano “codice SDI”) è il
seguente: M5UXCR1
Matteo Lavaggi
CEO
ufficio +390245071999
[image: PrestaShop]
www.pineappleitaly.com/pineapplegroup
PINEAPPLE® S.r.l.
Capitale sociale €100.000 i.v.
SL: Galleria C.so Garibaldi 16-18, 16043 Chiavari (GE) Italy
P.I./C.F.(VAT REG): IT01953500996 REA 447687 CCIAA di GENOVA
Full contacts: www.pineappleitaly.com/contatti
The information contained in this message is intended only for use of the
individual(s) named above and may contain confidential, proprietary or
legally privileged information. No confidentiality or privilege is waived
or lost by any mistransmission. If you are not the intended recipient of
this message you are hereby notified that you must not use, disseminate,
copy it in any form or take any action in reliance of it. If you have
received this message in error please delete it and any copies of it and
notify the sender immediately.
the store is a multisite with 4 domains
I made updates from 1.7.5.2 to 1.7.6.1
Unfortunately, I still have a 500 error after logging in to the store panel
version php7.1
the update was successful
however, I found in the update logs:
[OK] SQL 1.7.6.1 SET SESSION sql_mode = ''<\/div>","
[OK] SQL 1.7.6.1 SET NAMES 'utf8'<\/div>","
[OK] PHP 1.7.6.1 : \/* PHP:ps_1761_update_currencies(); *\/<\/div>"],"nextErrors":["[INTERNAL] \/usr\/home\/xxx\/domains\/xxx\/public_html\/vendor\/symfony\/symfony\/src\/Symfony\/Component\/Console\/Terminal.php line 127 - proc_open() has been disabled for security reasons","[INTERNAL] \/usr\/home\/xxx\/domains\/xxx\/public_html\/vendor\/symfony\/symfony\/src\/Symfony\/Component\/Console\/Terminal.php line 127 - Symfony\Component\Debug\Exception\FatalErrorException: Error: proc_open() has been disabled for security reasons\n#0 {main}"],"error":true,"next":"error"}"
in the php logs after the update I found it:
`[02-Sep-2019 22:56:46 Europe/Warsaw] PHP Fatal error: require(): Failed opening required '/usr/home/xxx/domains/xxx/public_html/vendor/composer/../markbaker/matrix/classes/src/functions/adjoint.php' (include_path='/usr/home/xxx/domains/xxx/public_html/vendor/pear/pear_exception:/usr/home/xxx/domains/xxx/public_html/vendor/pear/console_getopt:/usr/home/xxx/domains/xxx/public_html/vendor/pear/pear-core-minimal/src:/usr/home/xxx/domains/xxx/public_html/vendor/pear/archive_tar:.:/usr/local/share/pear') in /usr/home/xxx/domains/xxx/public_html/vendor/composer/autoload_real.php on line 61
[02-Sep-2019 22:57:16 Europe/Paris] PHP Fatal error: proc_open() has been disabled for security reasons in /usr/home/xxx/domains/xxx/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Terminal.php on line 127`
xxx - is my login and domain
any solution?
Hi @presciak,
This issue is currently closed, can you open a new one with more information about your configuration.
This issue is fixed in the PS1.7.6.1, Please Create a new issue about your problem to understand how to reproduce the issue.
Thanks!
Hi @Khouloudbelguith
I also upgraded to PS 1.7.6.1, unfortunately the problem was not corrected.
I was hoping this upgrade would solve the issue.
Thanks
On Tue, 3 Sep 2019 at 10:09, khouloudbelguith notifications@github.com
wrote:
Hi @presciak https://github.com/presciak,
This issue is currently closed, can you open a new one with more
information about your configuration.
This issue is fixed in the PS1.7.6.1, Please Create a new issue about your
problem to understand how to reproduce the issue.
Thanks!—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/PrestaShop/PrestaShop/issues/14595?email_source=notifications&email_token=AJRNIB2CSRKWRXED6YLWY5DQHYLUFA5CNFSM4IBKK76KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5XMJLA#issuecomment-527353004,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AJRNIB57ZFZPOPVNHM6TF7LQHYLUFANCNFSM4IBKK76A
.
--
Joel Nwafor
Procurement Manager
www.kisshoes.ch
@Kis-shoes, @presciak, Issue created here https://github.com/PrestaShop/PrestaShop/issues/15376
Please follow this ticket & provide me the exact information to understand how to reproduce the issue.
Thanks!
This problem is solved with the fix #15173
You can see the corrected files and upload them to your server. I did this before 1.7.6.1 was released and it worked perfect.
Also don't forget to clean browser history and cache files in prestashop.
I activated USD and it was working i think maybe as the demo orders are in USD devise maybe it cause problem ? but i could be great to delete thoses demo datas
There might by a problem after migration or something. It doesn't have to be a presta problem. You can check in your database the table ps_orders if the column id_currency match IDs in ps_currency table.
it was present and i made no migration , just new fresh installation but my workaround worked, activate USD then deactivated
I can't update my presta correctly in a multistore (many currencies and many languages)
PHP version 7.2
Prestashop 1.7.5.2
I have disabled all modules not from prestashop
I have updated 1 clik update to the latest version.
The update process has passed correctly. No error showed up. Everything went fine.
After updating, I have login to backoffice
When I do this, I get an error 500 (when I tried the update before it was a clean white page)
In debug mode I have:
php Uncaught Exception: Price specification not found for currency: ""
request "Price specification not found for currency:" "" at /xxx/xxx/xxx/xxx/xxx/public_html/src/Core/Localization/Locale.php line 171
I tried to enable and disable currencies in turn in databases - it also did not help
does anyone know how to fix it?
any suggestions for solutions?
Hi @presciak,
What is the exact version did you use after the upgrade? PS1.7.6.1? or PS1.7.6.2?
What is the exact version of the 1-click upgrade did you use? 4.10.0?
Thanks!
For me when i add this problem i deleted USD.. os i reinstalled it, activated it, then put first EURO, then deactivated USD, and deletetion. and it was ok.
Maybe it installed some test orders or some data linked to the currency not available.... but i am sure it is nothing really "blocking" if you reinstall USD (it is the base currency used with orders tests)
@khouloudbelguith your very active it is very great !
@khouloudbelguith, thanks for your feedback.
In fact, yes, you are right, there is a workaround to fix this issue.
But those issues are fixed partially in PS1.7.6.1 & totally in PS 1.7.6.2.
PRs to fix those issues:
Thanks!
Hi @presciak,
What is the exact version did you use after the upgrade? PS1.7.6.1? or PS1.7.6.2?
What is the exact version of the 1-click upgrade did you use? 4.10.0?Thanks!
My PS is 1.7.5.2
before upgrade prestashop i did update to 4.10.0
For me when i add this problem i deleted USD.. os i reinstalled it, activated it, then put first EURO, then deactivated USD, and deletetion. and it was ok.
Maybe it installed some test orders or some data linked to the currency not available.... but i am sure it is nothing really "blocking" if you reinstall USD (it is the base currency used with orders tests)
@khouloudbelguith your very active it is very great !
I have many currencies
I have already tried to turn currencies on and off in various ways
I left only dollars or only Euro
nothing helped
@khouloudbelguith, thanks for your feedback.
In fact, yes, you are right, there is a workaround to fix this issue.
But those issues are fixed partially in PS1.7.6.1 & totally in PS 1.7.6.2.
PRs to fix those issues:* #15643 * #15173 * #15036
Thanks!
I tried to update to version 1.7.6.0 and 1.7.6.1 as well as 1.7.6.2
each time the update process proceeded correctly
in versions 1760 and 1761 after logging into the panel there was a white screen
in version 1762 it shows me error 500 right away
@presciak,
We need to retrieve the PHP error log and the debug mode report in order to find out what's wrong.
If you can’t access your dashboard, you can still enable the Debug Move using an FTP client (for instance the free Filezilla tool) to edit the config/defines.inc.php file. Find the following line in the file:
define('_PS_MODE_DEV_', false);
… and change it to:
define('_PS_MODE_DEV_', true);
Could you please try to clear cache manually by deleting all the folder into var/cache (prod & dev).
Thanks to check and feedback.
@presciak,
We need to retrieve the PHP error log and the debug mode report in order to find out what's wrong.
If you can’t access your dashboard, you can still enable the Debug Move using an FTP client (for instance the free Filezilla tool) to edit the config/defines.inc.php file. Find the following line in the file:
define('_PS_MODE_DEV_', false);
… and change it to:
define('_PS_MODE_DEV_', true);
Could you please try to clear cache manually by deleting all the folder into var/cache (prod & dev).
Thanks to check and feedback.
I don't have access to the dashboard
What I sent is from debug mode
I turned on PHP exec () before upgrading
In the store I sometimes have one currency assigned to many countries. for example,
Spain and Slovakia have Euro, but they have completely different subdomains.
Hi @presciak,
As I can see in your log file.
You have an issue similar to this ticket: https://github.com/PrestaShop/PrestaShop/issues/15503#issue-492425592
It is a module's issue.
Thanks!
I see the php_error link on my post
[04-Dec-2019 20:38:49 Europe/Warsaw] PHP Fatal error: Uncaught Exception: Kernel Container is not available in /usr/home/xxx/domains/xxx/public_html/src/Adapter/ContainerFinder.php:77
Stack trace:0 /usr/home/xxx/domains/xxx/public_html/classes/Tools.php(796): PrestaShop\PrestaShop\Adapter\ContainerFinder->getContainer()
1 /usr/home/xxx/domains/xxx/public_html/classes/Tools.php(773): ToolsCore::getContextLocale(Object(Context))
2 /usr/home/xxx/domains/xxx/public_html/classes/Notification.php(133): ToolsCore::displayPrice(184, Object(Currency), false)
3 /usr/home/xxx/domains/xxx/public_html/classes/Notification.php(57): NotificationCore::getLastElementsIdsByType('order', NULL)
4 /usr/home/xxx/domains/xxx/public_html/admin682ue96wo/ajax.php(125): NotificationCore->getLastElements()
5 {main}
thrown in /usr/home/xxx/domains/xxx/public_html/src/Adapter/ContainerFinder.php on line 77
When I make updates, I disable all modules not from prestashop (remove from ftp)
@presciak, thanks to provide me a screenshot about your table ps_currency.
Thanks!
@presciak, this table is from a previous version PS1.7.5
It is not a table from PS1.7.6
What is your exact ps version?
Thanks!
I cannot access the back office after the upgrade.
I can't do anything about it yet.
The photo is from PHPMyAdmin from version 1752
I am working on a test domain to create the problem again. I can't have my shop turned off during the holiday season
@presciak, thank you!
This issue is currently closed, can you open a new one with more information about your new configuration & after the new test.
Thanks!
Hi,
Delete all rows withid_currency
== 1 fromps_orders
This worked. Thank you @rednour
This has worked for me but in my case currency ID 1 is the main one. I have deleted all old orders (orders from 2018) with different currencies (ID 4, ID 6) in ps_orders.
Most helpful comment
@khouloudbelguith I cannot Disable/Enable the EUR currency because it is the default currency... What I can do it to add a new currency, make it the default one but then I need to manually edit the price of 6000 products... so it is not feasible
My problem is solved thanks to @01park - I didnt change precision to 2 but I got inspired
I added a new currency "USD" and I disabled it, now there is no error 500, everything is working... very weird, very strange... I keep it like this
I have tried to remove the USD currency but the error 500 comes back, I added another currency again and the error disappeared...
now it looks like that