Moved Topics?

Post by **Stoker** » 30 Nov 2011, 12:13

'How about this:

<div class="forabg">
{$CA_BLOCK_START}
  <div class="inner"><span class="corners-top"><span></span></span>
  <ul class="topiclist">
	 <li class="header">
		<dl class="no_icon">
		   <dt>{TSRAT_NUMBER} {L_RECENT_ACTIVE}</dt>
		   <dd class="topics">{L_REPLIES}</dd>
		   <dd class="posts">{L_VIEWS}</dd>
		   <dd class="lastpost"><span>{L_LAST_POST}</span></dd>
		</dl>
	 </li>
  </ul>
  <ul <!-- IF S_TS_JSSCROLL and not S_TS_TICKER -->id="vertical-ticker"<!-- ELSEIF S_TS_TICKER and not S_TS_JSSCROLL -->id="news" <!-- ENDIF -->class="topiclist forums">
	 <!-- IF S_TS_TICKER and not S_TS_JSSCROLL -->
	 <li class="row">
	 <!-- BEGIN recent_active -->
	 <dl class="icon" style="background-image: url({ROOT_PATH}images/starimg.png); background-repeat: no-repeat;">
		<dt>
		   <a href="{recent_active.U_FIRST_TOPIC}" class="forumtitle">{recent_active.TOPIC_TITLE}</a><br />
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_FIRST_POSTER_COLOUR};" href="{recent_active.USERNAME_FIRST}">{recent_active.TOPIC_FIRST_POSTER_NAME}</a> {L_IN} <a href="{recent_active.FORUM_URL}">{recent_active.FORUM_NAME}</a> {recent_active.TOPIC_TIME}
		</dt>
		<dd class="topics" style="width:8%">{recent_active.TOPIC_REPLIES}</dd>
		<dd class="posts" style="width:8%">{recent_active.TOPIC_VIEWS}</dd>
		<dd class="lastpost"><span>
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_LAST_POSTER_COLOUR};" href="{recent_active.USERNAME_LAST}">{recent_active.TOPIC_LAST_POSTER_NAME}</a> <a href="{recent_active.U_LAST_TOPIC}">{LAST_POST_IMG}</a><br />{recent_active.TOPIC_LAST_POST_TIME}</span>
		</dd>
	 </dl>
	 <!-- END recent_active -->
	 </li>
	 <!-- ELSE -->
	 <!-- BEGIN recent_active -->
	 <li class="row">
	 <dl class="icon" style="background-image: url({ROOT_PATH}images/starimg.png); background-repeat: no-repeat;">
		<dt>
		   <a href="{recent_active.U_FIRST_TOPIC}" class="forumtitle">{recent_active.TOPIC_TITLE}</a><br />
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_FIRST_POSTER_COLOUR};" href="{recent_active.USERNAME_FIRST}">{recent_active.TOPIC_FIRST_POSTER_NAME}</a> {L_IN} <a href="{recent_active.FORUM_URL}">{recent_active.FORUM_NAME}</a> {recent_active.TOPIC_TIME}
		</dt>
		<dd class="topics" style="width:8%">{recent_active.TOPIC_REPLIES}</dd>
		<dd class="posts" style="width:8%">{recent_active.TOPIC_VIEWS}</dd>
		<dd class="lastpost"><span>
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_LAST_POSTER_COLOUR};" href="{recent_active.USERNAME_LAST}">{recent_active.TOPIC_LAST_POSTER_NAME}</a> <a href="{recent_active.U_LAST_TOPIC}">{LAST_POST_IMG}</a><br />{recent_active.TOPIC_LAST_POST_TIME}</span>
		</dd>
	 </dl>
	 </li>
	 <!-- END recent_active -->
	 <!-- ENDIF -->
  </ul>
  <span class="corners-bottom"><span></span></span></div>
{$CA_BLOCK_END}
</div>
<!-- IF S_TS_JSSCROLL and TS_JSSCROLL_NAVIGATION and not S_TS_TICKER -->
<div style="text-align:right; padding-right:10px;"><a href="#" title="{L_PREVIOUS_SCROLL}" id="ticker-previous"><img src="{ROOT_PATH}images/player_rew.png" width="16" height="16" alt="{L_PREVIOUS_SCROLL}" /></a> <a href="#" title="{L_NEXT_SCROLL}" id="ticker-next"><img src="{ROOT_PATH}images/player_fwd.png" width="16" height="16" alt="{L_NEXT_SCROLL}" /></a> <a href="#" title="{L_STOP_SCROLL}" id="stop"><img src="{ROOT_PATH}images/player_pause.png" width="16" height="16" alt="{L_STOP_SCROLL}" /></a> <a href="#" title="{L_START_SCROLL}" id="start"><img src="{ROOT_PATH}images/player_play.png" width="16" height="16" alt="{L_START_SCROLL}" /></a></div>
<!-- ENDIF -->

Post by **Blackwolf** » 30 Nov 2011, 12:31

hahah thanks....go one page back

I WORKED IT OUT TOO!

THANKS A MILLION!

Post by **Blackwolf** » 03 Dec 2011, 06:39

Stoker wrote:I cant reproduce the error. I tried moving some topics here. That went fine.
Even when a topic is moved, the old url to the topic is still working.
So the problem is probably something else than this mod.

You are not using latest version, which you should because I dont support old versions of any of my mods.

Just resurrecting this issue. I forgot that about 10 months ago one of the Moderators accidentally deleted the Wallpaper thread.....could this be an issue...I have enabled last 5 Most viewed topics and 5 Most replied topics so you can see the issue. At the moment I usually have it set to 2....as it looks stupid right now.

Yours shows completely different forums etc.....hope I have explained this ok.......

see there all by mmesantos1 on Mon Jan 24, 2011 11:02 pm

Which is the day it was deleted....

Post by **Stoker** » 03 Dec 2011, 08:13

There is for sure something very wrong with your board. But its not related to this mod.
This mod pulls its info from the topics table. If a topic is deleted it_just_doesnt_exist_no_more in the topics table.

For some reason the topic(s) doesnt get deleted on your board.
It could be caused by some modification of yours or that you have restored a database table with only some of the topic info.

Post by **Blackwolf** » 03 Dec 2011, 09:42

Is there any way I can delete the non existent ones via phpMyAdmin?

Post by **Stoker** » 03 Dec 2011, 09:49

Its probably something like that which got you into trouble in the first place so I wouldnt advice it.
Also I am not sure how to do this in the correct way.

Post by **Blackwolf** » 03 Dec 2011, 09:53

I'll not play around with it. This may have happened when the forum crashed some 12 months back.I helped crash it trying to install sitemap FX Mod....Found this.....last post.....http://www.phpbb.com/community/viewtopi ... p=11792095 I am reluctant to try this as my knowledge is limited.

I'll leave it for now as nothing else is affected.

Post by **Blackwolf** » 21 Mar 2012, 07:29

Before....if ...the board closes...any chance of another look into this ...please.....I am happy to give you phpMyAdmin access

For now I have it set to 2 due to "topic doesn't exist" message if clicked.

viewtopic.php?f=49&t=1581

Possibly related somehow ???

http://www.phpbb.com/community/viewtopi ... &t=2106283

I ran

Code: Select all

SELECT `post_text` FROM phpbb_posts WHERE `topic_id` = 3630;

which is one of the error forums and the result was...

Code: Select all

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0035 sec )

Post by **Blackwolf** » 31 Mar 2012, 05:31

http://www.phpbb.com/community/viewtopi ... &t=2034305

Same senario......

I also ran

Code: Select all

DELETE FROM phpbb_topics WHERE topic_id IN (SELECT topic_id FROM phpbb_posts WHERE post_id IS NULL);

But posts remain.

Post by **Stoker** » 31 Mar 2012, 05:54

I cant help you because I dont know the solution.
The bug you have is NOT related to the Top Stats mod.

Have you tried the phpBB Support Forums?