Can't create New Ticket or add answer after update 2.4

[Klemen]

@geekygemini - try the solution from my previous post, starting with "Aha, it's a problem with custom field values ..."

[ivoreis]

I know, I took on purpose to see if it worked, but had already been tested with all.

http://www.ciasoftware.com.br/temp/img2.gif

[Klemen]

I'm out of ideas then here...

Would it be possible for me to have FTP access to your help desk and run some tests? If you are willing to give me access (at least FTP, best would be FTP + MySQL (phpMyAdmin)) feel free to send me a private message.

I may not be able to do it today though, probably tomorrow. In the mean time you could restore your version 2.3 backup.

[geekygemini]

The error I am getting is this on ticket submission:

Error:

Can't execute SQL: SELECT `autoassign` FROM `hesk_categories` WHERE `id`=8 AND `type`='0' LIMIT 1
MySQL said:
Unknown column 'autoassign' in 'field list'


WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

and on ticket reply:

Error:

Can't execute SQL: UPDATE `hesk_tickets` SET `status`='2',`lastreplier`='1',`replierid`='4',`time_worked` = ADDTIME(`time_worked`,'00:00:00') WHERE `id`=625 LIMIT 1
MySQL said:
Unknown column 'time_worked' in 'field list'


WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

[Klemen]

You don't have database updated to version 2.4, make sure you follow "Upgrade from old HESK version" instructions in the readme.html file to the point!

Before doing that close all browser windows to reset sessions.

[geekygemini]

I did update it. In fact, when I try to reinstall the upgrade, it says

Testing database connection...success
Installing database tables... ERROR: 2.4 MySQL tables exist.

Your Hesk has already been updated to version 2.4. Click here to continue.

[geekygemini]

Is there a .sql file of all the new/changed tables for 2.4?

[Goue1]

Hi Klemen,

I test save hesk_setting.inc in UTF-8 (BOM)... delete all beetwen $hesk_settings['custom_fields']=array ( and );

I have always this issue....

have you other idea?

for info I tryre update hesk version because after first update in parameters Hesk version is sitll 2.3

when I try re update I have an issue where wizard say me Error SQL : you are still in 2.4...

[Klemen]

@geekygemini

That doesn't make sense - the database isn't updated because fields are from 2.3, but the hesk_pipe_loops table exists??

Did you perhaps change database settings or table prefix after updating?

The SQL code is inside "install/update.php" file starting with

Code: Select all

/* Updating version 2.3 to 2.4 */

You can try manually running the code from below $sql = array(); to see if that helps.

@Goue1

I'm running out of ideas here. Would it be possible for me to have FTP access to your help desk and run some tests? If you are willing to give me access to your help desk (at least FTP, best would be FTP + MySQL (phpMyAdmin)) feel free to send me a private message with info.

[Goue1]

I can't give you an FTP Access...

but I can upload you all the directory if you want

[Klemen]

No problem, but I'm not sure how I can help further.

You have the same files as me, so it must be a server-side problem, most likely encoding-related. This is not something I can debug on my server as I cannot repeat the issue here (different settings).

Your best bet would be to go back to version 2.3 until this is figured out.

[Klemen]

Found the problem - it was because a required function was missing in PHP prior to version 5.2.0

To fix this issue update your HESK to version 2.4.1 (just released).

[Goue1]

Hi Klemen,

Thanks for your update!!

It works great now!

Thanks a lot for your job!