Phpbb_topics »  Show posts from    to     

Icy Phoenix


Old Support Topics - Phpbb_topics



LakersLand [ Mon 29 Nov, 2010 15:51 ]
Post subject: Phpbb_topics
Hi guyz,
this morning an error occurred on my web site.
The assistance emailed me saying that there had been some issues with phpbb_topics
they told me that have been issued too many queries that created troubles on Mysql database.
So whats going on?
how can i fix it?

thanks in advance

i report the error below


Quote:
SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, u.user_active, u.user_color, f.forum_name
FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_users AS u, phpbb_forums AS f
WHERE t.forum_id NOT IN (2,20,28)
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
AND f.forum_id = t.forum_id

ORDER BY p.post_time DESC
LIMIT 10 |


spydie [ Mon 29 Nov, 2010 18:33 ]
Post subject: Re: Phpbb_topics
is this an Icy o PhpBB issue please??


LakersLand [ Mon 29 Nov, 2010 20:48 ]
Post subject: Re: Phpbb_topics
its phpbb_topics inside my mysql panel...
i think it is phpbb because the table is named phpbb_topics

and to be more clear, my website s running "Icy Phoenix 1.3.0.53a"


spydie [ Mon 29 Nov, 2010 21:27 ]
Post subject: Re: Phpbb_topics
hm first thing.

maybe you go to ACP-Database Management-Database management

and optimize your database.

afterwards, you might sync the users and topics and forums


Mighty Gorgon [ Sun 05 Dec, 2010 12:39 ]
Post subject: Re: Phpbb_topics
It is really strange that the SQL you posted is creating issues, are you using some blocks to display latest posts?




Powered by Icy Phoenix