20
« on: February 25, 2009, 05:57:49 am »
Hi - upgraded from 1.2 rc2 - 1.2.0.1 -> 1.2.1 -> 1.3 beta.
I did a quick test of the intermediate steps, and they seemed okay.
With version 1.3 beta I am getting the following error in the mail module:
Query failed with message 'Unknown column 'content_file_id' in 'field list''
SELECT `id`, `account_id`, `uid`, `from`, `from_name`, `to`, `date`, `sent_date`, `subject`, `content`, `body_plain`, `body_html`, `has_attachments`, `size`, `state`, `is_deleted`, `is_shared`, `is_private`, `created_on`, `created_by_id`, `trashed_on`, `trashed_by_id`, `imap_folder_name`, `account_email`, `content_file_id` FROM `og_mail_contents` WHERE `id` = '173'
I have had a look at the file db_migration/chinchulin.php and all the other columns to be added seem to have been added.
I thought chinchulin.php was the latest - seem to be a later file. Lovely names - but not helpful. I mean I can't even remember if I am on Gutsy or Heron (Kubuntu 8.10).
Anyway - I will try to add the table and hope it does not get populated with anything :-)
ALTER TABLE `<?php echo $table_prefix ?>mail_contents` ADD COLUMN `content_file_id` VARCHAR(40) NOT NULL default '';