[fastforward]

Originally posted by v0n
I'm still trying to work out solution to posts being loaded with threadid 0 and bodies not showing up under threads ( I know it's boring). By now I tried three perl versions on two machines with same effect.
Yet I know it worked, I had it running till last rc of vbb2.0. Then on some point it just stopped. Even if i do a fresh install of vbb 2.0.1 and install snapshots from my data the usenet posts still get inserted with thread = 0. There must be some method to this madness.
Is there any possiblity that this bug is caused not by perl version or DBI DBD modules but by database structure? Maybe my base vbb is missing something, some index or row? Is there any tool to compare structure with original vbb setup?

It's not the database structure. As you know the problem is that the mysql_insertid() function is not returning a threadid, postid or whatever id it asks for. The problem could be either in Perl, MySQL, or most likely, a combination of both due to a version mismatch.

The reason it seemed to suddenly 'stop' working is that previous versions of the script checked to see if the id was NULL and if it was, it would re-query the table to find it. This was only in place until we determined what the problem was with mysql_insertid. It added a lot of overhead and made the script almost unusable when the function wasn't working.

I have the latest version of MySQL, Perl 5.0053 and the latest version of the modules. This works.