briancline/ircplanet

CS not populating create_ts at registration time

briancline opened this issue · 0 comments

CS seems to be defaulting the create_ts database field to an empty value somewhere, which gets translated to an empty string at insertion time. MySQL rejects inserts during new channel registrations as an empty string is not a numeric value, which is probably a (correct, expected) behavior change that occurred sometime in the last, er, (inaudible) years.

As a result, new channel registrations don't work under newer versions of MySQL since the insert query fails outright.

It just doesn't seem to be copying the network-provided create timestamp for a channel into the DB_Channel instance at registration time before saving the record, which is probably a CS thing, but could actually be a core thing that is causing other problems too if it's not being populated in the core Channel instance.

There's like maybe one or two people in the world actually using this stuff, and there's so much more that's wrong with this ancient codebase, but this might be a relatively simple fix.