So odd, it works in mysql instance correctly, sqlalchemy automatically changes that from varchat to text
2012-02-28 22:48:26,452 INFO sqlalchemy.engine.base.Engine
CREATE TABLE notifications (
notification_id INTEGER NOT NULL AUTO_INCREMENT,
subject VARCHAR(512),
body VARCHAR(50000),
created_by INTEGER,
created_on DATETIME NOT NULL,
type VARCHAR(256),
PRIMARY KEY (notification_id),
FOREIGN KEY(created_by) REFERENCES users (user_id)
)
2012-02-28 22:48:26,452 INFO sqlalchemy.engine.base.Engine ()
/home/marcink/.virtualenvs/rhodecode/lib/python2.6/site-packages/SQLAlchemy-0.7.4-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py:330: Warning: Converting column 'body' from VARCHAR to TEXT
cursor.execute(statement, parameters)
What mysql version are you using ?
Anyway to fix it just edit the
https://secure.rhodecode.org/rhodecode/files/de372c3a329e0b353bdb093dd50d3cf6ecf7c8e4/rhodecode/model/db.py#L1141-1155 to make it work.