Page 1 of 1

Constantly Receiving Debug Mode

Posted: Wed Mar 05, 2008 11:40 pm
by corych562
I am constantly receiving this debug mode message on several of my pages (one of which is included below). Another issue is that whenever a user logs on or off, while it records the session start or end, it display a error404 page instead of taking them to the index page. Any and all help is appreciated, thanks.

My tentative domain is http://s236737213.onlinehome.us/PHPbb2

Cory H.

Could not obtain topic information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 11

SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.forum_id = 1 AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND t.topic_type <> 2 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC LIMIT 0,

Line : 327
File : viewforum.php

Re: Constantly Receiving Debug Mode

Posted: Wed Mar 05, 2008 11:44 pm
by Brf
You dont have a value in your posts-per-page in General Admin Config

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:07 am
by htoski
I am having a similar problem:
Could not insert new word

DEBUG MODE

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('posting', 0), ('test', 0), ('trouble', 0)

Line : 234
File : functions_search.php
I've had the forum up for 3 years without any problems and all of a sudden people are starting to get the above message when making a post.

How can I fix this problem?

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:18 am
by Brf
search_wordlist is a big table, so it is more likely to crash:

http://www.phpbb.com/kb/article/fixing- ... rom-mysql/

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:42 am
by htoski
Oh no, that is horrible news.

Would afull installation of the latest version of phpbb help? The only trouble with that is that I will have to re-install all my mods :-(.

I usually just install the files that need to be upgraded.

Are there any other possible suggestions?

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:43 am
by ric323
No, updating phpBB isn't going to help.
Did you try to repair the table as described?

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:44 am
by Brf
That article I linked to tells you how to repair it.

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:49 am
by htoski
Thanks, I'm going to try and repair it using the article you linked to.

Problem is it's been a while since I've had to do any kind of work on the forum so it will take me some time.

Any idea what could have caused the problem? Why did it happen?

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 1:51 am
by Brf
Brf wrote:search_wordlist is a big table, so it is more likely to crash:

Re: Constantly Receiving Debug Mode

Posted: Thu Mar 06, 2008 2:01 am
by htoski
:shock: :oops:

Thanks again.

Re: Constantly Receiving Debug Mode

Posted: Sat Mar 08, 2008 6:38 pm
by jlhaslip
Hi folks,
I was having this same issue with the search_wordlist table and using phpmyadmin I could not repair the table, nor did the 'fix' work.
Apparently, the table was somehow damaged beyond recognition.
Phpmyadmin could not even display the structure, so as a remedy, I 'FLUSHED' the table and it is all good (no errors displayed), but I have no Search Words now.

Will I be able to use a recent back-up to restore the search_wordlist table? Or will I simply have to live without the Search for previously posted information? The Site is not critical, just a small community site... wonder if it is worth the time, really, I don;t think the word_search is done very often.

Re: Constantly Receiving Debug Mode

Posted: Sun Mar 09, 2008 3:13 am
by ric323
Just run this MOD to rebuild your search tables:
http://www.phpbb.com/community/viewtopic.php?t=329629