Generator 2.6 Works Perfectly :up:

Hi,

I installed it and get this error:


I'm running 3.8.3 without vbSEO. Can anybody help? Thx in advance!

hello

I put the hack on my forum...3.8.4 PL2

Everything worked fine...knowing that my config.php files name is changed, so i editted some files in the hack to make it work

-Everything is fine now....BUT, When I click on RUN SITEMAP GENERATOR

it takes me to a page full of links like this one:

and then the page stops loading without giving any excuse or reason

and it gives me ERRORS in the TOP of the page like this one:

and no sitemap is generated

PLEASE HELP

when i click run report , it gives me this error

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.tagid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.visible = 1
AND thread.sticky IN (0, 1)' at line 5
Error Number : 1064
Request Date : Saturday, January 2nd 2010 @ 06:24:39 AM
Error Date : Saturday, January 2nd 2010 @ 06:24:40 AM
Script : http://www.hydrocanna.com/vbseo_site...eo_sitemap.php
Referrer : http://www.hydrocanna.com/vbseo_site...php?rlist=true
IP Address : 000000000
Username : Unregistered
Classname : vB_Database
MySQL Version :

Having a DB error when trying to run.....It worked fine in the past...

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1262706291,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, January 5th 2010 @ 09:44:51 AM
Error Date : Tuesday, January 5th 2010 @ 09:46:29 AM
Script : http://chataboutcars.com/forum/admin...cron&cronid=21
Referrer : http://chataboutcars.com/forum/admin....php?do=modify
IP Address : -------------
Username : ------------
Classname : vB_Database
MySQL Version :

Hi,

I would like to uninstall and remove the sitemap generator from my VB. Can someone please provide me the exact steps I should take in order to do so?

Thanks!

I can use this w/o vbseo, or not? thanks

As with any other, go to AdminCP->Plugins & Products->Manage Products. Here, under Controls (on the right side) you have options, default is Edit. Choose Uninstall for the product (any one you want to uninstall). After that, you can remove leftover files, if there are any (with vBSEO Sitemap Generator are). To do that check files you had to upload. The same ones you need to delete. You don't need to delete files, if you don't want to.

Hello,

Yes, you can run this without vBSEO.

I'm running 3.8.4
I downloaded all of the files as indicated by the instructions.
The vBSEO control panel seems to be working well.
When I choose vBSEO Sitemap reports from the Admin control panel I get:

"The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log. "

The data folder is set to "777"
.htaccess contains:
RewriteEngine On
RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

I've been racking my brain trying to figure out what I'm doing wrong :eek:

Any ideas?:confused:

Here is the error message that I'm getting on my server now:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.tagid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.visible = 1
AND thread.sticky IN (0, ' at line 5 Error Number : 1064 Request Date : Thursday, January 14th 2010 @ 03:29:26 PM

Will the vb 4 compatible version be free?

i have a problem.......... how do i login to the vBSEO Sitemap Interface Access Password?

I cant remember the password............. i cant even remember setting the password?

anyone know about this error ??

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1264298425,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, January 24th 2010 @ 02:00:25 AM
Error Date : Sunday, January 24th 2010 @ 02:02:14 AM
Script : hxxp://www.myforum.com/forums/cron.php?rand=1264298423
Referrer : hxxp://www.myforum.com/forums/kbox-discussions/6820-kbox-file-release-read.html
IP Address : xxx.xxx.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Not sure about the first one (Invalid SQL) but it may be related to the second (MySQL server has gone away) which tells you you've lost the connection to the MySQL server, a common and saqdly frequent occurrence with shared hosting.

Try breaking up the sitemap into smaller files in the options.

well, for what it is worth it is VPS.

Then my guess is your cron job is timing out. Try the suggestion of

1. setting Max URLs in Sitemap Files to something lower, perhaps 20000 or 25000, and
   
2. increasing the pause at Delay Execution After Each Sitemap File (I use 15 seconds on a VPS)

yes the one was 20000 i think it was default.

the 0 to 15 seconds seemed to do the trick thanks !!!

very good

where can i et the one for vb 4

It hasn't yet been released to anyone except vBSEO license owners - still in beta.

ok will the 3.8 work

No, it won't. You'll have to use the vBulletin version until vBSEO is released for 4.x.

ok i will have to wairt thank you

Is Bing already added instead of live.com?

when i click the link to the sitemap in my report. it shows 403 forbidden.
What can i do now?

Re-do the install, making sure you follow every step precisely.

Are you certain your host allows mod_rewrite?

actually how do i know when i'm able to create the sitemap correctly?

what i get when i open the sitemap_index.xml.gz

<sitemapindex xsi:schemaLocation=" http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/09/siteindex.xsd">
−
<sitemap>
<loc>http://www.myonedeco.com/forum/sitemap_1.xml.gz</loc>
<lastmod>2010-02-09T00:23:17+00:00</lastmod>
</sitemap>
</sitemapindex>

Same issue here. However i get an email everyday saying it went through.

And, did you upload the htaccess (or add its rules to your existing htaccess)?

yes, i upload the .htaccess to the forum root.

think the sitemap is generated correctly. Thanks!

Hope this will increase my site's rank.

Installed!

This hacks is excellent, would be great an update for VB4

I am having the same trouble as dgparent, I think. I get no errors when I run. The only gz file I see (sitemap_1.xml.gz) is in the /forums/vbseo_sitemap/data directory. Yet the "Your Google Sitemap Index URL" link leads to "/forums/sitemap_index.xml.gz"

What do I need to do to fix? I do have the .htaccess file in my "forums" directory. I did not previously have one before I downloaded this mod, so I just uploaded the one provided (didn't need to modify an existing one). I don't understand what would need to be changed in vbseo_sitemap_config.php (if that is applicable to me).

On a side note, should I be able to see a legible sitemap (in xml) somewhere? If I try to view any of the gz files, they are all 'garbage'. Should there be a sitemap.xml file somewhere?

Thanks

What happens if you call yourforums.com/forums/sitemap_1.xml.gz in a browser?

That is the sitemap file. When someone calls it in a browser or visits it as the Search Engines do, the .htaccess redirects the call to the vbseo_sitemap location, and changes it to the .xml version, all on the fly, so the Engine indexes your /forum/ information, not your /vbseo_sitemap/ location (as all Google sitemaps have to be in the folder they are indexing).

Thanks for the quick reply. I get "The page cannot be found"

You are substituting yourforums.com for your actual domain information?

You uploaded .htaccess , and not htaccess.txt?

Are you certain your host supports mod_rewrite? http://www.vbseo.com/f77/how-check-i...my-site-21502/ has an easy test.

Yes, here is a link to that path on my site

Yes, I uploaded .htaccess and not htaccess.txt

Per the site you referred to, I added
to the top of the .htaccess file and re-uploaded to my /forums directory. I tried testing it here... did I do that right? Still page not found.

Thanks

Hmm.

That would suggest that mod_rewrite isn't working/enabled for your site.

See if your host can offer assistance enabling it, then re-try. :)

Thanks kall. I sent my host a ticket. I'll see what they say.