View Issue Details

IDProjectCategoryView StatusLast Update
0005509OXID eShop (all versions)2.5. Administer userspublic2015-12-01 10:37
Reportercr 
PrioritynormalSeverityminorReproducibilityalways
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

thankyou
TagsUser Management
ThemeAll
BrowserAll
PHP VersionNot defined
MySQL VersionNot defined

Relationships

related to 0004945 acknowledged oxuser does not use oxcounter 

Activities

cr

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

FibreFoX

2013-11-07 17:26

reporter   ~0009253

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