Results 1 to 11 of 11

Sitemap alamıyorum

This is a discussion on Sitemap alamıyorum within the Türkçe forums, part of the General Discussion category; Vbseo yu 3.3.0 gold a sitemap generator u 2.5 e yükselttim 3.3.0 ile gelen Htaccess dosyasýnýda yükledim ancak sitemap alamýyorum, ...

  1. #1
    Member ikizbeyin's Avatar
    Real Name
    yuksel
    Join Date
    Aug 2008
    Posts
    69
    Liked
    0 times

    Sitemap alamıyorum

    Vbseo yu 3.3.0 gold a sitemap generator u 2.5 e yükselttim 3.3.0 ile gelen Htaccess dosyasınıda yükledim ancak sitemap alamıyorum, eski sitemap ları silip yenilerini oluşturmak için generate sitemap çalıştırmak istediğimde vbulletin database error geliyor.

    Nerede hata olabilir? ne yapmam lazım geliyor?
    There is no fear,
    I'm here.

  2. #2
    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
    Database hatasının içeriği nedir ?
    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

  3. #3
    Member ikizbeyin's Avatar
    Real Name
    yuksel
    Join Date
    Aug 2008
    Posts
    69
    Liked
    0 times
    Şöyle geliyor

    [SECTION START] member [9,593.1Kb mem used] [142,911s (+4,029s)]
    [create sitemap file] filename: sitemap_19.xml.gz, number of urls: 10000 [9,609.9Kb mem used] [142,913s (+2s)]
    [create sitemap in text format] part #20 [9,609.9Kb mem used] [142,913s (+0s)]
    [create sitemap file] filename: sitemap_20.xml.gz, number of urls: 10000 [9,610.3Kb mem used] [142,915s (+2s)]
    [create sitemap in text format] part #21 [9,610.4Kb mem used] [142,915s (+0s)]
    [create sitemap file] filename: sitemap_21.xml.gz, number of urls: 10000 [9,611.1Kb mem used] [142,917s (+2s)]
    [create sitemap in text format] part #22 [9,611.1Kb mem used] [142,917s (+0s)]
    [SECTION START] polls [10,049.4Kb mem used] [142,917s (+0s)]
    [SECTION START] blogs [10,049.4Kb mem used] [142,917s (+0s)]
    [SECTION START] albums [10,052.1Kb mem used] [142,917s (+0s)]
    [SECTION START] groups [10,052.1Kb mem used] [142,917s (+0s)]
    [SECTION START] tags [10,053.1Kb mem used] [142,917s (+0s)]
    Database errorThe turk-sat community database has encountered a problem.Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the www.turk-sat.com home page, then try to open another page.
    • Click the Back button to try another link.
    The turk-sat community - Powered by vBulletin forum technical staff have been notified of the error, though you may contact them if the problem persists.
    We apologise for any inconvenience.


    Bu arada ben ftp de data klasörü içine baktım ve 18 adet yeni sitemap gördüm ancak evvelden sitemap yapıldı diye mailime uyarı gelirdi şimdi gelmiyor.
    There is no fear,
    I'm here.

  4. #4
    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
    Lütfen sayfa kaynak kodunu kontrol edip bana hatanın içeriğini yapıştırın.

    Ancak sorununuz büyük ihtimalle mysql wait_timeout değeridir. Bu değeri 150 civarına getirip mysql service'ı restart atın.
    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

  5. #5
    Member ikizbeyin's Avatar
    Real Name
    yuksel
    Join Date
    Aug 2008
    Posts
    69
    Liked
    0 times
    [SECTION START] member [9,595.5Kb mem used] [143,394s (+477s)]<br/> [create sitemap file] filename: sitemap_22.xml.gz, number of urls: 10000 [9,612.1Kb mem used] [143,396s (+2s)]<br/> [create sitemap in text format] part #23 [9,612.2Kb mem used] [143,396s (+0s)]<br/> [create sitemap file] filename: sitemap_23.xml.gz, number of urls: 10000 [9,612.8Kb mem used] [143,398s (+2s)]<br/> [create sitemap in text format] part #24 [9,612.7Kb mem used] [143,398s (+0s)]<br/> [create sitemap file] filename: sitemap_24.xml.gz, number of urls: 10000 [9,613.3Kb mem used] [143,400s (+2s)]<br/> [create sitemap in text format] part #25 [9,613.2Kb mem used] [143,400s (+0s)]<br/> [SECTION START] polls [10,051.6Kb mem used] [143,400s (+0s)]<br/> [SECTION START] blogs [10,051.7Kb mem used] [143,400s (+0s)]<br/> [SECTION START] albums [10,054.2Kb mem used] [143,400s (+0s)]<br/> [SECTION START] groups [10,054.2Kb mem used] [143,400s (+0s)]<br/> [SECTION START] tags [10,055.2Kb mem used] [143,400s (+0s)]<br/> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>turk-sat community Database Error</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" /> <style type="text/css"> <!-- body { background-color: white; color: black; }#container { width: 400px; }#message { width: 400px; color: black; background-color: #FFFFCC; }#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }--> </style> </head> <body> <table cellpadding="3" cellspacing="5" id="container"> <tr> <td><img src="http://www.turk-sat.com/forum/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td> <td id="bodytitle" width="100%">Database error</td> </tr> <tr> <td class="bodytext" colspan="2">The turk-sat community database has encountered a problem.</td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td class="bodytext" colspan="2"> Please try the following:<ul> <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li> <li>Open the <a href="/">www.turk-sat.com</a> home page, then try to open another page.</li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> </td> </tr> <tr> <td class="bodytext" colspan="2">The turk-sat community - Powered by vBulletin forum technical staff have been notified of the error, though you may <a href="mailto:ikizbeyin@gmail.com">contact them</a> if the problem persists.</td> </tr> <tr> <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td> </tr> </table> <!--Database error in vBulletin 3.8.2:Invalid SQL:SELECT COUNT(*) as cnt,max(lastpost) as lastupdateFROM thread AS threadINNER JOIN tagthread AS tagthread ON(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)WHERE thread.forumid IN()AND thread.visible = 1AND thread.sticky IN (0, 1)AND thread.open &lt;&gt; 10GROUP BY tagthread.tagid;MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')AND thread.visible = 1AND thread.sticky IN (0, 1)' at line 5Error Number : 1064Request Date : Monday, May 25th 2009 @ 05:50:15 PMError Date : Monday, May 25th 2009 @ 05:50:22 PMScript : http://www.turk-sat.com/forum/vbseo_...ap.phpReferrer : vBSEO Google / Yahoo Sitemap for vBulletin Address : 85.107.175.215Username : UnregisteredClassname : vB_DatabaseMySQL Version : --> </body> </html>


    ****************************


    Burada yazılı username benim ve IP de benim IP im ancak beni unregistered olarak gösteriyor:(


    There is no fear,
    I'm here.

  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
    Lütfen içeriği code tagleri içerisine yapıştırır mısınız.Bu şekilde okunmuyor malesef.
    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
    Member ikizbeyin's Avatar
    Real Name
    yuksel
    Join Date
    Aug 2008
    Posts
    69
    Liked
    0 times
    Sayın Mert bey,

    Profesyonel ağızla konuşuyorsunuz ancak ben sizin kadar bilgi sahibi olsa idim zaten burada soru sormazdım.

    Bu nasıl yapılır???
    There is no fear,
    I'm here.

  8. #8
    Member ikizbeyin's Avatar
    Real Name
    yuksel
    Join Date
    Aug 2008
    Posts
    69
    Liked
    0 times
    Bunumu demek istiyorsunuz?


    [SECTION START] member [9,595.5Kb mem used] [143,394s (+477s)]<br/>

    [create sitemap file] filename: sitemap_22.xml.gz, number of urls: 10000 [9,612.1Kb mem used] [143,396s (+2s)]<br/>

    [create sitemap in text format] part #23 [9,612.2Kb mem used] [143,396s (+0s)]<br/>

    [create sitemap file] filename: sitemap_23.xml.gz, number of urls: 10000 [9,612.8Kb mem used] [143,398s (+2s)]<br/>

    [create sitemap in text format] part #24 [9,612.7Kb mem used] [143,398s (+0s)]<br/>

    [create sitemap file] filename: sitemap_24.xml.gz, number of urls: 10000 [9,613.3Kb mem used] [143,400s (+2s)]<br/>

    [create sitemap in text format] part #25 [9,613.2Kb mem used] [143,400s (+0s)]<br/>

    [SECTION START] polls [10,051.6Kb mem used] [143,400s (+0s)]<br/>

    [SECTION START] blogs [10,051.7Kb mem used] [143,400s (+0s)]<br/>

    [SECTION START] albums [10,054.2Kb mem used] [143,400s (+0s)]<br/>

    [SECTION START] groups [10,054.2Kb mem used] [143,400s (+0s)]<br/>

    [SECTION START] tags [10,055.2Kb mem used] [143,400s (+0s)]<br/>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html>

    <head>

    <title>turk-sat community Database Error</title>

    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

    <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />

    <style type="text/css">

    <!--

    body { background-color: white; color: black; }

    #container { width: 400px; }

    #message { width: 400px; color: black; background-color: #FFFFCC; }

    #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }

    .bodytext { font: 8pt/11pt verdana, arial, sans-serif; }

    a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }

    a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }

    -->

    </style>

    </head>

    <body>

    <table cellpadding="3" cellspacing="5" id="container">

    <tr>

    <td><img src="http://www.turk-sat.com/forum/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>

    <td id="bodytitle" width="100%">Database error</td>

    </tr>

    <tr>

    <td class="bodytext" colspan="2">The turk-sat community database has encountered a problem.</td>

    </tr>

    <tr>

    <td colspan="2"><hr /></td>

    </tr>

    <tr>

    <td class="bodytext" colspan="2">

    Please try the following:

    <ul>

    <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>

    <li>Open the <a href="/">www.turk-sat.com</a> home page, then try to open another page.</li>

    <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>

    </ul>

    </td>

    </tr>

    <tr>

    <td class="bodytext" colspan="2">The turk-sat community - Powered by vBulletin forum technical staff have been notified of the error, though you may <a href="mailto:ikizbeyin@gmail.com">contact them</a> if the problem persists.</td>

    </tr>

    <tr>

    <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>

    </tr>

    </table>





    <!--

    Database error in vBulletin 3.8.2:



    Invalid SQL:



    SELECT COUNT(*) as cnt,max(lastpost) as lastupdate

    FROM thread AS thread

    INNER JOIN tagthread AS tagthread ON

    (tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)

    WHERE thread.forumid IN()

    AND thread.visible = 1

    AND thread.sticky IN (0, 1)

    AND thread.open &lt;&gt; 10

    GROUP BY tagthread.tagid;



    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')

    AND thread.visible = 1

    AND thread.sticky IN (0, 1)' at line 5

    Error Number : 1064

    Request Date : Monday, May 25th 2009 @ 05:50:15 PM

    Error Date : Monday, May 25th 2009 @ 05:50:22 PM

    Script : http://www.turk-sat.com/forum/vbseo_...eo_sitemap.php

    Referrer : vBSEO Google / Yahoo Sitemap for vBulletin

    IP Address : 85.107.175.215

    Username : Unregistered

    Classname : vB_Database

    MySQL Version :

    -->





    </body>

    </html>

    There is no fear,
    I'm here.

  9. #9
    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
    Includes Tag opsiyonunu deaktif edin lütfen.
    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

  10. #10
    Member ikizbeyin's Avatar
    Real Name
    yuksel
    Join Date
    Aug 2008
    Posts
    69
    Liked
    0 times
    includes tag, sitemap generator içinde, bunu deaktif ettim, şimdi hata vermedi, sanırım düzeldi,

    size çok teşekkür ediyorum ve iyi çalışmalar diliyorum.

    Saygılar.
    There is no fear,
    I'm here.

  11. #11
    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
    Rica ederim , iyi çalışmalar
    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

Similar Threads

  1. Replies: 7
    Last Post: 03-13-2009, 02:47 PM
  2. Replies: 9
    Last Post: 12-26-2008, 03:40 PM
  3. sitemap generatorun yaptığı sitemap ile roottaki sitemap
    By chaostheory_ozzy in forum Türkçe
    Replies: 15
    Last Post: 07-07-2008, 07:12 AM
  4. Replies: 2
    Last Post: 06-11-2008, 04:26 AM
  5. vBSEO Sitemap Generator generated incorrect sitemap URL
    By X1C3W5 in forum Troubleshooting
    Replies: 2
    Last Post: 01-02-2008, 12:45 PM

Posting Permissions

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