Page 1 of 1
I got a strange error message posting.
Posted: Wed Jun 14, 2006 8:07 am
by JMEaT
Code: Select all
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.
Posted: Thu Jun 15, 2006 2:34 am
by Jeff250
Posted: Sun Jun 18, 2006 11:42 pm
by d3jake
Um...
Posted: Mon Jun 19, 2006 8:24 am
by KoolBear
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
really bad today...
Posted: Thu Jun 22, 2006 6:58 pm
by VonVulcan
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
Posted: Thu Jun 22, 2006 7:10 pm
by VonVulcan
ARGGGGGGGGG...
Cant POST!!! General error every time... cant even copy/paste the message to here...
Posted: Thu Jun 22, 2006 7:51 pm
by Xamindar
make your post smaller. Then you will be able to post.
These forums don't allow large posts any more
Posted: Thu Jun 22, 2006 8:22 pm
by Krom
The actual trigger is not the number of words total, but the number of unique words in a post.
Posted: Thu Jun 22, 2006 8:57 pm
by Xamindar
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?
Posted: Fri Jun 23, 2006 12:33 pm
by Jeff250
Do we really need more reasons to encourage contentless and repetitious posts?
Posted: Fri Jun 23, 2006 12:36 pm
by Topher
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?
Posted: Fri Jun 23, 2006 12:42 pm
by Xamindar
Ahah, I see.
Posted: Fri Jun 23, 2006 1:04 pm
by Krom
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.
Posted: Fri Jun 23, 2006 10:41 pm
by VonVulcan
The DBB is feeling MUCH BETTER now!
Thanks RC.
