Could not execute SQL query "UPDATE queueinfo SET "ETA"...

[senax]

Hi,

I've installed a newly downloaded urd and have some problems updating newsgroups. This is a new install and I let it create the tables automatically.

urdd: WARNING Database problem: (1690) mysqli error: [1690: BIGINT UNSIGNED value is out of range in '(-(243) + "urddb"."queueinfo"."ETA")'] in EXECUTE("UPDATE queueinfo SET "ETA"=((-243 + "ETA") / 2), "progress"='100', "comment"='37 articles/s - total 1000 articles', "lastupdate"='1325973151' WHERE "ID"='451'")

 urdd: ERROR Error while updating alt.binaries.hdtv.x264: Could not execute SQL query "UPDATE queueinfo SET "ETA"=((-243 + "ETA") / 2), "progress"='100', "comment"='37 articles/s - total 1000 articles', "lastupdate"='1325973151' WHERE "ID"='451'" mysqli error: [1690: BIGINT UNSIGNED value is out of range in '(-(243) + "urddb"."queueinfo"."ETA")'] in EXECUTE("UPDATE queueinfo SET "ETA"=((-243 + "ETA") / 2), "progress"='100', "comment"='37 articles/s - total 1000 articles', "lastupdate"='1325973151' WHERE "ID"='451'")


It seems a bit odd to add an integer to a string? ( -243 + "ETA")?

Ideas on how to fix this?

Thanks!

Senax

[spearhead]

It's not so strange as "ETA" refers to a column, and is not a string actually. Anyway, odd that this happens. A quick fix may be to edit the file functions/functions.php (under /usr/share/urd/ if using the .deb file) and at line 445  in function store_ETA() you see a line like 

Code:

$eta = floor($eta);

After that line add a line like:

Code:

$eta = max(0, $eta);

Thanx for reporting this tho.

[senax]

Thanks!

That seems to have done the trick =)