Thread:Project:Support desk/Confirm Account Extension and User access to private pages/reply (8)

Hi!

This error happens, when you tell MySQL to index a column, but do not provide a length for the key/index. That way MySQL cannot use it for a key leading to this error.

I think the fact that this is happening is a bug and you should report it in Bugzilla in order to get it solved properly.

To place a limit on the TEXT or BLOB column, you can try to use VARCHAR type and place a limit of length on it. By default, VARCHAR is limited to a maximum of 255 characters and its limit must be specified implicitly within a bracket right after its declaration, i.e VARCHAR(200) will limit it to 200 characters long only.