[WhSox21]

Originally Posted by computer1

I get this database eror when I install everything nowe
on vb.3.0.7
Database error in vBulletin 3.0.7:

Invalid SQL: SELECT ticketid, title, postusername, dateline, lastposter, lastupdate, department FROM ticket AS ticket JOIN ticketdepartment AS ticketdepartment ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND postuserid = 1
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND post' at line 1

mysql error number: 1064

Date: Sunday 06th of March 2005 08:49:34 PM
Script: http://forum.tanakawebb.com/helpdesk.php
Referer: http://forum.tanakawebb.com/

and where shld I change this????
Add a department. (www.yoursite.com/helpdesk.php?do=departments)

Start reading the past posts. I'm trying to get someone that has this problem run the script I attached in one of the past posts. Then if it works I'll update the hack.