|
Re: Upgrade Problems [message #19974 is a reply to message #19966] |
Mon, 20 September 2004 20:21 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The GLOBALS.php, the forum's settings file is clearly broken based on what you have pasted. You need to ensure that all files are readable by the upgrade script when it runs.
Make a list of all the files for which there was a permissions problem and ensure that they are readable and writable by the user the webserver runs as that is the user by whom the upgrade script will be running as.
FUDforum Core Developer
|
|
|
Re: Upgrade Problems [message #19981 is a reply to message #19974] |
Mon, 20 September 2004 20:51 |
Lynky
Messages: 38 Registered: May 2003 Location: Germany
Karma: 0
|
Member |
|
|
Hallo,
thank you very much for your quick answer.
Unfortunately I don't know anymore which files were locked. I haven't been so smart to make a print of it, because I thought, I'll upload my backups again.
I didn't make a dumb of the data with the forum's dumb function, instead I took the provider's backup-function, which creates a complete backup of all the files in the forum directory as backup.tgz.
I thought the best would be to extract the backed up files, upload them (so I should have all the rights to give to the necessary files) and then run the upgrade-script again... but... it didn't work.
I've tried to upload these files several times, but the only thing I get is a blank screen when I enter the start page. So it doesn't make sense to run the upgrade-skript when even the old version doesn't work.
First I thought, the unix-link of the globals.php gets broken while extracting the archive on a NTFS-filesystem, but I was trying to create one with a php-script and it didn't work, too.
I'm messing around with this issue for more than two weeks and the forum is down for that time. I don't have any idea what to do next. I would be glad enough to restore the old 2.5.2 version, but I don't even get this
Do you have any idea, how I can solve my problems?
Thank you very much in advance,
a helpless Lynky
|
|
|
Re: Upgrade Problems [message #19984 is a reply to message #19981] |
Mon, 20 September 2004 21:05 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Ok, when you made a backup I hope you made a backup of not only the forum's files but also the forum's database data, otherwise fixing things is far more difficult.
As far as restoring the compressed files, after you decompress them make sure to chmod all files 666 and all directories 777 so that the forum can write/modify them. Once that is done try to re-run the upgrade script.
FUDforum Core Developer
|
|
|
|
Re: Upgrade Problems [message #19990 is a reply to message #19989] |
Mon, 20 September 2004 21:27 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
even if the old forum does not run, as long as it's data is in place and has proper permissions the upgrade script can run.
Since you have a database dump, good thinking on your part btw, be sure to import it before running the upgrade script.
FUDforum Core Developer
|
|
|
|
Re: Upgrade Problems [message #19997 is a reply to message #19992] |
Mon, 20 September 2004 22:17 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The script needs the symlinks inside the forum's main dir and adm/ dir to exist to the "real" GLOBALS.php inside the forum's include/ directory.
FUDforum Core Developer
|
|
|
|
forum files unlocked but database problem [message #20004 is a reply to message #19997] |
Tue, 21 September 2004 08:11 |
Lynky
Messages: 38 Registered: May 2003 Location: Germany
Karma: 0
|
Member |
|
|
Hallo,
I've uploaded the 2.5.2 forum files again, created the symlinks to the GLOBALS.php, chmod all the directories with 777 and the files with 666 (including all subdirectories).
So I think the forum files would be ready for another try to upgrade.
Then I deleted the broken forum tables and tried to copy the old tables to the operating database. Everything worked fine but in table fud21_search (prefix because of an earlier FUD-version) mysql throws an exception:
#1062 - Duplicate entry 'das' for key 2
... the only thing is - that is not true! The first 218 Datasets import well, but on this _first_ occurence of the value "das" it throws it.
I can just copy the table with phpMyAdmin oder export and import the SQL into the new database - Although it hangs at this Dataset (when I delete it, it hangs 5 datasets past).
The SQL seems to be OK:
CREATE TABLE `fud21_search` (
`id` int(10) unsigned NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `word` (`word`)
) TYPE=MyISAM AUTO_INCREMENT=41460 ;
...
INSERT INTO `fud21_search` VALUES (218, 'schade,');
INSERT INTO `fud21_search` VALUES (219, 'das');
INSERT INTO `fud21_search` VALUES (220, 'solchen');
The Table-Structure is identically with the old structure.
MySQL-server-version: 4.0.20
Any idea to avoid this error?
Thank you in advance,
Lynky (now even more confused)
[Updated on: Tue, 21 September 2004 08:12] Report message to a moderator
|
|
|
|
Re: forum files unlocked but database problem [message #20016 is a reply to message #20014] |
Tue, 21 September 2004 18:17 |
Lynky
Messages: 38 Registered: May 2003 Location: Germany
Karma: 0
|
Member |
|
|
Ohoh,
here's what I've done:
I replaced the "INSERT INTO"s to "INSERT IGNORE INTO"s. I've found then, that mysql doesn't import many datasets as a result of that. Nevermind - it worked and I have the table in the 2nd database now.
Then I managed to convince my provider to play my forum-backup back into the right directory.
Then I tried out if the forum worked. I first chose the old database and I was very glad that the thing worked. Then I changed the database to the new one (the one with the missing entries in fud21_search) and I got a blank screen
OK... I thought, I will take a chance (because the forum worked on the old one) and tried an upgrade again. The script ran but never showed a result page - so I hitted the "authenticicate"-button again. The Skript told me, that I had already ran the upgrade - so far... sound's well, doesn't it?
But:
When I now enter the startpage of the new forum, the forum shows me the registered users on the board, but no threads! There's nothing in it! I also have no private messages!
Have I lost my data? Did the upgrade break my last working database-tables?
PANIC! Why doesn't it show the threads?
Greetings,
Lynky
[Updated on: Tue, 21 September 2004 18:29] Report message to a moderator
|
|
|
Additional information... [message #20017 is a reply to message #20014] |
Tue, 21 September 2004 18:50 |
Lynky
Messages: 38 Registered: May 2003 Location: Germany
Karma: 0
|
Member |
|
|
... I can see the threads in the administrator-menue (forum and category management) and when I see the details about a member, I can browse through his threads.
- but on the startpage I get completely nothing listed
Greetings,
Lynky
[Updated on: Tue, 21 September 2004 18:50] Report message to a moderator
|
|
|
Re: Additional information... [message #20019 is a reply to message #20017] |
Tue, 21 September 2004 22:41 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
run the consistency checker if you didn't already and if you still get an empty page, login as an admin and fix the group permissions by hand via the group manager linked via the front page of the forum.
FUDforum Core Developer
|
|
|
Re: Additional information... [message #20020 is a reply to message #20019] |
Wed, 22 September 2004 01:05 |
Lynky
Messages: 38 Registered: May 2003 Location: Germany
Karma: 0
|
Member |
|
|
Hallo,
thank you very much - after I ran the conistency-checker the forum worked
The old layout is lost, but that only means, that I have to spend this noon with adapting the new stylesheet to the old values...
You are the best!!
Greetings,
Lynky
[Updated on: Wed, 22 September 2004 01:58] Report message to a moderator
|
|
|
Re: Additional information... [message #20021 is a reply to message #20020] |
Wed, 22 September 2004 01:58 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
What do you mean, do you get a blank page? (if so check the error log viewer in admin control panel).
FUDforum Core Developer
|
|
|
|
My thanks... [message #20023 is a reply to message #20021] |
Wed, 22 September 2004 02:49 |
Lynky
Messages: 38 Registered: May 2003 Location: Germany
Karma: 0
|
Member |
|
|
Good work shall be honored!
Even I know, that is an unusual way to thank someone in a forum...
a prosit on Ilia...
LONG LIVE ILIA!
thanks for your fast, uncomplicated and competent advices!!
Best wishes for the future,
Lynky
PS: And now I have to manage my verbal bachelor-exam (in about 2h) ... another issue I'm afraid of
-
Attachment: sekt.gif
(Size: 17.28KB, Downloaded 1196 times)
[Updated on: Wed, 22 September 2004 02:53] Report message to a moderator
|
|
|