Reply New Topic
2009/10/22 13:39:42
#1
Offline
Home away from home

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'


2009/10/23 0:01:29
#2
Offline
Home away from home

Re: Imlinks: problems reporting broken links

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.


2009/10/23 7:25:14
#3
Offline
Home away from home

Re: Imlinks: problems reporting broken links

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?


2009/10/23 11:47:52
#4
Offline
Home away from home

Re: Imlinks: problems reporting broken links

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.

_________________
McDonalds Store

2009/10/23 14:50:44
#5
Offline
Home away from home

Re: Imlinks: problems reporting broken links

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.


2009/10/23 15:17:46
#6
Offline
Home away from home

Re: Imlinks: problems reporting broken links

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.

_________________
McDonalds Store

Reply New Topic extras
 Previous Topic   Next Topic
You can view topic.
You can start a new topic.
You can reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You can post without approval.