View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005940 | OXID eShop (all versions) | 2.2. Shop settings | public | 2014-10-29 15:39 | 2023-12-13 10:25 |
| Reporter | avalue | Assigned To | |||
| Priority | normal | Severity | tweak | Reproducibility | always |
| Status | confirmed | Resolution | open | ||
| Product Version | 4.5.7 revision 41909 | ||||
| Summary | 0005940: oxfolder field in oxorder has a limit of 32 characters, but more long folder names can be specified | ||||
| Description | In shop settings, I can specify a folder name longer than 32 characters. But the Field is only a VARCHAR(32) and information get lost. Moving to this folder now dont work. | ||||
| Steps To Reproduce | In shop settings, I can specify a folder name longer than 32 characters. But the Field is only a VARCHAR(32) and information get lost. Moving to this folder now dont work. | ||||
| Tags | No tags attached. | ||||
| Theme | Azure | ||||
| Browser | Google Chrome | ||||
| PHP Version | 5.3 | ||||
| Database Version | Not defined | ||||
|
|
SQL from 4.9 (CE): CREATE TABLE `oxorder` ( ... `OXFOLDER` varchar(32) NOT NULL default '' COMMENT 'Folder: ORDERFOLDER_FINISHED, ORDERFOLDER_NEW, ORDERFOLDER_PROBLEMS', ... ) Maybe solution would be to create a new table for this and reference it via its own id? EDIT: its more a feature than a bug, maybe adding this to the documentation would help too. |
|
|
I don't agree that this is a feature, because you can add new folders via backend panel and they are not inserted properly. Maybe as a Quick Fix there could be a simple information in the backend or a validation when writing folder names. |
|
|
There are no need to change the field length, because its should be defined as constant which is later translated. what is need to add help text button with explanation how to setup and defined limitation. |
