Re: MYSQL bug

[Paul DuBois]

At 9:45 AM -0800 02-28-2000, thao ngo wrote:
>Hi all,
>Could some one help me this problem?I am currently use mysql, I have a
>xml file, and I run one perl script to convert xml file to sql( I 
>called pq table in my database table)
>Here are errors when I run this script:
>>nywilly: {52} % ./testing1.pl -sn test_thao -uid thaongo -table pq 
>>-input abcd.xml -x
>insert into pq ( pqpid, pqqid ) values (?, ?)
>
>Use of uninitialized value at ./testing1.pl line 138, <FILE> chunk 37.
>Use of uninitialized value at ./testing1.pl line 138, <FILE> chunk 37.
>Binding: col [1] as [101]
>Binding: col [2] as [202]
>Inserting a row...
>Binding: col [1] as [102]
>Binding: col [2] as [201]
>Inserting a row...
>Binding: col [1] as [102]
>Binding: col [2] as [205]
>Inserting a row...
>Binding: col [1] as [103]
>Binding: col [2] as [203]
>Inserting a row...
>Binding: col [1] as [103]
>Binding: col [2] as [204]
>Inserting a row...
>Binding: col [1] as [104]
>Binding: col [2] as [204]
>Inserting a row...
>DBD::mysql::st execute failed: Duplicate entry '204-204' for key 1 at
>./testing1.pl line 106, <FILE> chunk 37.
>Can't use string ("<?xml version="1.0"?>
><test_thao") as a symbol ref while "strict refs" in use at
>/usr/local/lib/perl5/site_perl/XML/Parser/Expat.pm line 426, <FILE> chunk
>37.
>         ...propagated at ./testing1.pl line 106, <FILE> chunk 37.
>It looks lie DBD::MYSQL bug.I really don't know beyond that.
>Please help me ASAP.
>Thao

I don't see anything here to indicate a MySQL, DBI, or DBD bug.  It looks
like your script is written incorrectly from the "strict refs" error message.
Beyond that, it's hard to say, because we don't know what your script looks
like.

-- 
Paul DuBois, paul@stripped