Dear all,
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.
Now I get an error called:
#1054: Unknown column 'sticky' in 'order clause' für 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
It's a missing field in the database, too.
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?
Thanks a lot!
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
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
mantisbt-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mantisbt-help
