Newgrounds.com — Everything, By Everyone.

so every time someone makes a new post on my board I get this error:

Could not insert new word

DEBUG MODE

SQL Error : 145 Table './Endless/phpbb_search_wordlist' is marked as crashed and should be repaired

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('dbnsdhaskdfhkasdf', 0), ('fuck', 0)

Line : 234
File : functions_search.php

I've gone into the database and tried the repair button two or three times and it's failed to fix it. Is there anything I can do short of trying to do a database backup and lose whatever newer posts I've gotten since the last backup?

Thanks for any and all help guys.

Honestly you don't need the wordlist but I suggest you just drop the "phpbb_search_wordlist" table and run the SQL again.

CREATE TABLE `phpbb_search_wordlist` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_text` varchar(255) collate utf8_bin NOT NULL default '',
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  `word_count` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_id`),
  UNIQUE KEY `wrd_txt` (`word_text`),
  KEY `wrd_cnt` (`word_count`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=880 ;

At 6/26/08 02:04 AM, Masculine wrote: Honestly you don't need the wordlist but I suggest you just drop the "phpbb_search_wordlist" table and run the SQL again.

So I'd hit "drop table" then I'd hit "create table" and insert the code you posted up?

At 6/26/08 02:14 AM, aviewaskewed wrote: So I'd hit "drop table" then I'd hit "create table" and insert the code you posted up?

1. Drop the table.
2. Click the SQL tab.
3. Paste SQL and click Go.

At 6/26/08 02:04 AM, Masculine wrote: Honestly you don't need the wordlist

Yeah nice advice. Now the search function wont be able to index new posts!

Their should be info on how to repair your tables if you search along thoes lines. Otherwise post on the phpBB community forum. Where their is better support. But dont drop your word lists table. That would be a daft idea unless you have wrote your own search engine!

How about you just do a repair instead of dropping the table and all its data? There's a perfectly fine option in phpMyAdmin to do that.

At 6/26/08 03:46 AM, Jon-86 wrote: Yeah nice advice. Now the search function wont be able to index new posts!

You obviously know nothing about phpBB indexing.

It can index the words for you over again no problem.

No the way the search function work is when a new post is made (if it contains a new word that is unique and isnt a common word) this is added to the words list and given an ID number, this word ID is also linked to the post ID. Then when you search for a word it retrieves the word ID and looks up the word match table to see what post IDs contain the word ID and returns the posts or threads as required.

Dropping the word list table would stop you from searching in the first place and then from indexing new content (adding new unique words to the list)

You can rebuild the search index.

First ive heard of it. And how would you do that if you dont have a wordlist table to rebuild it with? Also it would take quite a while, no? From what ive seen the word tabe and the matched words table are the biggest ones you get if you have an average forum!

So again dropping the table is a stupid idea.

Yes, it'll take a while.
And yes, dropping the tables is stupid.

Cheers for the info. I will look up that and see how it works. Just to see if it is similar to something I wrote for a search engine project I was working on a while back.