From: <Dom...@at...> - 2007-06-12 08:51:09
|
Dear all, =20 we have a running Mantis 0.19.0 installation and need to upgrade to the = current version 1.1.0a3. After I performed the update with a copy of our = production i have had some errors with SQL-Statements. First of all = there was a column missing in the mantis_user_table after I changed the = user_api.php it was possible to perform a login. =20 Now I get an error called: =20 #1054: Unknown column 'sticky' in 'order clause' f=FCr die Abfrage: = SELECT DISTINCT mantis_bug_table.* FROM mantis_bug_table WHERE mantis_bug_table.id in (4232, 7110, 7137, 7500) ORDER BY sticky DESC, last_updated DESC, date_submitted DESC =20 It's a missing field in the database, too. =20 =20 I try to upgrade like this: 1. Make a fresh install of Version 1.1.0a3 2. Flush the old data into the new tables Is this the right way? Has anybody more knowledge about upgrade in this = szenario? =20 Thanks a lot! =20 Dominique Atos Origin GmbH, Theodor-Althoff-Str. 47, D-45133 Essen, Postfach 100 123, D-45001 Essen Telefon: +49 201 4305 0, Fax: +49 201 4305 689095, www.atosorigin.de Dresdner Bank AG, Hamburg: Kto. 0954411200, BLZ 200 800 00, Swift Code DRESDEFF200, IBAN DE69200800000954411200 Geschäftsführer: Dominique Illien, Handelsregister Essen HRB 19354, Ust.-ID.-Nr.: DE147861238 |