Issue with PHP SSP complex function only when using search box
Issue with PHP SSP complex function only when using search box
rpdog25
Posts: 2Questions: 1Answers: 0
I was unable to get the debug console to run - getting 404 about a css file
DataTables warning: table id=submissions-table - An SQL error occurred: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
So, I am using the ssp.php from GitHub and the latest dataTables js. All works great most of the time, and if I use the "simple" function for my queries, everything is perfect. When I need to add WHERE clauses I hit a problem. I use the "complex" function from SSP. The initial query works and shows my results exactly as it should. However, as soon as I enter anything into the search box, I get the above error about mismatched number of tokens/bindings. I'm at a loss on this one. Any help would be appreciated!
Answers
Could you try using this version of the SSP class which should address that issue.
It was this fix that corrected the issue you are seeing.
Allan
Will do, thanks!!
you can simply try using different ssp class files or make fix in yours. i have fixed the same problem with this SSP Class file