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

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

Go Back   vBulletin SEO Forums > vBSEO Google/Yahoo Sitemap > Troubleshooting

Error after upgrading to 3.2 RC4 Error after upgrading to 3.2 RC4

Enhancing 80 million pages.

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

Reply

 

LinkBack Thread Tools
  #1  
Old 05-04-2008, 10:20 PM
Member
Big Board Administrator
  
Real Name: Kaleem
Join Date: May 2006
Location: NJ
Posts: 94
Send a message via MSN to UnderEstimated
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 05-04-2008, 10:51 PM
Senior Member
Big Board Administrator
  
Real Name: Dhillon
Join Date: Apr 2006
Location: Chandigarh/Glasgow
Posts: 299
vBSEO 3.2.0 Release Candidate 4
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 05-05-2008, 07:44 AM
Member
Big Board Administrator
  
Real Name: Kaleem
Join Date: May 2006
Location: NJ
Posts: 94
Send a message via MSN to UnderEstimated
Ok thank you notorious. Can someone tell me in /data/ the sitemap.gz files PERMISSION whould be what?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 05-05-2008, 10:32 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
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.
__________________
Oleg Ignatiuk / 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
  #5  
Old 05-05-2008, 03:37 PM
Member
Big Board Administrator
  
Real Name: Kaleem
Join Date: May 2006
Location: NJ
Posts: 94
Send a message via MSN to UnderEstimated
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 05-05-2008, 04:19 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
What exactly is the error you get?
__________________
Oleg Ignatiuk / 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
  #7  
Old 05-05-2008, 09:41 PM
Member
Big Board Administrator
  
Real Name: Kaleem
Join Date: May 2006
Location: NJ
Posts: 94
Send a message via MSN to UnderEstimated
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 05-06-2008, 01:05 AM
Junior Member
  
Real Name: Maurício
Join Date: May 2008
Location: Porto Alegre, RS, Brazil
Posts: 4
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 05-06-2008, 01:40 AM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
  
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 5,776
click the link in the 2nd post of this thread
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #10  
Old 05-06-2008, 04:18 AM
Junior Member
  
Real Name: Maurício
Join Date: May 2008
Location: Porto Alegre, RS, Brazil
Posts: 4
Thank You!
Thank You !

Quote:
Originally Posted by briansol View Post
click the link in the 2nd post of this thread
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #11  
Old 05-06-2008, 05:49 PM
Member
Big Board Administrator
  
Real Name: Kaleem
Join Date: May 2006
Location: NJ
Posts: 94
Send a message via MSN to UnderEstimated
What happened to my error lol
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #12  
Old 05-06-2008, 05:58 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
Make sure that you have 0777 permissions for vbseo_sitemap/data/ folder and 0666 for all files inside that folder.
__________________
Oleg Ignatiuk / 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
  #13  
Old 05-06-2008, 10:41 PM
Member
Big Board Administrator
  
Real Name: Kaleem
Join Date: May 2006
Location: NJ
Posts: 94
Send a message via MSN to UnderEstimated
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

Tags
error 3.2.0 rc4, vbseo sitemap error

« errors with sitemap | Error on Sitemap Creation »
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
Fatal Error Upon Upgrading to vBSEO 3.1 908765 Troubleshooting 2 11-18-2007 10:21 PM
Upgrading from 1.7 to 2.0 jbartle Troubleshooting 4 04-13-2007 05:49 PM


All times are GMT -4. The time now is 02:35 PM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.0 Release Candidate 2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.