Skip to main content

Replied to a post on :

If its a new install, apply mysql.sql. If it's an old install you're updating install the sql patches in chronological order where those dates are greater than that in your versions table.

Most people should be update automatically, but it seems that a couple of folk this update failed... not sure why, but I suspect it was because the code was passing multiple line queries to the PDO driver (which is bad).

Some patches are safe to double up on, others may not be, but I can't think of any since 99/100 reapplying something like an alter table will simply puke.

Applying them in order is important though, since e.g. insert column queries rely on the table being an expected format.

Because this is messing with the database, you should of course take a backup of your database first :)