Chamilo LCMS Connect » Core » Admin

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