in reply to Re^8: Relational table with perl DBI
in thread Relational table with perl DBI

Even if I change the code as you said I still get :

<DBD::mysql::st execute failed: Unknown column 'event' in 'field list' at db3.pl line 73. Use of uninitialized value $inserted_records in numeric ne (!=) at db3.pl line 74. Use of uninitialized value $inserted_records in concatenation (.) or string at db3.pl line 74. Error inserting article http://news.google.com/news/url?sa=t&fd=R&usg=AFQjCNHR3sMDu6iIXwFJzHEGTgBVUyxixQ&url=http://www.depechedekabylie.com/kabylie/120828-un-glissement-de-terrain-menace-le-quartier-bouhlou.html, only [] got inserted: Unknown column 'event' in 'field list' at db3.pl line 74.

The code is a copy paste of your previous post, so I don't think there's any error in it.

Replies are listed 'Best First'.
Re^10: Relational table with perl DBI
by Neighbour (Friar) on Mar 14, 2013 at 10:13 UTC
    What does your event-table look like? It seems there is no column named event (even though your original post showed there should be).
    Once again, the insert query fails, $inserted_records becomes undef which doesn't quite compare to a number.
[reply]
[d/l]
[select]

      Well it looks like this :

      $create_query = qq{
        create table event(
            id_event int(10) auto_increment NOT NULL,
            event MEDIUMTEXT COLLATE utf8_general_ci,
            primary key (id_event)
        )
    };
    $dbh->do($create_query);

      [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom