Results 1 to 8 of 8

vbseo sitemap generator don't want to generate database problem?

This is a discussion on vbseo sitemap generator don't want to generate database problem? within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I use vbseo the latest version. I use vbulletin 4.0.1. I installed vbseo sitemap generator but i can't make it ...

  1. #1
    Junior Member
    Real Name
    Samuel
    Join Date
    Nov 2008
    Posts
    3
    Liked
    0 times

    vbseo sitemap generator don't want to generate database problem?

    I use vbseo the latest version.

    I use vbulletin 4.0.1.

    I installed vbseo sitemap generator but i can't make it work!

    Each time i try to generate a sitemap i have this error:

    Database error in vBulletin 4.0.1:
    Invalid SQL:
    SELECT
    count(*) as maxre
    FROM tagthread
    GROUP BY tagid
    ORDER BY maxre DESC
    LIMIT 0,1;
    MySQL Error : Table 'samuel_vbulletin.tagthread' doesn't exist
    Error Number : 1146
    Request Date : Tuesday, February 23rd 2010 @ 08:35:23 AM
    Error Date : Tuesday, February 23rd 2010 @ 08:35:23 AM
    Script : S'identifier - Gagner de l'argent - vBulletin Logiciel d'administration
    Referrer : S'identifier - Gagner de l'argent - vBulletin Logiciel d'administration
    IP Address : 74.58.192.108
    Username : Samuel
    Classname : vB_Database
    MySQL Version : 5.1.30

    Someone can help me fix this please?

    Thanks,
    Sam

  2. #2
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    23,111
    Liked
    622 times
    Blog Entries
    4
    For vBulletin 4 you need to install vBSEO Sitemap Generator 2.6 Beta
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  3. #3
    Junior Member
    Real Name
    Samuel
    Join Date
    Nov 2008
    Posts
    3
    Liked
    0 times
    FIXED! Thanks alut. A+++

  4. #4
    Junior Member
    Real Name
    Randy Durham
    Join Date
    Sep 2006
    Location
    Raleigh, NC
    Posts
    23
    Liked
    0 times
    We're receiving the same error in 2.6 Beta 2.

    Code:
    Database error in vBulletin 4.0.3:
    Invalid SQL:
             SELECT 
              count(*) as maxre
             FROM tagthread
             GROUP BY tagid
             ORDER BY maxre DESC
             LIMIT 0,1;
    MySQL Error   : Table 'ncangler_forums.tagthread' doesn't exist
    Error Number  : 1146
    Request Date  : Wednesday, May 5th 2010 @ 05:22:05 PM
    Error Date    : Wednesday, May 5th 2010 @ 05:22:05 PM
    Script        : http://www.ncangler.com/forums/vbseo...eo_sitemap.php
    Referrer      : 
    IP Address    : *
    Username      : Unregistered
    Classname     : vB_Database

  5. #5
    Senior Member
    Real Name
    Michael Biddle
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    7,097
    Liked
    5 times
    As a temporary fix you can disable the tags from being included.
    The Forum Hosting - Forum Hosting from the Forum Experts

  6. #6
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    Hello,

    it should work correctly with tags enabled. Please open a ticket with ftp access for troubleshooting.

  7. #7
    Junior Member
    Real Name
    Randy Durham
    Join Date
    Sep 2006
    Location
    Raleigh, NC
    Posts
    23
    Liked
    0 times
    I'm pretty sure I was able to fix it. The queries for vB3 were still being executed, so I checked this bit of code on line 39 of vbseo_sitemap_functions.php:
    Code:
      if($vbulletin->versionnumber >= '4.0')
       $vbseo_vars['isvb4'] = true;
    Once I changed it to use $vbulletin->options['versionnumber'] instead then it started loading up fine.

    (FYI, this is Brian from vBadvanced posting under NcAngler's account since I'm helping him with his vB4 upgrade )

  8. #8
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    Strange that it works in some instances, but not in others. Anyway, thanks for the follow-up!
    (especially since vBulletin itself uses $vbulletin->versionnumber)

Similar Threads

  1. vBulletin 3.x Sitemap Generator Database error =.= HELP PLS
    By angelvn in forum Troubleshooting
    Replies: 8
    Last Post: 02-20-2010, 10:09 AM
  2. Have Database problem with vbseo site map generator
    By longevityinc in forum Troubleshooting
    Replies: 1
    Last Post: 07-07-2009, 05:44 AM
  3. VBSEO Sitemap Generator Problem
    By Jesse in forum Deutsch
    Replies: 42
    Last Post: 07-02-2009, 05:25 PM
  4. Database error when running sitemap generator.
    By Lilmikeishere in forum Troubleshooting
    Replies: 3
    Last Post: 03-22-2009, 09:32 AM
  5. Replies: 2
    Last Post: 10-06-2006, 06:07 PM

Tags for this Thread

Posting Permissions

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