DB error 1064

dwilson

Can some some clarify this error plz?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') )' at line 1 :

dolmax

I have the exact same problem and been trying to find out what the cause is.

I'm not sure whether this is related to (this mod.)

dolmax

Anyone? :)

mseelenb

For some reason, I'm not able to see all of Masino's code (just what he posted in these forums), but I'm assuming you've made the following change to tickets.php:

} elseif ($thisuser->isManager()) { // manager can access tickets belong to his/her dept.

$sql.=' WHERE (ticket.dept_id IN ('.implode(',',$depts).') )';

Try changing:

$sql.=' WHERE (ticket.dept_id IN ('.implode(',',$depts.') )';

To:

$sql.=' WHERE (ticket.dept_id IN ('.implode(',',$thisuser->getDepts()).'))';

Hope that helps,

Mark

dolmax

Dear Mark,

I have edited related parts in Masino's code, based on your input. This solved the problem. I no longer get DB errors.

Thanks for your contribution. I'll make sure I add corrected code in the other MOD article. Will also make sure you get the credit.

Hakan