Hesk problems with 2 sites
Posted: Tue Aug 15, 2006 8:56 pm
Script URL: support.d2net.com and www.hillsdalepolice.com/hesk
Version of script:0.93.1
Hosting company:Ev1servers.net
URL of phpinfo.php: www.d2net.com/phpinfo.php and www.hillsdalepolice.com/phpinfo.php
URL of session_test.php: www.d2net.com/session_test.php and www.hillsdalepolice.com/session_test.php
What terms did you try when searching for a solution: Categories and E-mail
Write your message below:
I am currently running 2 different installations on 2 virtual sites. However, even though the php, mysql and script versions are the same, the two products act differently.
On the first site when a user logs in, he will only see the tickets in the category he is assigned to..
However, on the second site, when a user logs in he sees all tickets for all categories.
In addition on the first site you only receive e-mails for your category and for the second site you receive for all categories.
In addition the the above listed problems. I have also noticed that I have to sign in 2 times to enter the admin area. The first time I attempt to log in i receive a password error, The second time I log in it goes through. that only happens on the site that I am already having problems with (hillsdalepolice.com)
I set debug mode and received this one time only.
Error
Can't execute SQL: SELECT * FROM `hesk_tickets` WHERE ( `category`=Arra ) AND `status`=1 ORDER BY `priority` ASC
MySQL said:
Unknown column 'Arra' in 'where clause'
Can anyone assist with this?
P.S. My server is running ensim 4.0.1
Version of script:0.93.1
Hosting company:Ev1servers.net
URL of phpinfo.php: www.d2net.com/phpinfo.php and www.hillsdalepolice.com/phpinfo.php
URL of session_test.php: www.d2net.com/session_test.php and www.hillsdalepolice.com/session_test.php
What terms did you try when searching for a solution: Categories and E-mail
Write your message below:
I am currently running 2 different installations on 2 virtual sites. However, even though the php, mysql and script versions are the same, the two products act differently.
On the first site when a user logs in, he will only see the tickets in the category he is assigned to..
However, on the second site, when a user logs in he sees all tickets for all categories.
In addition on the first site you only receive e-mails for your category and for the second site you receive for all categories.
In addition the the above listed problems. I have also noticed that I have to sign in 2 times to enter the admin area. The first time I attempt to log in i receive a password error, The second time I log in it goes through. that only happens on the site that I am already having problems with (hillsdalepolice.com)
I set debug mode and received this one time only.
Error
Can't execute SQL: SELECT * FROM `hesk_tickets` WHERE ( `category`=Arra ) AND `status`=1 ORDER BY `priority` ASC
MySQL said:
Unknown column 'Arra' in 'where clause'
Can anyone assist with this?
P.S. My server is running ensim 4.0.1