FudForum 2.3.5 [message #18990] |
Mon, 21 June 2004 10:59 |
Eddie
Messages: 40 Registered: March 2003
Karma: 0
|
Member |
|
|
I have to change a forum version 2.3.5 to another server. The problem is that the file system on the new server is different. So I can't transfer all files by tar.
I made the following: I installed on the new server the same software 2.3.5. Then I merged the database and the directories with data from the old server to the new server.
I adapted the rights of the files that the forum can start and I reloadet the database.
Thereafter I can work with the forum on the new server. It seems all to work without one little detail: The private messages do not longer work.
I can read all old pms without problems. I can send a new message. But when I read this new pm either in my own outgoing box or in the incoming box of the receptient I get a message: Message contains no data. The data in the file "private" the message seems to be added as it should but in the database, the table "fud23_pms", there is a value 0 in the field length, while in all other entries there is a value representing the length of the message.
I'm trying out since 2 days to maintan the data in the admins section but without success. I looked again and again over the file permissions but I cant find an error.
So please can someone give me an instruction what I have do to move the forum to the new server.
Thanks in advance
|
|
|
Re: FudForum 2.3.5 [message #18991 is a reply to message #18990] |
Mon, 21 June 2004 13:01 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Make sure that the permissions of the files insides the messages/ directory are such that the web server can write to them. If the "private" file does not exist, create it (touch private) and chmod it 666.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #18994 is a reply to message #18993] |
Mon, 21 June 2004 13:46 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Sounds like a bug or lack of permissions to write. Try upgrading your forum.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #18999 is a reply to message #18996] |
Mon, 21 June 2004 14:58 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
I highly doubt a forum would be corrupted by an upgrade process.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19011 is a reply to message #18990] |
Mon, 21 June 2004 20:31 |
Eddie
Messages: 40 Registered: March 2003
Karma: 0
|
Member |
|
|
I restarted the Upgrade and I had the followings errors:
1:
MySQL Error: #1034 (Incorrect key file for table: 'fud23_ses'. Try to repair it): DELETE FROM fud23_ses WHERE sys_id='0'
I deleted all entries where sys_id = 0, then I repaired the table.
2:
MySQL Error: #1062 (Duplicate entry '2147483647' for key 1): ALTER TABLE fud23_action_log CHANGE id id INT NOT NULL AUTO_INCREMENT
I deleted all entgries in this table because I could'nt find the entry 2147....
3:
Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/home/ovh/www/forum-nolwenn/forumdata/errors/.backup/"
Beginning SQL Upgrades
SQL Upgrades Complete
Creating Avatar Cache
Notice: Undefined offset: 6 in /home/ovh/www/forum-nolwenn/upgrade.php on line 1276
Notice: Undefined offset: 6 in /home/ovh/www/forum-nolwenn/upgrade.php on line 1277
Populating pdest field for private messages
Reserving id for anon users
MySQL Error: #1064 (You have an error in your SQL syntax near 'on aime certaines personnes ; on s'en va parce qu'on en déteste d'autres. Il n'y' at line 1): INSERT INTO fud23_users (login,alias,passwd,name,email,location,interests,occupation,avatar,avatar_ loc,icq,aim,yahoo,msnm,jabber,posts_ppg,time_zone,bday,join_date,conf_key,u ser_image,theme,posted_msg_count,last_visit,referer_id,last_read,custom_sta tus,sig,level_id,reset_key,u_last_post_id,home_page,bio,cat_collapse_status ,affero,custom_color,buddy_list,ignore_list,group_leader_list,users_opt,sq, reg_ip) VALUES('Mira on the wall','Mira on the wall','38a701508e017be2a47991fe7699eca6','Administrator','mira(at)nolwenn(dot)org','','','','0','<img src="http://www.nolwenn-online.de/images/custom_avatars/1.jpg" width="100" height="100" /> ','','','','','','0','Europe/Paris','0','1046336810','0','','1','4784','108 7448949','0','0',' <font class="LevelText">Administrator<br></font>','"On ne reste pas parce qu'on aime certaines personnes ; on s'en va parce qu'on en déteste d'autres. Il n'y a que le moche qui vous fasse agir. On est lâches." - Boris Vian<br /> <br /> <br /> *Soutient Eve Angeli dans sa quête du Moi.*','6','0','124435','http://www.nolwenn.org','','','','','','','','9599484','','0')
I changed the entry a little bit so I could insert this row in the users table.
Finally the upgrade could be finished.
Now all forums are lost and just one user is in the table. You see that there are a lot of problems in converting the database.
Actually I try out to rebuilt the index to see what happens.
|
|
|
Re: FudForum 2.3.5 [message #19012 is a reply to message #19011] |
Mon, 21 June 2004 20:33 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Did you run the consistency checker after completing the upgrade?
FUDforum Core Developer
|
|
|
Re: FudForum 2.3.5 [message #19013 is a reply to message #18990] |
Mon, 21 June 2004 20:44 |
Eddie
Messages: 40 Registered: March 2003
Karma: 0
|
Member |
|
|
Disabling the forum for the duration of maintenance run
Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
OK
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
3534 entries unmatched, deleted
Checking messages against users & threads
10481 entries unmatched, deleted
Checking threads against forums
OK
Checking message approvals
Done: Checking message approvals
Checking threads against messages
OK
Checking thread last & first post ids
Done: Checking thread last & first post ids
Checking forum & topic relations
Done: Checking forum & topic relations
Validating Forum Order
Done: Validating Forum Order
Checking thread_exchange
OK
Checking read table against users & threads
15824 entries unmatched, deleted
Checking file attachments against messages
726 entries unmatched, deleted
Rebuild attachment cache for regular messages
Done: Rebuild attachment cache for regular messages
Rebuild attachment cache for private messages
Done: Rebuild attachment cache for private messages
Checking message reports
OK
Checking polls against messages
35 entries unmatched, deleted
Checking polls options against polls
45 entries unmatched, deleted
Checking polls votes
65 entries unmatched, deleted
Rebuilding poll cache
Done: Rebuilding poll cache
Validating poll activation
Done: Validating poll activation
Checking smilies against disk files
OK
Checking disk files against smilies
OK
Checking topic notification
2 entries unmatched, deleted
Checking forum notification
3 entries unmatched, deleted
Checking topic votes against topics
11 entries unmatched, deleted
Rebuild topic rating cache
Done: Rebuild topic rating cache
Rebuilding Topic Views
Done: Rebuilding Topic Views
Rebuilding user ranks, message counts & last post ids
Done: Rebuilding user levels, message counts & last post ids
Checking buddy list entries
3 entries unmatched, deleted
Checking ignore list entries
10 entries unmatched, deleted
Rebuilding buddy list cache
Done: Rebuilding buddy list cache
Rebuilding ignore list cache
Done: Rebuilding ignore list cache
Rebuilding ip filter cache
Done: Rebuilding ip filter cache
Rebuilding login filter cache
Done: Rebuilding login filter cache
Rebuilding email filter cache
Done: Rebuilding email filter cache
Rebuilding extension filter cache
Done: Rebuilding extension filter cache
Rebuilding custom tags for users
Done Rebuilding custom tags for users
Validating group resources
OK
Done: Validating group resources
Validating group validity
6 entries unmatched, deleted
OK
Done: Validating group validity
Validating group members
OK
Done: Validating group members
Validating group/forum relations
Done: Validating group/forum relations
Validating group/forum names
Done: Validating group/forum names (fixed: 0 relations)
Validating group/primary user relations
Done: Validating group/primary user relations
Rebuilding group leader cache
Done: Rebuilding group leader cache
Rebuilding group cache
Done: Rebuilding group cache
Validating User/Theme Relations
Done: Validating User/Theme Relations
Rebuilding Forum/Category order cache
Done: Rebuilding Forum/Category order cache
Remove absolete entries inside sessions table
Done: Removing absolete entries inside sessions table
Unlocking database
Database unlocked
Cleaning forum's tmp directory
Done: Cleaning forum's tmp directory
Validate GLOBALS.php
Done: Validate GLOBALS.php
Re-enabling the forum.
DONE
It is recommended that you run SQL table optimizer after completing the consistency check. To do so click here, keep in mind that this process make take several minutes to perform.
Now it looks much better. I refound the forums and the users. I will test a bit more to see if its really OK now.
But tell me if it's a problem that I have deleted all entries in fud23_action_log?
|
|
|
|
|
Re: FudForum 2.3.5 [message #19026 is a reply to message #19025] |
Tue, 22 June 2004 16:16 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
You can remove data from the sessions table, it won't break anything.
FUDforum Core Developer
|
|
|
Re: FudForum 2.3.5 [message #19029 is a reply to message #18990] |
Tue, 22 June 2004 17:53 |
Eddie
Messages: 40 Registered: March 2003
Karma: 0
|
Member |
|
|
I trieed it out again.
At first I have to say that in the browser I get 2 times a time out. Then I go back and restart again. I don't know if that can do something wrong.
Finally I got these message:
Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/home/ovh/www/forum-nolwenn/forumdata/errors/.backup/"
Beginning SQL Upgrades
SQL Upgrades Complete
Creating Avatar Cache
Notice: Undefined offset: 6 in /home/ovh/www/forum-nolwenn/upgrade.php on line 1276
Notice: Undefined offset: 6 in /home/ovh/www/forum-nolwenn/upgrade.php on line 1277
Reserving id for anon users
MySQL Error: #1064 (You have an error in your SQL syntax near 'on aime certaines personnes ; on s'en va parce qu'on en déteste d'autres. Il n'y' at line 1): INSERT INTO fud23_users (login,alias,passwd,name,email,location,interests,occupation,avatar,avatar_ loc,icq,aim,yahoo,msnm,jabber,posts_ppg,time_zone,bday,join_date,conf_key,u ser_image,theme,posted_msg_count,last_visit,referer_id,last_read,custom_sta tus,sig,level_id,reset_key,u_last_post_id,home_page,bio,cat_collapse_status ,affero,custom_color,buddy_list,ignore_list,group_leader_list,users_opt,sq, reg_ip) VALUES('Mira on the wall','Mira on the wall','38a701508e017be2a47991fe7699eca6','Administrator','mira(at)nolwenn(dot)org','','','','0','<img src="http://www.nolwenn-online.de/images/custom_avatars/1.jpg" width="100" height="100" /> ','','','','','','0','Europe/Paris','0','1046336810','0','','1','4786','108 7925069','0','0',' <font class="LevelText">Administrator<br></font>','"On ne reste pas parce qu'on aime certaines personnes ; on s'en va parce qu'on en déteste d'autres. Il n'y a que le moche qui vous fasse agir. On est lâches." - Boris Vian<br /> <br /> <br /> *Soutient Eve Angeli dans sa quête du Moi.*','6','0','124670','http://www.nolwenn.org','','','','','','','','9599484','','0')
I deleted the two tables aw we told about but I forgot to corrige the entry for the User Mira on the wall. There must be an error in the code because the field sig cannot be handled.
But then I have a question:
What are the error messages line 1276 and in line 1277?
Finally I can't start the forum and I cannot go into the admins section wit the following error messages:
Fatal error: Cannot redeclare intzero() (previously declared in /home/ovh/www/forum-nolwenn/index.php:47) in /home/ovh/www/forum-nolwenn/forumdata/include/core.inc on line 114
Fatal error: Cannot redeclare intzero() (previously declared in /home/ovh/www/forum-nolwenn/forumdata/include/core.inc:114) in /home/ovh/www/forum-nolwenn/forumdata/include/theme/default/db.inc on line 43
|
|
|
Re: FudForum 2.3.5 [message #19033 is a reply to message #19029] |
Tue, 22 June 2004 19:44 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The warnings are related to avatars. To be specific getimagesize() has return an unknown extension for the file.
The query failure I believe maybe a bug, I've just fixed in the upgrade script.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19045 is a reply to message #19042] |
Wed, 23 June 2004 12:43 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Running it from the command line would be safer then via the web if a lot of work needs to be done. BUT you need to make sure the forum is unlocked first.
FUDforum Core Developer
|
|
|
|
|
|
Re: FudForum 2.3.5 [message #19052 is a reply to message #19051] |
Wed, 23 June 2004 13:40 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
add the following at the top of the script
$_POST['login'] = 'your login';
$_POST['passwd'] = 'your password';
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19054 is a reply to message #19053] |
Wed, 23 June 2004 16:22 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
What directories do you have inside
/home/ovh/www/forum-nolwenn/forumdata/thm/ ?
FUDforum Core Developer
|
|
|
Re: FudForum 2.3.5 [message #19055 is a reply to message #18990] |
Wed, 23 June 2004 16:32 |
Eddie
Messages: 40 Registered: March 2003
Karma: 0
|
Member |
|
|
ls -rtla
total 24
-rw-rw-rw- 1 nobody nobody 14 jun 22 13:47 .htaccess
drwxrwxrwx 5 nobody nobody 4096 jun 22 13:47 default
drwxrwxrwx 12 root root 4096 jun 22 14:10 ..
drwxr-xr-x 3 root root 4096 jun 23 16:34 path_info
drwxr-xr-x 2 root root 4096 jun 23 16:42 french
drwxrwxrwx 5 nobody nobody 4096 jun 23 16:42
[Updated on: Wed, 23 June 2004 16:33] Report message to a moderator
|
|
|
Re: FudForum 2.3.5 [message #19056 is a reply to message #19055] |
Wed, 23 June 2004 16:33 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
what directories exist in the french directory?
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19058 is a reply to message #19057] |
Wed, 23 June 2004 16:45 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Looks like the upgrade script didn't have permissions to create the tmpl directory.
FUDforum Core Developer
|
|
|
Re: FudForum 2.3.5 [message #19059 is a reply to message #18990] |
Wed, 23 June 2004 16:49 |
Eddie
Messages: 40 Registered: March 2003
Karma: 0
|
Member |
|
|
And that means? What can I do now?
Here the file structure of thm and default:
[root@ns2777 thm]# ls -rtl
total 12
drwxrwxrwx 5 nobody nobody 4096 jun 22 13:47 default
drwxr-xr-x 3 root root 4096 jun 23 16:34 path_info
drwxr-xr-x 2 root root 4096 jun 23 16:42 french
[root@ns2777 thm]# cd default
[root@ns2777 default]# ls -rtl
total 12
drwxrwxrwx 24 nobody nobody 4096 jun 23 16:34 i18n
drwxrwxrwx 2 nobody nobody 4096 jun 23 16:34 tmpl
drwxrwxrwx 2 nobody nobody 4096 jun 23 16:34 images
Can I delete french and path info?
[Updated on: Wed, 23 June 2004 16:52] Report message to a moderator
|
|
|
Re: FudForum 2.3.5 [message #19060 is a reply to message #19059] |
Wed, 23 June 2004 16:50 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Check permissions, make sure the user you are running the script as has permissions to write to thm/french/ directory.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19068 is a reply to message #19061] |
Wed, 23 June 2004 20:42 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Rerun the script, it'll resume where it left off.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19095 is a reply to message #19087] |
Thu, 24 June 2004 13:30 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The problem is due to the theme build process failing as can be seen from the earlier error. No idea why that is happening.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19100 is a reply to message #19098] |
Thu, 24 June 2004 15:02 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
That could be a problem, chown the files to your webserver user/group.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19103 is a reply to message #19098] |
Thu, 24 June 2004 17:23 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Chown them to the user/group your webserver runs as.
FUDforum Core Developer
|
|
|
|
Re: FudForum 2.3.5 [message #19129 is a reply to message #19104] |
Sat, 26 June 2004 21:07 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Don't know... something is clearly wrong I am just not sure what.
FUDforum Core Developer
|
|
|