vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   Major Bug: Large User IDs Do Not Work (ie 302044006) (https://vborg.vbsupport.ru/showthread.php?t=183069)

imported_silkroad 06-20-2008 03:33 PM
Major Bug: Large User IDs Do Not Work (ie 302044006)
 
[BUG]

Hello,

Our forums have large user ids for many users (for example, 302044006) and none of these IDs will work in our forums correctly.

For example, I tried to add the Guest User from a new account with a high number, and each time it converted the big user id to something smaller.

In addition, users with the big ids cannot save scores, etc.

The code need to be upgraded to permit the maximum size of user ids permitted in vBulletin.

--------------- Added [DATE]1213982775[/DATE] at [TIME]1213982775[/TIME] ---------------

Note to developer:

All these large user ids are truncated / transformed to the user id 8388607 when saved as the user id of the guest user.

(just FYI).

--------------- Added [DATE]1213985072[/DATE] at [TIME]1213985072[/TIME] ---------------

See also, reply from Steve back at vBulletin.com ....

http://www.vbulletin.com/forum/showthread.php?p=1583363

--------------- Added [DATE]1213986405[/DATE] at [TIME]1213986405[/TIME] ---------------

vBulletin user IDs seem to be unsigned integers, where the unsigned range of user IDs is 0 to 4294967295.

ipProArcade uses signed mediumints for user IDs, where the range of user IDs is -8388608 to 8388607.

Ref: http://www.ispirer.com/doc/sqlways38...ays-1-190.html

MrZeropage 06-30-2008 03:19 PM
try to run the following queries:

Code:
ALTER TABLE " . TABLE_PREFIX . "games_champs MODIFY champ_mid INT(10) DEFAULT '0' NOT NULL
 
ALTER TABLE " . TABLE_PREFIX . "games_list MODIFY bestmid INT(10) DEFAULT '0' NOT NULL

ALTER TABLE " . TABLE_PREFIX . "games_session MODIFY mid INT(10) DEFAULT '0' NOT NULL
Please let me know if this fixes the problem, as it will be part of v2.6.8+ then :)

imported_silkroad 07-01-2008 10:30 AM
Hi Mr. ZeroPage,

Thank you for posting a fix. From memory, our team recalls changing these, in fact we think we changed all of the "mid" columns to "bigints" which should have more or less the same effect.

http://www.unix.com/arcade.php

MrZeropage 07-01-2008 06:31 PM
*fix included in next release*


All times are GMT. The time now is 04:09 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00958 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete