Hmm, not much to go on - that table has been around in Dada Mail unchanged for > year Maybe something on you end? Testing quickly, it does seem to work for me, with a similar MySQL version (5 1 39):
Welcome to the MySQL monitor Commands end with ; or \g Your MySQL connection id is 3538 Server version: 5 1 39 MySQL Community Server (GPL)
Type 'help;' or '\h' for help Type '\c' to clear the current input statement
mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed mysql> CREATE TABLE IF NOT EXISTS dada_message_drafts ( -> id INT4 NOT NULL PRIMARY KEY AUTO_INCREMENT, -> list varchar(16), -> created_timestamp TIMESTAMP DEFAULT NOW(), -> last_modified_timestamp TIMESTAMP, -> name varchar(80), -> screen varchar(80), -> role varchar(80), -> draft mediumtext -> ); Query OK, 0 rows affected, 1 warning (0 01 sec)
mysql>
Seems to work here, too:
http://sqlfiddle
com/#!2/7b9202
Maybe something else going on?
Start a new thread, email: dadadev@dadamailproject.com
This is the developer discussion mailing list for Dada Mail.
If you are just looking for support Dada Mail, consult the message boards at:
https://forum.dadamailproject.com
Documentation for Dada Mail:
Specifically, see the Error FAQ:
https://dadamailproject.com/d/FAQ-errors.pod.html
To post to this list, send a message to:
mailto:dadadev@dadamailproject.com
All subscribers of this list may post to the list itself.
Topics that are welcome:
Dada Mail is on Github:
https://github.com/justingit/dada-mail/
If you would like to fork, branch, send over PRs, open up issues, etc.
This Privacy Policy is for this mailing list, and this mailing list only.
Email addresses collection through this mailing list are used explicitly to work within this email discussion list.
We only collect email addresses through our Closed-Loop Opt-In system.
We don't use your email address for any other purpose.
We won't be sharing your email address with any other entity.
Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.
All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.
All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.