VBA Links Directory site map

Thanks for that Oleg. Just tested it and it works fine

Great!

Database error in vBulletin 3.6.8:

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

MySQL Error : Unknown column 'private' in 'where clause'
Error Number : 1054

and what about pages of the category , some categories has more than 1 page

Try to remove "WHERE private = 0" part from the query.

I would like to include vbadvanced links directory in the sitemap - also photopost classifieds.

I have been through this thread and cannot see if the issues around install of the addon have been completely resolved.

I have VBA Links Directory v2.0.1 installed on BizFace Community - Business Directory

cheers

RoyMogg

Please try the add-on code posted above: VBA Links Directory site map

Hi Oleg

From the code posted is is necessary to remove the where clause in the following statement for 3.6.8

SELECT * FROM vb5_adv_links_categories WHERE private = 0;


cheers

Roy

You should remove it if you get database error when generating sitemap.

This all seems very complicated, could we please include vblinks sitemap stuff in the next version of VB seo/Google sitemap generator? please ,because I dont like playing with messy code,as I am most likely to break something.

Hi Oleg,

Just to confim no issues at all with this small hack.

vbadvanced 3.0 RC1 vbadavanced links 2.0.1 and vb 3.6.8p2

Its as simple as suggested just the file to create and upload and include in the add-ons dialogue in vbseo - good job

cheers

Roy



www.bizface.co.uk

Great, I'm glad that it works fine.

Hi, Oleg

The timing of the error at 6.08 occurred during the site map generation with the links directory add-on so I expect the fault is here. I updated the links directory this weekend.

Can you advise issue - I will check is suspended is still a valid col in the new release if so I assume it can be removed from this statement in the vba_links module.

regards

RoyMogg

sorry this thread starter is a little old - admin can push to new thread if necessary no bump intended.



Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM bf_adv_links WHERE suspended = 0 AND open > 0;

MySQL Error : Unknown column 'suspended' in 'where clause'
Error Number : 1054
Request Date : Thursday, September 4th 2008 @ 06:08:37 AM
Error Date : Thursday, September 4th 2008 @ 06:08:45 AM
Script : http://www.example.com/bizfaceforum/...hp?rand=257151
Referrer : http://www.example.com/bizfaceforum/register.php
IP Address :
Username : Unregistered
Classname : vb_database
MySQL Version :

I do not have the latest vBa Links version, so please check if there is a "suspended" column in "bf_adv_links" db table and if it's not existing you can remove "suspeded = 0 AND" from sql query.

Thanks Oleg,

I have checked over with Brian at VBA and carried out the following tweak to the script:

In the vbseo_sm_vba_links.php file

Changed 'suspended = 0' to 'valid != 2' as suggested.

I have manually started a sitemap generations and it went through OK and seems to have mapped the links dir.

I suggest the script at the top of the thread is amended

regards

Roy