vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

vBSEO 3.2.0 RC4 - Errors on Sitemap Generation

This is a discussion on vBSEO 3.2.0 RC4 - Errors on Sitemap Generation within the Bug Reporting forums, part of the vBSEO SEO Plugin category; Code: Database error in vBulletin 3.7.0: Invalid SQL: SELECT t_threadid,count(*) as cnt FROM vb1_linkback GROUP BY t_threadid; MySQL Error : ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Bug Reporting

vBSEO 3.2.0 RC4 - Errors on Sitemap Generation vBSEO 3.2.0 RC4 - Errors on Sitemap Generation

Enhancing 80 million pages.

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

Reply
Page 1 of 2 1 2

 

LinkBack Thread Tools
  #1  
Old 04-30-2008, 11:15 PM
Senior Member
  
Real Name: Ged
Join Date: Dec 2006
Location: UK
Posts: 411
vBSEO 3.2.0 RC4 - Errors on Sitemap Generation
Code:
Database error in vBulletin 3.7.0:

Invalid SQL:

                SELECT t_threadid,count(*) as cnt
                FROM vb1_linkback
                GROUP BY t_threadid;

MySQL Error   : Table 'skyuser_.vb1_linkback' doesn't exist
Error Number  : 1146
Request Date  : Thursday, May 1st 2008 @ 03:16:01 AM
Error Date    : Thursday, May 1st 2008 @ 03:16:01 AM
Script        : http://www.domain.co.uk/forum/admincp/cronadmin.php?do=runcron&cronid=43
Referrer      : http://www.domain.co.uk/forum/admincp/cronadmin.php?do=modify
IP Address    : xx.xxx.xxx.xxx
Username      : myname
Classname     : vB_Database
MySQL Version : 5.0.37-community-nt
Any ideas?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 04-30-2008, 11:35 PM
Junior Member
  
Real Name: iodex
Join Date: Dec 2007
Posts: 10
I think its a problem in Vbulletin 3.6.10. Since i reverted the vbseo to 3.1 the same problem still exists in sitemap generator 2.1...

So this happened after i upgraded to Vbulletin 3.6.10
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 04-30-2008, 11:47 PM
Junior Member
  
Real Name: iodex
Join Date: Dec 2007
Posts: 10
The error when we open the sitmap files is:

Warning: fopen(/home/***/public_html/vbseo_sitemap/data/downloads.dat) [function.fopen]: failed to open stream: Permission denied in /home/****/public_html/vbseo_sitemap/vbseo_getsitemap.php on line 45

Warning: fwrite(): supplied argument is not a valid stream resource in /home/****/public_html/vbseo_sitemap/vbseo_getsitemap.php on line 46

Warning: fclose(): supplied argument is not a valid stream resource in /home/*****/public_html/vbseo_sitemap/vbseo_getsitemap.php on line 47
‹������‘1oà …çZÊ°X+ÃÙiªÙdë”NM¥l•…©ƒ òÑØê¯/%¶êŒ)ÓŞ÷ôxWnsJ/ªCílEr $UVºFÛ¶"ïû—lM¶b‘”¨½2õYÛF ‹$' +rôşÌëûžŽ*¤®kÊc@ è†Ü |@}ƒ÷Ë�9;¼îŞ¢A¦-úÚJõ£æWó“µÉ'ãk²;"ıÜÄoÅ:è€ ™uƇò䤘¥PÚ^z×á§ë¾ •ÎL½|ä4IÛï’ıB®Ñ׈PÄ:ƒ§l {XñUÁ‹çG�¤£$¬f2É쓉Ž`Mß��
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 04-30-2008, 11:48 PM
Senior Member
  
Real Name: Ged
Join Date: Dec 2006
Location: UK
Posts: 411
Hi

Thanks for the reply, however I am using 3.7.0 so maybe since the change from 3.6.8 to 3.6.9 / 3.7.0 something has gone wrong for you and I or vBSEO?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 05-01-2008, 12:33 AM
Mert Gökçeimam's Avatar
vBSEO.com Webmaster
vBSEO Total Customer SupportvBulletin HackerBig Board Administrator
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 7,817
Blog Entries: 1
Send a message via MSN to Mert Gökçeimam
You need to make a small change within vBSEO Sitemap Generator

Please modify vbseo_sitemap_functions.php file:
FIND:
PHP Code:
FROM " . TABLE_PREFIX . "linkback 
REPLACE WITH:
PHP Code:
FROM " . TABLE_PREFIX . "vbseo_linkback 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 05-01-2008, 12:34 AM
Mert Gökçeimam's Avatar
vBSEO.com Webmaster
vBSEO Total Customer SupportvBulletin HackerBig Board Administrator
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 7,817
Blog Entries: 1
Send a message via MSN to Mert Gökçeimam
Quote:
Originally Posted by iodex View Post
The error when we open the sitmap files is:

Warning: fopen(/home/***/public_html/vbseo_sitemap/data/downloads.dat) [function.fopen]: failed to open stream: Permission denied in /home/****/public_html/vbseo_sitemap/vbseo_getsitemap.php on line 45

Warning: fwrite(): supplied argument is not a valid stream resource in /home/****/public_html/vbseo_sitemap/vbseo_getsitemap.php on line 46

Warning: fclose(): supplied argument is not a valid stream resource in /home/*****/public_html/vbseo_sitemap/vbseo_getsitemap.php on line 47
‹������‘1oà …çZÊ°X+ÃÙiªÙdë”NM¥l•…©ƒ òÑØê¯/%¶êŒ)ÓŞ÷ôxWnsJ/ªCílEr $UVºFÛ¶"ïû—lM¶b‘”¨½2õYÛF ‹$' +rôşÌëûžŽ*¤®kÊc@ è†Ü |@}ƒ÷Ë�9;¼îŞ¢A¦-úÚJõ£æWó“µÉ'ãk²;"ıÜÄoÅ:è€ ™uƇò䤘¥PÚ^z×á§ë¾ •ÎL½|ä4IÛï’ıB®Ñ׈PÄ:ƒ§l {XñUÁ‹çG�¤£$¬f2É쓉Ž`Mß��
You shall chmod 777 vbseo_sitemap/data folder and all the files inside that folder
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 05-01-2008, 09:38 AM
Senior Member
  
Real Name: Ged
Join Date: Dec 2006
Location: UK
Posts: 411
Thanks Mert.

On hindsight vBSEO should have put that in the release notes.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 05-01-2008, 09:40 AM
Mert Gökçeimam's Avatar
vBSEO.com Webmaster
vBSEO Total Customer SupportvBulletin HackerBig Board Administrator
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 7,817
Blog Entries: 1
Send a message via MSN to Mert Gökçeimam
There is already an annocement for that Ged
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 05-01-2008, 09:43 AM
Senior Member
  
Real Name: Ged
Join Date: Dec 2006
Location: UK
Posts: 411
There is now, there wasn't when RC4 was released. At least its sorted now though - thanks again.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #10  
Old 05-01-2008, 10:55 AM
Junior Member
  
Real Name: iodex
Join Date: Dec 2007
Posts: 10
Quote:
Originally Posted by Mert Gökçeimam View Post
You need to make a small change within vBSEO Sitemap Generator

Please modify vbseo_sitemap_functions.php file:
FIND:
PHP Code:
FROM " . TABLE_PREFIX . "linkback 
REPLACE WITH:
PHP Code:
FROM " . TABLE_PREFIX . "vbseo_linkback 

Thanks for the quick reply, the problem is solved....
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #11  
Old 05-01-2008, 01:52 PM
Junior Member
  
Real Name: atsdp.com
Join Date: Apr 2007
Posts: 11
vBulletin 3.7.0
vBSEO 3.2.0 RC4
----------------
vBSEO Sitemap Generator
[homepage] [0s (+0s)]
[SECTION START] showthread [0s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 30000 [15s (+15s)]
[create sitemap in text format] part #2 [15s (+0s)]

Warning: fopen([path]/vbseo_sitemap/data//progress.dat) [function.fopen]: failed to open stream: Permission denied in [path]/vbseo_sitemap/vbseo_sitemap_functions.php on line 866

Warning: fwrite(): supplied argument is not a valid stream resource in [path]/vbseo_sitemap/vbseo_sitemap_functions.php on line 867

Warning: fclose(): supplied argument is not a valid stream resource in [path]/vbseo_sitemap/vbseo_sitemap_functions.php on line 868
[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 30000 [30s (+14s)]
[create sitemap in text format] part #3 [30s (+0s)]

==========
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #12  
Old 05-01-2008, 02:46 PM
Mert Gökçeimam's Avatar
vBSEO.com Webmaster
vBSEO Total Customer SupportvBulletin HackerBig Board Administrator
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 7,817
Blog Entries: 1
Send a message via MSN to Mert Gökçeimam
Quote:
Originally Posted by atsdp View Post
vBulletin 3.7.0
vBSEO 3.2.0 RC4
----------------
vBSEO Sitemap Generator
[homepage] [0s (+0s)]
[SECTION START] showthread [0s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 30000 [15s (+15s)]
[create sitemap in text format] part #2 [15s (+0s)]

Warning: fopen([path]/vbseo_sitemap/data//progress.dat) [function.fopen]: failed to open stream: Permission denied in [path]/vbseo_sitemap/vbseo_sitemap_functions.php on line 866

Warning: fwrite(): supplied argument is not a valid stream resource in [path]/vbseo_sitemap/vbseo_sitemap_functions.php on line 867

Warning: fclose(): supplied argument is not a valid stream resource in [path]/vbseo_sitemap/vbseo_sitemap_functions.php on line 868
[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 30000 [30s (+14s)]
[create sitemap in text format] part #3 [30s (+0s)]

==========
You shall chmod 777 vbseo_sitemap/data folder and all the files inside that folder
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #13  
Old 05-01-2008, 11:36 PM
Juan Muriente's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Juan Carlos Muriente
Join Date: Jun 2005
Location: Puerto Rico
Posts: 12,721
Quote:
Originally Posted by gedsta View Post
There is now, there wasn't when RC4 was released. At least its sorted now though - thanks again.
Right, it should have been notified concurrently with the release announcement. I missed that point while creating the announcemnt. But Mert rectified it pretty fast.

Thanks for your help during these (critical) testing times Ged!
__________________
Juan Muriente / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #14  
Old 05-01-2008, 11:52 PM
Senior Member
  
Real Name: Ged
Join Date: Dec 2006
Location: UK
Posts: 411
Quote:
Thanks for your help during these (critical) testing times Ged!
Its a pleasure Joe, you gave us a great product, the least we can do is rally round and try and resolve any issues.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #15  
Old 05-02-2008, 12:44 AM
Juan Muriente's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Juan Carlos Muriente
Join Date: Jun 2005
Location: Puerto Rico
Posts: 12,721
Quote:
Originally Posted by gedsta View Post
Joe
Close enough jeje... it's "Juan"
__________________
Juan Muriente / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply
Page 1 of 2 1 2

« 3.2.0 RC4 - Stopwords being removed from tag rewrites | vBSEO 3.2.0 RC4 - IIS »
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
just got vbseo and now database errors.. Likenota Troubleshooting 4 03-02-2008 07:40 PM
Getting 404 errors if vBSEO activated Fokker Troubleshooting 3 09-14-2007 06:37 PM
VBSEO errors in error log Capper Troubleshooting 5 12-16-2006 12:19 AM
vBSEO 2.4.0 & Sitemap v.1.6 errors? stockhideout Troubleshooting 5 02-11-2006 04:58 PM
2 XHTML 1.0 errors on vbseo.com Metro Man Bug Reporting 1 08-06-2005 01:31 AM


All times are GMT -4. The time now is 09:00 PM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.0 Beta 4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.