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
-
hoks
- RO Payments
- Tuesday, 21 May 2024
- Subscribe via email
Accepted Answer
Pending Moderation
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
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory