Support is offline. We are back Monday 16 November, 09:00.

Unknown column 'currency' in 'field list' #80306

Resolved hoks opened this topic Tuesday, 21 May 2024 · 2 replies
Author

Hello,

After installing i have a error Unknown column 'currency' in 'field list'. And maybe related, when going to Transactions, the page gives a error (translated from dutch: The page does not redirect properly) url=https://www.domainname.com/administrator/index.php?option=com_jdidealgateway&view=logs

How to solve?

Joomla 5.0.1, Hikashop Business 5.0.4, ROpayment 8.4.0

Regards Michel

Support

Hello Michel,

So when you installed RO Payments it looks like there were some old tables still in the database. If you have no data to preserve from the RO Payments installation the cleanest way is to uninstall RO Payments and then remove all tables that contain _jdidealgateway. After that do a clean installation, the error should no longer be there.

If you have data to preserve, you will have to modify the database manually. In your website look for the file administrator/components/com_ropayments/sql/install/install.sql. In that file you can find the database table definitions. The field you are missing is from the jdidealgateway_logs table. However I suspect there may be more missing if this is also missing.

The currency field was added in RO Payments 4.11, so that is quite a long time ago ;)

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thank you, must be a install from the previous admin. De-installed all, and error is gone.
Regards Michel

Log in to reply to this topic.