Yuttana Hiruntraporn
New Pleskian
Dear All
I try to open the helpdesk case from Reseller Account and got this error
==== Start of Error ====
<b>[/B]Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.
---------------------- Debug Info -------------------------------
0: common_func.php3:163
com->execute(string 'SELECT COUNT(1) FROM tts_tickets t, tts_reporters tr, domains d, clients c, mail m WHERE t.reporter_id = tr.id AND tr.type = N'mailname' AND tr.ref_reporter_id = m.id AND m.dom_id = d.id AND c.id AND c.parent_id = 10', NULL null)
1: common_func.php3:163
db_query(string 'SELECT COUNT(1) FROM tts_tickets t, tts_reporters tr, domains d, clients c, mail m WHERE t.reporter_id = tr.id AND tr.type = 'mailname' AND tr.ref_reporter_id = m.id AND m.dom_id = d.id AND c.id AND c.parent_id = 10')
2: class.TTSTicketsList.php:94
TTSTicketsList->_fetchTTSNonAdminTicketsList()
3: class.TTSTicketsList.php:44
TTSTicketsList->fetchTTSTicketsList()
4: class.TTSClientTicketsList.php:39
TTSClientTicketsList->fetchTTSClientTicketsList()
5: class.cList.php3:105
cList->fetchList()
6: class.cList.php3:124
cList->init()
7: client.php:40
==== End of Error ======
What is the problem?
and Can reseller account receieve the email from Customer ticket ?
because after test, my resller account didn't get email from ticket
I try to open the helpdesk case from Reseller Account and got this error
==== Start of Error ====
<b>[/B]Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.
---------------------- Debug Info -------------------------------
0: common_func.php3:163
com->execute(string 'SELECT COUNT(1) FROM tts_tickets t, tts_reporters tr, domains d, clients c, mail m WHERE t.reporter_id = tr.id AND tr.type = N'mailname' AND tr.ref_reporter_id = m.id AND m.dom_id = d.id AND c.id AND c.parent_id = 10', NULL null)
1: common_func.php3:163
db_query(string 'SELECT COUNT(1) FROM tts_tickets t, tts_reporters tr, domains d, clients c, mail m WHERE t.reporter_id = tr.id AND tr.type = 'mailname' AND tr.ref_reporter_id = m.id AND m.dom_id = d.id AND c.id AND c.parent_id = 10')
2: class.TTSTicketsList.php:94
TTSTicketsList->_fetchTTSNonAdminTicketsList()
3: class.TTSTicketsList.php:44
TTSTicketsList->fetchTTSTicketsList()
4: class.TTSClientTicketsList.php:39
TTSClientTicketsList->fetchTTSClientTicketsList()
5: class.cList.php3:105
cList->fetchList()
6: class.cList.php3:124
cList->init()
7: client.php:40
==== End of Error ======
What is the problem?
and Can reseller account receieve the email from Customer ticket ?
because after test, my resller account didn't get email from ticket