vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
New vBSEO Discount Level for Network Builders Meet vBSEO Team in New York (Nov. 3rd & 4th) vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

Database Errors

This is a discussion on Database Errors within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Database error in vBulletin 3.5.0: Invalid SQL: SELECT * FROM forum WHERE forumid =; MySQL Error : You have an ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Troubleshooting

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read
  #1  
Old 10-31-2005, 09:28 AM
Michael's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael Benson
Join Date: Sep 2005
Location: United Kingdom
Posts: 778
Send a message via AIM to Michael Send a message via MSN to Michael
Database Errors

Quote:
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM forum WHERE forumid =;

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 1
Error Number : 1064
Date : Sunday, October 30th 2005 @ 11:23:11 PM
Script : http://www.staff-lounge.com/forumdisplay.php?f=&page=1
Referrer :
IP Address : **.*.***.***
Username : Unregistered
Classname : vb_database
I am persistantly receiving errors identical to this to my email account email. Although i havent yet experienced an error like this before, and i would assume i am visiting more of the sites pages than unregistered user. Moreso these errors always appear to be delivered in batches of around 3-10 ... which leads me to think this could be something server related, being unable to handle the queries.

I have found one of the errors which appeared to be vBSEO related. After registration, you are presented with a welcome page which asks you to edit your Profile .... visit the Forums etc ... well the link to visit the forums was not http://www.staff-lounge.com/ but instead http://www.staff-lounge.com/www.staff-lounge.com this error message has only began appearing after i upgraded to 2.1.1
__________________
The Staff Lounge - Your vBulletin Resource.
vBulletin, InvisionFree, IPB, phpBB and Forum Resources.

vBSEO: The SEO Solution for Expert vBulletin Forum Admins
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 10-31-2005, 01:54 PM
acers's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Ajay
Join Date: Jul 2005
Location: India
Posts: 477
Send a message via MSN to acers
Re: Database Errors

ahh yes same prob here.. pointed the above one to michael too on his site
although i may add that thats only url that i have found that gives a db error.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 10-31-2005, 04:19 PM
Michael's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael Benson
Join Date: Sep 2005
Location: United Kingdom
Posts: 778
Send a message via AIM to Michael Send a message via MSN to Michael
Re: Database Errors

Same here, it is freaky.
Thanks for pointing this out, i would have never have known otherwise!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 10-31-2005, 04:47 PM
Joe Ward's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Joseph Ward
Join Date: Jun 2005
Location: Puerto Rico
Posts: 19,320
Blog Entries: 7
Re: Database Errors

@Michael:

The forum ID is missing in that URL. How do you navigate to that URL?
__________________
Joe Ward / 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 10-31-2005, 06:02 PM
Michael's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael Benson
Join Date: Sep 2005
Location: United Kingdom
Posts: 778
Send a message via AIM to Michael Send a message via MSN to Michael
Re: Database Errors

Thats exactly what i would like to know?
I dont have any URLs pointed to this direction.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 10-31-2005, 10:02 PM
Joe Ward's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Joseph Ward
Join Date: Jun 2005
Location: Puerto Rico
Posts: 19,320
Blog Entries: 7
Re: Database Errors

We'll look into it.
__________________
Joe Ward / 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #7  
Old 11-01-2005, 01:18 PM
Michael's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael Benson
Join Date: Sep 2005
Location: United Kingdom
Posts: 778
Send a message via AIM to Michael Send a message via MSN to Michael
Re: Database Errors

Thanks, i have followed your instructions as specified within in the PM.
And it appears users are commonly trying to follow the ./forumdisplay.php?do=markread URL
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #8  
Old 11-01-2005, 02:56 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,449
Blog Entries: 1
Re: Database Errors

Hi Michael,

do you have any modifications applied to forumdisplay.php file? (as the standard markread link leads to db error in your case)
__________________
Oleg Ignatiuk / 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #9  
Old 11-01-2005, 03:30 PM
Michael's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael Benson
Join Date: Sep 2005
Location: United Kingdom
Posts: 778
Send a message via AIM to Michael Send a message via MSN to Michael
Re: Database Errors

I havent made hard coded modifications to the forumdisplay.php file.
Should i perhaps re-upload the vBulletin 3.5.X default just to be sure?

I was checking my "last modified" timeline for my files, and it would appear that a modification has been applied to the .forumdisplay.php file on the 23/10/2005. I began, though, receiving error messages on the day i upgraded to vB SEO 2.1.1
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #10  
Old 11-01-2005, 03:39 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,449
Blog Entries: 1
Re: Database Errors

Yes, I suggest you to revert to original file once its lastmod time changed. You can also disable vBSEO and open markread link to check if that happens anyway.
__________________
Oleg Ignatiuk / 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #11  
Old 11-01-2005, 04:13 PM
Michael's Avatar
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael Benson
Join Date: Sep 2005
Location: United Kingdom
Posts: 778
Send a message via AIM to Michael Send a message via MSN to Michael
Re: Database Errors

I have overwriten the modified file with the newly downloaded vBulletin edition from my Members Area, and i must admit that the ./forumdisplay.php?do=markread URL is now functioning fine. I took the liberty of checking my modified file, and the fresh file and discovered that infact i had installed a modification, it was called: Filter Threads by Post Icon
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #12  
Old 11-03-2005, 05:39 PM
Juan Muriente's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Juan Carlos Muriente
Join Date: Jun 2005
Location: Puerto Rico
Posts: 12,699
Blog Entries: 2
Re: Database Errors

Great! I'm glad this one got sorted out
__________________
Juan Muriente / 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

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


Similar Threads

Thread Thread Starter Forum Replies Last Post
DataBase Errors in random threads - Showthread is the problem - How to resolve? system0 Troubleshooting 11 05-01-2006 10:00 PM
Periodic PHP Errors ePressive Troubleshooting 5 01-01-2006 03:08 PM
Database errors and problems with drex Bug Reporting 2 11-02-2005 09:02 PM
lotsa database errors on vbseo acers General Discussion 1 08-11-2005 11:40 PM


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


Powered by vBulletin Version 3.8.0 Beta 3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.