MyBB Community Forums

Full Version: When update usergroup setting...
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i get this when i'm update usergroup setting

MySQL Error...

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'gn' in 'field list'
Query:
UPDATE mybb_usergroups SET gn='' WHERE gid='4'

please help me Sad
Did you upgraded your forum from MyBB 1.4.x ?
What plugins you've installed ?
nope... i didn't upgrade.. i'm install it from 1.6.3 version

i use many plugin ..
Quote:Tabbed(1.5)
Simple Audito Video Embeder (1.0.1)
adf.ly links (2.0)
Advanced Quick Reply Form (1.0.3)
Advanced Forum Signatures (2.0.3)
Ajax PM Notification (1.8.1)
Akismet (1.2.1)
Advanced MyCode Permissions (1.2)
blocking threads with bad words (blothwibawor) (1.0)
Break Email Links (1.2)
ChangUonDyU - Extra File Chatbox (3.6.0)
Color Notes (CSS extras) + bonus stuff (1.4)
Default Avatar (1.0)
Fassim Anti Spam (1.21)
FBConnect (1.0.0)
Forum Icons (2.1)
Forum Age by HSC Community (1.0)
Guests Can't View Threads (1.1)
Group Notice (1.0)
Header Announcements (1.0)
Hello World! (1.0)
HP / MP / EXP Statistics (1.0.0)
Index Ads (1.1)
Image Resizer & Optimizer with GD (1.1.1)
Index Top Posters (1.0.1)
Its My Birthday! (2.2)
Last Visitors in Profile (1.1)
LockOldThreads (1.1)
My Awards (1.3)
My Permissions (1.2)
MyCode: MySpoiler (1.2)
mystatus (3.1)
NewPoints (1.8)
OpenID Login (1.0)
PM Spy (1.0)
PostAd(lite) (1.0.0)
ProStats (1.8)
Quick Register (1.0)
reCAPTCHA Plugin (1.1)
Resend Activation Code (3.0)
Reset Poll (1.0)
Restrict Email Domains (1.0.1)
Rules Page (2.0)
Spoiler MyCode (1.0)
Hide Until Thanks (1.0)
Undo Delete (1.2.1)
Welcome Guest (1.5)
Welcome PM/Email (1.1)
De-activate Group Notice plugin.
now i can't deactivate this plugin Sad

error message :
Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Can't DROP 'gn'; check that column/key exists
Query:
ALTER TABLE mybb_usergroups DROP gn
Alright, you probably have accidentally or manually delete that column yourself.

Go to: ./inc/plugins/gn.php and find this line;
	$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP `gn`");
and Comment out like this;
// 	$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP `gn`");

Now de-activate the plugin in ACP > Plugins Manager.
ok solved Big Grin big thanks for you Yaldaram... btw, can i still use Group notice plugin?
Yes, Just do the revers of the above and Install the plugin again. Like this;

Open plugin file and remove // from that line. Then activate the plugin again Smile
okay .. big thanks for you man Big Grin
No problem, I'm glad to help Smile