Mods for Hesk & Hesk. Getting SQL Errors and I'm not sure what to do next.

[davehkiin]

Script URL: http://ticket.provello.co.uk
Version of script: HESK: 2.8.1 MFH: 2018.1.0
Hosting company: BigWetFish
URL of phpinfo.php: http://ticket.provello.co.uk/phpinfo.php
URL of session_test.php: http://ticket.provello.co.uk/session_test.php
What terms did you try when SEARCHING for a solution: Really?


Write your message below: The installation you're looking at is completely fresh - I've made no adjustments to it, however, I'm consistently getting an SQL Error. Can you please have a look and see if you can help with this.

I've never had this issue before and successfully installed previously on 2.7.6 (?)(Last major version released)

Moved to a new hosting company, so ran through HESK Installation manually, let it run and logged in successfully after deleting installation folder. Dropped in Mods For Hesk & tried to run through, this was the first error I got:



Rectified this with 775 permissions

Now I get this:



Again, it's a fresh installation. Will change Database password after you've looked, it's randomly gen'd anyway.

[mkoch227]

It looks like your database went into a bad state after reaching the 403 Forbidden message, as the installer could not roll itself back properly.

Here are two possible solutions, one being "easier" than the other:

1. Reinstall HESK + Mods for HESK again: since you claim you have a fresh install, then you probably don't have any data to worry about losing. Simply delete the folder and database and re-install (and make sure that all file permissions are correct )
2. On the Mods for HESK install homepage, go to Tools -> Uninstall. I can't guarantee that this will work due to the state of your current database, but it might work. If the uninstall succeeds, then you can try reinstalling Mods for HESK.

A third option would be to manually go in the database and fix the DB to match what the installer is expecting. This would take a considerable amount of time, so if one of the other options above is an acceptable solution, I suggest going with one of the easier options before going down this road.

[davehkiin]

Just tried again





An error occurred! (Error Code: 14)
Could not execute query: ALTER TABLE `hesk_users` ADD COLUMN `notify_note_unassigned` ENUM('0', '1') NOT NULL DEFAULT '0'. MySQL said: Duplicate column name 'notify_note_unassigned'

An error occurred! (Error Code: 10)
Could not execute query: ALTER TABLE `hesk_tickets` DROP COLUMN `parent`. MySQL said: Can't DROP 'parent'; check that column/key exists

New errors. Brand new installation, brand new DB. Permissions set up before running install. Confirmed HESK working before Mods For Hesk.

Probably already worth noting I have done all of your easy methods, I've just never come across this before. I'm not great with MySQL So I'm not 100% confident in what I'd actually be doing. If you can explain what I'm doing with the tables, which ones I'm changing or dropping or what I'll be able to do it.

[mkoch227]

Can you send me a PM with the following information?
- FTP Username/password
- phpMyAdmin URL (or a username/password combo for your database that allows outside connections (as I don't have access to your cPanel))

I'm quite surprised that this is even happening on a clean install.... I checked the HESK 2.8.1 files to make sure that HESK didn't add a column with the same name, but that's not the case.

(finally got a post to work without the forum freaking out about my message lol)