FUDforum: FUDforum Installation Issues » Post are gone, consistency won't run

Home » FUDforum » FUDforum Installation Issues » Post are gone, consistency won't run (Post gone no consistency)

Show: Today's Messages :: Polls :: Message Navigator

Re: Post are gone, consistency won't run [message #165458 is a reply to message #165457]

Mon, 20 June 2011 02:31

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

It happens because your MySQL version is so old (4.1 dates back to 2004). Would it be possible to upgrade your database to MySQL 5.1 or higher?

Alternatively, mail me an admin user & password to check it out. You probably need to change the query to:

SELECT m.thread_id, t.id, count(*) as cnt FROM fud26_thread t LEFT JOIN fud26_msg m ON t.id=m.thread_id WHERE m.apr=1 GROUP BY m.thread_id, t.id ORDER BY cnt

Report message to a moderator

[Message index]

		Post are gone, consistency won't run By: sallen812 on Sat, 18 June 2011 23:06
		Re: Post are gone, consistency won't run By: naudefj on Sun, 19 June 2011 04:49
		Re: Post are gone, consistency won't run By: sallen812 on Sun, 19 June 2011 21:52
		Re: Post are gone, consistency won't run By: naudefj on Mon, 20 June 2011 02:31

Previous Topic:	can´t install: Warning: gzuncompress()
Next Topic:	Anonymous user's id must be 1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 04:26:29 GMT 2024

Total time taken to generate the page: 0.03912 seconds