Oops. That CREATE TABLE should be for habari__revisions and not for
{$prefix}revisions. Too quick to paste.
Owen
On Friday, April 5, 2013 10:45:10 PM UTC-4, ringmaster wrote:
>
> 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.
