Forum Topic: Phpbb2 Problem

(121 views • 11 replies)

This topic is 1 page long.

<< < > >>
None

aviewaskewed

Reply To Post Reply & Quote

Posted at: 6/26/08 01:10 AM

aviewaskewed EVIL LEVEL 44

Sign-Up: 02/04/02

Posts: 14,577

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.

You don't have to pass an IQ test to be in the senate. --Mark Pryor, Senator
The Endless Crew: Comics and general wackiness. Join us or die.
PM me about forum abuse.

BBS Signature

None

Masculine

Reply To Post Reply & Quote

Posted at: 6/26/08 02:04 AM

Masculine EVIL LEVEL 39

Sign-Up: 06/18/02

Posts: 8,391

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 ;

None

aviewaskewed

Reply To Post Reply & Quote

Posted at: 6/26/08 02:14 AM

aviewaskewed EVIL LEVEL 44

Sign-Up: 02/04/02

Posts: 14,577

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?

You don't have to pass an IQ test to be in the senate. --Mark Pryor, Senator
The Endless Crew: Comics and general wackiness. Join us or die.
PM me about forum abuse.

BBS Signature

None

Masculine

Reply To Post Reply & Quote

Posted at: 6/26/08 03:15 AM

Masculine EVIL LEVEL 39

Sign-Up: 06/18/02

Posts: 8,391

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.

Phpbb2 Problem


None

Jon-86

Reply To Post Reply & Quote

Posted at: 6/26/08 03:46 AM

Jon-86 NEUTRAL LEVEL 13

Sign-Up: 01/30/07

Posts: 4,181

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!

PHP Main :: C++ Main :: Java Main :: irc.freenode.net

BBS Signature

None

elbekko

Reply To Post Reply & Quote

Posted at: 6/26/08 04:22 AM

elbekko EVIL LEVEL 16

Sign-Up: 07/23/04

Posts: 6,587

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.

"My software never has bugs. It just develops random features. " - Unknown

[ FluxBB developer | Quickmarks 0.5.1 | Strings & Ints - my blog ]

BBS Signature

None

Masculine

Reply To Post Reply & Quote

Posted at: 6/26/08 05:27 AM

Masculine EVIL LEVEL 39

Sign-Up: 06/18/02

Posts: 8,391

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.


None

Jon-86

Reply To Post Reply & Quote

Posted at: 6/26/08 07:30 AM

Jon-86 NEUTRAL LEVEL 13

Sign-Up: 01/30/07

Posts: 4,181

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)

PHP Main :: C++ Main :: Java Main :: irc.freenode.net

BBS Signature

None

elbekko

Reply To Post Reply & Quote

Posted at: 6/26/08 07:31 AM

elbekko EVIL LEVEL 16

Sign-Up: 07/23/04

Posts: 6,587

You can rebuild the search index.

"My software never has bugs. It just develops random features. " - Unknown

[ FluxBB developer | Quickmarks 0.5.1 | Strings & Ints - my blog ]

BBS Signature

None

Jon-86

Reply To Post Reply & Quote

Posted at: 6/26/08 07:35 AM

Jon-86 NEUTRAL LEVEL 13

Sign-Up: 01/30/07

Posts: 4,181

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.

PHP Main :: C++ Main :: Java Main :: irc.freenode.net

BBS Signature

None

elbekko

Reply To Post Reply & Quote

Posted at: 6/26/08 07:46 AM

elbekko EVIL LEVEL 16

Sign-Up: 07/23/04

Posts: 6,587

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

"My software never has bugs. It just develops random features. " - Unknown

[ FluxBB developer | Quickmarks 0.5.1 | Strings & Ints - my blog ]

BBS Signature

None

Jon-86

Reply To Post Reply & Quote

Posted at: 6/26/08 07:57 AM

Jon-86 NEUTRAL LEVEL 13

Sign-Up: 01/30/07

Posts: 4,181

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.

PHP Main :: C++ Main :: Java Main :: irc.freenode.net

BBS Signature

All times are Eastern Standard Time (GMT -5) | Current Time: 07:38 AM

<< Back

This topic is 1 page long.

<< < > >>
You need a Grounds Gold Account to post on the NG BBS! If you don't have one, click here to sign up now! It's fast, free, and easy — and opens up tons of great NG features!