Suitecrm8: Error occurred while fetching metadata

English Language - Forum šŸ“¦ Install & Upgrade Help
21

This is what I see in suitecrm.log after runnign the diagnostic tool:

Thu Nov  3 15:43:09 2022 [371565][1][FATAL] Mysqli_query failed.
Thu Nov  3 15:43:09 2022 [371565][1][FATAL]  Query Failed: SELECT favorites.*
                  FROM favorites
                  JOIN config ON ( config.id = favorites.parent_id )
                  WHERE favorites.assigned_user_id = '1'
                    AND favorites.parent_type = 'Administration'
                    AND favorites.deleted = 0
                    AND config.deleted = 0
                  ORDER BY favorites.date_entered DESC LIMIT 0,10: MySQL error 1054: Unknown column 'config.deleted' in 'where clause'
Thu Nov  3 15:43:38 2022 [371566][1][FATAL] Mysqli_query failed.
Thu Nov  3 15:43:38 2022 [371566][1][FATAL]  Query Failed: DESCRIBE versions: MySQL error 1146: Table 'suitecrm.versions' doesn't exist
Thu Nov  3 15:43:38 2022 [371566][1][FATAL] Mysqli_query failed.
Thu Nov  3 15:43:38 2022 [371566][1][FATAL]  Query Failed: SHOW INDEX FROM versions: MySQL error 1146: Table 'suitecrm.versions' doesn't exist
Thu Nov  3 15:43:38 2022 [371566][1][FATAL] Mysqli_query failed.
Thu Nov  3 15:43:38 2022 [371566][1][FATAL]  Query Failed: select * from versions: MySQL error 1146: Table 'suitecrm.versions' doesn't exist
22

I just noticed that if I activate form the Administration panel the ā€œDeveloper modeā€, the issue seems to be solved.
Does it makes sense?

23

That might have cleared some cached templates. If that was the case, then you were just having a transitory problem.

Letā€™s hope it doesnā€™t show up againā€¦

24

Hi, please can somebody adviseā€¦we are running version 8.2.0 of SuiteCRM in a Bitnami container and cannot access Admin (get error ā€œerror occured while fetching metadataā€ when trying to). Having read through this thread I thought we may be using an unsupported version of PHP. The CLI version is PHP 8.1.16 (cli) (built: Feb 20 2023 19:03:07). One of the comments says to also check the web server version (Admin ā†’ Diagnostic ā†’ phpinfo), but we cannot access Admin to do this. Is there another way to get this info? Obviously the PHP version is packaged in the bitnami container anyway so surely this should be a compatible version? Can anyone help? Iā€™m a marketing person with very little technical knowledge so hopefully my question makes sense!