[Maintain-dev] [JIRA] Commented: (MNT-1273) Data conversion and update scheme

Kirsten Petersen (JIRA) jira at osuosl.org
Wed Jan 31 02:20:00 PST 2007

     [ http://bugs.osuosl.org/browse/MNT-1273?page=comments#action_11215 ]
Kirsten Petersen commented on MNT-1273:

In trying to upgrade the database from 2.4 to 3.1, I get this message:

  Form Errors
  Please review the following error(s) below.
        MySQL error: Table 'maintain.host_history' doesn't exist

The only history table I have in Maintain 2.4 is object_history.

My update_info table contains the following, if it helps:
db_version      240001

Shouldn't the script simply create missing tables?  Or maybe it is expecting to rename a table, but the name it is looking for is incorrect?

> Data conversion and update scheme
> ---------------------------------
>          Key: MNT-1273
>          URL: http://bugs.osuosl.org/browse/MNT-1273
>      Project: Maintain
>         Type: Task
>     Versions: 3.1
>     Reporter: Brandon Philips
>     Assignee: Zack Bartel
>     Priority: Urgent
>      Fix For: 3.1

> Original Estimate: 2 weeks
>         Remaining: 2 weeks
> Keeping the data from older versions of Maintain alive is very important.  We need to create some scripts that will not only transition the old data to the new schema but also create a log of problems that exist.  I have a feeling that after the foreign key constraints are put on the DB alot of problems will be found.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

More information about the Maintain-dev mailing list