MySQL : key specification without a key length

[Kris]

BLOB column 'caption' used in key specification without a key length.

Caption is a TEXT field
Key is:

key search (field1, caption, field3)

Someone any idea?

If I amend that key, restoring my backup works, but then I need to add the key manaully.
Known bug or so?

[Tomer]

I once had that also, don't remember how I fixed it.

You can try deleting that column and creating it like this:

Code Select Expand


caption TEXT NOT NULL,


[Kris]

I once had that also, don't remember how I fixed it.

You can try deleting that column and creating it like this:

Code Select Expand


caption TEXT NOT NULL,


I have that one like
caption TEXT NOT NULL DEFAULT '',

[[Unknown]]

You need to terminate the key at some point... ie. caption(30).

-[Unknown]

[Kris]

I changed all key that had a text field.
Seems like the dumped database did not contain any values for those fields.