I have just installed the following versions of the above software
on a Solaris machine:

apache 1.3.9
mod_perl 1.21
DBI 1.13
Msql-Mysql-modules-1.2207

Afterwards my database Perlscripts were not able to run. They produce
the following in the server logfile and I don't understand the problem!
Without mod_perl under apache or in a shell there is no problem. The
script works fine and is also included in this mail!

Thanks for your help!!!

DBD::mysql::st execute failed: ase Selected at
/users/grupp/public_html/test.pl line 12.
[Tue Oct  5 16:07:37 1999] [error] Can't execute prepared Statement: ase
Selected at /users
/grupp/public_html/test.pl line 12.

====================================================================
#!/usr/bin/perl -w

use DBI;

print "Content-type: text/html\n\n";
print "<HTML><HEAD><TITLE>Test</TITLE></HEAD><BODY>";

$dbh = DBI->connect('dbi:mysql:umat_meta', 'www', '') ||
    die "Can't connect to DB-Server: $DBI::errstr\n";
$sth = $dbh->prepare("SELECT * FROM UMaterial") ||
    die "Can't prepare Select-Statement: $DBI::errstr\n";
$sth->execute || die "Can't execute prepared Statement: " .$sth->errstr;
print "Found " . $sth->rows . " rows!<BR>";
print "Test ended!</BODY></HTML>";
====================================================================

Andreas Grupp
____________________________________________________________________

Elektronikschule Tettnang         
Oberhofer Str. 25, 88069 Tettnang, Tel.: +49 7542 9372-33, Fax.: +49
7542 9372-40
http://www.est.fn.bw.schule.de/~grupp
mailto:[EMAIL PROTECTED]
PGP-Key is available via Mail! Use subject: send pgp-public-key
   RSA-Pub.-Key-Fingerpr.: F6066582A66A82773B6B4E4BAE76D28E
DH/DSS-Pub.-Key-Fingerpr.: AAE08895DD23C34A5CED358639075B9C7BA77A21

Reply via email to