DevHeads.net

Perl

Please update DBD::MySQL with how to create test database

By David Favor at 04/13/2013 - 12:20

make test fails for me, regardless of how I've created
the test database.

To simplify everyone's life.

Please add the exact command line commands for creating
the test database, so make test passes all tests.

Specifically this includes creating the test user with
an empty password, which seems to be the failure point.

Thanks.

Still active?

By Lyle at 04/11/2013 - 20:30

Hi,
Is this list still active? I've found that DBD::mysql bugs are no
longer reported via the mysql bug tracker:
<a href="http://bugs.mysql.com/bug.php?id=68266" title="http://bugs.mysql.com/bug.php?id=68266">http://bugs.mysql.com/bug.php?id=68266</a>
Is this list going as well?

Lyle

question about stored procedures with Select statements and critical errors.

By Kern, Daniel at 07/19/2012 - 08:34

Can someone please help with the following.

bind parameter guessing corrupts results

By Marc Lehmann at 02/12/2012 - 23:01

Hi!

We today upgraded DBD::mysql to 4.020, and some of our scripts started to
work very slowly.

The reason was quickly found to be an integer that was stringified in the
current version of DBD::mysql.

In old versions of DBD::mysql, one could get reliable behaviour by using e.g.

$num*1 # for numbers
"string" # for strings

it seems in current versions of DBD::mysql there is some autoguessing
going on, which seems to be wrong in many cases, and doesn't seem to be
documented at all.

Worse, whoeveer wrote the documentation seems to think this is a
performance issue in mysql only, howe

Cepat tengoh.....mesti ada punya....

By MOHD NASIR BIN ... at 11/07/2011 - 05:06

Your email client cannot read this email.
To view it online, please go here:
<a href="http://wsend.webkita.org/display.php?M=7724053&amp;C=0af494c4536bd0d8929af7ae06a6226a&amp;S=1109&amp;L=604&amp;N=298" title="http://wsend.webkita.org/display.php?M=7724053&amp;C=0af494c4536bd0d8929af7ae06a6226a&amp;S=1109&amp;L=604&amp;N=298">http://wsend.webkita.org/display.php?M=7724053&amp;C=0af494c4536bd0d8929af7a...</a>

To stop receiving these
emails:http://wsend.webkita.org/unsubscribe.php?M=7724053&C=0af494c4536bd0d8929af7ae06a6226a&L=604&N=1109

DBD::drizzle version 0.304 released

By Patrick Galbraith at 11/03/2011 - 18:04

Hi!

I have released DBD::drizzle version 0.304 as today. This release
includes much easier building than before. The Makefile.PL now does a
much better job of finding the libdrizzle headers and libraries.

For this release, please go to:
<a href="http://search.cpan.org/~capttofu/DBD-drizzle-0.304/lib/DBD/drizzle.pm" title="http://search.cpan.org/~capttofu/DBD-drizzle-0.304/lib/DBD/drizzle.pm">http://search.cpan.org/~capttofu/DBD-drizzle-0.304/lib/DBD/drizzle.pm</a>.

You can also obtain the latest source from Launchpad: bzr branch lp:dbd-drizzle

Thank you for using DBD::drizzle and Drizzle itself, and have fun!

regards,

Patrick "CaptTofu" Galbraith

DBD::mysql: no errstr under Windows

By Neubauer, Ralf at 10/18/2011 - 12:13

Hi,

as you may have seen in <a href="https://rt.cpan.org/Public/Bug/Display.html?id=71047" title="https://rt.cpan.org/Public/Bug/Display.html?id=71047">https://rt.cpan.org/Public/Bug/Display.html?id=71047</a> or even in <a href="http://bugs.activestate.com/show_bug.cgi?id=91026" title="http://bugs.activestate.com/show_bug.cgi?id=91026">http://bugs.activestate.com/show_bug.cgi?id=91026</a> there is no ->errstr or ->err on the Windows platform, if ->execute failed.

In DBD::mysql 4.018 the code at the end of mysql_st_internal_execute() in dbdimp.c that executed the statement and transferred the error codes looked like this:

if ((mysql_real_query(svsock, sbuf, slen)) &&
(!mysql_db_reconnect(h) ||
(mysql_real_query(svsock, sbuf, slen))))
{
Safefree(salloc);
do_error(h, mysql_errno(svsock), mysql_error(svsock),

want to install mysql client only

By Hauck, John P [... at 09/29/2011 - 17:35

I am trying to do a client-only install of mysql on a Solaris 10 zone so I can access a mysql db on a remote machine using DBD::mysql. Can someone please point me at some instructions for doing this? I'm trying to do this with mysql 5.0.67 using "-without-server" on ./configure.

nature of the server side prepared statement issues?

By Corey Hickey at 09/25/2011 - 21:10

Hi,

I see in the documentation:

can't call statistics_info() method

By Keedi Kim at 08/29/2011 - 23:26

Hi,

I have a problem to call statistics_info() method since 4.019.
I'm using DBD::mysql with Fey::Loader and before DBD::mysql 4.019,
Fey::Loader::mysql module has a fix up code to call statistics_info method.

Since DBD::mysql 4.019, following code was added.

DBD::mysql 4.020 released

By Patrick Galbraith at 08/24/2011 - 09:20

Dear Perl community,

I'm pleased to announce the release of DBD::mysql, the MySQL Perl
client, 4.020. The release has several great fixes provided by the
community, and in particular from Masahiro Chiba, who fixed several
issues pertaining to prepared statement support as well as UTF8
support, something that I myself have had a difficult time fixing and
testing.

From the Change log:

2011-08-15 Patrick Galbraith <patg at patg dot net> (4.020)
* Numerous (!!

How to install DBD::mysql at Macosx

By Takaaki T. Komatsu at 06/10/2011 - 22:39

Dear Sirs,

I'm try to install mysql and perl at my computer.
with in the CPAN installation I got a error msg.
would you please tell me ha to fix....
Best regards,

Takaaki Komatsu

H/W: MacBookPro
S/W: Mac OSX 10.6.7
Perl:5.14.0
mysql:5.5.13.0 osx

cpan[1]> install DBD::mysql
Going to read '/Users/tti/.cpan/Metadata'
Database was generated on Fri, 10 Jun 2011 05:29:39 GMT
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.019.tar.gz
Checksum for /Users/tti/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.019.tar.gz ok
Scanning cache /Users/tti/.cpan/build f

DBD::mysql 4.019 Released

By Patrick Galbraith at 05/09/2011 - 14:24

Dear Perl and MySQL enthusiasts,

I’m pleased to announce the release of DBD::mysql 4.019. I’m
especially pleased because there are some new enhancements and
features that have been provided by contributions from the community:

* Asynchronous support, added by Rob Hoelz.

The install fails due a missing compile parameter

By Thelma Vance at 05/09/2011 - 13:59

Hello,

The module fails during the make.

Respectfully,
Thelma

'sprintf' is not recognized as an internal or external command, operable program or batch file.

By Leo Susanto at 04/06/2011 - 18:11

Hi,

I am trying to make the makefile with the option of inserting
testuser, testpassword and testhost into "perl.exe Makefile.PL"
command line, but I keep getting "'sprintf' is not recognized as an
internal or external command, operable program or batch file."

C:\CPANTesters\Perl5.10.0\cpan\build\DBD-mysql-4.018-d8v5HG>perl.exe
Makefile.PL INSTALLDIRS=site --testuser=cpantesters
--testpassword=cpantesters --testhost=localhost
'sprintf' is not recognized as an internal or external command,
operable program or batch file.
Problem running C:\CPANTE~1\bin\MYSQL-~1.11-\bin\MYSQLA~1.EXE - aborting

MySQL queries in a relational database

By francesca casalino at 03/30/2011 - 06:58

Dear Perl and MySQL gurus,

I have been learning a lot from you for the past month, and, learning from
your comments and with your help, I was able to build a database on MySQL
through Perl DBI.

I am now having trouble with generating a query in Perl DBI to take data
from this database and insert it into another table in MySQL; I am still
just at the start in learning both MySQL and Perl, and sorry if this is a
simple question again, but I have been stuck on this for a while now…if you
have any advice on how to tackle this please let me know.

My database is constructed with different t

Insert or update data in mysql using a perl script

By francesca casalino at 03/04/2011 - 13:36

Hi perl and mysql experts,

I am lost again into a problem that I do not know how to approach, and was
wondering whether you could direct me to the right path once more, telling
me if I am using the correct approach or I am totally off-path… I can find
only some solutions in the help pages but I am still confused about my
particular case…

The database on mysql has various tables where each one is related to the
other through foreign keys, and

LOCATION_ID (AUTO-INCREMENT) LOCATION
SITE NAME

1
1234

Bind parameters for SET statements

By Alfie John at 03/02/2011 - 20:25

Hi,

Not sure if this is a DBD::mysql or a plain DBI problem but thought I
would start here.

It seems that the following code is broken:

$dbh->do( 'SET TIMESTAMP=?', undef, $timestamp );

This fails with:

Incorrect argument type to variable 'timestamp'

Yet the following works:

$dbh->do( "SET TIMESTAMP=$timestamp" );

Alfie

Re: Perl script to insert data in mysql from Excel file

By hwigoda at 02/23/2011 - 13:26

Isn't there a Perl module CSV that will extract data from a CSV file?

Perl script to insert data in mysql from Excel file

By francesca casalino at 02/23/2011 - 07:30

Hi everybody,

I am a real newbie in both perl and relational databases like mysql, and I
have been banging my head on the wall trying to understand how to populate a
mysql database using an Excel file (.csv).

I constructed a my sql database (called “test”), set up the DBD::mysql
module, read a book on perl, but I still cannot figure out how to approach
this problem, so I resort to the experts…Could you please help me understand
how to approach this?

The database on mysql has tables where each one is related to the other
through foreign keys, so for example table_2 is:

CREATE TABLE

DBD::MySQL

By Andy at 11/15/2010 - 14:01

I have installed DBD:MySQL 4.0.18 on Perl 5.10, Mac OS X 10.6.

Any ideas about what I might have done wrong?

Faulty version check in foreign_key_info

By Bernt Marius Johnsen at 10/27/2010 - 11:04

The version check in foreign_key_info fails to check the minor version.
The fix is easy, though:

--- a/lib/DBD/mysql.pm
+++ b/lib/DBD/mysql.pm
@@ -638,7 +638,7 @@ sub foreign_key_info {

# INFORMATION_SCHEMA.KEY_COLUMN_USAGE was added in 5.0.6
my ($maj, $min, $point) = _version($dbh);
- return if $maj < 5 || ($maj == 5 && $point < 6);
+ return if $maj < 5 || ($maj == 5 && $min == 0 && $point < 6);

my $sql = <<'EOF';
SELECT NULL AS PKTABLE_CAT,

Re: selectrow_hashref() propagating wrong message (bug in DBD::mysql)

By Paul Silevitch at 08/06/2010 - 10:42

Hello All,

I have started to see random "fetch() without execute()" messages on a
production when mysql is under heavy load. I believe the thread below
describes my problem (from dbi-dev mailing list circa 2007). The production
system is currently using an older version of DBD::mysql and I wanted to
make sure this bug was fixed before scheduling an upgrade. I looked through
changesets on github and couldn't pinpoint when it was fixed.

cgi script permission error

By Jamal Nasir at 07/29/2010 - 15:29

when i try to create a file or directory using perl running as cgi in windows i
get error that you dont have access to the folder. i have installed apache in my
personal administrative account. and i have given permission to this
account.still getting same error.

mysql perl connection problem

By Jamal Nasir at 07/29/2010 - 15:29

i have installed perl in windows.
When i execute the following code:

#!/usr/bin/perl

# PERL MODULE

use DBD::Mysql;

# HTTP HEADER
print "Content-type: text/html \n\n";

# CONFIG VARIABLES
$host = "127.0.0.1";
$database = "shah569";

$user = "jmlnsr";
$pw = "ntr562";

# PERL MYSQL CONNECT
$connect = Mysql->connect($host, $database, $user, $pw);
print 'Hello';

I get following error in apache error log.

Can't locate object method "connect" via package "Mysql" (perhaps you forgot to
load "Mysql"

Syndicate content