Testimonial Manager Support Thread

[DivaVocals]

When I updated Clydes Testimonials Manager to run on zen cart version 1.5.0 I didn't change anything with the install.sql statement. I added a couple lines to run on v.1.5.0. I don't have any problem with the sql statement.

But the SQL statement does have some issues that could cause issues with newer versions of mySQL (as lat9 pointed out TYPE= is indeed deprecated) and the SQL script also contains code that could inadvertently delete items from the configuration table.

More importantly here is the reason why when lat9 removed the back quotes (not to be confused with single quotes) around the column names in the create table section of the script the problem was resolved. The syntax issue is the back quotes:

The error 1064 occurs due to Mysql version mismatch,because differnt versions have differnt
reserved words,which if used by a previous version causes the error to occur.

Removing the back quotes solves the issue.

This is why I think it has something to do with running on a PHP 5.3. I may be wrong but no one else is having this except you and LadyArlette. I'm going to to test this out tonight on php 5.3 and see whats going on. Thank you for your version of the sql statement that worked for you.

Not a PHP compatibility issue or you would have seen an error relating to that instead of a SQL error which is indicative of invalid syntax being used in the SQL script.. Besides that Clyde himself certified that this add-on was PHP v5.3 ready with his last release of Testimonials Manager..

The fact that you are not having an issue when you run the same script would only seem to indicate that your server is running an older version of mySQL which still supports some of this old (and now invalid) syntax..