Phpbb_topics


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 |

Profile PM  
Subject: Re: Phpbb_topics
is this an Icy o PhpBB issue please??

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"

Profile PM  
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

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?


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.1793s (PHP: 10% SQL: 90%)
SQL queries: 15 - Debug Off - GZIP Enabled