Table dosen't exists in the expression editor from

Table dosen't exists in the expression editor from

Dec 01 (4 months ago)
Max wrote
Hello! I'm trying to make SQL in the expression editor like
--
round([CSV_COL(35)]/(SELECT conversion_rate FROM `mh_presta`.`ps_currency` WHERE `iso_code` LIKE 'USD'),0)
--
But it throws an error
--
Error: "Table 'mh_presta.ps_currency' doesn't exist"
--
The database name and table name are correct.
I tried many variants, but still have an error. What is the sintax I must use?
Thank you.
Reply
4 Answers
Avatar image
Dec 03 (4 months ago)
Nadia Bezpalko agent wrote
Thanks for writing to us. As we understood, yu try to convert the price to dollars and round it. We tested on a test store and expression works. https://prnt.sc/vuxapy

The error only reproduces if you enter incorrect table name. Please check the exact table name in your database.
Dec 03 (4 months ago)
Max wrote
Thanx for answer.
Yeah, I'm trying to convert price.
Look at this screens, please:
https://prnt.sc/vv7ol9
https://prnt.sc/vv7lwg
https://prnt.sc/vv7n9p
Avatar image
Dec 07 (4 months ago)
Nadia Bezpalko agent wrote
Thanks for the screenshots. Please try to remove ` from the database and table names. Like this:
round([CSV_COL(35)]/(SELECT conversion_rate FROM mh_presta.ps_currency WHERE iso_code LIKE 'USD'),0)
Dec 14 (4 months ago)
System wrote
Hello,

We haven't heard back from you for last 7 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team