RE: did you try to install Openfire 3.6.x and let Openfire update the MySQL database? This should work and would be the most easy solution.
Actually i did install openfire 3.6 and overwrite the old version and the moment i open the web console while prompting database i got an error like problem on tables…
RE: Look in the openfire_3_6_3/resources/database/upgrade/ directory. There you will find the update scripts 17/openfire_mysql.sql, 18/openfire_mysql.sql, 19/openfire_mysql.sql and 20/openfire_mysql.sql which you can run manually.
So it means that ill connect to the old database of openfire 3.5 then go to MSSQL analyzer then run the 17,18,19,20 MSSQL.sql scripts to update it to
OPENFIRE 3.6 database?
im currently using MSSQL server 2000
I restore the old database from openfire 3.5 to MSSQL SERVER 2000
Installed Openfire 3.6.x
Heres the screenshot of the error… i also attached the console errors of somekind of upgrading…thanks…
thanks for the reply LG.
openfire errors.txt (3965 Bytes)