PDA

View Full Version : White website after opening a ticket


OAA
01-13-2008, 05:31 PM
i´ll get a white website, without any answer, wenn i choose the preferences like shown in the screenshot:

http://www.telepeep.de/service/images/osticket.jpg

but the ticket is shown in the admin area. the user gets an email,too

if i´ll disable the points "Spammy" in the admin area, everything runs normal, so the person who wants to open a ticket, can see some information after sending the ticket...

what must i do. it´s my aim to send an email to every department member, after opening a new ticket in the department

mark
01-16-2008, 06:29 PM
Hi

If it helps I get the same, but I see the following in the error log

PHP Fatal error: Call to undefined method Dept::getDeptId() in /home/x/public_html/include/class.ticket.php on line 1009

Also, in the SQL String - I assume 'onvavaion' should be 'onvacation'

mark
01-16-2008, 06:36 PM
I think that SQL string might be:-

$sql='SELECT staff_id FROM '.STAFF_TABLE.' WHERE onvacation=0 AND dept_id='.db_input($deptId);

or $this->getDept(); ??

The answer is here http://www.osticket.com/forums/showpost.php?p=580&postcount=5

4ice
01-17-2008, 03:17 AM
Don't forget the search every now and then, this is an old issue and has been solved already :)

The error occurs when Dept. members alert is enabled on new tickets!

in include/class.ticket.php line 1009.
Change:
$sql='SELECT staff_id FROM '.STAFF_TABLE.' WHERE onvavaion=0 AND dept_id='.db_input($dept->getDeptId());to:
$sql='SELECT staff_id FROM '.STAFF_TABLE.' WHERE onvacation=0 AND dept_id='.db_input($dept->getId());Thanks everyone.

See: http://www.osticket.com/forums/showthread.php?t=135