Please help - dB errors after installation

I've just install vBSEO and have arrived home from work to find a lot of dB error emails waiting for me. Any ideas what is going on and how I can fix this?

I've got lots of these:

Invalid SQL:

UPDATE session
SET lastactivity = 1132337336, location = '', inforum = 219, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '';

MySQL Error :
Error Number :
Date : Friday, November 18th 2005 @ 06:08:56 PM
Script : http://www.littlewales.com/forumdisp...p?f=219&page=1
Referrer :
IP Address : 81.179.79.127
Username : Trancetopia
Classname : vb_database

also

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

UPDATE session
SET lastactivity = 1132337165, location = '', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '';

MySQL Error :
Error Number :
Date : Friday, November 18th 2005 @ 06:06:05 PM
Script : http://www.littlewales.com/member.ph...n=getinfo&u=27
Referrer : http://www.littlewales.com/calendar.php
IP Address : 81.179.79.127
Username : Trancetopia
Classname : vb_database

and

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

UPDATE session
SET lastactivity = 1132336939, badlocation = 0
WHERE sessionhash = '';

MySQL Error :
Error Number :
Date : Friday, November 18th 2005 @ 06:02:19 PM
Script : http://www.littlewales.com/image.php...ine=1132336939
Referrer : http://www.littlewales.com/index.php...tats&gameid=30
IP Address : 81.179.79.127
Username : Trancetopia
Classname : vb_database

These are just some examples.

Any ideas?

Ok, i'm getting more errors and seems that they all have something to do with inserting or updating sessions and the sessionhash value is missing from the queries.

I'm on your site right now and do not see any errors- beyond the error the skin is giving the browser.
You have a dragon above your Little Wales.com logo. Seems to be running just fine-

Yeah, what happened then... Spooked me right out lol

The site appears to work fine but I'm mailed these errors continuously.

I stop getting the dB errors when I deactivate vBSEO but that stop's me from using vBSEO.

Anyone have any ideas?

I've tried de-activating all the products I have installed but the same thing still happens :(

Although there is no visual errors on the site, there does seem to be an added delay in viewing some pages which i'm assuming are the pages that are generating these errors such as member.php, forumdisplay.php to name but a few.

Is there nobody that can help me?

The following option:

Rewrite Forum URLs?
Set this option to "Yes" to have forum URLs rewritten

When set to no, I stop getting the errors.

Hope there is an easy fix for this.

I wish that I could help you out, just wait a while and I am sure that one of the Authors/ owners/ Moderators will come in shortly to help you out. I myself have never encountered such an issue before, my Only problem with vBSEO was caused by FlashFXP not uploading the files in Binary mode (even when I told it to do so.)

Good news, this is now fixed.

I decided to finally upgrade vB from 3.5 RC3 to Gold 3.5.1 and no more dB errors yay

Now I can concentrate on configuring vbSEO.

Even more good news. For the very first time, I have a Google spider viewing threads instead of stopping at forumhome.

This is so exciting

You were still on RC3?

Trancetopia,

thanks for letting us know that the issue disappeared with vB upgrade from RC version to the stable release (we were investigating your issue, but haven't reproduced it because of vB version).

I was *slapped wrists*

I added the vBSEO sitemap as well last night and I just had a look at my WOL and there are 8 google spiders crawling away I've only ever had 1 in the past that view my homepage and then went away. They are here to stay now by the looks of things.

This vBSEO tool is well worth the money.

Originally Posted by Oleg Ignatiuk

Trancetopia,

thanks for letting us know that the issue disappeared with vB upgrade from RC version to the stable release (we were investigating your issue, but haven't reproduced it because of vB version).

Thanks Oleg, the only thing that I hadn't tried trying to fault find the problem myself was to finally make the upgrade. I'm glad I did

Hope I didn't waste to much of anybody's time.

I'm going to watch the Google bots grab all my content today now. It's like watching a movie premier

You are welcome, Paul!

Please update us on your site's SE indexing progress in vBSEO Reviews forum!

It's like watching a movie premier

heheheh, I like the way put it ... it's exciting, isn't it? check our logs out!!