Database error from links module

Hi All,

I have been running the vba links plugin for some while now with no problem but since the upgrade to 2.5 sitemap I have been getting the error below. The table referred does not exist in the db (I checked the plug-in file (one of Olegs) and checked the call to the database:

$lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_links_categories WHERE private = 0");
while ($lnk = $db->fetch_array($lnkg)) etc ...

The table prefix is bf_ so
As can be seen the correct table bf_adv_links_categories is called but the error below shows bf_links_categories as the invalid sql error as the table bf_links_categories does not exist - I cannot explain this can anyone help?

cheers

Roy

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT * FROM bf_links_categories WHERE private = 0;

MySQL Error : Table 'BF_FORUM.bf_links_categories' doesn't exist
Error Number : 1146
Request Date : Tuesday, September 8th 2009 @ 05:12:48 PM
Error Date : Tuesday, September 8th 2009 @ 05:13:11 PM
Script :
http://www.example.com/forum/vbseo_s...eo_sitemap.php
Referrer :
http://www.example.com/forum/vbseo_sitemap/index.php
IP Address : xxx
Username : Unregistered
Classname : vb_database
MySQL Version :

Maybe this will help:
VBA Links Directory site map

i know i had to use it when i upgraded to v3 of the links system.

This is the one I am using - so I cannot see what the problem is.

cheers

Roy

Hi All,

I noticed during a recent upgrade of the links directory that the the prefix for the table call in the links sitemap module had the incorrect name - hence caused a db error (table does not exist).

I have added the correct table prefix adv_ to the sitemap code below.

RoyMogg

PHP Code:

<?php

 /******************************************************************************************
 * vBSEO Google/Yahoo Sitemap Generator for vBulletin v3.x.x by Crawlability, Inc.         *
 *-----------------------------------------------------------------------------------------*
 *                                                                                         *
 * Copyright © 2005-2008, Crawlability, Inc. All rights reserved.                          *
 * You may not redistribute this file or its derivatives without written permission.       *
 *                                                                                         *
 * Sales Email: sales@crawlability.com                                                     *
 *                                                                                         *
 *-------------------------------------LICENSE AGREEMENT-----------------------------------*
 * 1. You are free to download and install this plugin on any vBulletin forum for which    *
 *    you hold a valid vB license.                                                         *
 * 2. You ARE NOT allowed to REMOVE or MODIFY the copyright text within the .php files     *
 *    themselves.                                                                          *
 * 3. You ARE NOT allowed to DISTRIBUTE the contents of any of the included files.         *
 * 4. You ARE NOT allowed to COPY ANY PARTS of the code and/or use it for distribution.    *
 ******************************************************************************************/

    // replace the URL below with your vBa links main folder URL
    $vba_links_url = 'http://www.example.co.uk/links/';

    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_links_categories WHERE private = 0");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'browselinks.php?c='.$lnk['catid'];
        if(VBSEO_ON)
            $url = vbseo_any_url($url);

        $url = $vba_links_url . $url;

          vbseo_add_url($url, 1.0, $lnk['lastupdated'], 'daily');
    }

    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_links WHERE valid != 2 AND open > 0");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'showlink.php?do=showdetails&l='.$lnk['linkid'];

        if(VBSEO_ON)
            $url = vbseo_any_url($url);

        $url = $vba_links_url . str_replace($vbseo_vars['bburl'] . '/', '', $url);

          vbseo_add_url($url, 0.5, $lnk['lastupdated'] ? $lnk['lastupdated'] : $lnk['dateline'], 'weekly');
    }

?>