View Issue Details

IDProjectCategoryView StatusLast Update
0005509OXID eShop (all versions)2.5. Administer userspublic2015-12-01 10:37
Status acknowledgedResolutionopen 
Product Version4.7.10 / 5.0.10 
Target VersionFixed in Version 
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

TagsUser Management
PHP VersionNot defined
Database VersionNot defined


related to 0004945 acknowledged oxuser does not use oxcounter 



2013-11-07 17:12

reporter   ~0009252

Last edited: 2013-11-07 17:12

View 2 revisions

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?