MySQL error in vbseo sitemap generator

roderjit Seguir

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
28 Ago 2012
Mensajes
7
Bueno al generar los sitemaps veo que ocurre un error en MySQL que es el siguiente, a ver si alguien me puede ayudar:



Insertar CODE, HTML o PHP:
Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagcontent AS tagcontent ON
(tagcontent.tagid = 1 AND tagcontent.contentid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 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 : Sunday, September 23rd 2012 @ 10:02:29 PM
Error Date : Sunday, September 23rd 2012 @ 10:02:29 PM
Script : [URL="http://activedz.com/foro/vbseo_sitemap/vbseo_sitemap.php"]http://mydomain.com/foro/vbseo_sitemap/vbseo_sitemap.php[/URL]
Referrer : [URL="http://activedz.com/foro/vbseo_sitemap/"]http://mydomain.com/foro/vbseo_sitemap/[/URL]
IP Address : 190.176.40.230
Username : No registrado
Classname : vB_Database
 
Arriba