Skip to content

Failed to install index for persistence.PDRecord model on MySQL backend. #26

Closed
jdcourcol opened this Issue Oct 29, 2013 · 2 comments

2 participants

@jdcourcol

When using a MySQL backend (Version 14.14 Distrib 5.5.29 for debian-linux-gnu (x86_64)), I got the following error at database creation:
Failed to install index for persistence.PDNamespace model: (1170, "BLOB/TEXT column 'uri' used in key specification without a key length")
Failed to install index for persistence.PDRecord model: (1170, "BLOB/TEXT column 'rec_id' used in key specification without a key length")

There is a related question on SO :
http://stackoverflow.com/questions/11129309/how-do-i-specify-an-index-for-a-textfield-in-django-with-a-mysql-backend
and
http://stackoverflow.com/questions/1827063/mysql-error-key-specification-without-a-key-length

@trungdong
Owner

I recently changed some fields from fixed-length text to unlimited-length to fix the bug where literals with length longer than 255 (8a19fa8).

I can't look at the links above as StackOverflow is offline at the moment. I'll look into this at a later time.

BTW, PostgreSQL does not have this problem.

@trungdong trungdong added the wontfix label Oct 14, 2014
@trungdong
Owner

Sorry, the prov.persistence subpackage is no longer supported.

@trungdong trungdong closed this Oct 14, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.