Package: linkchecker
Version: 6.9-1
Severity: important
When attempting to load the resulting data into a database, all logged data
fails with the following error:
ERROR: INSERT has more expressions than target columns
This occurs in the last 4/5 attributes that are pushed out.
An example...
insert into
linksdb(urlname,parentname,baseref,valid,result,warning,info,url,line,col,name,checktime,dltime,dlsize,cached)
values
('http://aseigo.blogspot.com/2008/05/discussing-free-software-syncronicity.html','http://linuxdatabases.info/info/linux.html','http://linuxfinances.info/info/index.html',1,'200
OK','could not get content: ''timeout: timed out''','Using proxy
`http://localhost:3128/''.
Last modified Tue, 02 Aug 2011 17:48:14
GMT.','http://aseigo.blogspot.com/2008/05/discussing-free-software-syncronicity.html',726,3,'
aseigo: Discussing free software syncronicity ',44,-1,0,0,2);
Note the last few integer columns; that's where the mismatch takes place.
The columns are:
checktime, dltime, dlsize, cached
The numbers that it tries to squeeze in:
44,-1,0,0,2
I'm not sure which is the extra column.
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (990, 'testing'), (600, 'unstable'), (100, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=ANSI_X3.4-1968)
(ignored: LC_ALL set to C)
Shell: /bin/sh linked to /bin/dash
Versions of packages linkchecker depends on:
ii libc6 2.13-10 Embedded GNU C Library: Shared lib
ii python 2.6.7-1 interactive high-level object-orie
ii python2.6 2.6.7-3 An interactive high-level object-o
ii python2.7 2.7.2-3 An interactive high-level object-o
linkchecker recommends no packages.
Versions of packages linkchecker suggests:
ii apache2 2.2.19-1 Apache HTTP Server metapackage
ii apache2-mpm-worker [httpd] 2.2.19-1 Apache HTTP Server - high speed th
pn clamav-daemon <none> (no description available)
ii linkchecker-gui 7.0-1 check websites and HTML documents
ii python-cssutils 0.9.8~a1-1 CSS Cascading Style Sheets parser
pn python-gconf <none> (no description available)
pn python-geoip <none> (no description available)
pn python-optcomplete <none> (no description available)
pn python-pysqlite2 <none> (no description available)
pn python-twill <none> (no description available)
pn python-utidylib <none> (no description available)
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
