Another interesting thing. Mysql is running on Solaris. Once past the "Cannot lock" error, I got approximately:
db.TBUSR does not exist on this server
db.tbusr does. I thought table names were case insensitive on unix. Apparently not.
----- Original Message ----- From: "Mike Wexler" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Sunday, October 24, 2004 4:53 PM
Subject: Re: Cannot lock: called with 1 bind variables when 0 are needed
Try this:
my $sql = "LOCK tables TBUSR write, TBAUTH write, TBDATALOG write, TBAGCY write, TBREL write, TBACCESSLOG write"; my $sth = $dbh->prepare($sql); $sth->execute();
On Sat, 23 Oct 2004 20:39:38 -0500, Jonathan Mangin <[EMAIL PROTECTED]> wrote:Hi all,
With 3.23.38 I have:
my $sql = "LOCK tables TBUSR write, TBAUTH write, TBDATALOG write, TBAGCY write, TBREL write, TBACCESSLOG write"; my $sth = $dbh->prepare($sql); $sth->execute($sql) || die "Cannot lock: " . $sth->errstr();
I get:
Cannot lock: called with 1 bind variables when 0 are needed ... Carp.pm...
--Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]