SQL Error From News Module

[curriertech]

I'm getting the following error after upgrading from RC2, any ideas?
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.

[Masiello]

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.

[Our Sponsors]

[Brian]

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.

[Masiello]

Thank you Brian, great work :)

[Our Sponsors]

[curriertech]

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

[curriertech]

Perfect! Thanks Brian! :)

[mertoxin]

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.

[takizbiz]

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

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

[holyrhapsody]

me too
please help me

Me three. I've uploaded the new.php file but i still get the same error.

[Brian]

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.

[holyrhapsody]

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.