The name-field of items is restricted to 30 characters. I would like to extend it to 40 characters. I believe I have to change the table structure for table `iteminfo` (name varchar(40)) in 'admin/create_db.inc.php'.
I have two questions:
Is the above modification correct? Can I reuse an existing database with iteminfo restricted to 30 characters or have I to reconstruct the whole database?
Best,
Eknassin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The name-field of items is restricted to 30 characters. I would like to extend it to 40 characters. I believe I have to change the table structure for table `iteminfo` (name varchar(40)) in 'admin/create_db.inc.php'.
I have two questions:
Is the above modification correct? Can I reuse an existing database with iteminfo restricted to 30 characters or have I to reconstruct the whole database?
Best,
Eknassin
If did not install phPay you can change it in create_db* or for future installations.
If installation is completed you should change table definitions with phpMyAdmin. Entered values are not deleted in this way.
You should also check, if in admin/item.php and size.php a limit for <input type=text maxlength ...> is set.
Note also, that colorinfo.value is limited to same values as size before.
Greetings,
Andreas.
Hi Andreas,
thanks for your answer. Meanwhile I have decided to shorten all names to 30 letters which looks like the simplest solution to this problem. ;-)
Best,
Eknassin