Results 1 to 9 of 9

Thread: Database Errors

  1. #1
    Junior Member
    Join Date
    Jan 2005
    Posts
    10

    Default Database Errors

    I am receiving the following error message through e-mail.

    Database error in vBulletin 3.0.5:

    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
    , thread.iconid AS threadiconid, iconpath AS threadiconpath
    ,thread.forumid, forum.title AS forumtitle
    , post.pagetext AS preview

    FROM thread as thread
    LEFT JOIN icon USING (iconid)
    LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
    LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
    LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')

    WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(44,24,30,,89,90,24,30,44,27) 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 '89,90,24,30,44,27) AND deletionlog.primaryid IS NULL
    ORDER

    mysql error number: 1064

    Date: Monday 10th of January 2005 05:32:19 AM
    Script: http://www.rdtiburon.com/index.php?n...=viewforum&f=1
    I submitted it to vbulletin.com but they said it is custom code, so they can't help me.

  2. #2
    Super Moderator KW802's Avatar
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,606

    Default Re: Database Errors

    JavaGeek,

    The big question is.... what's generating that URL? I was poking around your site and was trying the different links but didn't see one that matches the link you gave. Is this for a new CMPS module that you're adding or something else?

  3. #3
    Junior Member
    Join Date
    Jan 2005
    Posts
    10

    Default Re: Database Errors

    I can't find anything that is generating it. I was assuming the latest threads module was doing it.

  4. #4
    Super Moderator Zachery's Avatar
    Join Date
    Jan 2004
    Posts
    3,186

    Default Re: Database Errors

    Zachery
    I may or may not do things.

  5. #5
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,460

    Default Re: Database Errors

    Something in the coding you have on that page is messing up the forum permissions.

  6. #6
    Super Moderator KW802's Avatar
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,606

    Default Re: Database Errors

    Quote Originally Posted by Zachery
    I saw that in the DB error log but I didn't see anything on the portal page linking to anything even close to that. Everything on the portal and the forums seemed to be working so that's why I was as to where that particular URL was coming from.

  7. #7

    Default Re: Database Errors

    It would appear Google has indexed that page for some reason (http://www.google.co.uk/search?q=sit...f%3D1%22&hl=en) - It's likely that someone clicked through to that page from Google, or it was the Google spider that caused the error e-mail.

    Thanks,
    Alan.

  8. #8
    Super Moderator KW802's Avatar
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,606

    Default Re: Database Errors

    Quote Originally Posted by Alan @ CIT
    It would appear Google has indexed that page for some reason (http://www.google.co.uk/search?q=sit...f%3D1%22&hl=en) - It's likely that someone clicked through to that page from Google, or it was the Google spider that caused the error e-mail.

    Thanks,
    Alan.
    Nice call! From Google it looks like the site used to be running phpBB and was just recently switched over to VB.

  9. #9
    Junior Member
    Join Date
    Jan 2005
    Posts
    10

    Default Re: Database Errors

    That's probably it. I did some major work on Saturday importing CPGNuke and my old pnPHPBB site into one vBulletin site. I received the error message but couldn't figure out who was clicking on what. Thanks...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database errors
    By Mythotical in forum Troubleshooting / "How do I..." Questions
    Replies: 6
    Last Post: 02-07-2005, 03:10 PM
  2. How Do I.....Database
    By nubian in forum Chit Chat
    Replies: 1
    Last Post: 12-09-2004, 11:35 AM
  3. Array errors and SQL errors
    By Richard-HH in forum Troubleshooting / "How do I..." Questions
    Replies: 4
    Last Post: 11-14-2004, 01:49 PM
  4. Database error
    By Garamond in forum Troubleshooting / "How do I..." Questions
    Replies: 2
    Last Post: 07-21-2004, 05:35 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
  •