MySQL database setup for user registration.

[danbates2]

I recently went through an install and the problem still exists.
#791

I also had to do the following:
ALTER TABLE users CHANGE preferences preferences TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

[danbates2]

I believe if we drop in :

ALTER TABLE users CHANGE tags tags TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

ALTER TABLE users CHANGE preferences preferences TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

here:
https://github.com/emoncms/emoncms/blob/master/Lib/dbschemasetup.php

this would be a fix?

[takkaria]

If you just remove 'null'=>true from user_schema.php it should work. I did submit a pull request that rewrote the database schema code in a more robust way in #930 but no-one's accepted it yet.

[danbates2]

That worked Perfectly.
I didn't realise that I had to delete the original database to get that to work. I'm new to this.

[danbates2]

@TrystanLea
A very simple fix to the problem is to be found in takkaria's comment above.
@takkaria Thank you :)

[danbates2]

@glynhudson
Thought to tag you in Glyn, Trys is still away on hols :) Check out this simple fix in the pull request.