Error: Can't execute SQL

[deriklogov]

Hi,
Having issue with login to admin area, getting error: Error:Can't execute SQL
I make brand new installation of HESK completed without any errors, then I make installation of mods , same completed without any issues. Now I can not login and do any action , after submitting any form getting same error: Error: Can't execute SQL
Please help

[mkoch227]

Turn on debug mode by setting $hesk_settings['debug_mode'] = 1 and try your request again. Copy and paste the error message into a response here.

[deriklogov]

Issue resolved, so what happens is that mysqli (extension) wasnt installed on the server, so hesk was installed fine but mods didnt create some table during installation (statuses) but it didnt notify me during installation.
So I removed both of them, install mysqli extension and reinstall both of them , working fine

[ugogo.info]

Hi

I have the same error after a clean install of Hesk and then a clean install of Mods. Debug error message shows this:

Error:

Can't execute SQL: SELECT `Key`, `Value` FROM `lva_settings` WHERE `Key` <> 'modsForHeskVersion'

MySQL said:
Table 'XXXXX_hesk529.lva_settings' doesn't exist

I'm not sure if this has any bearing on it, but the original Hesk I installed is version 2.5.2 but only 2.5.1 shows up on the install page to choose what version.

Please let me know what I should do to fix this, thanks.

[mkoch227]

On the Mods for HESK install page, select your Mods for HESK version, not your HESK version. Since you said this is a clean install, make sure you select "No previous installation" so all of the tables are set up.

[ugogo.info]

Thanks, i will uninstall and try again and report back.

[yogatekat]

hesk.hesk_mfh_service_message_to_location

Can't execute SQL: SELECT `title`, `message`, `style`, `icon` FROM `hesk_service_messages` AS `sm` INNER JOIN `hesk_mfh_service_message_to_location` AS `location` ON `sm`.`id` = `location`.`service_message_id` AND `location`.`location` = 'CUSTOMER_HOME' AND `sm`.`mfh_language` IN ('ALL', 'en') WHERE `type`='0' ORDER BY `order` ASC
MySQL said:
Table 'hesk.hesk_mfh_service_message_to_location' doesn't exist

please help me. when to upgrade hesk version from 2.7.5 to 2.7.6 .......

[mkoch227]

It sounds like you may have updated HESK, copied over the new Mods for HESK files, but never actually updated Mods for HESK? Make sure you follow the instructions exactly at https://mods-for-hesk.com/download.php.

If you continue to have issues, please provide the exact steps you took when trying to update HESK to 2.7.6.