| Post are gone, consistency won't run [message #165452] |
Sat, 18 June 2011 23:06  |
sallen812
Messages: 6
Registered: September 2006
Location: USA
Karma:
|
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<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' => 'Yes', 'S' => 'be08426dbcc36e5983c2b9c59d208cec', 'SQ' => 'e50767c4396a2c20f40ebf919a7c58fc', )<br /> Database version: 4.1.22-standard<br /> [Referring Page] http://www.vashonforum.com/adm/consist.php?S=be08426dbcc36e5983c2b9c59d208c ec&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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]