masfonos

Pandemix

I will send a report of your problem to our technicians so they can fix your forum.

twitter / flickr

masfonos

Thanks Pandemix.


Not sure if it's just a coincidence or what, but now my portal is also screwy, giving the message:

**********************************
Could not query announcements 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 ') AND t.topic_time <= 1191015468 AND t.topic_poster = u.user_id AND ' at line 23

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM thatonesong_topics AS t, thatonesong_users AS u, thatonesong_posts_text AS pt, thatonesong_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1191015468 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 0,3

Line : 92
File : fetchposts.php
***************************************************

when trying to access the portal (set as main page http://thatonesong.20.forumer.com/)

Sanna1

Can you send a raport of my problem on my portal?

http://lepabrena.14.forumer.com/portal.php

Could not query announcements 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 ') AND t.topic_time <= 1191016208 AND t.topic_poster = u.user_id AND ' at line 23

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM lepabrena_topics AS t, lepabrena_users AS u, lepabrena_posts_text AS pt, lepabrena_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1191016208 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC

Line : 92
File : fetchposts.php

Treborish

Many people are experiencing this bug, so take care in the knowledge that you are not alone.

CARLi2

masfonos

Hmmm. Yep, yours looks broke too, CARL. I did the same thing and just disabled the portal from being the main page so it goes to the forum index.

Looks like either their SQL queries got broke or their DB got broke. Whatever it is hopefully it doesn't require a DB reset/restore.

How often are the forums backed up?

masfonos

Awesome. Thanks, Radhey. I found your post to be helpful and informative. That definitely clears up all questions I had about my forums slow response times and bad SQL queries on the portal page. Go die.

masfonos

Hello? Support staff? Techies? Mods? Admins?


Is anyone home? How can all of these threads be here relating to the SQL debug error and not a single helpful response by any Forumer staff or even an acknowledgment of the problem or indication of what is going on?