View Issue Details

IDProjectCategoryView StatusLast Update
0001714OXID eShop (all versions)1.05. Userspublic2010-06-28 19:23
Reportersebber 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.2.0 revision 23610 
Target VersionFixed in Version4.4.0 revision 28699 
Summary0001714: Double User number allocation
DescriptionWhen you delete the last Registered User, this Number is given the next registering User.

Sometimes User numbers are skipped.

The Result is that you cannot forecast the next User Number.
Additional Informationhttp://www.oxid-esales.com/forum/showthread.php?t=4706
TagsNo tags attached.
Theme
BrowserFireFox 3.x
PHP Versionany
Database Versionany

Activities

ralf_trapp

2010-04-14 13:16

reporter   ~0002539

As google translate does not help much when translating forum thread i help out here:

According to forum, basically this is about duplicate user numbers. E.g. when customer with highest customer number is deleted but this one was already exported to some erp software, the same customer number is assigned a second time. This leads to troubles.

Using auto_increment is one suggestion to solve that.

arvydas_vapsva

2010-05-26 13:35

reporter   ~0003077

fixed by making "oxcustnr" field auto_increment