vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now!
vBSEO 2.0 Style Released vBSEO 3.3.0 GOLD Launched vBSEO's "LiveStats" for Google Analytics vB Sitemap Generator, Version 2.5 Success with vBSEO = 600ore Web Visitors + $1400 in a Day!

vbadvanced links directory / vbseo sitemap

This is a discussion on vbadvanced links directory / vbseo sitemap within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; Upon running the sitemap generator, it went through most (I assume) of it... It got as far as... Code: [SECTION ...

Go Back   vBulletin SEO Forums > vBSEO Google/Yahoo Sitemap > Troubleshooting

vbadvanced links directory / vbseo sitemap vbadvanced links directory / vbseo sitemap

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1  
Old 09-04-2008, 11:21 AM
Member
  
Real Name: Karl
Join Date: Aug 2008
Location: England
Posts: 77
Blog Entries: 1
Question vbadvanced links directory / vbseo sitemap
Upon running the sitemap generator, it went through most (I assume) of it...

It got as far as...
Code:
[SECTION START] tags [9,105.4Kb mem used] [93s (+0s)]
[create sitemap file] filename: sitemap_11.xml.gz, number of urls: 20000 [9,077.8Kb mem used] [96s (+3s)]
[create sitemap in text format] part #12 [9,077.7Kb mem used] [96s (+0s)]
[create sitemap file] filename: sitemap_12.xml.gz, number of urls: 20000 [9,072.0Kb mem used] [103s (+8s)]
[create sitemap in text format] part #13 [9,071.9Kb mem used] [103s (+0s)]
[addon module] vbseo_sm_vba_links.php [9,341.3Kb mem used] [104s (+1s)]
and promptly displayed the following d/b error.

Code:
Database error in vBulletin 3.7.3:

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

MySQL Error   : Table 'antimisan6.vblinks_categories' doesn't exist
Error Number  : 1146
Request Date  : Thursday, September 4th 2008 @ 11:07:16 AM
Error Date    : Thursday, September 4th 2008 @ 11:09:00 AM
Script        : http://mysite.com/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://mysite.com/vbseo_sitemap/index.php
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vB_Database
I'm running the latest vba links directory (3.0RC1) & vBSEO (3.2.0 gold).

Any ideas folks?


ETA: When I click my sitemap link, it says one doesn't exist.
http://mysite.com/sitemap_index.xml
Quote:
Sitemap file not found
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 09-04-2008, 11:52 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer Support
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 23,637
Do you have existing "vblinks_categories" table in your database?
__________________
Oleg Ignatiuk / Crawlability Inc.
vBSEO Styles: Version 1.0 PRO For Everyone Version 2.0 For vBSEO Customers

 vBSEO 3.3.0 Gold Released with New "Virtual HTML Display" Feature Available for Download Now

6X Traffic - $1400 in One Day with vBSEO! Max Out Your SEO
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 09-05-2008, 01:57 PM
Member
  
Real Name: Karl
Join Date: Aug 2008
Location: England
Posts: 77
Blog Entries: 1
I have
vbadv_links_categories

How on Earth that's got there instead??? I'll have a word over on vbadvanced.com and see what Brian says... 'cos this has me slightly stumped
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 09-05-2008, 02:04 PM
Member
  
Real Name: Karl
Join Date: Aug 2008
Location: England
Posts: 77
Blog Entries: 1
ps - this was supposed to be in troubleshooting for the sitemap forum, my apologies for posting it in wrong area. if a mod could move it to the appropriate area, i'd appreciate it. cheers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 09-05-2008, 04:40 PM
Michael Biddle's Avatar
vBSEO Staff
vBSEO Total Customer Support
  
Real Name: Michael Biddle
Join Date: Jan 2007
Location: Southern California
Posts: 4,599
Looks like he changed the structure of the table then. From within your vbseo_sitemap/addons/vbseo_sm_vba_links.php file find: links_categories and change that too: vbadv_links_categories.

Let me know how that turns out.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 09-05-2008, 06:42 PM
Member
  
Real Name: Karl
Join Date: Aug 2008
Location: England
Posts: 77
Blog Entries: 1
I removed the links from the Addon Generator Modules input box... that seems to have got it working.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 09-13-2008, 04:16 AM
Sysop's Avatar
Senior Member
  
Real Name: Toni
Join Date: Oct 2007
Location: Italy
Posts: 119
Oops, same issue here, I've open a Ticket for this, but I'm thinking that's the cause..
Anyway in my DB structure I haven't any of that table, I'll create and post the feedback. BrB
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 09-13-2008, 04:22 AM
Sysop's Avatar
Senior Member
  
Real Name: Toni
Join Date: Oct 2007
Location: Italy
Posts: 119
I don not have vblinks_categories nor vbadv_links_categories
EDIT, I don't use a vb link directory, it just removed from module addons in config.

It works great now, sorry for confisung.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 09-13-2008, 05:28 AM
Member
  
Real Name: Karl
Join Date: Aug 2008
Location: England
Posts: 77
Blog Entries: 1
Here's what Brian at vbadvanced replied with...

Quote:
Originally Posted by Brian View Post
The table names changed quite a while ago in v1.0.1. The table name needs to be changed to 'adv_links_categories', and the 'WHERE private = 1' part needs to be updated to use vBa Links permissions system, something like this:

PHP Code:
require_once(DIR . '/includes/vba_links_functions.php');

$privcats = links_fetch_private_categories();

$something = $db->query_read("
    SELECT *
    FROM " . TABLE_PREFIX . "adv_links_categories
    " . iif($privcats, 'WHERE catid NOT IN(' . $privcats . ')')
); 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

Tags
links directory, vbadvanced, vbseo 3.2.0 gold

« .htaccess | Problem with Sitemap Index URL after installing VBSEO »
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
vBadvanced Links Directory fattony69 Custom Rewrite Rules 8 08-02-2008 06:50 AM
VBSEO, VBAdvanced Links Directory? philmckrackon Pre-Sales Questions 2 05-12-2008 01:42 AM
vbadvanced pages and vbadvanced link directory ludachris General Discussion 3 02-26-2008 11:38 AM
Working with vBadvanced Links Directory blackgem Pre-Sales Questions 13 10-10-2007 07:34 PM
Does vBseo also work with vBadvanced and vBadvanced links directory? ChrisGuthrie.net General Discussion 30 05-16-2007 01:15 AM


All times are GMT -4. The time now is 04:10 PM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.0 ©2009, Crawlability, Inc.