Re^4: Mysql and Perl Module

Hello again ! I'm testing at the moment, but I get an error message. Maybe my system is missing some module ?


DBD::myql::insert_tab('ARRAY(0x938eb9c)', 'ARRAY(0x9384cd8)', '/data14
+/docs/konvdocs/ebookkto.txt.old', 'HASH(0x93
        main::Main() called at ./csvtest.pl line 10
DBD::mysql::st execute failed: You have an error in your SQL syntax; c
+heck the manual that corresponds to your MySQL servemysql.pm line 45
        edi_mysql::insert_tab('ARRAY(0x938eb9c)', 'ARRAY(0x9384cd8)', 
+'/data14/docs/konvdocs/ebookkto.txt.old', 'HASH(0x93
        main::Main() called at ./csvtest.pl line 10
Issuing rollback() due to DESTROY without explicit disconnect() of DBD
+::mysql::db handle dbname=testdb at /usr/lib/perl5/e
        eval {...} called at /usr/lib/perl5/edi_mysql.pm line 45
[download]

Comment on Re^4: Mysql and Perl Module Download Code

Replies are listed 'Best First'.
Re^5: Mysql and Perl Module by Anonymous Monk on Jun 15, 2012 at 07:02 UTC
Hello again ! I'm testing at the moment, but I get an error message. Maybe my system is missing some module ? Nope, definitely not missing any module I would guess its this part "on duplicate key update" that is causing the error, you can get more info by raising DBI trace level ( see trace in DBI docs) I had to remove that bit because sqlite3 doesn't support it Earlier versions of mysql did not support that either	[reply]

Replies are listed 'Best First'.

Re^5: Mysql and Perl Module
by Anonymous Monk on Jun 15, 2012 at 07:02 UTC

Hello again ! I'm testing at the moment, but I get an error message. Maybe my system is missing some module ?

Nope, definitely not missing any module

I would guess its this part "on duplicate key update" that is causing the error, you can get more info by raising DBI trace level ( see trace in DBI docs)

I had to remove that bit because sqlite3 doesn't support it

Earlier versions of mysql did not support that either

[reply]