From ab200a7da2f7723af0e4fda4ffd1106ee1ab117a Mon Sep 17 00:00:00 2001 From: ISHIKAWA Mutsumi Date: Thu, 18 Oct 2012 15:11:23 +0900 Subject: [PATCH] fix SQL --- mubot4fb.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mubot4fb.pl b/mubot4fb.pl index ef62902..a2ecbd9 100755 --- a/mubot4fb.pl +++ b/mubot4fb.pl @@ -92,7 +92,7 @@ sub _db_insert { my ($me, $db_args) = @_; my ($scheme, $path) = split(/:\/\//, $db_args->{uri}); - my $sth = $me->{dbh}->prepare("insert into posts (submitter, fb_post_id, uri, prefix, suffix, scheme, path, post_time) values (?, ?, ?, ?, ?, ?)"); + my $sth = $me->{dbh}->prepare("insert into posts (submitter, fb_post_id, uri, prefix, suffix, scheme, path, post_time) values (?, ?, ?, ?, ?, ?, ?, ?)"); $sth->bind_param(1, $db_args->{submitter}, SQL_VARCHAR); $sth->bind_param(2, $db_args->{fb_post_id}, SQL_BIGINT); $sth->bind_param(3, $db_args->{uri}, SQL_VARCHAR); -- 2.11.0