Mysqli_query failed

Hi Guys

I edited a custom module and deployed but some Tabs are displaying the field relationship LBL instead of the Label Name

Quick repair and rebuild return a database failure error and the below in the logs

Anny hints on what the issue could be?

Version 7.11.15
Sugar Version 6.5.25 (Build 344)

Log snippet

Mon Mar 8 13:01:30 2021 [1905112][1][FATAL] Mysqli_query failed.
Mon Mar 8 13:01:30 2021 [1905112][1][FATAL] Executing repair query: Query Failed: ALTER TABLE users_feeds modify COLUMN rank int(11) NULL: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘rank int(11) NULL’ at line 1
Mon Mar 8 13:01:30 2021 [1905112][1][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:400
Mon Mar 8 13:01:30 2021 [1905112][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Mar 8 13:01:30 2021 [1905112][1][FATAL] backtrace:
#0 /var/www/html/include/database/DBManager.php(353): sugar_die()
#1 /var/www/html/include/database/DBManager.php(328): DBManager->registerError()
#2 /var/www/html/include/database/MysqliManager.php(179): DBManager->checkError()
#3 /var/www/html/modules/Administration/repairDatabase.php(95): MysqliManager->query()
#4 /var/www/html/include/MVC/View/SugarView.php(839): include_once(’/var/www/html/m…’)
#5 /var/www/html/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile()
#6 /var/www/html/include/MVC/View/SugarView.php(226): ViewClassic->display()
#7 /var/www/html/include/MVC/Controller/SugarController.php(435): SugarView->process()
#8 /var/www/html/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /var/www/html/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /var/www/html/index.php(52): SugarApplication->execute()
#11 {main}

That’s not a DB issue. Names are stored on files located on the custom folder. Make sure your files have the proper ownership and permissions assigned.

Check here for more information: https://docs.suitecrm.com/admin/installation-guide/downloading-installing/#_copying_suitecrm_files_to_web_server

The problem is 99.9% certainly that you are using MySQL v8, which is not yet supported

Very true @pgr, thanks. Have noticed, now looking to downgrade

Thanks

Thanks @AlxGr

Let me read this through

Thanks @pgr I downgraded to MySQL 5.7 and worked well. Now as I configure, I fine some areas not functioning properly

  1. Password recovery not functioning
    image
  2. Email templates settings are disabled!

What might be the issue here?