Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro
Author Message
nooblet
Regular
Regular


Joined: Sep 09, 2005
Posts: 88

PostPosted: Mon Nov 28, 2005 10:10 am Reply with quote

I got this error when i access the Only registered users can see links on this board! Get registered or login!

Quote:
BigDump: Staggered MySQL Dump Importer ver. 0.21b
Error listing directory

Start from the beginning (DROP the old tables before restarting if reloading)

© 2003-2005 Alexey Ozerov - BigDump Home



Slightly modified for use with phpNuke installations Only registered users can see links on this board! Get registered or login!


Anyone knows how can i fix this error?
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Mon Nov 28, 2005 2:24 pm Reply with quote

That would appear to indicate that your installation is not interpreting some settings the expected way. Save the following code to test.php. Then ftp test.php to your INSTALLATION folder and run it with this url: Only registered users can see links on this board! Get registered or login! (or whatever your path to INSTALLATION is). The put the results in your next reply.

Code:
<?

echo '$upload_dir = '.dirname($_SERVER["SCRIPT_FILENAME"]);
echo '<br /><br />';
echo 'PT = '.dirname($_SERVER["PATH_TRANSLATED"]);
echo '<br /><br />';
echo 'PHP_SELF = '.dirname($_SERVER["PHP_SELF"]);
?>
 
View user's profile Send private message
nooblet
PostPosted: Mon Nov 28, 2005 8:45 pm Reply with quote

Here's the output of the Only registered users can see links on this board! Get registered or login!


Quote:
$upload_dir =

PT = C:\\Inetpub\\vhosts\\mydomain.com\\httpdocs\\INSTALLATION

PHP_SELF = /INSTALLATION
 
Raven
PostPosted: Mon Nov 28, 2005 8:47 pm Reply with quote

As I suspected, your web server setup is not allowing certain environment variables that the script expects. Are you using Apache or IIS?
 
nooblet
PostPosted: Mon Nov 28, 2005 9:02 pm Reply with quote

IIS i guess... Confused
 
Raven
PostPosted: Mon Nov 28, 2005 9:07 pm Reply with quote

The easiest way would be to switch to Apache for windows as this won't be the end of your problems ROTFL

You could also try changing this line in INSTALLATION/installSQL.php from
$upload_dir=dirname($_SERVER["SCRIPT_FILENAME"]);
to
$upload_dir=dirname($_SERVER["PATH_TRANSLATED"]);

as a temporary fix.
 
nooblet
PostPosted: Mon Nov 28, 2005 9:18 pm Reply with quote

i have done that temporary fix but stills there's an error when uploading the ravennuke.sql.tar.gz

Quote:

BigDump: Staggered MySQL Dump Importer ver. 0.21b
Processing file: ravennuke.sql.tar.gz

Starting at the line: 1

UNEXPECTED: Can't read the file pointer offset

Stopped on error

Start from the beginning (DROP the old tables before restarting if reloading)

 
Raven
PostPosted: Mon Nov 28, 2005 9:25 pm Reply with quote

That error and the solution is actually explained in the README
 
nooblet
PostPosted: Mon Nov 28, 2005 9:43 pm Reply with quote

I have unzip the sql files and then upload it and i got this error

Quote:

Processing file: Step1_meganuke.sql

Starting at the line: 1

Error at the line 27: ) TYPE=MyISAM;

Query: meganuke.sqlCREATE TABLE `nuke_authors` ( `aid` varchar(25) NOT NULL default '', `name` varchar(50) default NULL, `url` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `pwd` varchar(40) default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) NOT NULL default '', PRIMARY KEY (`aid`), KEY `aid` (`aid`) ) TYPE=MyISAM;

MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'meganuke.sqlCREATE TABLE `nuke_authors` ( `aid` varchar(25) NO

Stopped on error
 
Raven
PostPosted: Mon Nov 28, 2005 10:01 pm Reply with quote

I don't think you are using the latest package. Please d/l the v1.04.00 package and replace all of your files. It should all fall into place then.
 
nooblet
PostPosted: Mon Nov 28, 2005 10:56 pm Reply with quote

i guess im using the latest version... i downloaded that file here Only registered users can see links on this board! Get registered or login!
 
Raven
PostPosted: Mon Nov 28, 2005 11:17 pm Reply with quote

Check the Change Log and see if it's v1.04.00
 
nooblet
PostPosted: Mon Nov 28, 2005 11:24 pm Reply with quote

here's the changelog

Quote:
2005-11-27 v1.04.00 Bugfix Release
#0008 FIX - Downloads upload function not working. filter() function changed to check_html()
#0009 ENH - Combined the 2 sql INSTALL files into 1
#0010 ENH - preSet some of the Blocker configuration in NukeSentinel(tm)
#0011 ENH - installSQL.php file

2005-11-27 v1.03.00 Enhancement Release
#0007 ENH - Since the BigDump application can handle GZIP files, I was able to save the 6meg of SQL uploads!

2005-11-26 v1.02.00 BugFix Release
#0002 FIX - Forum JumpTo was not working in default subSilver template.
#0003 FIX - Could not create new survey/poll and/or survey/poll block did not work.
#0004 DEL - fisubice theme folder. This was mistakenly included in the distribution.
#0005 ADD - LICENSE file.
#0006 ADD - REDISTRIBUTION file.

2005-11-24 v1.01.00 BugFix Release
#0001 FIX - INSTALLATION folder was misnamed INSTALLATIONx

2005-11-24 v1.00.00 Initial Release
#0000 REL - Initial Release
 
Raven
PostPosted: Mon Nov 28, 2005 11:41 pm Reply with quote

Something's not right. Did you download the FULL or just the PATCH? If you just d/l the PATCH then what you're describing would happen. I just verified the FULL version and it is definitely not what you have. the patches assume that you already have a working version and so you would not need to d/l the INSTALLATION files again. Bottom line, download the FULL again and replace all of your files.
 
nooblet
PostPosted: Tue Nov 29, 2005 12:14 am Reply with quote

I have download the full version and replace all the files but still i get this error

Quote:
BigDump: Staggered MySQL Dump Importer ver. 0.21b
Processing file: ravennuke.sql.tar.gz

Starting at the line: 1

UNEXPECTED: Can't read the file pointer offset

Stopped on error
 
Raven
PostPosted: Tue Nov 29, 2005 12:45 am Reply with quote

You will always get that error on windows. remember? In the readme? Now you must unpack it.
 
nooblet
PostPosted: Wed Nov 30, 2005 7:19 am Reply with quote

umm... ok.. anyway when i unpack it the db size is really huge and my server allows the maximum upload limit to 2mb... is there any posibilites that i can upload that ravennuke.sql.tar.gz? Sad
 
Raven
PostPosted: Wed Nov 30, 2005 8:55 am Reply with quote

Then you will need to brek it into smaller files and upload them. Name them something like part1.sql, part2.sql, etc.
 
nooblet
PostPosted: Wed Nov 30, 2005 9:33 am Reply with quote

i have did that.. but the file size of ip2country tables is too large i guess 5mb+...
is there any posibilities that i can break the ip2country tables so that i can upload it? Very Happy
 
Raven
PostPosted: Wed Nov 30, 2005 9:43 am Reply with quote

That's what I said to do Smile. Break all the sql file into files up to 2meg in size. Name them as I said in the above post. Also, see my next to last post here: Only registered users can see links on this board! Get registered or login!
 
nooblet
PostPosted: Thu Dec 01, 2005 11:14 pm Reply with quote

Got it working... Thank You Very Much Raven.. more power to your site! Very Happy
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©