Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 20 Feb 2010, 11:24
KevinGupta KevinGupta is offline
 
Join Date: Dec 2006
vBulletin Database Error?

What is this? I mean what should I do about this error? I don't even know why I am getting it?

I received this error in email via my forum:

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1266667805 AND open <> 10, 1, 0)) AS newthread
FROM thread AS thread
WHERE forumid IN( )
AND thread.visible = 1;

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 ')
AND thread.visible = 1' at line 3
Error Number : 1064
Request Date : Saturday, February 20th 2010 @ 06:10:05 AM
Error Date : Saturday, February 20th 2010 @ 06:10:06 AM
Script : http://www."forum".com/forum/articles.php?c=33
Referrer : http://www."forum".com/forum/articles.php?c=33
IP Address : 195.xxx.xx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :


This is the error that I get on the website when I click on the link that I received in email (above):

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: navbar in [path]/includes/functions.php on line 3893

Parse error: syntax error, unexpected T_STRING in /home/public_html/forum/articles.php(40) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: STANDARD_ERROR in [path]/includes/functions.php on line 3893

Parse error: syntax error, unexpected T_STRING in /home/public_html/forum/articles.php(73) : eval()'d code on line 1
Database error
Forum database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www."forum".com home page, then try to open another page.
Click the Back button to try another link.

The www."forum".com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Reply With Quote
  #2  
Old 20 Feb 2010, 11:32
ForumsMods ForumsMods is offline
 
Join Date: Aug 2007
Real name: Adrian Sacchi
It is a problem with a product. Disable the product.
Reply With Quote
  #3  
Old 20 Feb 2010, 14:20
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Hoe it happened? Did you do any modifications to your forum prior to getting that error?
__________________
My mods.
Reply With Quote
  #4  
Old 20 Feb 2010, 21:47
KevinGupta KevinGupta is offline
 
Join Date: Dec 2006
I am not sure... Although, it looks like it is due to a mod for Articles that I installed a while ago (before I upgraded my forum to 4.0.1) So, do you think it could be due to some files left uploaded on the server?

I am sure new mods that I installed are not related to articles and all the other previous mods were fully uninstalled via vB Admin Panel.
Reply With Quote
  #5  
Old 21 Feb 2010, 02:18
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
If this was a one time error, I'd ignore it. Especially if you're on a shared server, since a random timeout could cause it. Don't go changing a whole bunch of stuff because of one random error.
Reply With Quote
  #6  
Old 21 Feb 2010, 09:58
KevinGupta KevinGupta is offline
 
Join Date: Dec 2006
Alright... I don't think I am using this much.. So, not too worried about it.. but thought if there could be something to fix easily without changing much.. I would do it... So, I stop receiving emails about this error...lol
Reply With Quote
  #7  
Old 21 Feb 2010, 10:21
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by KevinGupta View Post
I am not sure... Although, it looks like it is due to a mod for Articles that I installed a while ago (before I upgraded my forum to 4.0.1)
Mods written for vb3 will almost always fail on vb4.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #8  
Old 23 Feb 2010, 09:46
KevinGupta KevinGupta is offline
 
Join Date: Dec 2006
So you are saying it could be due to a mod that I installed recently for vB 4.0.1?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:20.

Layout Options | Width: Wide Color: