1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    Dismiss Notice

Upgrade from 3.9 to 3.10 (partially) fails

Discussion in 'Community' started by railer, Sep 23, 2021.

  1. railer

    railer Member

    Level: Community
    Trying to upgrade from Fabrik 3.9 to 3.10 and am getting the following error, which I also got when trying to install it:

    Warning
    JFolder: :delete: Path is not a folder. Path: /var/www/vhosts/account.com/components/com_fabrik/fabrikfeed
    JFolder: :delete: Path is not a folder. Path: /var/www/vhosts/account.com/components/com_fabrik/pdf
    JFolder: :delete: Path is not a folder. Path: /var/www/vhosts/account.com/components/com_fabrik/partial
    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;

    Package Install: There was an error installing an extension: com_fabrik_3.10.zip
    Error

    ------- Your Thoughts? In the Extensions/Update, it shows the version number as 3.10. Site is Joomla 3.10.2, all other Fabrik plugins updated fine.
     
  2. p38

    p38 Active Member

    Level: Community
    I get the same error

    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;
     
  3. troester

    troester Well-Known Member Staff Member

    Level: Community
  4. railer

    railer Member

    Level: Community
    Thanks for your reply, Troester.

    The extension ID is 844, but there isn't a record for it in #_schemas.
    Your thoughts?

    Do you think I should try re-installing Fabrik 3.10? That "mysteriously" solved the user's problem in your link.
     
  5. troester

    troester Well-Known Member Staff Member

    Level: Community
    If you did a Joomla update you can try to download and re-install Fabrik3.10. It shouldn't make any difference, but it's a "mystic" error, so maybe a "mystic" solution.
    You can also do a GitHub update to get the lastest version (but this is only updating the files so probably you'll see the same error with the next regular Update via Joomla).
     
  6. p38

    p38 Active Member

    Level: Community
    What I did was to delete the offending SQL statement in 3.0.9 sql file and subsequent versions until there were no more install errors.

    WHat should actually occur is that it should check first if the field column to rename does in fact exist.

    In my case it did not exist, so I deleted the statement in the update file before installing again.
     
  7. troester

    troester Well-Known Member Staff Member

    Level: Community
    Yup, but therefor you must modify the zip.
    I think these old SQL files shouldn't be longer in the package at all. If somebody is trying to do an "update" from Fabrik3.0 (or even Fabrik2) via Joomla updater now the database structure won't be the only problem.
     
  8. railer

    railer Member

    Level: Community
    Thanks Troester! I'll give it a shot.
     

Share This Page