View Issue Details

IDProjectCategoryView StatusLast Update
0005509OXID eShop (all versions)2.5. Administer userspublic2024-01-10 08:53
Reportercr Assigned To 
PrioritynormalSeverityminorReproducibilityalways
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

thankyou
TagsSpecialized Management Apps, User Management
ThemeAll
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Relationships

related to 0004945 confirmedSven Brunk oxuser does not use oxcounter 

Activities

cr

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

FibreFoX

2013-11-07 17:26

reporter   ~0009253

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