Thanks Owen! Solved the problem. For the record also need an extra '_' in
habari_posts. If anyone wants the complete SQL it's
ALTER TABLE habari__posts ADD COLUMN input_formats VARCHAR(255) NOT NULL;
CREATE TABLE habari__revisions (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
post_id INT UNSIGNED NOT NULL,
change_field VARCHAR(255) NOT NULL,
old_value LONGTEXT DEFAULT NULL,
user_id INT UNSIGNED DEFAULT NULL,
change_date INT UNSIGNED NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY revisions (post_id, change_date, change_field)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE habari__crontab ADD COLUMN failures INT UNSIGNED NOT NULL
DEFAULT 0;
ALTER TABLE habari__crontab ADD COLUMN active TINYINT(1) UNSIGNED NOT NULL
DEFAULT 1;
Problem arose when I had my host update PHP to 5.4. They forgot to change
the php.ini to point to the new version's extensions folder and left it
pointing to the old version's extensions which they noticed was causing
problems so they commented out the extensions_dir in the ini file. (I have
no idea why they thought this was a valid fix)
Anyway, this was the state when I ran the upgrade to 0.9. No surprise
things didn't completely execute. After I got the PHP installation sorted
and ran the SQL everything's running fine.
Dave
On Friday, April 5, 2013 7:46:15 PM UTC-7, ringmaster wrote:
>
> Oops. That CREATE TABLE should be for habari__revisions and not for
> {$prefix}revisions. Too quick to paste.
>
> Owen
>
>
>
--
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at http://groups.google.com/group/habari-dev
---
You received this message because you are subscribed to the Google Groups
"habari-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
