#175 updateplugins fails with 'Unknown column t1.id'

[Arno]

Updateplugins doesn't work on my system, it gives this error in the local var/log/updateplugins.log:

DBD::mysql::st execute failed: Unknown column 't1.id' in 'field list' at ./updateplugins_1.00.pl line 308.

Arno

[Kenneth Kline]

Sounds like a wrong table version per the install/upgrade. I would recommend trying 1.9.2 per SVN if you haven't done so yet. download the tar.gz under the builds dir. I need to do a test on the latest 1.9.2 code and update the rev file and commit the clean_install_db table. I recommend the new code base over 1.0. I will check to see if I can get Greg/Michael to post a build of it soon.

Ken

[Kenneth Kline]

alternatively from the front-end what version does it say you have installed. 1.00 final or some earlier version,

based on the line:

298 $sql = qq{ SELECT t1.id, t1.name, t3.id, t4.id, t1.copyright, t1.summary, t1.description,
299 t1.version, t2.id, t2.version, t2.custom_risk, t1.cve_id, t1.bugtraq_id, t1.xref
300 FROM plugins t1
301 LEFT JOIN nessus_plugins t2 on t1.id=t2.id
302 LEFT JOIN nessus_family t3 ON t1.family = t3.name
303 LEFT JOIN nessus_category t4 ON t1.category = t4.name
304 };

it sounds like the plugins table was not recreated on the import, it is temporary it gets dropped/recreated, check the table exists; the user being used to do db managment may not have sufficient access to the db to drop/create tables.

plugins should look like this:

DROP TABLE IF EXISTS `plugins`;
CREATE TABLE IF NOT EXISTS `plugins` (
`id` int(11) NOT NULL,
`name` varchar(255) default NULL,
`family` varchar(255) default NULL,
`category` varchar(255) default NULL,
`copyright` varchar(255) default NULL,
`summary` varchar(255) default NULL,
`description` blob,
`version` varchar(255) default NULL,
`cve_id` varchar(255) default NULL,
`bugtraq_id` varchar(255) default NULL,
`xref` blob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;