|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: how to use the datadump file [message #15040 is a reply to message #15033] |
Sat, 29 November 2003 04:36 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The CVS instructions for Linux for win32 you need to make the following changes:
1) Checkout the CVS repository via WinCVS (or other win32 cvs client) login is anonymous, there is no password.
2) You do not need to run "chmod"
3) Go into the fud21_install directory that was created thanks to CVS checkout.
4) Instead of
./create_file_list install 1>> install.php
run
php.exe create_file_list install 1 >> install.php
If you do not zlib installed do not pass put 1 after install
FUDforum Core Developer
|
|
|
Re: how to use the datadump file [message #15041 is a reply to message #14983] |
Sat, 29 November 2003 10:12 |
bobmurphy
Messages: 166 Registered: November 2003 Location: ireland
Karma: 0
|
Senior Member |
|
|
ended up getting it through the cvs that runs using the command prompt ---
when i uploaded the update.php file there was something wrong with it
this is the error i got when i tried to use it
Quote: | 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
The upgrade script is missing the data archive, cannot run.
|
(also it seemed small 60k )
what i did to create it was:
a) did not alter the permissions at all as i am on a windowsXP machine and i dont think i can really ?
b) cd fud21_upgrade ( i presume the line cd fud21_install in the docs is a misprint )
c) made a copy of php.exe and put it into the fud21_upgrade directory
d) typed the line you gave meQuote: | php.exe create_file_list install >> install.php
| at the command prompt
e) uploaded the upgrade.php file that i found in the fud21_upgrade directory and ran the script
can you figure where i went wrong ??
[Updated on: Sat, 29 November 2003 19:33] Report message to a moderator
|
|
|
Re: how to use the datadump file [message #15053 is a reply to message #15041] |
Sun, 30 November 2003 21:28 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Your install.php is so small because it is missing the archive bit. The ./create_file_list install 1>> install.php is what adds it.
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15058 is a reply to message #15055] |
Sun, 30 November 2003 23:48 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
If you making the upgrade script you should run:
php.exe create_file_list install >> upgrade.php
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15074 is a reply to message #15069] |
Mon, 01 December 2003 13:42 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
For upgrade script use:
cvs -z3 -d :pserver:anonymous(at)asuka(dot)prohost(dot)org:/forum21 checkout fud21_upgrade
cd fud21_upgrade
chmod 644 upgrade.php
chmod 755 create_file_list
./create_file_list install 1>> upgrade.php
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15091 is a reply to message #15080] |
Tue, 02 December 2003 00:14 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Not sure, I generate upgrade/install archive almost everytime and often serveral times a day and never had any problems doing so.
FUDforum Core Developer
|
|
|
Re: how to use the datadump file [message #15093 is a reply to message #14983] |
Tue, 02 December 2003 00:52 |
bobmurphy
Messages: 166 Registered: November 2003 Location: ireland
Karma: 0
|
Senior Member |
|
|
really the cvs method seems to work fine --- the exact same upgrade script that i downloaded works fine on the new server --- it just doesnt work on the old one --- so i dont think it's a problem with the cvs download or build -- it could be a problem with the script though.
[Updated on: Tue, 02 December 2003 00:52] Report message to a moderator
|
|
|
Re: how to use the datadump file [message #15095 is a reply to message #15093] |
Tue, 02 December 2003 01:40 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
I never tried the archive generation script on windows, so it is possible it may have issues on that OS.
FUDforum Core Developer
|
|
|
Re: how to use the datadump file [message #15099 is a reply to message #14983] |
Tue, 02 December 2003 12:14 |
bobmurphy
Messages: 166 Registered: November 2003 Location: ireland
Karma: 0
|
Senior Member |
|
|
Quote: | The problem is fixed in CVS.
|
ok well i upgraded the forum on the old server using the new rc9 download on the site -- having upgraded the new one via the rc9 from the cvs site --- so they are both rc9 --- i did a new datadump between them but i still get a similar error
(/home/oneweekofdays/www/FUDforum/include/theme/default/db.inc:133
/home/oneweekofdays/www/forum/adm/admimport.php:169
) 1146: Table 'murphyr.fud26_ses' doesn't exist
Query: DELETE FROM fud26_ses
Server Version: 4.0.14-standard-log
[Referring Page] http://stresa.hostireland.com/~oneweekofdays/forum/adm/admimport.php?rid=2&S=a901659213cf3c3329b9ef2a342b02e1&SQ=e795713ab96d92b7d368e17eecc246f1
EDIT
just to be on the safe side, i have since reinstalld ver2.6rc9 on the new server from the regular download available on the site -- so now both servers are running the same rc9 forum; however the error still persists:
i'll include it here just in case you need it:
(/home/oneweekofdays/www/FUDforum/include/theme/default/db.inc:133
/home/oneweekofdays/www/forum/adm/admimport.php:169
) 1146: Table 'murphyr.fud26_ses' doesn't exist
Query: DELETE FROM fud26_ses
Server Version: 4.0.14-standard-log
[Referring Page] http://stresa.hostireland.com/~oneweekofdays/forum/adm/admimport.php?rid=2&S=b98b8143746768d375a6f859c044b77c&SQ=3ffd89dfb818459d484dcacfbec31d4d
[Updated on: Tue, 02 December 2003 15:22] Report message to a moderator
|
|
|
Re: how to use the datadump file [message #15109 is a reply to message #15099] |
Tue, 02 December 2003 16:25 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Strange it works here flawlessly and I was even able to convert between forums using a different database backends.
Could you please send me your datadump?
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15119 is a reply to message #15110] |
Tue, 02 December 2003 23:55 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Just imported the data dump you sent me without any problems.
The query failure you are getting implies that fud26_ses table does not exist (should've been created by importing of data).
The only possible reason I can see for this happening if the code that supposed to read the SQL queries from the dump fails to do so, which would fall inline with your previous comments about the destination forum lacking any SQL data.
You can check this by adding var_dump($i) before line 169 of admimport.php that'll print how many lines of SQL were imported.
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15124 is a reply to message #15123] |
Wed, 03 December 2003 01:29 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
I think this is because you do not have permissions (the forum is locked) to view the contents of those directories. So the forum is showing them as empty. You need to use the "File Unlock" admin control panel to unlock the forum's files.
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15126 is a reply to message #15125] |
Wed, 03 December 2003 02:29 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Actually is was very helpful, thank you.
int(0) means that not a single line of SQL was processed, now we just need to figure out why.
I am assuming you are trying to import the same datadump that you have sent me, which is compressed. Could you try doing the following:
gzip -d [data_dump_file].gz this will uncompress it creating [data_dump_file]. Then try importing the non-compressed file. I want to see if this is a zlib related problem or something more generic.
FUDforum Core Developer
|
|
|
|
Re: how to use the datadump file [message #15128 is a reply to message #15127] |
Wed, 03 December 2003 15:57 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Ok, I got the account information and will try to import the datadump hopefully figuring out what is the problem...
I'll write a import script like script that will emulate the 'real' script and hopefully be affected by the same problem.
I'll let you know once I got any results.
FUDforum Core Developer
|
|
|
Re: how to use the datadump file [message #15135 is a reply to message #15128] |
Wed, 03 December 2003 18:20 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
I just tried importing the compressed datadump with a test script "admimpt.php" inside the forum/adm/ directory. It only differs from the "real" import script is that the user authentication is not performed.
Anyhow, the thing is that is has worked just fine with the uncompressed file and imported the data correctly. (you can try it for yourself if you like).
In fact the only bug that I found was with the query counter.
FUDforum Core Developer
|
|
|
|
|
|