error when i install mods for hesk

[jessar94]

I have backup everyting , public folder and db.

I install hesk 2.7.1 and then i install hesk 2.7.2 it says everything is correct installed.
Okey, next step is mods for hesk.

Im trying too install mods for hesk 3.0.2 i get error so i restore everything, public folder and db.
I try too uninstall mods for hesk then install hesk 2.7.1 then 2.7.2, it show a message, it is correct installed

Then i install mods for hesk - here i get error here.

Code: Select all

INFO	Starting updates for 3.0.0 beta 1
INFO	Starting updates for 3.0.0 RC 1
INFO	Starting updates for 3.0.0
INFO	Starting updates for 3.0.1
INFO	Starting updates for 3.0.2
ERROR	Could not execute query: UPDATE `hesk_users` SET `autoreload` = `autorefresh` / 10. MySQL said: Unknown column 'autorefresh' in 'field list'
SUCCESS	Updates for 3.0.1 complete
INFO	Starting updates for 3.0.2
ERROR	Could not execute query: ALTER TABLE `hesk_stage_tickets` ADD COLUMN `custom21` MEDIUMTEXT, ADD COLUMN `custom22` MEDIUMTEXT, ADD COLUMN `custom23` MEDIUMTEXT, ADD COLUMN `custom24` MEDIUMTEXT, ADD COLUMN `custom25` MEDIUMTEXT, ADD COLUMN `custom26` MEDIUMTEXT, ADD COLUMN `custom27` MEDIUMTEXT, ADD COLUMN `custom28` MEDIUMTEXT, ADD COLUMN `custom29` MEDIUMTEXT, ADD COLUMN `custom30` MEDIUMTEXT, ADD COLUMN `custom31` MEDIUMTEXT, ADD COLUMN `custom32` MEDIUMTEXT, ADD COLUMN `custom33` MEDIUMTEXT, ADD COLUMN `custom34` MEDIUMTEXT, ADD COLUMN `custom35` MEDIUMTEXT, ADD COLUMN `custom36` MEDIUMTEXT, ADD COLUMN `custom37` MEDIUMTEXT, ADD COLUMN `custom38` MEDIUMTEXT, ADD COLUMN `custom39` MEDIUMTEXT, ADD COLUMN `custom40` MEDIUMTEXT, ADD COLUMN `custom41` MEDIUMTEXT, ADD COLUMN `custom42` MEDIUMTEXT, ADD COLUMN `custom43` MEDIUMTEXT, ADD COLUMN `custom44` MEDIUMTEXT, ADD COLUMN `custom45` MEDIUMTEXT, ADD COLUMN `custom46` MEDIUMTEXT, ADD COLUMN `custom47` MEDIUMTEXT, ADD COLUMN `custom48` MEDIUMTEXT, ADD COLUMN `custom49` MEDIUMTEXT, ADD COLUMN `custom50` MEDIUMTEXT. MySQL said: Duplicate column name 'custom21'
ERROR	Could not execute query: ALTER TABLE `hesk_users` DROP COLUMN `autorefresh`. MySQL said: Can't DROP 'autorefresh'; check that column/key exists
ERROR	Could not execute query: ALTER TABLE `hesk_stage_tickets` ADD COLUMN `custom21` MEDIUMTEXT, ADD COLUMN `custom22` MEDIUMTEXT, ADD COLUMN `custom23` MEDIUMTEXT, ADD COLUMN `custom24` MEDIUMTEXT, ADD COLUMN `custom25` MEDIUMTEXT, ADD COLUMN `custom26` MEDIUMTEXT, ADD COLUMN `custom27` MEDIUMTEXT, ADD COLUMN `custom28` MEDIUMTEXT, ADD COLUMN `custom29` MEDIUMTEXT, ADD COLUMN `custom30` MEDIUMTEXT, ADD COLUMN `custom31` MEDIUMTEXT, ADD COLUMN `custom32` MEDIUMTEXT, ADD COLUMN `custom33` MEDIUMTEXT, ADD COLUMN `custom34` MEDIUMTEXT, ADD COLUMN `custom35` MEDIUMTEXT, ADD COLUMN `custom36` MEDIUMTEXT, ADD COLUMN `custom37` MEDIUMTEXT, ADD COLUMN `custom38` MEDIUMTEXT, ADD COLUMN `custom39` MEDIUMTEXT, ADD COLUMN `custom40` MEDIUMTEXT, ADD COLUMN `custom41` MEDIUMTEXT, ADD COLUMN `custom42` MEDIUMTEXT, ADD COLUMN `custom43` MEDIUMTEXT, ADD COLUMN `custom44` MEDIUMTEXT, ADD COLUMN `custom45` MEDIUMTEXT, ADD COLUMN `custom46` MEDIUMTEXT, ADD COLUMN `custom47` MEDIUMTEXT, ADD COLUMN `custom48` MEDIUMTEXT, ADD COLUMN `custom49` MEDIUMTEXT, ADD COLUMN `custom50` MEDIUMTEXT. MySQL said: Duplicate column name 'custom21'
SUCCESS	Updates for 3.0.0 complete
INFO	Starting updates for 3.0.1
INFO	Starting updates for 3.0.2
ERROR	Could not execute query: ALTER TABLE `hesk_stage_tickets` ADD COLUMN `custom21` MEDIUMTEXT, ADD COLUMN `custom22` MEDIUMTEXT, ADD COLUMN `custom23` MEDIUMTEXT, ADD COLUMN `custom24` MEDIUMTEXT, ADD COLUMN `custom25` MEDIUMTEXT, ADD COLUMN `custom26` MEDIUMTEXT, ADD COLUMN `custom27` MEDIUMTEXT, ADD COLUMN `custom28` MEDIUMTEXT, ADD COLUMN `custom29` MEDIUMTEXT, ADD COLUMN `custom30` MEDIUMTEXT, ADD COLUMN `custom31` MEDIUMTEXT, ADD COLUMN `custom32` MEDIUMTEXT, ADD COLUMN `custom33` MEDIUMTEXT, ADD COLUMN `custom34` MEDIUMTEXT, ADD COLUMN `custom35` MEDIUMTEXT, ADD COLUMN `custom36` MEDIUMTEXT, ADD COLUMN `custom37` MEDIUMTEXT, ADD COLUMN `custom38` MEDIUMTEXT, ADD COLUMN `custom39` MEDIUMTEXT, ADD COLUMN `custom40` MEDIUMTEXT, ADD COLUMN `custom41` MEDIUMTEXT, ADD COLUMN `custom42` MEDIUMTEXT, ADD COLUMN `custom43` MEDIUMTEXT, ADD COLUMN `custom44` MEDIUMTEXT, ADD COLUMN `custom45` MEDIUMTEXT, ADD COLUMN `custom46` MEDIUMTEXT, ADD COLUMN `custom47` MEDIUMTEXT, ADD COLUMN `custom48` MEDIUMTEXT, ADD COLUMN `custom49` MEDIUMTEXT, ADD COLUMN `custom50` MEDIUMTEXT. MySQL said: Duplicate column name 'custom21'
SUCCESS	Updates for 3.0.1 complete
INFO	Starting updates for 3.0.2
ERROR	Could not execute query: ALTER TABLE `hesk_stage_tickets` ADD COLUMN `custom21` MEDIUMTEXT, ADD COLUMN `custom22` MEDIUMTEXT, ADD COLUMN `custom23` MEDIUMTEXT, ADD COLUMN `custom24` MEDIUMTEXT, ADD COLUMN `custom25` MEDIUMTEXT, ADD COLUMN `custom26` MEDIUMTEXT, ADD COLUMN `custom27` MEDIUMTEXT, ADD COLUMN `custom28` MEDIUMTEXT, ADD COLUMN `custom29` MEDIUMTEXT, ADD COLUMN `custom30` MEDIUMTEXT, ADD COLUMN `custom31` MEDIUMTEXT, ADD COLUMN `custom32` MEDIUMTEXT, ADD COLUMN `custom33` MEDIUMTEXT, ADD COLUMN `custom34` MEDIUMTEXT, ADD COLUMN `custom35` MEDIUMTEXT, ADD COLUMN `custom36` MEDIUMTEXT, ADD COLUMN `custom37` MEDIUMTEXT, ADD COLUMN `custom38` MEDIUMTEXT, ADD COLUMN `custom39` MEDIUMTEXT, ADD COLUMN `custom40` MEDIUMTEXT, ADD COLUMN `custom41` MEDIUMTEXT, ADD COLUMN `custom42` MEDIUMTEXT, ADD COLUMN `custom43` MEDIUMTEXT, ADD COLUMN `custom44` MEDIUMTEXT, ADD COLUMN `custom45` MEDIUMTEXT, ADD COLUMN `custom46` MEDIUMTEXT, ADD COLUMN `custom47` MEDIUMTEXT, ADD COLUMN `custom48` MEDIUMTEXT, ADD COLUMN `custom49` MEDIUMTEXT, ADD COLUMN `custom50` MEDIUMTEXT. MySQL said: Duplicate column name 'custom21'

what should i do?

Video: https://dl.dropboxusercontent.com/u/422 ... -51-39.mp4

[mkoch227]

Code: Select all

INFO	Starting updates for 3.0.0 beta 1
INFO	Starting updates for 3.0.0 RC 1
INFO	Starting updates for 3.0.0
INFO	Starting updates for 3.0.1
INFO	Starting updates for 3.0.2

I made a tweak in the JavaScript that ran each update, and it looks like I made a small mistake resulting in the same update being ran multiple times. Ideally nothing should be wrong with your install. I'll be releasing a bugfix tonight to address the issue, but I recommend you run the database validator (which is accessible via http://<path to your helpdesk install>/install/mods-for-hesk/database-validation.php. If everything looks good, you can ignore the errors you got for now (as the installer was trying to do the same thing multiple times).

[jessar94]

Thanks Mike

I have another question.

if you take a look at the picture:


There are an ugly line and if i test footer.txt and just add Copyright 2016 is thre results that, why?, can i fix that?

link to my site: http://supportportalen.mobi/antilopen/

[Klemen]

You'll need to change the style in css/mods-for-hesk.css file:

Code: Select all

div.footerWithBorder {
    border-top: 1px solid #cfd4d6;
}

to

Code: Select all

div.footerWithBorder {
    /*! border-top: 1px solid #cfd4d6; */
}

[jrentzke]

Hi Klemen,

that doesn't seem to get rid of that line. I've checked the posters site, and it seems he also couldn't get the line to go away.
Any other suggestions please?

Thanks,
Jerry


edit: just tried the code again, and it now seems to work as suggested by Klemen. Don't know why it didn't before though.