16 messages in com.mysql.lists.perlRe: Unable to prepare statement with ...
FromSent OnAttachments
Patrik Jansson14 Nov 2006 04:15 
Kenny Scott14 Nov 2006 04:23 
Patrik Jansson14 Nov 2006 04:36 
Kenny Scott14 Nov 2006 04:38 
Patrik Jansson14 Nov 2006 04:47 
Kenny Scott14 Nov 2006 04:59 
Patrik Jansson14 Nov 2006 05:08 
Kenny Scott14 Nov 2006 05:12 
Patrik Jansson14 Nov 2006 05:25.pl
Kenny Scott14 Nov 2006 05:45 
Patrik Jansson14 Nov 2006 05:55 
Mikael Fridh14 Nov 2006 05:59 
Patrik Jansson14 Nov 2006 06:17 
Simon Rees14 Nov 2006 08:37 
Harald Fuchs14 Nov 2006 08:38 
Patrik Jansson14 Nov 2006 23:56 
Subject:Re: Unable to prepare statement with underscore
From:Mikael Fridh (mika@ongame.com)
Date:11/14/2006 05:59:34 AM
List:com.mysql.lists.perl

Patrik Jansson wrote:

It works for me using MySQL 5.0.24, libdbd 3.0007. What versions are you using?

Well, this particular server is running MySQL 4.1.14. How can I see which libdbd version it is? I need this script to run on different machines, on with a MySQL server as old as 4.0.14.

Hi,

I just ran the same thing on MySQL 4.1.11 and again, it worked.

From your script you can get the version of the library by doing this:

print $DBD::mysql::VERSION, "\n";

Thanks for your help, libdbd seems to be 3.0002_1 I try to update by running cpan install DBD::mysql but it fails on the test because it is not able to login as root, duh! How can I change username / password?

with cpan, if you decide any of the failed tests are ok you can force install: cpan> force install <module>

-- Fridh