- Desde
- 26 Jul 2012
- Mensajes
- 4
[Solucionado] Error base de datos al generar sitemap de vbseo
Bueno, ya he tenido varios errores con esto. Resulta que estoy intentando generar un sitemap de vbseo (vbseo sitemap generator) y me encuentro con este error al realizar la tarea programada:
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 : Thursday, August 16th 2012 @ 03:03:54 PM
Error Date : Thursday, August 16th 2012 @ 03:03:54 PM
Script : http://midominio.net/admincp/cronadmin.php?do=runcron&cronid=42
Referrer : http://midominio.net/admincp/cronadmin.php?do=modify
IP Address : 190.176.##.787
Username : roderjit
Classname : vB_Database
MySQL Version : 5.5.25a
Espero me puedan ayudar !
Bueno, ya he tenido varios errores con esto. Resulta que estoy intentando generar un sitemap de vbseo (vbseo sitemap generator) y me encuentro con este error al realizar la tarea programada:
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 : Thursday, August 16th 2012 @ 03:03:54 PM
Error Date : Thursday, August 16th 2012 @ 03:03:54 PM
Script : http://midominio.net/admincp/cronadmin.php?do=runcron&cronid=42
Referrer : http://midominio.net/admincp/cronadmin.php?do=modify
IP Address : 190.176.##.787
Username : roderjit
Classname : vB_Database
MySQL Version : 5.5.25a
Espero me puedan ayudar !