Skip Menu |

This queue is for tickets about the CPAN-Testers-Data-Uploads CPAN distribution.

Report information
The Basics
Id: 65945
Status: resolved
Priority: 0/
Queue: CPAN-Testers-Data-Uploads

People
Owner: Nobody in particular
Requestors: RCAPUTO [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: uploads.db.bz2 - illegal characters in "released" column
http://devel.cpantesters.org/uploads/uploads.db.bz2 is produced with trailing newlines in some uploads.released values. Show quoted text
sqlite> select author, dist, hex(released) from uploads where
DATE(released, 'unixepoch') is null limit 1; EMAZEP|SQL-SplitStatement|313239373231323036300A Note the "0A" at the end, and that it's causing the sqlite3 DATE() function to fail.
I believe this has been resolved. I have tried this query in the latest version of the uploads.db download and I'm not getting the error. Thanks, Barbie.