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?

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

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ß
��

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?

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 


Originally Posted by iodex

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

Thanks Mert.

On hindsight vBSEO should have put that in the release notes.

There is already an annocement for that Ged

There is now, there wasn't when RC4 was released. At least its sorted now though - thanks again.

Originally Posted by 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 


Thanks for the quick reply, the problem is solved....

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)]

==========

Originally Posted by atsdp

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

Originally Posted by gedsta

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!

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.

Originally Posted by gedsta

Joe

Close enough jeje... it's "Juan"