MyBB Community Forums

Hi,

I'm having problems with usernames. Someone wants to sign up as :

Frédrick Blogs

The é causes it to fail. How do I allow these? I tried to install: https://community.mybb.com/mods.php?action=view&pid=350 , but I get an error when trying to activate it:

Quote:SQL Error: 1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1 Query: INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('NULL','strictUsername','Strict Username','Settings for plugin \"Strict Username\"',30,'0')

Thanks

Andy

in the plugin's file : strictUsername.settings.php [GitHub Link]

find occurrences of NULL & replace with 0 [zero] & check if it helps.

Note: php files should be saved with utf-8 encoding without Byte Order Mark.
in general, we use editor like Notepad++ or file editor at web host panel to edit the files.

however the issue is due to strict mode of your database server.
it might be problematic while installing some other plugins ...

(2020-03-30, 08:19 AM).m. Wrote: [ -> ]in the plugin's file : strictUsername.settings.php  [GitHub Link]

find occurrences of NULL & replace with 0 [zero] & check if it helps.

Note: php files should be saved with utf-8 encoding without Byte Order Mark.
in general, we use editor like Notepad++ or file editor at web host panel  to edit the files.

however the issue is due to strict mode of your database server.
it might be problematic while installing some other plugins ...

You star! That did it