I got a strange error message posting.

JMEaT · Post by **JMEaT** » Wed Jun 14, 2006 8:07 am

General Error 
  
Could not insert new word matches

DEBUG MODE

SQL Error : The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 169256, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('forward', 'playing', 'mgs4', 'ps3', 'heard', 'cost')

Line : 251
File : functions_search.php

I was posting in this thread: viewtopic.php?t=10457

Posts take awhile to take effect as well as loading pages.

Jeff250 · Post by **Jeff250** » Thu Jun 15, 2006 2:34 am

This periodically goes around.

d3jake · Post by **d3jake** » Sun Jun 18, 2006 11:42 pm

Um...

KoolBear · Post by **KoolBear** » Mon Jun 19, 2006 8:24 am

Richard and I have been working on the backend to convert the DB from mssql back to mysql.

I beleive most of these issues will be corrected once the transfer is done.

No current date on the transfer is set yet as I have a considerable amount of work upgrading files. And RC has some work to do but this is in process.

KB

VonVulcan · Post by **VonVulcan** » Thu Jun 22, 2006 6:58 pm

General Error

Could not insert new word matches

DEBUG MODE

SQL Error : The statement has been terminated.

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 170082, word_id, 1 FROM phpbb_search_wordlist WHERE word_text IN ('give', 'goosebumps')

Line : 251
File : functions_search.php

VonVulcan · Post by **VonVulcan** » Thu Jun 22, 2006 7:10 pm

ARGGGGGGGGG...

Cant POST!!! General error every time... cant even copy/paste the message to here...

Xamindar · Post by **Xamindar** » Thu Jun 22, 2006 7:51 pm

make your post smaller. Then you will be able to post.

These forums don't allow large posts any more

Krom · Post by **Krom** » Thu Jun 22, 2006 8:22 pm

The actual trigger is not the number of words total, but the number of unique words in a post.

Xamindar · Post by **Xamindar** » Thu Jun 22, 2006 8:57 pm

Krom wrote:The actual trigger is not the number of words total, but the number of unique words in a post.

Really? That's interesting. Why does it do that?

Jeff250 · Post by **Jeff250** » Fri Jun 23, 2006 12:33 pm

Do we really need more reasons to encourage contentless and repetitious posts?

Topher · Post by **Topher** » Fri Jun 23, 2006 12:36 pm

Xamindar wrote:
Krom wrote:The actual trigger is not the number of words total, but the number of unique words in a post.
Really? That's interesting. Why does it do that?

Because that's how an optimized search table works. Why store duplicate keywords for a post?

Xamindar · Post by **Xamindar** » Fri Jun 23, 2006 12:42 pm

Ahah, I see.

Krom · Post by **Krom** » Fri Jun 23, 2006 1:04 pm

Yup, so you can write a post that has \"All work and no play makes Jack a dull boy\" written over and over again but the search table will only have one copy of it when you post.

VonVulcan · Post by **VonVulcan** » Fri Jun 23, 2006 10:41 pm

The DBB is feeling MUCH BETTER now!

Thanks RC.

I got a strange error message posting.

I got a strange error message posting.

really bad today...