Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Error on Quick Export

Quote Reply
Error on Quick Export
Hi:

Just a heads up on something.... for some reason, when I export data with Quick Export, I get this error:

There was a problem exporting: [Fri Nov 26 11:22:47 1999] editor.cgi: DBSQL (39189): Fatal Error: Unable to execute query: [Fri Nov 26 11:22:47 1999] editor.cgi: SELECT * FROM Links [Fri Nov 26 11:22:47 1999] editor.cgi: INTO OUTFILE 'export' [Fri Nov 26 11:22:47 1999] editor.cgi: FIELDS TERMINATED BY '|' [Fri Nov 26 11:22:47 1999] editor.cgi: . Reason: at editor.cgi line 398 .

Yet a normal export works...

Am I doing something wrong, or is there maybe a problem?

Dave
Quote Reply
Re: Error on Quick Export In reply to
Can you edit DBSQL.pm and change:

$sth->execute() or return $self->error ('CANTEXECUTE', $query, $!);

to:

$sth->execute() or return $self->error ('CANTEXECUTE', $query, $DBI::errstr);

It's on line 1169. Let me know what the new error message says.

Cheers,

Alex
Quote Reply
Re: Error on Quick Export In reply to
Alex:

NO RUSH ON THIS!!!!! I got through with the reqular export!

But the new error is:

There was a problem exporting: [Fri Nov 26 14:20:14 1999] editor.cgi: DBSQL (46189): Fatal Error: Unable to execute query: [Fri Nov 26 14:20:14 1999] editor.cgi: SELECT * FROM Links [Fri Nov 26 14:20:14 1999] editor.cgi: INTO OUTFILE 'eexport.txt' [Fri Nov 26 14:20:14 1999] editor.cgi: FIELDS TERMINATED BY '|' [Fri Nov 26 14:20:14 1999] editor.cgi: . Reason: Access denied for user: 'cartoon@jupiter.aros.net' (Using password: YES) at editor.cgi line 398 .

Dave