MyBB Community Forums

Full Version: Plugin giving mysql error?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
im back again, just tried installing PM on activation plugin but it gives me this MySQL error. it seems like it's missing a table that should've been created during installation

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'sgforums.mybb_mybb_settinggroups' doesn't exist
Query:
INSERT INTO mybb_mybb_settinggroups (name,title,description,disporder,isdefault) VALUES ('dennistt_pm_on_registration','PM On Registration (DennisTT)','Settings for the PM On Registration plugin','1','no')

I'm going to try to edit it to only look for mybb_ instead of mybb_mybb
It looks like it's looking for the table mybb_mybb_settingsgroup
Shouldn't it be looking for mybb_settingsgroup intead?
I didn't have that problem when I installed that plugin.

I think you can go into phpMyAdmin and run the SQL query manually to fix it.
hm, i don't have phpmyadmin, is there another way to do it? or should i just go download it?
Are you sure you're using the version made for 1.4?? Look like you're using the 1.2 version. Can you post the URL you downloaded it from?? Don't try and manually fix it, if it's the 1.2 version, you'll only have more errors when trying to use it.
hmm, i thought i downloaded it from mybboard.net, how can i check from the ACP?
Yeah, I'm using MyBB version 1.4.9
I don't think you can check from the ACP really, it'll be easier to just have the URL to the page you downloaded it from...

No not the version of MyBB, the version of the plugin... we need the URL of where you got the plugin...
oh, sorry. i DL'd the plugin from
http://mods.mybboard.net/view/pm-on-registration-v1.1.2
oh god, im sorry. i didn't see that it was last updated in 2007, >_<
Yeah, won't work, it was made for MyBB 1.2. Use this one: http://mods.mybboard.net/view/pm-on-registration
Thanks. I'm loving this!!