Results 1 to 13 of 13

Error after upgrading to 3.2 RC4

This is a discussion on Error after upgrading to 3.2 RC4 within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; Code: Database error in vBulletin 3.7.0: Invalid SQL: SELECT t_threadid,count(*) as cnt FROM linkback GROUP BY t_threadid; MySQL Error : ...

  1. #1
    Senior Member UnderEstimated's Avatar
    Real Name
    Kaleem
    Join Date
    May 2006
    Location
    NJ
    Posts
    267
    Liked
    10 times

    Error after upgrading to 3.2 RC4

    Code:
    Database error in vBulletin 3.7.0:
    
    Invalid SQL:
    
                            SELECT t_threadid,count(*) as cnt
                            FROM linkback
                            GROUP BY t_threadid;
    
    MySQL Error   : Table 'friendsk_forum.linkback' doesn't exist
    Error Number  : 1146
    Request Date  : Sunday, May 4th 2008 @ 09:17:58 PM
    Error Date    : Sunday, May 4th 2008 @ 09:17:59 PM
    Script        : http://www.friendskorner.com/forum/v...eo_sitemap.php
    Referrer      : vBSEO Google / Yahoo Sitemap for vBulletin
    
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    vBulletin 3.7.0 Gold
    vBSEO 3.2.0 RC4
    vBSEO Sitemap 2.1

  2. #2
    Senior Member
    Real Name
    Dhillon
    Join Date
    Apr 2006
    Posts
    341
    Liked
    1 times

  3. #3
    Senior Member UnderEstimated's Avatar
    Real Name
    Kaleem
    Join Date
    May 2006
    Location
    NJ
    Posts
    267
    Liked
    10 times
    Ok thank you notorious. Can someone tell me in /data/ the sitemap.gz files PERMISSION whould be what?

  4. #4
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    You can keep default permissions for sitemap files inside data/ folder. If you will move to another server, it may be required to change permissions to 0666 since file owner id is likely to change.

  5. #5
    Senior Member UnderEstimated's Avatar
    Real Name
    Kaleem
    Join Date
    May 2006
    Location
    NJ
    Posts
    267
    Liked
    10 times
    Quote Originally Posted by Oleg Ignatiuk View Post
    You can keep default permissions for sitemap files inside data/ folder. If you will move to another server, it may be required to change permissions to 0666 since file owner id is likely to change.
    Yes i just moved and now i dont know if they are rite cus my Google index went down traffic is good still.

    And i see errors like on vbseo_sitemap_functions.php have an error on 607 or 608 or something like that.

  6. #6
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    What exactly is the error you get?

  7. #7
    Senior Member UnderEstimated's Avatar
    Real Name
    Kaleem
    Join Date
    May 2006
    Location
    NJ
    Posts
    267
    Liked
    10 times
    Code:
    Warning: gzopen(/home/f/forum/vbseo_sitemap/data/sitemap_1.xml.gz) [function.gzopen on line ]: failed to open stream: Permission denied in /home/f/forum/vbseo_sitemap/vbseo_sitemap_functions.php579
    
    Warning: gzopen(/home/f/forum/vbseo_sitemap/data/urllist.txt.gz) [function.gzopen on line ]: failed to open stream: Permission denied in /home/f/forum/vbseo_sitemap/vbseo_sitemap_functions.php583
    
     on line Warning: gzwrite(): supplied argument is not a valid stream resource in /home/fri/forum/vbseo_sitemap/vbseo_sitemap_functions.php593
    
     on line Warning: gzwrite(): supplied argument is not a valid stream resource in /home/f/forum/vbseo_sitemap/vbseo_sitemap_functions.php604

  8. #8
    Junior Member
    Real Name
    Maurício
    Join Date
    May 2008
    Location
    Porto Alegre, RS, Brazil
    Posts
    5
    Liked
    0 times
    Hi,

    Same kind of error (table xxxxxx doesn't exist), same table...
    Any help available?

    By the way... Identical vB, vBSEO and vBSEO Sitemap versions.

    []s

    MaurícioSB

    Quote Originally Posted by UnderEstimated View Post
    Code:
    Database error in vBulletin 3.7.0:
     
    Invalid SQL:
     
                            SELECT t_threadid,count(*) as cnt
                            FROM linkback
                            GROUP BY t_threadid;
     
    MySQL Error   : Table 'friendsk_forum.linkback' doesn't exist
    Error Number  : 1146
    Request Date  : Sunday, May 4th 2008 @ 09:17:58 PM
    Error Date    : Sunday, May 4th 2008 @ 09:17:59 PM
    Script        : http://www.friendskorner.com/forum/v...eo_sitemap.php
    Referrer      : vBSEO Google / Yahoo Sitemap for vBulletin
     
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    vBulletin 3.7.0 Gold
    vBSEO 3.2.0 RC4
    vBSEO Sitemap 2.1

  9. #9
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    click the link in the 2nd post of this thread

  10. #10
    Junior Member
    Real Name
    Maurício
    Join Date
    May 2008
    Location
    Porto Alegre, RS, Brazil
    Posts
    5
    Liked
    0 times

    Thank You!

    Thank You !

    Quote Originally Posted by briansol View Post
    click the link in the 2nd post of this thread

  11. #11
    Senior Member UnderEstimated's Avatar
    Real Name
    Kaleem
    Join Date
    May 2006
    Location
    NJ
    Posts
    267
    Liked
    10 times
    What happened to my error lol

  12. #12
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    Make sure that you have 0777 permissions for vbseo_sitemap/data/ folder and 0666 for all files inside that folder.

  13. #13
    Senior Member UnderEstimated's Avatar
    Real Name
    Kaleem
    Join Date
    May 2006
    Location
    NJ
    Posts
    267
    Liked
    10 times
    Quote Originally Posted by Oleg Ignatiuk View Post
    Make sure that you have 0777 permissions for vbseo_sitemap/data/ folder and 0666 for all files inside that folder.
    Great!, Worked.

Similar Threads

  1. Fatal Error Upon Upgrading to vBSEO 3.1
    By 908765 in forum Troubleshooting
    Replies: 2
    Last Post: 11-18-2007, 09:21 PM
  2. Upgrading from 1.7 to 2.0
    By jbartle in forum Troubleshooting
    Replies: 4
    Last Post: 04-13-2007, 04:49 PM

Tags for this Thread

Posting Permissions

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