vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Board Optimization - vBSEO Search Engine XML Sitemap (https://vborg.vbsupport.ru/showthread.php?t=253516)

jscieza 11-13-2010 05:44 PM

Quote:

Originally Posted by jscieza (Post 2121342)
Why product's files are being marked as "File does not contain expected contents"?

Also, I have double checked that the file sitemap.xsl is in my server but the system still says "File not found".

Quote:

Originally Posted by Chuta (Post 2121468)
Hello,

Because they aren't part of vBulletin at all.

You're wrong.

In that case, it should say "File not recognized as part of vBulletin" instead of "File does not contain expected contents". Also, you didn't replied my second question: sitemap.xsl is being marked as "File not found" but the file is in the server.

Chuta 11-13-2010 05:58 PM

Quote:

Originally Posted by Neptun (Post 2121475)
this i found there

return $friendlyurl->get_url(false, $canonical);


i hope you can help me :) with the old sitemap i had no problems ....

What's the vBulletin version you are running?.

Chuta 11-13-2010 05:59 PM

Quote:

Originally Posted by Jigsaw! (Post 2121478)
Ah ok, well i got a new problem i unistalled everything for vBSEO and installed it again, i click Run Generator and get this.

Code:

[SECTION START] tags [8,142.5Kb mem used] [2,821s (+2,821s)]
Database Error        Database error
The Solo Host database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the solohost.com home page, then try to open another page.
    * Click the Back button to try another link.

The solohost.org forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.


Please take a look at your source code and paste here the SQL error you see.

Neptun 11-13-2010 05:59 PM

Quote:

Originally Posted by Chuta (Post 2121485)
What's the vBulletin version you are running?.

4.0.3 suite

★Slap 11-13-2010 06:06 PM

Quote:

Originally Posted by Chuta (Post 2121486)
Please take a look at your source code and paste here the SQL error you see.

Here you go.

Code:

[SECTION START] tags [8,142.4Kb mem used] [4,843s (+4,843s)]<br/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
        <title>Solo Host 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.hidden.com/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">Solo Host 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.hidden.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 www.hidden.com forum technical staff have been notified of the error, though you may <a href="mailto:jigsaw@solohost.org">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 4.0.8:

Invalid SQL:

                          SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
                          FROM vb_thread AS thread
                          INNER JOIN vb_tagcontent AS tagcontent ON
                                  (tagcontent.tagid = 13 AND tagcontent.contentid = thread.threadid)
                          WHERE thread.forumid IN()
                                  AND thread.visible = 1
                                  AND thread.sticky IN (0, 1)
                                  AND thread.open &lt;&gt; 10
                          GROUP BY tagcontent.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  : Saturday, November 13th 2010 @ 03:05:11 PM
Error Date    : Saturday, November 13th 2010 @ 03:05:11 PM
Script        : http://www.hidden.com/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.hidden.com/vbseo_sitemap/index.php
IP Address    : 81.178.197.130
Username      : Unregistered
Classname    : vB_Database
MySQL Version :
-->


</body>
</html>


Chuta 11-13-2010 06:17 PM

Quote:

Originally Posted by Neptun (Post 2121487)
4.0.3 suite

You should consider upgrading your instance to a more stable vB 4 version. I'll try to reproduce the issue on my dev. instance.

Chuta 11-13-2010 06:19 PM

Quote:

Originally Posted by Jigsaw! (Post 2121490)
Here you go.

Code:

Database error in vBulletin 4.0.8:

Invalid SQL:

                          SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
                          FROM vb_thread AS thread
                          INNER JOIN vb_tagcontent AS tagcontent ON
                                  (tagcontent.tagid = 13 AND tagcontent.contentid = thread.threadid)
                          WHERE thread.forumid IN()
                                  AND thread.visible = 1
                                  AND thread.sticky IN (0, 1)
                                  AND thread.open &lt;&gt; 10
                          GROUP BY tagcontent.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  : Saturday, November 13th 2010 @ 03:05:11 PM
Error Date    : Saturday, November 13th 2010 @ 03:05:11 PM
Script        : http://www.hidden.com/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.hidden.com/vbseo_sitemap/index.php
IP Address    : 81.178.197.130
Username      : Unregistered
Classname    : vB_Database
MySQL Version :


Please try to disable adding tags to your sitemaps and try to regenerate them again.

CRDeveloper 11-13-2010 09:14 PM

Im getting this in the first sitemap and others. Problem with characters...

https://vborg.vbsupport.ru/

How to fix?

★Slap 11-13-2010 09:50 PM

Quote:

Originally Posted by Chuta (Post 2121496)
Please try to disable adding tags to your sitemaps and try to regenerate them again.

OMG, It WORKED =D thanks so much Chuta it actually created the sitemap i can see it in the reports so does this mean it will automatically crawl into Google i don't have to do nothing right?

Code:

Google        Successful
Bing        Successful
Yahoo        Successful
Ask        Successful

Update
I was editing my settings and got another error once i pressed on Run Generator

Code:

[homepage] [8,138.3Kb mem used] [0s (+0s)]<br/>
[SECTION START] forumdisplay [8,141.4Kb mem used] [0s (+0s)]<br/>
[SECTION START] showthread [8,141.8Kb mem used] [0s (+0s)]<br/>
[SECTION START] polls [8,141.3Kb mem used] [0s (+0s)]<br/>
[create sitemap file] filename: sitemap_forum_1.xml.gz, number of urls: 1 [8,143.5Kb mem used] [0s (+0s)]<br/>
[archive homepage] [8,142.5Kb mem used] [0s (+0s)]<br/>
[SECTION START] forumdisplay archived [8,144.3Kb mem used] [0s (+0s)]<br/>
[SECTION START] showthread archived [8,144.7Kb mem used] [0s (+0s)]<br/>
[create sitemap file] filename: sitemap_archive_1.xml.gz, number of urls: 1 [8,145.9Kb mem used] [0s (+0s)]<br/>

[SECTION START] member [8,144.1Kb mem used] [0s (+0s)]<br/>
[create sitemap file] filename: sitemap_member_1.xml.gz, number of urls: 65 [8,560.5Kb mem used] [0s (+0s)]<br/>
[SECTION START] albums [8,486.5Kb mem used] [0s (+0s)]<br/>
[SECTION START] blogs [8,486.7Kb mem used] [0s (+0s)]<br/>
[SECTION START] blog tags [8,488.1Kb mem used] [0s (+0s)]<br/>
[create sitemap file] filename: sitemap_blog_1.xml.gz, number of urls: 1 [8,490.0Kb mem used] [0s (+0s)]<br/>
[SECTION START] groups [8,488.3Kb mem used] [0s (+0s)]<br/>
[create sitemap file] filename: sitemap_group_1.xml.gz, number of urls: 1 [8,491.4Kb mem used] [0s (+0s)]<br/>
[SECTION START] cms [8,490.0Kb mem used] [0s (+0s)]<br/>

[section] node_id: 1 [9,291.1Kb mem used] [0s (+0s)]<br/>
[create sitemap file] filename: sitemap_cms_1.xml.gz, number of urls: 4 [9,287.3Kb mem used] [0s (+0s)]<br/>
[addon module] vbseo_sm_calendar.php [9,281.9Kb mem used] [0s (+0s)]<br/>
[addon module] vbseo_sm_downloads.php [9,282.8Kb mem used] [0s (+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>Solo Host 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.solohost.org/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">Solo Host 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.solohost.org</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 www.solohost.org forum technical staff have been notified of the error, though you may <a href="mailto:jigsaw@solohost.org">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 4.0.8:

Invalid SQL:
SELECT id,name FROM vb_dl_cats ORDER BY `id`;

MySQL Error  : Table 'majestic_jigsaw.vb_dl_cats' doesn't exist
Error Number  : 1146
Request Date  : Saturday, November 13th 2010 @ 07:21:03 PM
Error Date    : Saturday, November 13th 2010 @ 07:21:03 PM
Script        : http://www.hidden.com/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.hidden.com/vbseo_sitemap/
IP Address    : 81.178.197.130
Username      : Unregistered
Classname    : vB_Database
MySQL Version :
-->


</body>
</html>


Chuta 11-14-2010 12:35 AM

Quote:

Originally Posted by ToxXxicas (Post 2121551)
Im getting this in the first sitemap and others. Problem with characters...

http://screensnapr.com/u/uef5fl.png

How to fix?

Hello,

Please try to change the accent words with common english characters. I mean:

From:

Code:

http://www.ticoracer.com/forum/showthread.php/54930-El-?til-Bot?n-Report
To:

Code:

http://www.ticoracer.com/forum/showthread.php/54930-El-util-Boton-Report


All times are GMT. The time now is 04:50 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01619 seconds
  • Memory Usage 1,805KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete