Mantis upgrade/import errors

[stattersall]

Hi I have exported my mantis database from a server running the following:

os: red hat enterprise es 3
mysql 5.1.22-rc (red-linux-gnu)
PHP 5.2.9
mantis 1.0.8

mysqldump -u root -p mantis > mantisbkp.sql

and I have been running across issues when trying to import the database onto another server running the following:

os: solaris 10 server
mysql 5.1.42
PHP 5.3.1

In Mantis 1.1.8 I created the mantis database via the /admin/install.php page then I imported the database as follows

mysql -u root -p --max_allowed_packet=32M mantis < mantisbkp.sql

As I read on a previous thread somewhere about problems running upgrade.php I decided the test the installation of mantis on 1.1.8 before running this.

After creating a test issue in mantis I got the following error.

APPLICATION ERROR #401

Database query failed. Error received from database was #1054: Unknown column 'target_version' in 'field list' for the query: INSERT INTO mantis_bug_table
( project_id,
reporter_id, handler_id,
duplicate_id, priority,
severity, reproducibility,
status, resolution,
projection, category,
date_submitted, last_updated,
eta, bug_text_id,
os, os_build,
platform, version,
build,
profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version,
target_version
)
VALUES
( '57',
'4', '0',
'0', '20',
'20', '30',
'10', '10',
10, 'Bug',
'2010-02-16 15:53:10','2010-02-16 15:53:10',
10, '445',
'', '',
'', '',
'',
'0', 'test', '10', '0', '0', '',
''
).

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

I have since tried the upgrade.php but I get the following error:

Schema AlterColumnSQL ( mantis_bug_history_table ) GOOD
Schema CreateTableSQL ( mantis_email_table ) BAD
CREATE TABLE mantis_email_table ( email_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(64) NOT NULL DEFAULT '', subject VARCHAR(250) NOT NULL DEFAULT '', submitted DATETIME NOT NULL DEFAULT '1970-01-01 00:00:01', metadata LONGTEXT NOT NULL, body LONGTEXT NOT NULL, PRIMARY KEY (email_id) )TYPE=MyISAM
Table 'mantis_email_table' already exists

can you advise on what the best solution is to get around this. I did read a similiar issue that was posted about a year ago, but there was no clear solution. I wondered if there is any fix since then, thanks in advance,

Steve

[atrol]

First step is to import the database,
then start MantisBT install to update the database