How to upgrade 1.1.4 to 1.2.3

[mhonmon23]

Hi,

Please help me with upgrading mantis 1.1.4 to 1.2.3.
Instructions and guidelines is highly appreciated.


Thanks alot

[atrol]

follow the instructions given in file doc/INSTALL of your MantisBT 1.2.3 download

[mhonmon23]

Thanks.. doing it now.

[mhonmon23]

Hi just want to confirm something..
after I do this => Click install/upgrade

blank page shows up.
is this mean that the upgrade is successful?
Thanks

[atrol]

I don't think that this was successfull.
Check value in mantis_config_table where config_id is database_version
IIRC should be 183

[mhonmon23]

Hi,

These are the values inside mantis_config_table
config_id => database_version
project_id => 0
user_id => 0
access_reqd => 90
type => 1
value => 183

What do you think?

[atrol]

Check if table mantis_user_pref_table has a column advanced_update
If yes, your update failed.
If no, at least all database schema changes are OK and update seems to be OK

[mhonmon23]

Hi Atrol,

I checked my DB and found mantis_user_pref_table, and this mean that my upgrade failed.
What should I do with this?


Thanks

[atrol]

The existence of table mantis_user_pref_table is not a problem, but the existence of a column advanced_update in this table would indicate a problem.

[mhonmon23]

Sorry atrol, I gave a wrong info.
Yes the advanced_update is existed in my mantis_user_pref_table.
What should I do?

Thanks

[atrol]

I have no idea how database_version can be 183 and column advanced_update can exist.
Are you sure that there is just one instance of database?
You should go back to 1.1.4 (I hope you backuped the database) and try again the update.
Did you run http://path/to/mantisbt/admin/check.php before running the upgarde?
Was there any error / warning?

[mhonmon23]

Hi atrol,

While trying to fix this by my own (I know your busy too), I found out that my php.ini is not properly configure.

e.g.
max execution time & mysql.connect_timeout

I set this both to infinite. I will inform you if this solve my problem.

Thanks

[mhonmon23]

Hi atrol,

I think I know now whats happening..
The upgrade stop in mantis_bug_history_table.

It able to convert some of the date_modified to date_modified_int.

I have a big data in my mantis DB.

What configuration should I have in my php.ini and my.ini (php and mysql)
so it can continue this large upgrade.

remember that I already changed
max execution time & mysql.connect_timeout to infinite

Thanks alot

[mhonmon23]

my computer specs :
HP core 2 duo 2.93
2G memory
300G HD
win7 OS

Im using wamp
Apache 2.0.63
PHP 5.3
Mysql 5.1.34

[atrol]

My last post get lost!!! Seems there is also a bug in forum

You could change the upgrade process and disable the upgrading of date.

After running the upgrade, migrate dates by direct manipulating of database
http://www.mantisbt.org/bugs/view.php?id=12357