- Desde
- 21 Mar 2008
- Mensajes
- 272
hola, al intentar acceder a mi foro, me salia database error, y debajo una ventana con este error:
Insertar CODE, HTML o PHP:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
, allowsmilie, pagetext_html, hasimages, showsignature, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, thread.iconid AS threadiconid, iconpath AS threadiconpath, avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = post.userid) LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 11 AND postparsed.languageid = 2) LEFT JOIN sigparsed AS sigparsed ON (sigparsed.userid = user.userid AND sigparsed.styleid = 11 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON (sigpic.userid = post.userid) LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(8)
ORDER BY thread.dateline DESC
LIMIT 10;
MySQL Error : Column 'hasimages' in field list is ambiguous
Error Number : 1052
Date : Saturday, March 22nd 2008 @ 12:37:07 AM
Script : sale_la_url_de_mi_web
Referrer :
IP Address : mi ip
Username : Fire[PrEDaToR]
Classname : vB_Database
bien, olviden eso de hackeo, me da error al instalar el modulo noticias ¿como lo instalo? es que cuando le pongo en el módulo noticias foro de noticias---> y selecciono el foro de noticias, me sale ese error. ¿como lo soluciono'
