MyBB Community Forums

Full Version: mytabs error: 1364 - Field 'default_tab' doesn't have a default value
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
every time i go to add a new user from the admin cp i get this error

1364 - Field 'default_tab' doesn't have a default value

how do i fixed this?

do i need to do something in phpmyadmin? how do i also add the fix to the plugin file too?
Take a look at the replies here:
https://community.mybb.com/thread-154553...pid1079109
https://community.mybb.com/thread-154553...pid1078933

Let me know if this fixed your problem.
(2019-05-26, 11:46 PM)Brian. Wrote: [ -> ]Take a look at the replies here:
https://community.mybb.com/thread-154553...pid1079109
https://community.mybb.com/thread-154553...pid1078933

Let me know if this fixed your problem.

that didn't fix my problem unless im doing something wrong i dont know lol

Hello? Any help??
I im having the same problem is there any other free tab plugin that can be customized like MyTabs or is there a way to fix this little bug? i lack experience with stuff like this
Bump still need help
Bump again

Any help???
basically the problem appears to be due to strict mode of your database server.
perhaps it would be better to contact your webhost & request to disable that strict mode

you may also try below method but not sure it would work

uninstall the plugin.
open the plugin file mytabs.php with notepad++ or editor at webhost panel

around line 116 find
$db->add_column('users', 'default_tab', 'TEXT NOT NULL');
change to
$db->add_column('users', 'default_tab', 'TEXT NOT NULL DEFAULT 0');
save the file & try using it

btw, this MyTabs plugin was NOT coded in a perfect manner. better to not use it.
(2019-05-29, 12:45 AM).m. Wrote: [ -> ]basically the problem appears to be due to strict mode of your database server.
perhaps it would be better to contact your webhost & request to disable that strict mode

you may also try below method but not sure it would work

uninstall the plugin.
open the plugin file mytabs.php with notepad++ or editor at webhost panel

around line 116 find
$db->add_column('users', 'default_tab', 'TEXT NOT NULL');
change to
$db->add_column('users', 'default_tab', 'TEXT NOT NULL DEFAULT 0');
save the file & try using it

btw, this MyTabs plugin was NOT coded in a perfect manner. better to not use it.

thanks so much it was because of strict mode and what are the risks of using it? is their a better tabbed forum plugin?
^ many of the earlier plugins were coded without considering strict mode.
so there can be a problem while installing such plugins.

some use Tabbed Menu plugin from mybbcentral. that was coded better.
oh k it wont let me download how do i get Tabbed Menu if sign ups are disabled on mybbcentral?
Pages: 1 2