phpBMS icon indicating copy to clipboard operation
phpBMS copied to clipboard
verified publisher icon weex

Bug Fix - MySQL 5.5.8 Install Errors

Open jwjmurray opened this issue 14 years ago • 1 comments

Attempts to install on servers running MySQL 5.5.8 fail with numerous SQL errors during the install process. These stem from the changes made to the timestamp functionality in later versions on MySQL and are fairly easy to correct.

  • Replace all occurrences of modifieddate timestamp(14) NOT NULL with modifieddate timestamp DEFAULT CURRENT_TIMESTAMP
  • Replace all occurrences of modifieddate timestamp(14) with modifieddate timestamp

This will correct the install files and allow the installer to complete. Note this needs to be done in all install directories (including modules).

I have a full set of fixed install files available if needed, let me know.

Jim.

jwjmurray avatar Sep 01 '11 09:09 jwjmurray

Thanks for the description. Instead of the files, would you consider creating a pull request by forking, patching, etc?

weex avatar Oct 29 '11 08:10 weex