Originally Posted by Chuck S
Those look like standard strict mysql errors if you made a change restart the server and then try installing.
Nope. I *had* restarted. But I deleted the Photopost tables, confirmed the line in my.cnf (sql-mode="TRADITIONAL"), and restarted again. Result was the same exact errors.
Commenting out that line from my.cnf and restarting the MySQL server allowed the tables to be created and absolutely no errors being thrown - of course using the modified install.php to make the SQL statements consistent with MySQL 5.5.x. The result is again, that I am locked out as an administrator.