Topic: Database error on portal page.

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: 
  		SELECT 
  		
  		thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  		L
			L
			L
			L
			FROM thread as thread
			L
			L
			L
			LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			L
			WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(6,13,31,54,53,30,20,11,26,24)  AND deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC 
			LIMIT 10
	
mysql error: 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 'L
			L
			L
			FROM thread as thread
			L
			L
			L
			LEFT JOI

mysql error number: 1064

Date: Sunday 28th of November 2004 08:41:25 AM
Script: http://nzboards.com/
Referer:

me/ woders what's in forums 6,13,31,54,53,30,20,11,26, and 24

Just noticed that...WTF?

And the witchita lineman......is still on the lah-lah-lah-lah-lah-lah-lah-lah-lalalala-LEFT JOIN!

I don't know enough about php/mySQL to know why it is saying L L L L L ... and vBs search engine doesn't like searching for 'L L L L L'.

Stupid bloody thing!

*deactivates latest threads box till he can work out what is up*

Originally Posted by kall

I don't know enough about php/mySQL to know why it is saying L L L L L ... and vBs search engine doesn't like searching for 'L L L L L'.

Stupid bloody thing!

*deactivates latest threads box till he can work out what is up*

The search function separates the search string at spaces so it regards each 'L' as a separate 1 character word.

I take it that the minimum search word length is set higher than 1 character.

Well, probably...and the buggers don't have the full-text turned on over at vbadvanced.com.