Userid's in Anarchy Online too large for id db fields

Bug #404401 reported by Thomas Juberg on 2009-07-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
BeBot
Critical
Unassigned

Bug 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.

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/

description: updated
description: updated
Thomas Juberg (thomas-juberg) wrote :

Fixed for 0.6.4 release by using BIGINT for col's.
Internal userid handling will not be fixed for 0.6 branch most likely.

no longer affects: bebot/trunk
no longer affects: bebot/0.6
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers