Project

General

Profile

Bug #2494

mysql >= 5.0.3 required?

Added by Nathalie Blocry about 9 years ago. Updated almost 8 years ago.

Status:
Bug resolved
Priority:
Normal
Start date:
06/01/2011
Due date:
% Done:

0%

Estimated time:
Complexity:
Normal

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

#1

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)

#2

Updated by Stefaan Vanbillemont about 9 years ago

  • Target version set to 21
#3

Updated by Hans De Bisschop almost 9 years ago

  • Project changed from Chamilo LCMS Connect to Admin
  • Category deleted (5)
  • Target version deleted (21)
#4

Updated by Hans De Bisschop almost 9 years ago

  • Target version set to 2.1.0
#5

Updated by Stefaan Vanbillemont over 8 years ago

  • Target version changed from 2.1.0 to Backlog (default)
#6

Updated by Stefaan Vanbillemont over 8 years ago

  • Target version changed from Backlog (default) to 2.1.0
#7

Updated by Stefaan Vanbillemont about 8 years ago

  • Target version changed from 2.1.0 to Backlog (default)
#8

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.

Also available in: Atom PDF