[Mayan EDMS: 2588] Migration error using MySql db

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[Mayan EDMS: 2588] Migration error using MySql db

vsolvstab
I configured project using Django server. I had added the required libraries based on requirement. when I tried to migrate Django using Mysql server, I get error:
"django.db.utils.OperationalError: (1170, "BLOB/TEXT column 'value' used in key specification without a key length")"

When I searched this error, I found -->MySQL error: key specification without a key length. but I occur error while migration.

mysql version - 5.7.20

please help me to find the problem. thanks in advance


--

---
You received this message because you are subscribed to the Google Groups "Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

[Mayan EDMS: 2631] Re: Migration error using MySql db

rosarior
Administrator
Which version or fork of Mayan are you using? This error is typical of MySQL when indexing text fields. Mayan doesn't index text fields. All indexed fields are of CHAR 255 type.

On Tuesday, July 17, 2018 at 8:40:05 AM UTC-4, [hidden email] wrote:
I configured project using Django server. I had added the required libraries based on requirement. when I tried to migrate Django using Mysql server, I get error:
"django.db.utils.OperationalError: (1170, "BLOB/TEXT column 'value' used in key specification without a key length")"

When I searched this error, I found --><a href="https://stackoverflow.com/questions/1827063/mysql-error-key-specification-without-a-key-length" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F1827063%2Fmysql-error-key-specification-without-a-key-length\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGt3jK8EtoX2a0-lcVdaelXC0ucow&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F1827063%2Fmysql-error-key-specification-without-a-key-length\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGt3jK8EtoX2a0-lcVdaelXC0ucow&#39;;return true;">MySQL error: key specification without a key length. but I occur error while migration.

mysql version - 5.7.20

please help me to find the problem. thanks in advance


--

---
You received this message because you are subscribed to the Google Groups "Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.