MyBB Community Forums

Full Version: 2 Questions. one important MySQL Ques.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
First:

How can I activate ALL members accounts that are in the "Awaiting Activation" stage? (have more then 300 awaiting activation)


Second Problem: Serious One

I get this error ALL throughout my forums, members and everyone else does also.

Quote:MySQL error: 1030
Got error 127 from storage engine
Query: DELETE FROM mybb_sessions WHERE uid=0 AND time<='1191022561'

I dont know what it is, or how to fix it.. can someone help?


Thanks
~ Zalaki
1. Not by default, you'll need a plugin
Zalaki Wrote:First:

How can I activate ALL members accounts that are in the "Awaiting Activation" stage? (have more then 300 awaiting activation)

Backup your mybb_users table first (just in case), then run this query in phpmyadmin:

UPDATE `mybb_users` SET `usergroup` = '2' WHERE `usergroup` ='5';

Zalaki Wrote:Second Problem: Serious One

I get this error ALL throughout my forums, members and everyone else does also.

Quote:MySQL error: 1030
Got error 127 from storage engine
Query: DELETE FROM mybb_sessions WHERE uid=0 AND time<='1191022561'

Has this error occurred after installing a plugin recently?


Regards
I don't know about the plugin, I de activated most of them already... I had already had tons of plugins installed, the latest 1 I added was labroccas image rep thing..

all others were from when it was first installed and set up