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

Home » FUDforum Development » Bug Reports » Issue with consist.php (You have an error in your SQL syntax)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Issue with consist.php [message #166589] Fri, 27 January 2012 01:09 Go to previous message
DaveQB is currently offline  DaveQB   Australia
Messages: 109
Registered: January 2006
Location: Sydney
Karma:
Senior Member

A user reported that trying to reply to a thread failed. I tried and the site presented you with a blank page with no source.

So I ran a consistency check and it stopped here:


Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match


The error logs are saying this:

(.../include/theme/default/db.inc:72
.../public_html/adm/consist.php:72
.../public_html/adm/consist.php:17 7
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mm FROM amod mm LEFT JOIN ausers u ON mm.user_id=u.id LEFT JOIN aforum f ON f.id' at line 1
Query: DELETE amod mm FROM amod mm LEFT JOIN ausers u ON mm.user_id=u.id LEFT JOIN aforum f ON f.id=mm.forum_id WHERE u.id IS NULL OR f.id IS NULL


I found this thread but the patch won't apply to my consist.php
http://fudforum.org/forum/index.php?t=msg&th=119924

I am running FudForum 2.8

I think I need to accelerate that plan to upgrade. But right now, I have the forum disabled as the last it was enabled, forums had no threads in them but thread counts and multiple pages in the forum (1,2,3,4 links etc) were all there.

Any advice appreciated.



[Updated on: Fri, 27 January 2012 01:11]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: When I post...
Next Topic: Disabled forum message saving in GLOBALS.php with \r\n
Goto Forum:
  

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

Current Time: Fri Nov 29 21:21:04 GMT 2024

Total time taken to generate the page: 0.04121 seconds