vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Team: Hot or Not? Ready for Traffic Explosion? vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! vBSEO Helps Forum Earn $100/day from Google AdSense Discover the Power of "Long Tail Search" Crawlability Inc. Files for SEO Technology Patent
se sw

database error help

This is a discussion on database error help within the General Discussion forums, part of the vBulletin SEO Discussion category; I hope this is the right section, but here it goes. I have been getting a few database errors for ...

Go Back   vBulletin SEO Forums > vBulletin SEO Discussion > General Discussion

Enhancing 80 million pages.

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 02-01-2007, 04:45 AM
Senior Member
Big Board Administrator
 
Real Name: Matt
Join Date: May 2006
Posts: 505
database error help

I hope this is the right section, but here it goes.

I have been getting a few database errors for quite some time now, and I'm thinking it may be a hack that i've installed but i've been unable to work out which one or if it is even one.

This is the error

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

                                SELECT usergroupid FROM vb3_icon AS icon
                                INNER JOIN vb3_imagecategorypermission USING (imagecategoryid)
                                WHERE icon.iconid = 10
                                        AND usergroupid IN ();

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 4
Error Number : 1064
Date         : Thursday, February 1st 2007 @ 03:26:51 AM
Script       : Gamerz Needs - For All Your Gaming Needs!
Referrer     : Gamerz Needs - For All Your Gaming Needs! 
and another

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

                                SELECT usergroupid FROM vb3_icon AS icon
                                INNER JOIN vb3_imagecategorypermission USING (imagecategoryid)
                                WHERE icon.iconid = 10
                                        AND usergroupid IN ();

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 4
Error Number : 1064

Date         : Thursday, February 1st 2007 @ 03:29:08 AM

Script       : Gamerz Needs - For All Your Gaming Needs!

Referrer     : Gamerz Needs - For All Your Gaming Needs! 
and another

Code:
atabase error in vBulletin 3.6.4:

Invalid SQL:

                                SELECT usergroupid FROM vb3_icon AS icon
                                INNER JOIN vb3_imagecategorypermission USING (imagecategoryid)
                                WHERE icon.iconid = 12

                                        AND usergroupid IN ();

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 4
Error Number : 1064

Date         : Thursday, February 1st 2007 @ 03:30:08 AM

Script       : Gamerz Needs - For All Your Gaming Needs!

Referrer     : Gamerz Needs - For All Your Gaming Needs! 

hopefully the above will be able to help you track down the error and possible give me a fix to end this database error thats been going on for a while. (I've never had the error, so it makes it hard for me to know what is causing it)

Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 02-01-2007, 05:26 AM
Ace Shattock's Avatar
vBSEO Staff
vBSEO Total Customer SupportCommunity Builder
 
Real Name: Ace Shattock
Join Date: Jul 2005
Location: New Zealand
Posts: 2,785
Looks to be a mod that deals with assigining permissions .. possibly to the default post icons?
__________________
Ace Shattock / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: New Zealand Forum | vBulletin Modifications and Styles | vBulletin Hosting
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads

Thread Thread Starter Forum Replies Last Post
vBulletin Database Error Chewie Bug Reporting 11 01-19-2007 07:44 AM
VBSEO and my Database sinjix_media General Discussion 4 01-04-2007 10:19 AM
Database Errors majordude Off-Topic & Chit Chat 4 09-21-2006 09:28 PM
Database errors and problems with drex Bug Reporting 2 11-02-2005 08:02 PM


All times are GMT -4. The time now is 09:07 PM.


Powered by vBulletin Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc.