Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 10 Years, 2 Months, 1 Week ago When update usergroup setting...
#1
Solved: 10 Years, 2 Months, 1 Week ago
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
#2
Solved: 10 Years, 2 Months, 1 Week ago
Did you upgraded your forum from MyBB 1.4.x ?
What plugins you've installed ?
#3
Solved: 10 Years, 2 Months, 1 Week ago
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)
#4
Solved: 10 Years, 2 Months, 1 Week ago
De-activate Group Notice plugin.
#5
Solved: 10 Years, 2 Months, 1 Week ago
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
#6
Solved: 10 Years, 2 Months, 1 Week ago
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.
#7
Solved: 10 Years, 2 Months, 1 Week ago
ok solved Big Grin big thanks for you Yaldaram... btw, can i still use Group notice plugin?
#8
Solved: 10 Years, 2 Months, 1 Week ago
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
#9
Solved: 10 Years, 2 Months, 1 Week ago
okay .. big thanks for you man Big Grin
#10
Solved: 10 Years, 2 Months, 1 Week ago
No problem, I'm glad to help Smile


Forum Jump:


Users browsing this thread: 1 Guest(s)