|
|
Home » Community » U++ Webs: Functioning, Layout , Design, Features and Structure of these forums, homepage etc. » Forum upgrade
Forum upgrade [message #42693] |
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
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
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.
|
|
|
|
|
|
|
Re: Forum upgrade [message #42702 is a reply to message #42701] |
Sun, 30 March 2014 13:41 |
|
mirek
Messages: 13975 Registered: November 2005
|
Ultimate Member |
|
|
New problem (while upgrading do 3.0.5):
Fatal error: Uncaught exception 'Exception' with message '1062:
Duplicate entry '147641-32818' for key 'PRIMARY' @ ALTER IGNORE TABLE fud26_title_index ADD PRIMARY KEY (word_id,msg_id)' in /var/www/forum/upgrade.php:170
Stack trace: #0 /var/FUDforum/sql/mysql/db.inc(72): fud_sql_error_handler('ALTER IGNORE TA...', 'Duplicate entry...', 1062, '5.5.35-0ubuntu0...') #1 /var/FUDforum/include/dbadmin.inc(359):
q('ALTER IGNORE TA...') #2 /var/www/forum/upgrade.php(980): create_primary_key('fud26_title_ind...', 'word_id,msg_id') #3 {main} thrown in /var/www/forum/upgrade.php on line 170
[Updated on: Sun, 30 March 2014 14:17] Report message to a moderator
|
|
|
Re: Forum upgrade [message #42703 is a reply to message #42702] |
Sun, 30 March 2014 13:52 |
|
mirek
Messages: 13975 Registered: November 2005
|
Ultimate Member |
|
|
Fix:
create temporary table temp (word_id int, msg_id int);
insert into temp select word_id, msg_id from fud26_title_index group by word_id, msg_id;
delete from fud26_title_index where msg_id > -10;
insert into fud26_title_index select word_id, msg_id from temp;
drop table temp;
[Updated on: Sun, 30 March 2014 14:17] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Forum upgrade [message #42726 is a reply to message #42721] |
Mon, 31 March 2014 14:07 |
|
mirek
Messages: 13975 Registered: November 2005
|
Ultimate Member |
|
|
PM, signature fix:
update fud30_users set users_opt = users_opt & ~(1073741824|131072|2097152|1|268435456|1048576|2097152|65536|33554432|67108864|16777216|536870912|8|32768|128|256) where id <> 3;
update fud30_users set users_opt = users_opt | 131072|64|16384 where id <> 3;
[Updated on: Sat, 05 April 2014 12:52] Report message to a moderator
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat May 04 17:51:26 CEST 2024
Total time taken to generate the page: 0.02903 seconds
|
|
|