Support System Plugin Not Work

[horaz]

Hi,

 

I got an issue while installing support system plugin

 

SQLSTATE[42000]: Syntax error or access violation: 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 '?, `status` enum('open','awaiting_reply','in_progress','closed') NOT NULL DEFAUL' at line 1

 

Thanks for your explanation and clue to solve this issue.

 

 

Regards,

Horaz

[Tyson]

What version of MySQL, PHP, Blesta, and the Support Manager plugin are you using?

[horaz]

Hi Tyson,

 

This is of my softwares version :

 

Mysql 5.5.32

PHP 5.3.26

Blesta 3.0.5

Support Manager 1.5.4

[Tyson]

Are you still experiencing this issue? Did it occur the first time you tried to install it, or did you previously have it installed, uninstalled it, and are trying to install it again?

 

The query excerpt it shows starts with a question mark, as if PDO is not replacing them. But if that were the case, I'd expect you would have all kinds of problems.

 

SQLSTATE[42000]: Syntax error or access violation: 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 '?, `status` enum('open','awaiting_reply','in_progress','closed') NOT NULL DEFAUL' at line 1

 

If you can check the logs for the full query that is executed, it may shed some more light on what's going on.