Hi Dave,
Sorry you're having trouble with the upgrade.
I've put together a set of SQL statements that should get you from 0.8 to
0.9.1 (which should also work with 0.9, if you're still using that):
ALTER TABLE habari_posts ADD COLUMN input_formats VARCHAR(255) NOT NULL;
CREATE TABLE {$prefix}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;
If you run those and have further trouble, please write again. After you
get this sorted out, we'll have to see if we can figure out what caused the
problem.
Owen
On Friday, April 5, 2013 10:03:38 PM UTC-4, Dave Perry wrote:
>
> Need some help here. Upgraded my site installation to 0.9 from 0.8 but due
> to a botched PHP upgrade I think the database tables were not modified for
> changes in 0.9. I am getting column not found errors like
>
> Column not found: 1054 Unknown column 'habari__posts.input_formats' in 'field
> list'
>
> Result can be seen at giantscreamingrobotmonkeys.com
>
> Any chance there is a SQL or PHP script that I can manually run to update the
> database?
>
> At the very least with a list of the changes I can update the tables by hand.
>
> Anyone?
>
> Thanks,
>
> Dave
>
>
--
--
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.
