PHPJunkyard support forum

Script URL:
Version of script: Current
Version of PHP: PHP 4.4.1
Hosting company: Self
Have you searched THIS FORUM for your problem: Yes
(if not please do before posting)
If so, what terms did you try:

Write your message below:

First off, hats off to you for an amazing script in Hesk! My problem is this: The script works beautifully, until I try to log in as a user that isn't an Admin. When I try, this is the error message I get:

"Can't execute SQL: SELECT * FROM `hesk_tickets` WHERE ( `category`=Array OR `category`=Array OR `category`=Array OR `category`=Array OR `category`=Array OR `category`=Array OR `category`=Array ) AND `status`=1 ORDER BY `priority` ASC

MySQL said:
Unknown column 'Array' in 'where clause'"

Any clues?

Hello,

Have you made any changes to the script (except the settings file)? If yes try with the ORIGINAL files.

Regards

No changes have been made that I'm aware of. Can you give me an idea of what files may have been changed? That way I can start swapping them out with fresh copies to isolate the problem.

On a side note, I tried a fresh install on another machine and it seemed to work just fine. So I'm a bit confused as to the difference b'twixt the two.

I would suggest making a clean install on the problematic server as I am not sure what could be edited/wrong.

Actually, a clean install would be more hassle than it's worth, as I've already begun toying with it, placing tickets, etc.

Besides, I think I've got it sorted out. For some reason, making users Admins then switching them back to normal users cleared up the problem. While this may not be exact enough for some, it works...and that's really all that matters to me.

Thanks though!

Can't wait to see the next version you come up with!