Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2019-01-11 23:25:29

Shortik
Member
Registered: 2019-01-11
Posts: 5

Unable to create user - Field 'token' doesn't have a default value

Hi all,
I have a fluxBB 1.5.8.
I have to migrate my fluxBB from one hosting to another one. I copied all files to new hosting and export and import the database. Everything looks great but when I try to register a new user, I'm getting an error (with these debug info):

File: /register.php
Line: 163

FluxBB reported: Unable to create user

Database reported: Field 'token' doesn't have a default value (Errno: 1364)

Failed query: INSERT INTO users (username, group_id, password, email, email_setting, timezone, dst, language, style, registered, registration_ip, last_visit) VALUES('shortik_test', 0, 'b83d2b4384995f2fa2c2b1b152efd0e49d1950dd', 'o7710930@nwytg.net', 1, 1 , 0, 'Czech', 'Air', 1547246628, 'some_ip_address', 1547246628)

When I look to database, there is a "token" field with NOT NULL parameter, but register.php doesn't send any "token".
I was googling a while and it seems my old hosting has a non-strict MySQL server mode, but the new hosting has a strict MySQL server mode.

My question is:
What is the token used for? Can I simply change the NOT NULL parameter? Or is there any default value I can set up? Or what is the right solution of this problem?

Thanks
Shortik

Last edited by Shortik (2019-01-11 23:29:26)


Sorry for my English, I'm not a native speaker. smile

Offline

#2 2019-01-11 23:40:08

Gianluigi
Member
Registered: 2018-06-23
Posts: 17

Re: Unable to create user - Field 'token' doesn't have a default value

Can't find token column here:
https://fluxbb.org/docs/v1.5/dbstructure#users

And nothing related to it if I check a 1.5.x version. Could it be related to some mod?

If you have the chance, I would try to delete the column at all, and try if all works fine (without modifications I think it should work without troubles..)

Offline

#3 2019-01-12 08:20:16

Shortik
Member
Registered: 2019-01-11
Posts: 5

Re: Unable to create user - Field 'token' doesn't have a default value

Maybe you are right. Previously we tried to use Ajax chat and IRC, it could be leftover of one of these! I will check that mods.
Because the first rapid tests seems OK when I set that column to accept the null value.


Sorry for my English, I'm not a native speaker. smile

Offline

Board footer

Powered by FluxBB