Post subject: Error messages in SNES Tin Star topic
Skilled player (1827)
Joined: 4/20/2005
Posts: 2161
Location: Norrköping, Sweden
When I enter the Tin Star topic in the SNES section I get these error messages at the top of the screen:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/tasvideos/nvsite/forum/db/mysql4.php on line 118

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/page_header.php on line 483

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/page_header.php on line 485

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/page_header.php on line 486

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/template.php on line 131
... and this general error at the bottom of the screen:
Could not obtain post/user information.

DEBUG MODE

SQL Error : 1194 Table 'pt' is marked as crashed and should be repaired

SELECT u.username, u.user_id, u.user_posts, u.user_from ,u.user_website, u.user_email, u.user_icq, u.user_aim ,u.user_skype ,u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail ,u.user_rank, u.user_sig, u.user_sig_bbcode_uid ,u.user_avatar, u.user_mood_avatar, u.user_avatar_type ,u.user_allowavatar, u.user_allowsmile, p.* ,pt.post_text, pt.post_subject, pt.bbcode_uid FROM posts p, users u, posts_text pt WHERE p.topic_id = 7642 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 20

Line : 453
File : viewtopic.php

Backtrace:
  includes/functions.php[741]: ErrorPrintBacktrace()
  viewtopic.php[453]: message_die(202, string(39) "Could not obtain post/user information."
, string(0) ""
, 453, {string(42)}, {string(595)})
I don't get any errors in any other thread, so it's something related to that thread only. Just thought I should report it.
Player (88)
Joined: 1/15/2006
Posts: 333
Location: Bangkok, Thailand
A similar error occurs when attempting to do a forum search:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/tasvideos/nvsite/forum/db/mysql4.php on line 118

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/page_header.php on line 483

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/page_header.php on line 485

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/page_header.php on line 486

Warning: Cannot modify header information - headers already sent by (output started at /home/tasvideos/nvsite/forum/db/mysql4.php:118) in /home/tasvideos/nvsite/forum/includes/template.php on line 131
Could not obtain matched posts list

DEBUG MODE

SQL Error : 1194 Table 'posts_text' is marked as crashed and should be repaired

SELECT post_id FROM posts_text WHERE match(post_text)against('zzazz' in boolean mode) OR match(post_subject)against('zzazz' in boolean mode)

Line : 312
File : search.php

Backtrace:
  includes/functions.php[741]: ErrorPrintBacktrace()
  search.php[312]: message_die(202, string(35) "Could not obtain matched posts list"
, string(0) ""
, 312, string(39) "/home/tasvideos/nvsite/forum/search.php"
, {string(141)})
Most likely related.
print reduce(lambda x,p:p/2*x/p+2*10**1000,range(6643,1,-2))
Editor, Active player (297)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Running MySQL repairer. Should be fixed in a moment. Thanks for reporting.