BLOB/TEXT column 'description' can't have a default value [Intégré]
SQL statements have to change for MySQL 5
Propriétaire | Bernard Paques |
Avancement | |
Workflow | Besoin d'aide |
Statut | La solution a été intégrée |
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
Workaround: the straightforward way to proceed is to replace the string
This will apply the change both to TEXT and MEDIUMTEXT column types.
Here is the list of scripts to look at: -
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.
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.
Bernard Paques | |
Bernard Paques |