2.6.4 upgrade error in update.php

[macchickpro]

From 2.0.15
PGSQL 8.4
PHP 5.3
macosx 10.6.3

update.php has an error in one of the query line 365/366

Code: Select all

  $query[] = "ALTER TABLE ".SQLPREFIX."faqdata ADD sticky INTEGER NOT NULL AFTER active";
                $query[] = "ALTER TABLE ".SQLPREFIX."faqdata_revisions ADD sticky INTEGER NOT NULL AFTER active";

AFTER is not valid here

ADD STICKY INTEGER NOT NULL requires a default value (because it adds the column to an existing database and wants to fill it with something NOT NULL (I guess).

I removed the AFTER ACTIVE and set the default to 0 and it worked

[Thorsten]

Hi,

thanks for the hint, I fixed it for the 2.6.5 release.

bye
Thorsten