View Issue Details

IDProjectCategoryView StatusLast Update
0005940OXID eShop (all versions)2.2. Shop settingspublic2015-12-01 10:14
Reporteravalue 
PrioritynormalSeveritytweakReproducibilityalways
Status acknowledgedResolutionopen 
Product Version4.5.7 revision 41909 
Target VersionFixed in Version 
Summary0005940: oxfolder field in oxorder has a limit of 32 characters, but more long folder names can be specified
DescriptionIn 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 ReproduceIn 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.
TagsNo tags attached.
ThemeAzure
BrowserGoogle Chrome
PHP Version5.3
MySQL VersionNot defined

Activities

FibreFoX

2014-10-29 15:56

reporter   ~0010288

Last edited: 2014-10-29 17:05

View 2 revisions

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.

avalue

2014-10-29 21:16

reporter   ~0010289

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.

Linas Kukulskis

2014-12-02 10:07

reporter   ~0010365

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.