Not Solved mytabs error: 1364 - Field 'default_tab' doesn't have a default value
#1
Not Solved
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?
Reply
#2
Not Solved
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.
Reply
#3
Not Solved
(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??
Reply
#4
Not Solved
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
Reply
#5
Not Solved
Bump still need help
Reply
#6
Not Solved
Bump again

Any help???
Reply
#7
Not Solved
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.
Reply
#8
Not Solved
(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?
Reply
#9
Not Solved
^ 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.
Reply
#10
Not Solved
oh k it wont let me download how do i get Tabbed Menu if sign ups are disabled on mybbcentral?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)