Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need someone to update MyTabs Plugin
#1
can someone update this plugin please users cant register on ur forums once its active 
comes up with this messege 

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1364 - Field 'default_tab' doesn't have a default valueQuery:INSERT INTO mybb_users


Added attachment to this post for the plugin that needs updating.


original post for plugin 

https://community.mybb.com/mods.php?action=view&pid=456


Attached Files
.zip   2617-1313208204-MyTabs.zip (Size: 10.54 KB / Downloads: 8)
Reply
#2
Edit line 115 of inc/mytabs.php

original: $db->add_column('users', 'default_tab', 'TEXT NOT NULL');

replacement: $db->add_column('users', 'default_tab', 'TEXT NOT NULL DEFAULT 0');

And you can correct your database without uninstall/reinstall the plugin using phpmyadmin (or any access to your MySQL) with the query alter table users alter default_tab set default 0

Nota bene: if you have no tab with index 0, it may occure an error in MyBB front.
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply
#3
i go to plugins to set up my tabs and get

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'yplzyosrbzlsjqec_544.mybbte_mytabs_tabs' doesn't exist
Query:
SELECT * FROM mybbte_mytabs_tabs ORDER BY order ASC

edited and fixed the plugin and a few other Errors
and uploaded it to plugins section so everyone can enjoy it the mytabs program to work with the latest mybb version

thanks @CrazyCat

https://community.mybb.com/mods.php?acti...w&pid=1337
Reply
#4
(02-08-2020, 01:09 AM)FatalMessiah777 Wrote: i go to plugins to set up my tabs and get

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'yplzyosrbzlsjqec_544.mybbte_mytabs_tabs' doesn't exist
Query:
SELECT * FROM mybbte_mytabs_tabs ORDER BY order ASC

edited and fixed the plugin and  a few other Errors
and uploaded it to plugins section so everyone can enjoy it  the mytabs program to work with the latest mybb version

thanks @CrazyCat

https://community.mybb.com/mods.php?acti...w&pid=1337


Looking at the file you provided as well as the one you posted on the mods site, I am simply curious why you are opting to fix, well correction on that, umm request others to fix the 1.6 version rather than use the 1.8 version https://community.mybb.com/mods.php?action=view&pid=456 and if the issue is still present in such then fix that in the 1.8 version https://community.mybb.com/mods.php?action=view&pid=456 and perhaps credit the person that actually fixed it for you as well? Just saying...
MyBB Themes Team - Making more professional themes by the hour. (Retired)
My Mods | Offer me a coffee!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)