#65 field 'info_hash' doesn't have a default value (xbt_files)

[Emil Henriksen]

I've used XBTT for some weeks now, and found out that the table xbt_files not is being updated.

XBT Tracker gives me this info:

Field 'info_hash' doesn't have a default value
insert into xbt_files (leechers, seeders, completed, fid) values (0,2,0,1) on duplicate key update leechers = values(leechers), seeders = values(seeders), completed = values(completed), mtime = unix_timestamp()

I guess it can be fixed (via SQL) by changing the collumn type from blob to something that supports a default value, but it could result in a info_hash change, in case someone access the table via phpmyadmin or similar.

I'm using XBT Tracker version 0.2.6 on windows with mysql 5.0.51a.

[Emil Henriksen]

Logged In: YES
user_id=2036717
Originator: YES

also, mtime and ctime in xbt_files gives the no-default-value message/error
Also, the row already exists in the database, and auto_register is 0

[Olaf van der Spek]

Logged In: YES
user_id=30264
Originator: NO

You have to disable the STRICT_TRANS_TABLES SQL mode in my.ini.

[SourceForge Robot]

Logged In: YES
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).