FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » All forum show no thread , but message are there - 2.6
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: All forum show no thread , but message are there - 2.6 [message #30684 is a reply to message #30681] Wed, 08 March 2006 17:25 Go to previous messageGo to previous message
idofud is currently offline  idofud   France
Messages: 7
Registered: March 2006
Karma:
Junior Member
After going with mysql log query, making a dump of production database on my dev box, i try with my old dev environnement to post a thread and then with the new database created from the dump

i track the query which fail to report thread :
SELECT
		m.attach_cnt, m.poll_id, m.subject, m.icon, m.post_stamp,
		u.alias, u.id,
		u2.id, u2.alias,
		m2.id, m2.post_stamp,
		f.id, f.name,
		t.id, t.moved_to, t.root_msg_id, t.replies, t.rating, t.thread_opt, t.views,
		r.last_view
		FROM phpgw_fud_thread_view tv
			INNER JOIN phpgw_fud_thread	t	ON tv.thread_id=t.id
			INNER JOIN phpgw_fud_msg	m	ON t.root_msg_id=m.id
			INNER JOIN phpgw_fud_msg	m2	ON m2.id=t.last_post_id
			LEFT JOIN phpgw_fud_users	u	ON u.id=m.poster_id
			LEFT JOIN phpgw_fud_users	u2	ON u2.id=m2.poster_id
			LEFT JOIN phpgw_fud_forum	f	ON f.id=t.moved_to
			LEFT JOIN phpgw_fud_read 	r	ON t.id=r.thread_id AND r.user_id=2
			WHERE tv.forum_id=2 AND tv.page=1 ORDER BY tv.pos ASC


ok so far so good.
so something went wrong with the db, the hoster happened to say there had a migration and i found a mysql lost connection in my php error log,
but i must datetime doesn't match for any action with the accesslog...

anyway
i'm trying to figure out how i could update the db to repare the harm...

after testing query, join by join, i finally arrive to the AND tv.page=1 which cause no row return since all row in thread_view have page=3

how is used the page parameter?
what is expected, the query to ask for tv.page=3 or the row may contains page=1

thanks in advance.

[Updated on: Wed, 08 March 2006 17:32]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: all PMs lost
Next Topic: LOCK TABLES
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 07:01:06 GMT 2024

Total time taken to generate the page: 0.05784 seconds