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

Post are gone, consistency won't run [message #165452]

Sat, 18 June 2011 23:06

sallen812

Messages: 6
Registered: September 2006
Location: USA

Karma: 0

Junior Member

My forum is off-line and the post disappeared, but the number count indicate that they are still there. Consistency won't run; get error:

Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
OK
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
OK
Checking messages against users & threads
OK
Checking threads against forums
OK
Checking message approvals
Done: Checking message approvals
Checking threads against messages

Fatal error: Uncaught exception 'Exception' with message '(/home/forum/FUDforum/include/theme/default/db.inc:80 /home/forum/public_html/adm/consist.php:198 ) 1111: Invalid use of group function Query: 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 count(*) _POST: array ( 'conf' => 'Yes', 'S' => 'be08426dbcc36e5983c2b9c59d208cec', 'SQ' => 'e50767c4396a2c20f40ebf919a7c58fc', ) Database version: 4.1.22-standard [Referring Page] http://www.vashonforum.com/adm/consist.php?S=be08426dbcc36e5983c2b9c59d208c ec&SQ=e50767c4396a2c20f40ebf919a7c58fc ' in /home/forum/FUDforum/include/core.inc:215 Stack trace: #0 /home/forum/FUDforum/include/theme/default/db.inc(80): fud_sql_error_handler() #1 /home/forum/public_html/adm/consist.php(198): uq('SELECT m.thread...', 'Invalid use of ...', 1111, '4.1.22-standard') #2 {main} thrown in /home/forum/FUDforum/include/core.inc on line 215

Report message to a moderator

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

Sun, 19 June 2011 04:49

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Is this now after you've moved your forum to a new host?
Are you using a MySQL database? What version?
What is your FUDforum version?

BTW: You posts are probably still there, they just don't show.

Report message to a moderator

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

Sun, 19 June 2011 21:52

sallen812

Messages: 6
Registered: September 2006
Location: USA

Karma: 0

Junior Member

Upgraded to version 3.0.2 about 3 months ago no problem. I just ent in a deleted some post and this happened
FUDforum: 3.0.2
PHP: 5.2.6
Database: mysql 4.1.22-standard (mysql)
Operating system: Linux 2.6.18-8.1.15.el5
More... »

Report message to a moderator

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: 28

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

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: Sat Nov 30 20:24:02 GMT 2024

Total time taken to generate the page: 0.02458 seconds