Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

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 : ...

  1. #1
    Senior Member
    Real Name
    Ged
    Join Date
    Dec 2006
    Location
    UK
    Posts
    438
    Liked
    0 times

    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?

  2. #2
    Junior Member
    Real Name
    iodex
    Join Date
    Dec 2007
    Posts
    10
    Liked
    0 times
    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

  3. #3
    Junior Member
    Real Name
    iodex
    Join Date
    Dec 2007
    Posts
    10
    Liked
    0 times
    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ß��

  4. #4
    Senior Member
    Real Name
    Ged
    Join Date
    Dec 2006
    Location
    UK
    Posts
    438
    Liked
    0 times
    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?

  5. #5
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    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 
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  6. #6
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    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
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  7. #7
    Senior Member
    Real Name
    Ged
    Join Date
    Dec 2006
    Location
    UK
    Posts
    438
    Liked
    0 times
    Thanks Mert.

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

  8. #8
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    There is already an annocement for that Ged
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  9. #9
    Senior Member
    Real Name
    Ged
    Join Date
    Dec 2006
    Location
    UK
    Posts
    438
    Liked
    0 times
    There is now, there wasn't when RC4 was released. At least its sorted now though - thanks again.

  10. #10
    Junior Member
    Real Name
    iodex
    Join Date
    Dec 2007
    Posts
    10
    Liked
    0 times
    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....

  11. #11
    Junior Member
    Real Name
    atsdp.com
    Join Date
    Apr 2007
    Posts
    11
    Liked
    0 times
    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)]

    ==========

  12. #12
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    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
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  13. #13
    vBSEO Staff Juan Muriente's Avatar
    Real Name
    Juan Carlos Muriente
    Join Date
    Jun 2005
    Location
    Puerto Rico
    Posts
    14,267
    Liked
    558 times
    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.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  14. #14
    Senior Member
    Real Name
    Ged
    Join Date
    Dec 2006
    Location
    UK
    Posts
    438
    Liked
    0 times
    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.

  15. #15
    vBSEO Staff Juan Muriente's Avatar
    Real Name
    Juan Carlos Muriente
    Join Date
    Jun 2005
    Location
    Puerto Rico
    Posts
    14,267
    Liked
    558 times
    Quote Originally Posted by gedsta View Post
    Joe
    Close enough jeje... it's "Juan"
    Juan Muriente / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


Page 1 of 2 1 2 LastLast

Similar Threads

  1. just got vbseo and now database errors..
    By Likenota in forum Troubleshooting
    Replies: 4
    Last Post: 03-02-2008, 07:40 PM
  2. Getting 404 errors if vBSEO activated
    By Fokker in forum Troubleshooting
    Replies: 3
    Last Post: 09-14-2007, 06:37 PM
  3. VBSEO errors in error log
    By Capper in forum Troubleshooting
    Replies: 5
    Last Post: 12-16-2006, 12:19 AM
  4. vBSEO 2.4.0 & Sitemap v.1.6 errors?
    By stockhideout in forum Troubleshooting
    Replies: 5
    Last Post: 02-11-2006, 04:58 PM
  5. 2 XHTML 1.0 errors on vbseo.com
    By Metro Man in forum Bug Reporting
    Replies: 1
    Last Post: 08-06-2005, 01:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •