BLOB/TEXT column 'description' can't have a default value [Solved]

This issue has been reported initially reported in Can not install....

During installation of the software, this user receives error messages related to malformed SQl statements.

The root cause of this issue is that MySQL version 5 does not accept default values for blob/large objects anymore.

This is confirmed in the on-line MySQL Manual, at C.1. Server Error Codes and Messages (look for the error code 1101).

Workaround: the straightforward way to proceed is to replace the string TEXT DEFAULT '' by TEXT throughout all scripts.

This will apply the change both to TEXT and MEDIUMTEXT column types.

Here is the list of scripts to look at:

• actions/actions.php
• agents/referrals.php
• articles/articles.php
• categories/categories.php
• comments/comments.php
• decisions/decisions.php
• files/files.php
• images/images.php
• links/links.php
• locations/locations.php
• scripts/phpdoc.php
• sections/sections.php
• servers/servers.php
• shared/cache.php
• shared/values.php
• tables/tables.php
• users/users.php
• versions/versions.php

Code has been modified at the development machine, to make this fully available along next release, due in January 2007.

Also, as a reference file I have attached the database schema reported by phpMyAdmin on the development machine. This could be use against the MySQL engine as an attempt to create the database structure anyway.