Welcome to the New Zealand Messageboards


Your forum for New Zealand topics and talk.


  •  » Want to know more about NZ?
  •  » From NZ and want to meet new people?
  •  » Have a photo to share?
  •  » Something on your mind?

...then you have come to the right place!


NZB is here for all these things.


YES! I want to register an account for free right now!


P.S: When you Register, this box vanishes!

Welcome to the New Zealand Messageboards


Your forum for New Zealand topics and talk.


  •  » Want to know more about NZ?
  •  » From NZ and want to meet new people?
  •  » Have a photo to share?
  •  » Something on your mind?

...then you have come to the right place!


NZB is here for all these things.


YES! I want to register an account for free right now!


P.S: When you Register, this box vanishes!

Results 1 to 6 of 6

Topic: Database error on portal page.

              
   
  1. #1
    Darkling
    has no status.
    Founder
    Awards:
    Community Award
    Darkling's Avatar
    Join Date
    May 2004
    Replies
    985
    Liked
    0 times
    Points
    10,450
    Level
    67
    Points: 10,450, Level: 67
    Level completed: 50%, Points required for next Level: 400
    Overall activity: 54.5%
    Blog Entries
    1

    Default 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

  2. #2
    kall
    is tired.
    Community Manager


    kall's Avatar
    Join Date
    Jan 2004
    Location
    Auckland, New Zealan
    Age
    33
    Replies
    5,566
    Liked
    4 times
    Points
    206,456
    Level
    100
    Points: 206,456, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 100.0%
    Blog Entries
    20

    Default

    Just noticed that...WTF?

  3. #3
    Darkling
    has no status.
    Founder
    Awards:
    Community Award
    Darkling's Avatar
    Join Date
    May 2004
    Replies
    985
    Liked
    0 times
    Points
    10,450
    Level
    67
    Points: 10,450, Level: 67
    Level completed: 50%, Points required for next Level: 400
    Overall activity: 54.5%
    Blog Entries
    1

    Default

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



  4. #4
    kall
    is tired.
    Community Manager


    kall's Avatar
    Join Date
    Jan 2004
    Location
    Auckland, New Zealan
    Age
    33
    Replies
    5,566
    Liked
    4 times
    Points
    206,456
    Level
    100
    Points: 206,456, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 100.0%
    Blog Entries
    20

    Default

    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*

  5. #5
    Darkling
    has no status.
    Founder
    Awards:
    Community Award
    Darkling's Avatar
    Join Date
    May 2004
    Replies
    985
    Liked
    0 times
    Points
    10,450
    Level
    67
    Points: 10,450, Level: 67
    Level completed: 50%, Points required for next Level: 400
    Overall activity: 54.5%
    Blog Entries
    1

    Default

    Quote 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.

  6. #6
    kall
    is tired.
    Community Manager


    kall's Avatar
    Join Date
    Jan 2004
    Location
    Auckland, New Zealan
    Age
    33
    Replies
    5,566
    Liked
    4 times
    Points
    206,456
    Level
    100
    Points: 206,456, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 100.0%
    Blog Entries
    20

    Default

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

Similar Topics

  1. New Style/Portal Returns!
    By kall in forum NZB Site News
    Replies: 1
    Latest Reply: 12-Jul-2005, 03:58 AM
  2. A page from my J
    By Mutant in forum The Lounge
    Replies: 3
    Latest Reply: 14-Jan-2005, 02:07 AM
  3. Page 23
    By kall in forum The Lounge
    Replies: 14
    Latest Reply: 16-May-2004, 01:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Content Relevant URLs by vBSEO