FUDforum: Bug Reports » Issue with consist.php

Home » FUDforum Development » Bug Reports » Issue with consist.php (You have an error in your SQL syntax)

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

Issue with consist.php [message #166589]

Fri, 27 January 2012 01:09

DaveQB

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]

		Issue with consist.php By: DaveQB on Fri, 27 January 2012 01:09
		Re: Issue with consist.php By: naudefj on Fri, 27 January 2012 02:21
		Re: Issue with consist.php By: DaveQB on Fri, 27 January 2012 07:16
		Re: Issue with consist.php By: DaveQB on Fri, 27 January 2012 07:30
		Re: Issue with consist.php By: DaveQB on Fri, 27 January 2012 08:29
		Re: Issue with consist.php By: DaveQB on Fri, 27 January 2012 08:50
		Re: Issue with consist.php By: DaveQB on Fri, 27 January 2012 08:51
		Re: Issue with consist.php By: DaveQB on Sat, 28 January 2012 02:14
		Re: Issue with consist.php By: DaveQB on Sat, 28 January 2012 02:18
		Re: Issue with consist.php By: DaveQB on Sat, 28 January 2012 02:20
		Re: Issue with consist.php By: DaveQB on Sat, 28 January 2012 02:32
		Re: Issue with consist.php By: DaveQB on Sat, 28 January 2012 02:33
		Re: Issue with consist.php By: DaveQB on Sat, 28 January 2012 03:14

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) ] [

]

Current Time: Mon Jul 01 05:46:10 GMT 2024

Total time taken to generate the page: 0.04223 seconds