[phpodpworld-users] phpodpworld 2.0 structure table
Status: Beta
Brought to you by:
hansfn
|
From: Howard L. <hl...@gm...> - 2006-04-19 14:18:36
|
Dear all,
In the structure table, there are 7 fields as shown in tools/db.sql.
However, in the script tools/structure2db.pl, there are only 5 fields
when inserting records to the table. I have met a problem with MySQL
5.x and it returns an error. It might work for Postgresql but I have
not verified it though.
As I understand, the last 2 fields "count" and "totalcount" are not
imported by this script and the default are "-1". So I have modified
the tools/structure2db.pl file, line 123 from:
my $str_sth =3D $dbh->prepare("INSERT INTO structure VALUES (?, ?, ?, ?, ?)=
");
to:
my $str_sth =3D $dbh->prepare("INSERT INTO structure VALUES (?, ?, ?, ?,
?, -1, -1)");
It then works for my MySQL 5.x.
Cheers,
Howard
|