Bug #2494
mysql >= 5.0.3 required?
0%
Description
install issue in forum:
_After upgraden the server i've been able to get the installion process started until step 8. But there I get a lot of SQL errors
[Last executed query: CREATE TABLE chamilo.admin_dynamic_form_element_value (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, user_id INT UNSIGNED NOT NULL, time INT UNSIGNED NOT NULL, dynamic_form_element_id INT UNSIGNED NOT NULL, value VARCHAR DEFAULT ' ' NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci]
[Native code: 1074]
[Native message: Column length too big for column 'value' (max = 255); use BLOB or TEXT instead]I have MySQL 4.1.20, has anyone seen this error before?_
untill mysql 5.0.3 varchars have a maximum length of 255
the length of the value-field is set to 500 in the file/admin/php/install/dynamic_form_element_value.xml
maybe there are other tables with bigger varchars, I haven't checked
we should reduce the field-size if this does not break the functionality (or change the type) or make mysql 5.0.3 a minimum requirement for chamilo 2.0
History
Updated by Anonymous about 9 years ago
500 is a rather strange (arbitrary?) limit. Another solution would be to drop the length altogether (causing it to be a TEXT field)
Updated by
Updated by Hans De Bisschop almost 9 years ago
Updated by - Project changed from Chamilo LCMS Connect to Admin
- Category deleted (
5) - Target version deleted (
21)
Updated by Stefaan Vanbillemont over 8 years ago
- Target version changed from 2.1.0 to Backlog (default)
Updated by Stefaan Vanbillemont over 8 years ago
- Target version changed from Backlog (default) to 2.1.0
Updated by Stefaan Vanbillemont about 8 years ago
- Target version changed from 2.1.0 to Backlog (default)
Updated by Stefaan Vanbillemont almost 8 years ago
- Status changed from New to Bug resolved
- Assignee set to Stefaan Vanbillemont
- Target version changed from Backlog (default) to LCMS 3
Expected PHP version for Chamilo Connect 3 = PHP5.3 or higher.