Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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 Go to next message
mirek is currently offline  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.
Re: Forum upgrade [message #42694 is a reply to message #42693] Sat, 29 March 2014 18:36 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
update fud26_search set word = 'you2' where id = 161729;
update fud26_search set word = 'eai2' where id = 169972;


Seems to fix the duplicate key error.
Re: Forum upgrade [message #42695 is a reply to message #42694] Sat, 29 March 2014 18:47 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
...but now consistency check stops at

Checking for presence of forum lock tables
Re: Forum upgrade [message #42700 is a reply to message #42695] Sun, 30 March 2014 11:51 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
OK, latest issue is the same as in 2.7.6, so it needs (in 3.0.0) to add

q("UNLOCK TABLES");


at line 299 of consist.php.

Now once again, status the same as with 2.7.6: forums are empty.
Re: Forum upgrade [message #42701 is a reply to message #42700] Sun, 30 March 2014 13:39 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Empty forum are caused by invalid topics_per_page setting in users. To fix:

update forum.fud26_users set topics_per_page = 25;


Now the forum seems to be working, only part of structure and all theming is lost. I guess it will be actually cheaper to recreate them then trying to find a way how to migrate them.

Now going on to try ugrading to the latest fudforum version.
Re: Forum upgrade [message #42702 is a reply to message #42701] Sun, 30 March 2014 13:41 Go to previous messageGo to next message
mirek is currently offline  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 Go to previous messageGo to next message
mirek is currently offline  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 #42704 is a reply to message #42703] Sun, 30 March 2014 14:03 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
And one more:

create temporary table temp (word_id int, msg_id int);
insert into temp select word_id, msg_id from fud26_index group by word_id, msg_id;
delete from fud26_index where msg_id > -10;
insert into fud26_index select word_id, msg_id from temp;
drop table temp;
Re: Forum upgrade [message #42705 is a reply to message #42704] Sun, 30 March 2014 14:19 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
One last issue: Forum now thinks I am a bot. This fixes that:

update fud26_users set users_opt = users_opt & ~1073741824 where id > -1;
Re: Forum upgrade [message #42707 is a reply to message #42705] Sun, 30 March 2014 15:20 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
The last sql should be perhaps changed to

update fud26_users set users_opt = users_opt & ~(1073741824|131072|2097152) where id > -1;


to fix more issues...
Re: Forum upgrade [message #42713 is a reply to message #42707] Sun, 30 March 2014 20:52 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
(obsoleted)

[Updated on: Mon, 31 March 2014 14:08]

Report message to a moderator

Re: Forum upgrade [message #42721 is a reply to message #42713] Mon, 31 March 2014 10:06 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Fix for join date:

update forums.fud30_users n set join_date = (select o.join_date from ultimatepp.fud26_users o where o.id = n.id);
Re: Forum upgrade [message #42726 is a reply to message #42721] Mon, 31 March 2014 14:07 Go to previous messageGo to next message
mirek is currently offline  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

Re: Forum upgrade [message #42741 is a reply to message #42726] Tue, 01 April 2014 18:03 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Fix of home_page, delete skype, google:

update forums.fud30_users n set home_page = (select o.home_page from ultimatepp.fud26_users o where o.id = n.id), skype = NULL, google = NULL;
Re: Forum upgrade [message #42748 is a reply to message #42741] Tue, 01 April 2014 19:58 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Time-zone fix:

update forums.fud30_users n set time_zone = (select o.time_zone from ultimatepp.fud26_users o where o.id = n.id);
Re: Forum upgrade [message #42847 is a reply to message #42748] Thu, 10 April 2014 00:55 Go to previous messageGo to next message
nixnixnix is currently offline  nixnixnix
Messages: 415
Registered: February 2007
Location: Kelowna, British Columbia
Senior Member
Not sure if you're aware of this but when I try to search UPP I often get directed to a page which says

Forum upgraded
Administrators can login here

If you're already aware of this then I don't mean to jump on and add to your woes.

Good luck!

Nick

Re: Forum upgrade [message #42849 is a reply to message #42847] Thu, 10 April 2014 08:14 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Search where?

About that page... I have taken conservative approach here, old forum is still installed on the website, just disabled. New forum has a new link to it (it ends 'forums' instead of 'forum').

Mirek
Re: Forum upgrade [message #42850 is a reply to message #42849] Thu, 10 April 2014 10:36 Go to previous messageGo to next message
nlneilson is currently offline  nlneilson
Messages: 644
Registered: January 2010
Location: U.S. California. Mojave &...
Contributor
mirek wrote on Wed, 09 April 2014 23:14
Search where?

That is the page that comes up with the old link to the Upp forum.

The upgraded forum seems great so far.
Re: Forum upgrade [message #42851 is a reply to message #42850] Thu, 10 April 2014 10:49 Go to previous message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
nlneilson wrote on Thu, 10 April 2014 08:36
mirek wrote on Wed, 09 April 2014 23:14
Search where?

That is the page that comes up with the old link to the Upp forum.


Then that is correct, for now. I will put there some redirect soon.

Mirek
Previous Topic: To forum moderators: We are starting to be too harsh rejecting accounts
Next Topic: Smaller pics on the forum
Goto Forum:
  


Current Time: Thu Mar 28 11:27:15 CET 2024

Total time taken to generate the page: 0.01549 seconds