The table is created, but the def file isn't, and the script just hangs.
$db_ping->cols(
ID => {
pos => 1,
type => "INT",
size => 10,
not_null => 1
},
url => {
pos => 2,
type => "CHAR",
not_null => 1
},
excerpt => {
pos => 3,
type => "CHAR"
},
blog_name => {
pos => 4,
type => "CHAR"
},
title => {
pos => 5,
type => "CHAR"
}
);
$db_ping->unique({ "id_url" => ['ID', 'url']});
$db_ping->create();
I've pinpointed the problem down to:
If I comment that out, them the def file is created. I just don't see what's wrong with it, as the usage appears to be within spec with GT::SQL::Creator documentation.
any ideas?
Philip
------------------
Limecat is not pleased.
Code:
my $db_ping = $DB->creator('Blog_Ping'); $db_ping->cols(
ID => {
pos => 1,
type => "INT",
size => 10,
not_null => 1
},
url => {
pos => 2,
type => "CHAR",
not_null => 1
},
excerpt => {
pos => 3,
type => "CHAR"
},
blog_name => {
pos => 4,
type => "CHAR"
},
title => {
pos => 5,
type => "CHAR"
}
);
$db_ping->unique({ "id_url" => ['ID', 'url']});
$db_ping->create();
I've pinpointed the problem down to:
Code:
$db_ping->unique({ "id_url" => ['ID', 'url']});If I comment that out, them the def file is created. I just don't see what's wrong with it, as the usage appears to be within spec with GT::SQL::Creator documentation.
any ideas?
Philip
------------------
Limecat is not pleased.
creating tables causes script to hang