Error listing directory

Regular Joined: Sep 09, 2005 Posts: 88

I got this error when i access the http://www.MYDOMAIN.com/INSTALLATION/installSQL.php

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 http://www.ravenphpscripts.com

Anyone knows how can i fix this error?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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: http://www.yourdomain.com/INSTALLATION/test.php (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"]);


?>

Posted: Mon Nov 28, 2005 8:45 pm

Here's the output of the http://www.yourdomain.com/INSTALLATION/test.php

Quote:

$upload_dir =

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

PHP_SELF = /INSTALLATION

Posted: Mon Nov 28, 2005 8:47 pm

As I suspected, your web server setup is not allowing certain environment variables that the script expects. Are you using Apache or IIS?

Posted: Mon Nov 28, 2005 9:02 pm

IIS i guess... Confused

Posted: Mon Nov 28, 2005 9:07 pm

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.

Posted: Mon Nov 28, 2005 9:18 pm

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)

Posted: Mon Nov 28, 2005 9:25 pm

That error and the solution is actually explained in the README

Posted: Mon Nov 28, 2005 9:43 pm

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

Posted: Mon Nov 28, 2005 10:01 pm

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.

Posted: Mon Nov 28, 2005 10:56 pm

i guess im using the latest version... i downloaded that file here http://www.ravenphpscripts.com/modules.php?name=Downloads&d_op=ns_getit&cid=26&lid=224&type=url#get

Posted: Mon Nov 28, 2005 11:17 pm

Check the Change Log and see if it's v1.04.00

Posted: Mon Nov 28, 2005 11:24 pm

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

Posted: Mon Nov 28, 2005 11:41 pm

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.

Posted: Tue Nov 29, 2005 12:14 am

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

Posted: Tue Nov 29, 2005 12:45 am

You will always get that error on windows. remember? In the readme? Now you must unpack it.

Posted: Wed Nov 30, 2005 7:19 am

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

Posted: Wed Nov 30, 2005 8:55 am

Then you will need to brek it into smaller files and upload them. Name them something like part1.sql, part2.sql, etc.

Posted: Wed Nov 30, 2005 9:33 am

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

Posted: Wed Nov 30, 2005 9:43 am

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: http://www.ravenphpscripts.com/postt7535.html

Posted: Thu Dec 01, 2005 11:14 pm

Got it working... Thank You Very Much Raven.. more power to your site! Very Happy