Database error in vBulletin 3.8.4:
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 <> 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 : Wednesday, April 28th 2010 @ 02:43:25 AM
Error Date : Wednesday, April 28th 2010 @ 02:43:25 AM
Script :
http://www.xxx.com/vbseo_sitemap/vbseo_sitemap.php
Referrer :
http://www.xxx.com/vbseo_sitemap/index.php
IP Address : 88.226.139.191
Username : Kayıtsız Üye
Classname : vB_Database
MySQL Version :
-->
bu hata kodunu ama Include Tag Pages bu secenegi hayır yaptım duzeldı butun sitemabları silmistim data klasorundeki suan için Run Sitemap Generator
[homepage] [5,894.2Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,894.6Kb mem used] [0s (+0s)]
[SECTION START] showthread [5,894.8Kb mem used] [0s (+0s)]
[SECTION START] polls [5,894.9Kb mem used] [0s (+0s)]
[SECTION START] blogs [5,895.3Kb mem used] [0s (+0s)]
[SECTION START] albums [5,896.4Kb mem used] [0s (+0s)]
[SECTION START] groups [5,896.7Kb mem used] [0s (+0s)]
[SECTION START] blog tags [5,897.9Kb mem used] [0s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 3 [5,898.3Kb mem used] [0s (+0s)]
[create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 1 [5,899.0Kb mem used] [0s (+0s)]
Sitemap has been created. Click here to return [5,901.7Kb mem used] [2s (+2s)]
bu şekilde tammlıyor ama ftp data klasörüne dosya atmıyor