Setting Default View in Hesk

[AKearns13]

Hello,

When we have a user try to set a new default view, i.e. Group and Sort by Category, for their instance of Hesk, the tickets are sorted by Category, but there is an error message stating that it can't execute SQL. This prevents the new view from being saved, so the user has to sort for each instance. If I select the next page number at the bottom, then the error goes away but the setting is not saved.


The error message below is what is produced when I enable Debug Mode and try the same process.


Can't execute SQL: UPDATE `hesk_users` SET `default_list`='s0=1&s1=1&s2=1&s4=1&s5=1&s6=1&s7=1&s8=1&s9=1&s11=1&s12=1&s13=1&s14=1&s15=1&p0=1&p1=1&p2=1&p3=1&s_my=1&s_un=1&s_ot=1&sort=status&g=category&duedate_option=specific&duedate_specific_date=&duedate_amount_value=&duedate_amount_unit=day&category=0&limit=20&asc=1&more=1' WHERE `id`='1'

MySQL said:
Data too long for column 'default_list' at row 1


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

[Klemen]

Try running this SQL query in your database:

Code: Select all

ALTER TABLE `hesk_users` CHANGE `default_list` `default_list` VARCHAR(1000) NOT NULL;

Please BACKUP the table first before doing anything.