Database error in vBulletin 3.7.3:

imported_alyen Seguir

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
24 Abr 2008
Mensajes
6
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT COUNT(*) AS countFROM vb_threadWHERE visible IN (0,1,2)AND sticky IN (0,1)AND open <> 10AND dateline >= 1223190000;

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 'vb_threadWHERE visible IN (0,1,2)AND sticky IN (0,1)AND open <> 10AND dateline >' at line 1
Error Number : 1064
Request Date : Sunday, October 5th 2008 @ 01:42:47 AM
Error Date : Sunday, October 5th 2008 @ 01:42:52 AM
Script : http://xxxxxx/forum/admincp/index.php?do=home
Referrer : http://xxxxxx/forum/admincp/index.php
IP Address : 000000000
Username : Alyen
Classname : vB_Database
MySQL Version : 5.0.67-log

que se pude hacer ???
 

imported_Jhonnyf

Épsilon
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
6 Sep 2008
Mensajes
959
lo que hayas instalado en tu foro, esta armando mal el SQL
SELECT COUNT(*) AS countFROMvb_threadWHERE visible IN (0,1,2)AND sticky IN (0,1)AND open <> 10AND dateline >= 1223190000;

debería decir:
SELECT COUNT(*) AS count FROM vb_thread WHERE visible IN (0,1,2) AND sticky IN (0,1) AND open <> 10 AND dateline >= 1223190000;
 
Arriba