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

Bug #404401 reported by Thomas Juberg
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
BeBot
In Progress
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
Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.