Re: Problem using placeholders - Lazar Paul - com.mysql.lists.perl

5 messages in com.mysql.lists.perlRe: Problem using placeholders

From	Sent On	Attachments
Lazar Paul	28 Apr 2004 00:55
Rudy Lippan	28 Apr 2004 06:43
Lazar Paul	29 Apr 2004 05:43
Rudy Lippan	29 Apr 2004 05:53
Lazar Paul	29 Apr 2004 06:35

Subject:	Re: Problem using placeholders
From:	Lazar Paul (pau...@ebizchem.com)
Date:	04/29/2004 06:35:55 AM
List:	com.mysql.lists.perl

Thanks a lot Rudy!! that helped. A force recompile in cpan solved the problem.

Thank you once again.

Rudy Lippan wrote:

On Thu, 29 Apr 2004, Lazar Paul wrote:

I checked up mysql_config is in /usr/bin/,

Are you running the mysqld in /usr/bin ? or did you install your own copy in /usr/local?

I also recompiled DBD::mysql through MCPAN shell as you suggested, it gives the messages that DBI and DBD are up-todate but i still get the following error message while running the script.

It would probably be best to compile it by hand, or you can force a recompile in cpan

DBI->connect using 'old-style' syntax is deprecated and will be an error in future versions at ./test_placeholders.pl line 3 perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386- linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_real_escape_string

Is the lib mysql shared object in your LD_LIBRARY_PATH? An other option would be to compile DBD::mysql staticaly, and then you won't have to worry about undefined symbols.