View Issue Details

IDProjectCategoryView StatusLast Update
0005509OXID eShop (all versions)2.5. Administer userspublic2024-01-10 08:53
Reportercr Assigned To 
Status acknowledgedResolutionopen 
Product Version4.7.10 / 5.0.10 
Summary0005509: setting big number for oxcustnr
Descriptionoxuser.oxcustnr is int(11) ; that means max allowed value is 2147483647

oxcustnr is not validated in admin to that max value
Steps To Reproduce1. create an user with eg. 999999999 as oxcustnr so the max value is set instead.

2. create any new users from admin/frontend and they will always have this value, and that is an issue, because "auto increment" on oxuser table is set also to 2147483648

pleas have a check on admin to NOT allow oxcustnr to be set to any invalid values, so the "auto increment" property of oxuser remains ok

TagsSpecialized Management Apps, User Management
PHP VersionNot defined
Database VersionNot defined


related to 0004945 confirmedSvenBrunk oxuser does not use oxcounter 



2013-11-07 17:12

reporter   ~0009252

Last edited: 2013-11-07 17:12

on 2. I mean any new users will always have oxcustnr = 2147483647


2013-11-07 17:26

reporter   ~0009253

maybe it would be better to use varchar here, or even oxcounter?