Imlinks: problems reporting broken links

Environment:
iCMS 1.1.3
Inlimks 1.02

Debug mode shows in queries:
INSERT INTO xxxx_imlinks_broken (reportid, lid, sender, ip, date, confirmed, acknowledged, title ) VALUES ( 0, 87, 405, 'xxxxxxxxxx', 1256229857, 0, 0, 'xxx')
Error number: 1054
Error message: Unknown column 'title' in 'field list'

Open up your xxxx_imlinks_broken table in PHPMyAdmin
See if there is a column called "title". If not, maybe update the module?
(let mcDonald stop by this thread and reply too )

simple solution is adding the column yourself, but we need to figure out how the column is missing while the script needs it.

It is curious: "title" column was not in table. Updating module did not created it.
I tried:
Deleting xxx_imlinks_broken table; updating the module: the table was created without prefix.
Changing table name (adding prefix) and it works now. But why the previous error?

For some reason the 'title' has dissappeared from your database table.
I don't know why this has happened.
No changes have ever been made to the brokenlinks table.
The field 'title' did always exist in the sql-file even with WF-Links.

Can it be that the issue happened after importing a corrupted database backup? ...just a thought...

I will see if I can make something that will check if the database tables of imLinks correct and will fix issues if they exist.

Thank you McDonald.

Actually, there is a mechanism in ImBuilding that will rebuild the tables based on the contents of the fields in the constructors of the classes (am I saying this right, someone correct me if I'm wrong).
Let's see... an example:

I have a class. In that class is a constructor. In the constructor I declare the fields for the class.

class UnderDog
{
/*
I know : Old Style. New style would be __Construct()
*/
function UnderDog()
{
field1 = integer;
field2 = string;
field3 = date;
}
}

Now the mechanism. If I added another field (field4, type is image) and I update the module then automatically the field4 will be added to the database.

In imLinks the file /include/onupdate.inc.php is used for altering an existing database. This file can probably be used. It's executed when updating the module.