Problem after update

[superfaria]

Script URL: Hesk.com
Version of script: 3.6.0
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:
Hi !
My name is Manuel Faria from Portugal
I use:
HESK version : 3.6.0
HESK license: Licensed
PHP version: 7.1.33 (MySQLi)
MySQL version: 10.6.20-MariaDB-cll-lve
/hesk_settings.inc.php: Exists, Writable
/attachments: Exists, Writable
/cache: Exists, Writable

I'm new here, and today I updated the version from 3.5.3 to 3.6.0
The first think I saw : The Portuguese language, I don't now how I can´t put back again.
The second and the big problem for me: I can´t see the customers , give a error.

"Error
Can't execute SQL
Please notify webmaster at.... (our email)
Go back "

Can some people here help me ?
Thank you

[Klemen]

For the SQL error: What error message do you get, if you:

1. go to Admin panel > Settings > Help desk
2. find "Debug mode" and turn it ON
3. save changes
4. go back to customers page

For language: you will need to update your language packs to be compatible with 3.6.0

Try updating them in Hesk admin panel > Settings > General.

If auto-updates do not work on your server, update the language pack manually from
https://www.hesk.com/language/

[Klemen]

Update: for the customers page issue, one potential problem has been identified.

To fix the customer page issue, try using this manage_customers.php file in your "admin" folder:
https://hesk.com/extras/hesk3/hesk360_m ... rs_fix.zip

[superfaria]

Problem Fix,
- Thank you very much
Manuel Faria
Portugal

[shddcit]

Update: for the customers page issue, one potential problem has been identified.

To fix the customer page issue, try using this manage_customers.php file in your "admin" folder:
https://hesk.com/extras/hesk3/hesk360_m ... rs_fix.zip

Klemen, since we're talking about Customer now, then after the release of update 3.5.7 the following issue has occurred. It's not constant, but rather intermittent.

When customer accounts are enabled, periodically when a random customer creates a ticket, it seems that their account isn't being pulled from SQL and displayed—for example—as "Klemen (HESK)", instead it shows up as "Customer". This happens very rarely and usually only with those who create the most tickets under their account. So far, I've identified four customers with whom this problem occurs.

Nevertheless, I don't think this is an issue with Hesk 3.5.7. I'll check whether this issue persists with Hesk 3.6.0.

[Klemen]

This usually happens when there is a ticket generated from email, but the user doesn't have a name set in "From" header.

If you have some other examples of when this occurs, please let me know details (can via private message).

[shddcit]

This usually happens when there is a ticket generated from email, but the user doesn't have a name set in "From" header.

If you have some other examples of when this occurs, please let me know details (can via private message).

It turns out that a client can somehow clear the field containing their full name (last name, first name, and patronymic) when submitting a ticket. I suspect this happens because of Chrome's autocomplete feature, which replaces the Name field with a different value instead of using the one from the client's database. Additionally, there seems to be no validation checking whether the "Full Name" field matches the data in the clients' database. Well, at least this occurs very rarely.

[Klemen]

It could be. If you figure out the process that creates these for you, let me know and I will look into it.