Results 1 to 11 of 11

Thread: SQL Error From News Module

  1. #1

    Default SQL Error From News Module

    I'm getting the following error after upgrading from RC2, any ideas?
    Code:
    Invalid SQL:
    
                                   SELECT COUNT(*) AS count
                                   FROM thread
                                   WHERE visible = 1 AND open != 10 AND (threadid IN(8,457);
    
    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 '' at line 3
    Error Number : 1064
    Date         : Tuesday, February 5th 2008 @ 08:53:40 AM
    Script       : http://www.whatababy.org/index.php
    Referrer     :
    IP Address   : 12.193.81.226
    Username     : Administrator
    Classname    : vB_Database_MySQLi

    EDIT: If I have two threads selected from two different forums for my News module, it gives this error. If I remove one or the other, it works fine.
    Last edited by curriertech; 02-05-2008 at 10:03 AM.

  2. #2

    Default Re: vBa CMPS v3.0.0 ("Gold") Released!

    Please, help, I get this error on a index page
    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM vb_thread
    WHERE visible = 1 AND open != 10 AND (threadid IN(783,1099,1162,1211,1451,1512,1578,1717,1936,1938,2048,2349);

    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 '' at line 3
    Error Number : 1064
    Date : Tuesday, February 5th 2008 @ 05:52:21 PM
    Script : http://www.mysite.org/
    Referrer : http://www.mysite.org/forum.php
    IP Address : 87.xx.xx.xx
    Username : Anyone
    Classname : vB_Database
    EDIT: this error shows like the friend above, only if I select manual thread, it works if I select forums.
    I need to select only the specific thread's and not entire forum

    Anyway, thanks for this release, I hope a fix for this will be released soon as possible, thz.
    Last edited by Masiello; 02-05-2008 at 01:30 PM.

  3. #3
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQL Error From News Module

    Thank you both for pointing this out. Looks like there was a small mistake in the code for the new pagination setting in the news module (which was something I snuck in at the last minute before release). I've just applied the fix to the download package here though, so if you will download the files from here again and replace your current modules/news.php file with the updated verison, that should take care of the issue.

  4. #4

    Default Re: SQL Error From News Module

    Thank you Brian, great work

  5. #5

    Default Re: SQL Error From News Module

    Thanks Brian, I'll download the new package and give it a try right now.

  6. #6

    Default Re: SQL Error From News Module

    Perfect! Thanks Brian!

  7. #7
    Join Date
    Oct 2007
    Posts
    11

    Exclamation Re: SQL Error From News Module

    Database error in vBulletin 3.7.0 Beta 4:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM thread
    WHERE visible = 1 AND open != 10 AND (threadid IN(31668,31828,31834,31863,31864,32225,32375,32470,32699,32785) AND dateline > 1198865504;

    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 '' at line 3
    Error Number : 1064
    Date : Tuesday, February 26th 2008 @ 08:11:44 PM
    Script : http://www.xxxxxxx.xxx/index.php
    Referrer : http://www.xxxxxxx.com
    IP Address : xx.xxx.51.171
    Username : mertoxin
    Classname : vb_database
    MySQL Version : 4.1.22-standard
    Brian, I download news.php file and replace my current modules/news.php file with the updated verison one minute ago.

    But nothing changes.

    This error if I select manual thread, it works if I select forums.


    Please Brian, Help me...



    Note: I'm using Vbseo.
    Last edited by mertoxin; 02-26-2008 at 02:22 PM.

  8. #8
    Join Date
    Feb 2008
    Posts
    1

    Default Re: SQL Error From News Module

    Database error in vBulletin 3.7.0 Beta 4:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM thread
    WHERE visible = 1 AND open != 10 AND (threadid IN(31668,31828,31834,31863,31864,32225,32375,32470,32699,32785) AND dateline > 1198865504;

    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 '' at line 3
    Quote Originally Posted by mertoxin View Post
    Brian, I download news.php file and replace my current modules/news.php file with the updated verison one minute ago.

    But nothing changes.

    This error if I select manual thread, it works if I select forums.

    Please Brian, Help me...

    Note: I'm using Vbseo.
    me too
    please help me

  9. #9
    Join Date
    Oct 2007
    Posts
    11

    Default Re: SQL Error From News Module

    Quote Originally Posted by takizbiz View Post
    me too
    please help me
    Me three. I've uploaded the new.php file but i still get the same error.

  10. #10
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQL Error From News Module

    There shouldn't be any way you would get that error if you're using the latest version of the modules/news.php file. If you'd like to submit a support ticket via the Members' Area here though I'll be glad to take a look at things for you.

  11. #11
    Join Date
    Oct 2007
    Posts
    11

    Default Re: SQL Error From News Module

    What do you know.. It working now, haha. I was getting ready to submit a ticket and then decide to test the it again just to see if it still was giving me an error so i don't look like an idiot lol.

    Thanks, brian.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. News Archive/Duplicate News Module Issue
    By Xil Ze in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 09-01-2007, 03:03 PM
  2. Illegal Offset error w/ News Module & vB 3.6.7PL1 + CMPS v2.2.1
    By Torqued in forum Troubleshooting & Problems
    Replies: 10
    Last Post: 06-18-2007, 03:08 PM
  3. Database Error when News Module Active
    By breamy in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 06-13-2007, 11:39 AM
  4. News module deleted for error, how to reimport?
    By Brubaum in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 11-21-2005, 06:08 PM
  5. Numbers (link to pages) of the previous news in news module
    By JWEB in forum "How Do I..." Questions
    Replies: 3
    Last Post: 08-20-2005, 04:54 AM

Posting Permissions

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