Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

Error Message : error open file

Nov 20, 2001, 1:12 PM
ktt
Novice (29 posts)
Nov 20, 2001, 1:12 PM
Post #1 of 7
Views: 3950
Shortcut
Quote Reply
Error Message : error open file
Hi,

trying to export data i get this error. Everything else including complete dumps is working.

Code:
# Exported data from table dbsql
# A temporary file (./GTMM10062905171704236) was create in the temp directory.
# Please remove the file manually as necessary.

# =========== Export Starts ===========

CGI ERROR
==========================================
Error Message : error open file
Script Location : \home\henning\test\cgi-bin\gforum\admin\mysqlman\mysql.cgi
Perl Version : 5.006001

...

Its the bundled installation of dbsql and gforum.

Thanks for any help.

Henning
Nov 20, 2001, 2:07 PM
Paul
Veteran (19537 posts)
Nov 20, 2001, 2:07 PM
Post #2 of 7
Views: 3894
Shortcut
Quote Reply
Re: [ktt] Error Message : error open file In reply to
Hmm weird. All your /'s are backwards.

It isn't like this in the config right?
Nov 20, 2001, 10:50 PM
ktt
Novice (29 posts)
Nov 20, 2001, 10:50 PM
Post #3 of 7
Views: 3886
Shortcut
Quote Reply
Re: [PaulW] Error Message : error open file In reply to
Hi Paul,
Quote:
It isn't like this in the config right?
In the config ist all "/". The (Test and Dev)System is running on win2k however. As i said, no other problem identified yet.

Henning

Last edited by:

ktt: Nov 20, 2001, 10:51 PM
Nov 21, 2001, 5:01 AM
Paul
Veteran (19537 posts)
Nov 21, 2001, 5:01 AM
Post #4 of 7
Views: 3903
Shortcut
Quote Reply
Re: [ktt] Error Message : error open file In reply to
Are you sure those paths are right? They look more like *nix paths to me.
Nov 21, 2001, 7:38 AM
Chaz
Enthusiast (819 posts)
Nov 21, 2001, 7:38 AM
Post #5 of 7
Views: 3870
Shortcut
Quote Reply
Re: [PaulW] Error Message : error open file In reply to
Hi Paul,

/path/to/file will work on a 2k box as long as the file(s) are on the c drive. I don't remember the /'s turning into \'s when I get error messages though. That's an odd error.

Henning, have you tried adding the drive letter to the path? c;/path/to/file?

Regards,
Charlie
Nov 21, 2001, 10:24 AM
Paul
Veteran (19537 posts)
Nov 21, 2001, 10:24 AM
Post #6 of 7
Views: 3850
Shortcut
Quote Reply
Re: [CP] Error Message : error open file In reply to
Yeah I know what Win vs Unix paths look like but I wasn't referring to the slashes, rather the directory structure:

\home\henning\test\cgi-bin\gforum\admin\

/home/username etc is _unix_ like

>>/path/to/file will work on a 2k box as long as the file(s) are on the c drive<<

That isn't true. It will work on any drive that Apache is installed on.

Last edited by:

PaulW: Nov 21, 2001, 10:26 AM
Nov 21, 2001, 12:49 PM
ktt
Novice (29 posts)
Nov 21, 2001, 12:49 PM
Post #7 of 7
Views: 3842
Shortcut
Quote Reply
Re: [CP] Error Message : error open file In reply to
Hi,

had nothing to do with slashes or c:.
It was looking for a temp directory and couldn't find it.

Quote:
sub get_temp_file_name {
# ---------------------------------------------------
# This function creates a random temp file name, looks
# up the temp directory and returns the path to the
# temp file.

my $temp_file_path = '';
my $directory = '.';
my @temp_dirs =("/WINNT/Temp","/usr/tmp","/var/tmp","C:/temp","/tmp","/temp","/WWW_ROOT");
foreach (@temp_dirs) {
if (-d $_ && -w _) { $directory = $_; last; }
}
my $rand_name = "GTMM" . time . $$ . int(rand(1000));
while (-e $directory . '/' . $rand_name) {
$rand_name = "GTMM" . time . $$ . int(rand(1000));
}
$temp_file_path = "$directory/$rand_name";
return $temp_file_path;
}
I have added /WINNT/Temp to the array and now it works fine.

Thanks,

Henning