And can you confirm if manually applying the fix gets it working?
https://github.com/salesagility/SuiteCRM-Core/pull/239/files
Confirmed. I did the fix you posted on github, delete one line, add 3 lines and it worked after that without the problem.
Hi,
I also facing this error when Doing repair and rebuild:
/suitecrm.log
Fri Jun 30 06:51:32 2023 [583][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’
No menubar after done repair and rebuild process
I also did changes that you posted on github, delete one line, add 3 lines and even though problem not fixed
pls someone say why this issue generate @pgr
1 Like
I see this issue as well and I am fixing it in my environment once by one.
My error shows MySQL error 1054: Unknown column ‘config.id’ in ‘on clause’
Update : Added the Id field to the config table and the issue is resolved.
As I am new to the echosystem, not sure if this change in table will prevent me from upgrading .
v8.3.1 fixes this problem for me. If you upgrade, your fix will be wiped but the v8.3.1 should replace with working code. See the release notes that addresses the problem.