Page 1 of 1

Installation Issue

Posted: Tue Sep 26, 2017 10:14 am
by CodeCo
Script URL:
Mods for HESK version: 3.1.1
HESK version: 2.7.3
Hosting company: Myself
What terms did you try when SEARCHING for a solution: Couldn't find anyone else with this issue.

Write your message below:
After trying to install, it get stuck on

Code: Select all

Could not execute query: ALTER TABLE `hesk_categories` CHANGE `color` `background_color` VARCHAR(7) NOT NULL DEFAULT '#FFFFFF'. MySQL said: Data truncated for column 'background_color' at row 1
I have replicated the same issue around 4 times now.

https://file.properties/CFYXxBFV.png

Re: Installation Issue

Posted: Tue Sep 26, 2017 10:26 am
by CodeCo
I manually set the thing to #FFFFFF in the database and restarted the installation and upgraded from 3.10

Now I have a css issue :p https://i.codeco.tk/qBwxJPvm.png

Re: Installation Issue

Posted: Tue Sep 26, 2017 10:40 am
by CodeCo
https://file.properties/RyKpzDQP.png Seems like a database issue, but I have no idea how to fix this. I've cleared and reinstalled Hesk, the database and MFH 4 times in the past all ending with the same issue.

Re: Installation Issue

Posted: Tue Sep 26, 2017 12:15 pm
by mkoch227
Download this copy of installSql.php and place into your /install/mods-for-hesk/sql folder: https://gitlab.com/mike-koch/Mods-for-H ... allSql.php

Then try another clean install and let me know if it works or not.