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

Home » FUDforum » FUDforum Installation Issues » Post are gone, consistency won't run (Post gone no consistency)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Post are gone, consistency won't run [message #165452] Sat, 18 June 2011 19:06 Go to next message
sallen812 is currently offline  sallen812   United States
Messages: 6
Registered: September 2006
Location: USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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<br /> /home/forum/public_html/adm/consist.php:198<br /> ) 1111: Invalid use of group function<br /> 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(*)<br /> _POST: array ( 'conf' =&gt; 'Yes', 'S' =&gt; 'be08426dbcc36e5983c2b9c59d208cec', 'SQ' =&gt; 'e50767c4396a2c20f40ebf919a7c58fc', )<br /> Database version: 4.1.22-standard<br /> [Referring Page] http://www.vashonforum.com/adm/consist.php?S=be08426dbcc36e5983c2b9c59d208c ec&amp;SQ=e50767c4396a2c20f40ebf919a7c58fc<br /> ' 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
Re: Post are gone, consistency won't run [message #165453 is a reply to message #165452] Sun, 19 June 2011 00:49 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
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.
Re: Post are gone, consistency won't run [message #165457 is a reply to message #165453] Sun, 19 June 2011 17:52 Go to previous messageGo to next message
sallen812 is currently offline  sallen812   
Messages: 6
Registered: September 2006
Location: USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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... »
Re: Post are gone, consistency won't run [message #165458 is a reply to message #165457] Sun, 19 June 2011 22:31 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Thu Oct 19 19:36:07 EDT 2017

Total time taken to generate the page: 0.00702 seconds