Re: [phpodpworld-users] phpodpworld 2.0 structure table

[Hans F. N. <Han...@hi...>]

* Howard Lee <hl...@gm...> [2006-04-19]:
> 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.

Of course it works on Postgresql - this software is in use :-)
 
> 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 = $dbh->prepare("INSERT INTO structure VALUES (?, ?, ?, ?, ?)");
> to:
> my $str_sth = $dbh->prepare("INSERT INTO structure VALUES (?, ?, ?, ?, ?, -1, -1)");
> 
> It then works for my MySQL 5.x.

Strange that this is needed, but since it doesn't hurt adding it I
will do so. (Yes, my development environment is using Postgresql so I
have noticed this problem.) Thanks again for fixing (and reporting
here).

Hans