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)