Activity log for bug #404401

Date Who What changed Old value New value Message
2009-07-25 00:39:38 Thomas Juberg bug added bug
2009-07-25 00:40:42 Thomas Juberg branch linked lp:bebot
2009-07-25 00:40:59 Thomas Juberg branch linked lp:bebot/0.6
2009-07-25 00:41:27 Thomas Juberg bug task added bebot/0.6
2009-07-25 00:41:27 Thomas Juberg bug task added bebot/trunk
2009-07-25 21:28:34 Thomas Juberg description http://bebot.shadow-realm.org/bebot-0-6-support/bot_logon-column-not-large-enough/ According to this user the userid's returned by Anarchy Online for new characters at least on one dimension now contains more characters than can be stored in the current database schema. This means we will most likely have to alter the schema for all tables storing userid. http://bebot.shadow-realm.org/bebot-0-6-support/bot_logon-column-not-large-enough/ According to this user the userid's returned by Anarchy Online for new characters at least on one dimension now contains more characters than can be stored in the current database schema. This means we will most likely have to alter the schema for all tables storing userid. Note: This affects 64bit platforms where the int's for userid's does NOT overflow to become signed int's. This also means that database entries for users created on 32bit php installs won't be recognized when run on 64bit installs and vice versa.
2009-07-25 21:28:47 Thomas Juberg bebot/trunk: status New In Progress
2009-07-25 21:57:12 Thomas Juberg description http://bebot.shadow-realm.org/bebot-0-6-support/bot_logon-column-not-large-enough/ According to this user the userid's returned by Anarchy Online for new characters at least on one dimension now contains more characters than can be stored in the current database schema. This means we will most likely have to alter the schema for all tables storing userid. Note: This affects 64bit platforms where the int's for userid's does NOT overflow to become signed int's. This also means that database entries for users created on 32bit php installs won't be recognized when run on 64bit installs and vice versa. http://bebot.shadow-realm.org/bebot-0-6-support/bot_logon-column-not-large-enough/ According to this user the userid's returned by Anarchy Online for new characters at least on one dimension now contains more characters than can be stored in the current database schema. This means we will most likely have to alter the schema for all tables storing userid. Note: This affects 64bit platforms where the int's for userid's does NOT overflow to become signed int's. This also means that database entries for users created on 32bit php installs won't be recognized when run on 64bit installs and vice versa. We will likely have to fix this properly at some point forcing userid's to be float. For reference: http://www.mysqlperformanceblog.com/2008/01/10/php-vs-bigint-vs-float-conversion-caveat/
2009-07-30 15:19:39 Thomas Juberg bebot/trunk: milestone 0.6.4 0.7.0
2010-04-24 17:18:46 Wouter van Heyst branch unlinked lp:bebot
2012-05-27 21:04:36 Thomas Juberg bug task deleted bebot/trunk
2012-05-27 21:04:44 Thomas Juberg bug task deleted bebot/0.6
2012-05-27 21:11:38 Thomas Juberg branch unlinked lp:bebot/0.6