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 Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders 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

DB Error on sitemap update

This is a discussion on DB Error on sitemap update within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Had my sitemap running before I installed vbseo , now when I run after installing vbseo , I get this ...

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 11-16-2008, 11:45 AM
glorify's Avatar
Senior Member
 
Real Name: Scott
Join Date: Oct 2005
Location: Indiana, USA
Posts: 100
DB Error on sitemap update

Had my sitemap running before I installed vbseo, now when I run after installing vbseo, I get this error. See the screen--that's all I get, no other info and no db error email. I also since the last succeccful run of the sitemap had my host do 2,3,6,and 7 of this server opt request.
Attached Thumbnails
error.jpg  

Last edited by glorify; 11-16-2008 at 12:27 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 11-16-2008, 04:27 PM
Loco's Avatar
Senior Member
vBSEO Pre-Release TeamBig Board Administrator
 
Real Name: Brandon Sheley
Join Date: Oct 2005
Location: Kansas
Posts: 1,923
Blog Entries: 1
Send a message via AIM to Loco Send a message via MSN to Loco Send a message via Yahoo to Loco
try to view source on that page and post the DB error.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 11-16-2008, 09:06 PM
glorify's Avatar
Senior Member
 
Real Name: Scott
Join Date: Oct 2005
Location: Indiana, USA
Posts: 100
Code:
<!--
Database error in vBulletin 3.8.0 Beta 1:

Invalid SQL:

         		SELECT count(*)as cnt,max(dateline) as lastupdate
         		FROM groupmessage
         		WHERE groupid='1';

MySQL Error   : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, November 16th 2008 @ 07:14:20 PM
Error Date    : Sunday, November 16th 2008 @ 07:14:24 PM
Script        : http://www.glorifythepast.com/forums/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.glorifythepast.com/forums/vbseo_sitemap/index.php?rlist=true
IP Address    : 216.176.155.193
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 
-->
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 11-16-2008, 09:15 PM
Michael Biddle's Avatar
vBSEO Staff
vBSEO Total Customer Support
 
Real Name: Michael Biddle
Join Date: Jan 2007
Location: Southern California
Posts: 3,204
Blog Entries: 5
Please try: Links not working after site transfer
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 11-16-2008, 09:45 PM
glorify's Avatar
Senior Member
 
Real Name: Scott
Join Date: Oct 2005
Location: Indiana, USA
Posts: 100
Seemed to work
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 11-17-2008, 12:40 AM
Junior Member
 
Real Name: Rik Brown
Join Date: Apr 2006
Location: St. Louis, Missouri, USA
Posts: 19
I too just encountered the exact same problem. The advised changes to the vbseo_sitemap_functions.php file worked. -- Rik
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
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


Similar Threads

Thread Thread Starter Forum Replies Last Post
Unable to match directive-apache update error poprulz URL Rewrite Settings 0 01-16-2008 06:32 AM
After update fatal error piepo Troubleshooting 5 10-06-2005 07:51 AM


All times are GMT -4. The time now is 03:00 AM.


Powered by vBulletin Version 3.8.0 Release Candidate 2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.