Results 1 to 6 of 6

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 ...

  1. #1
    Senior Member glorify's Avatar
    Real Name
    Scott
    Join Date
    Oct 2005
    Location
    Indiana, USA
    Posts
    100
    Liked
    0 times

    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 Attached Thumbnails error.jpg  
    Last edited by glorify; 11-16-2008 at 11:27 AM.

  2. #2
    Senior Member Brandon Sheley's Avatar
    Real Name
    Brandon Sheley
    Join Date
    Oct 2005
    Location
    Kansas
    Posts
    2,348
    Liked
    20 times
    Blog Entries
    1
    try to view source on that page and post the DB error.
    My forums: General Forums | Admin Talk (running xenforo)

  3. #3
    Senior Member glorify's Avatar
    Real Name
    Scott
    Join Date
    Oct 2005
    Location
    Indiana, USA
    Posts
    100
    Liked
    0 times
    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 : 
    -->

  4. #4
    Senior Member
    Real Name
    Michael Biddle
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    7,097
    Liked
    5 times
    The Forum Hosting - Forum Hosting from the Forum Experts

  5. #5
    Senior Member glorify's Avatar
    Real Name
    Scott
    Join Date
    Oct 2005
    Location
    Indiana, USA
    Posts
    100
    Liked
    0 times
    Seemed to work

  6. #6
    Junior Member
    Real Name
    Rik Brown
    Join Date
    Apr 2006
    Location
    St. Louis, Missouri, USA
    Posts
    28
    Liked
    0 times
    I too just encountered the exact same problem. The advised changes to the vbseo_sitemap_functions.php file worked. -- Rik

Similar Threads

  1. Unable to match directive-apache update error
    By poprulz in forum URL Rewrite Settings
    Replies: 0
    Last Post: 01-16-2008, 05:32 AM
  2. After update fatal error
    By piepo in forum Troubleshooting
    Replies: 5
    Last Post: 10-06-2005, 06:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •