Support System

[dlsodders]

I just installed the support system contribution and I am getting the following error

 

1064 - 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 'select * from support_tickets where customers_id = \'2\' and ti

 

select count(select * from support_tickets where customers_id = \'2\' and ticket_status=\'1\' order by ticket_date DESC) as total

 

[TEP STOP]

 

Anyone know why or how I can fix this?

 

Thanks,

David

[♥kymation]

I don't have this contribution, but I'll take a stab at the problem anyway. MySQL is probably choking on the slashes (\'2\' and \'1\' should be '2' and '1').

 

Find where this is being generated in the code and see if it uses the addslashes() function. If it does, remove that function. If the slashes are coded in the file just remove them. If the slashes aren't there and addslashes() is not being used, try adding stripslashes() to remove them.

 

If none of this makes sense, please post just the line of code that generates this SQL statement and we'll take a look at the problem.

 

Regards

Jim