# MySQL tracker store gives error VARCHAR requires a length on dialect mysql

**URL:** <https://forum.rasa.com/t/mysql-tracker-store-gives-error-varchar-requires-a-length-on-dialect-mysql/10486>\
**Category:** Rasa Open Source\
**Created:** [May 28, 2019, 5:43am UTC](https://forum.rasa.com/t/mysql-tracker-store-gives-error-varchar-requires-a-length-on-dialect-mysql/10486 "2019-05-28T05:43:54Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Marrahi](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@Marrahi](https://forum.rasa.com/u/Marrahi)\
**Post date:** [May 29, 2019, 1:43pm UTC](https://forum.rasa.com/t/mysql-tracker-store-gives-error-varchar-requires-a-length-on-dialect-mysql/10486/2 "2019-05-29T13:43:11Z")

</div>

Hi Palash,

I just had the exact same problem. It seems like an issue with the ‘sqlalchemy’ package when it tries to create the table column because no lenght is specified.

I found a ‘temporary’ solution:

Locate the following file:

`~/.local/lib/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py` (might not be the same exact path) and right after the line: visit\_VARCHAR

add the following:

```auto
if type_.length is None:
    type_.length = 1024 # change 1024 to whatever lenght value you need

```

Save the file and run rasa again. The table is created, and all varchar columns will have that exact size. I hope you can move on with this solution for the moment.

Byeee

 ![screen](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/2X/a/a564a75eb755f56d11b1c6f5a666193cc1143ff5.jpeg)

(Don’t forget this is a kind of ‘hack’ so once your table is created, you can actually remove those two lines.)

---

_[View the full topic](https://forum.rasa.com/t/mysql-tracker-store-gives-error-varchar-requires-a-length-on-dialect-mysql/10486)._
