You've got to be kidding. We waited over five hours for you to simply ask us for information which we already provided? I am the sysadmin and am more than familiar with how MySQL works and how to adjust it's settings.
We dropped all pp records from the vbforum table to begin another fresh install attempt.
We disabled strict mode per your recommendation, restarted the MySQL server, verified the changes took effect, and then re-ran the pp install script.
Here is the current MySQL error being reported by the pp installer:
Step 3: MySQL error reported: [CREATE TABLE IF NOT EXISTS pp_photoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP]
Result: 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 'TYPE=HEAP' at line 1
To test whether or not it was a collation issue, we dropped the pp tables again, changed the vbforum db collation (including all tables and columns) to general_ci (from bin), and re-ran the pp installer.
Same error and we just gave you.
The version of MySQL we are using is the current, STABLE release. Don't you test your software against these releases as they become available?
Regardless, we need you to either fix your code or provide us with some other sort of direction. We renewed our license yesterday and are still unable to install the current version.
Last edited by gmatthews; June 3rd, 2011 at 08:02 PM.