[phpodpworld-users] phpodpworld 2.0 structure table

[Howard L. <hl...@gm...>]

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