MyBB Community Forums

Full Version: Problem with Bad Words manager
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Everytime I click on it It shows up as a blank page that says "35"...How do I fix this...I tried re-loading the badwords.php...But that didn't do anything, How do I fix this x.x?

Here's a Screenshot: Click Here
How many badwords do you currently have?

You can try to empty the entire table and add your bad words again.

truncate mybb_badwords;

I think that's it.

Also you should double check the tables are even there.
Where is the truncate mybb_badwords; ?
And I only have a few...
Are you on Freehostia? They have a dodgey filter of their own, which causes pages containing those bad words to not show up (and display the number "35").

You edit the badwords table through phpMyAdmin.
Yes it is freehostia x.x...Where's phpMyAdmin? o_O

Now I'm getting
"MySQL error: 1146
Table 'faumor35_bo.mybb_datacache' doesn't exist
Query: SELECT title,cache FROM mybb_datacache"

How do I fix this...Please give me details...
You weren't meant to drop (delete) any tables, and you shouldn't have even touched the datacache table...

You can try reconstruct it by running the following query:
CREATE TABLE mybb_datacache (
  title varchar(50) NOT NULL default '',
  cache mediumtext NOT NULL,
  PRIMARY KEY(title)
) TYPE=MyISAM
After that, go to your AdminCP and go to Maintanence and rebuild all the caches.
Note that some things will be lost, ie the most users ever online.
Plus, all your plugins will probably be screwed...
Didn't touch the datacache...Idk how to run queries...


Edit:

Ok I created it, And made me create 2 others, And now I get this.

MySQL error: 1054
Unknown column 'sid' in 'where clause'
Query: SELECT * FROM mybb_sessions WHERE sid='0' AND ip='69.14.97.108' LIMIT 1