U++ forum: Welcome to the forum

Sat, 29 March 2014 18:32

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Forum upgrade is now top priority, unfortunately the process is far from simple. I will use this thread to comment on steps and glitches. I am writting this mostly for myself, but if anybody with better PHP experience would be willing to help at points where I am stuck, it would be very helpful.

First of all, we need to achieve is to

* install LAMP at local machine
* install 2.7.6 at local machine
* import forum dump into 2.7.6
* upgrade 2.7.6 to 3.0.0
* upgrade 3.0.0 to 3.0.5
* export forum dump
* install 3.0.5 at ultimatepp.org
* import forum dump
* pray everything works Smile

You can download forum dump at

http://www.ultimate.org/forum/FUDforum_23_03_2014_06_27.fud. gz

if you want to experiment/help.

Now, after importing dump into 2.7.6, forum stops working. I have already found that there is a problem with themes which can be fixed by issuing

update fud_users set theme = 1;

Now it is possible to run consistency check, but it fails because of changes in MySQL. To make it work, add

q("UNLOCK TABLES");

at adm/consist.php line 299.

Anyway, after this consistency check passes, but all forums are empty...

I have also tried alternative path, upgrading to 3.0.0 immediately without consistency check (with the hope that the check is better in higher version). There I am for now stuck with

ERROR: Duplicate entry '�ou' for key 'fud26_search_i_w'
QUERY: ALTER TABLE fud26_search CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

during upgrade process. I think this is unrelated to empty forums and will have to be dealt with anyway.

Report message to a moderator