railer
Member
Greetings!
I am attempting to upgrade a Joomla 3.9.19 site from Fabrik 3.8.1 to 3.9.2. PHP is 7.3.23. MySQL 5.6.47.
When updating the component via Extensions/Updates I get the following error in the backend:
JInstaller: :Install: Error SQL Unknown column 'table_id' in '#__fabrik_joins'
Extension Update: SQL error processing query: DB function failed with error number 1054
Unknown column 'table_id' in '#__fabrik_joins'
SQL =
ALTER TABLE `#__fabrik_joins` CHANGE `table_id` `list_id` INT( 6 ) NOT NULL;
Trying to install the package file also fails.
The extensions update list still displays the component but the versions are both 3.9.2.
I read in other forums, the following:
1. Fabrik could be trying to install an old SQL file.
2. Fabrik 3.0 to 3.5 was a major upgrade (is 3.8.1 to 3.9.2 considered a major upgrade?)
How do I resolve this? I tried to run the alter table query above and it failed because the table doesn't exist.
Should I do the upgrades of all the other modules and plugins? (The original installation was the Kitchen Sink version.)
I am attempting to upgrade a Joomla 3.9.19 site from Fabrik 3.8.1 to 3.9.2. PHP is 7.3.23. MySQL 5.6.47.
When updating the component via Extensions/Updates I get the following error in the backend:
JInstaller: :Install: Error SQL Unknown column 'table_id' in '#__fabrik_joins'
Extension Update: SQL error processing query: DB function failed with error number 1054
Unknown column 'table_id' in '#__fabrik_joins'
SQL =
ALTER TABLE `#__fabrik_joins` CHANGE `table_id` `list_id` INT( 6 ) NOT NULL;
Trying to install the package file also fails.
The extensions update list still displays the component but the versions are both 3.9.2.
I read in other forums, the following:
1. Fabrik could be trying to install an old SQL file.
2. Fabrik 3.0 to 3.5 was a major upgrade (is 3.8.1 to 3.9.2 considered a major upgrade?)
How do I resolve this? I tried to run the alter table query above and it failed because the table doesn't exist.
Should I do the upgrades of all the other modules and plugins? (The original installation was the Kitchen Sink version.)