That SQL error deals with MySQL version, but the 'offending' queries were changed to allow for older MySQL versions. Don't do the step by step stuff, do all the general upgrade instructions again: revert PhotoPlog templates, if changed, FTP both /photoplog and /forum content, install the product, then call the following to ensure its occurrence:
Code:
admincp/index.php?do=buildbitfields