View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001714 | OXID eShop (all versions) | 1.05. Users | public | 2010-03-22 23:24 | 2010-06-28 19:23 |
| Reporter | sebber | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.2.0 revision 23610 | ||||
| Fixed in Version | 4.4.0 revision 28699 | ||||
| Summary | 0001714: Double User number allocation | ||||
| Description | When 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 Information | http://www.oxid-esales.com/forum/showthread.php?t=4706 | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | FireFox 3.x | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
|
|
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. |
|
|
fixed by making "oxcustnr" field auto_increment |
