Ayuda! Error Incorrect file format 'sigparsed'

Flareon Seguir

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
5 Feb 2013
Mensajes
8
Ayuda porfavor el foro me comenzo a tirar este error al querer ingresar a todos los post!

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

Invalid SQL:

        SELECT
            post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
            user.*, userfield.*, usertextfield.*,
            icon.title as icontitle, icon.iconpath,
            avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
            spamlog.postid AS spamlog_postid,
            deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
            
            editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
            editlog.reason AS edit_reason, editlog.hashistory,
            postparsed.pagetext_html, postparsed.hasimages,
            sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
            sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
            IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
            
            
        FROM post AS post
        LEFT JOIN user AS user ON(user.userid = post.userid)
        LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
        LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
        LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
        LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
            LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
        LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
        LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 7 AND postparsed.languageid = 2)
        LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 7 AND sigparsed.languageid = 2)
        LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
        
            
        WHERE post.postid IN (04702132)
        ORDER BY post.dateline;

MySQL Error   : Incorrect file format 'sigparsed'
Error Number  : 130
Request Date  : Wednesday, March 27th 2013 @ 11:00:32 PM
Error Date    : Wednesday, March 27th 2013 @ 11:00:32 PM
Script        : 
Referrer      : 
IP Address    : 
Username      : Admin
Classname     : vB_Database
MySQL Version : 5.1.53-community
 

CarcaBot

Épsilon
Verificación en dos pasos activada
Desde
5 Ago 2008
Mensajes
910
debes borrar la tabla sigparsed desde phpmyadmin o desde el panel de control -> Mantenimiento -> Ejecutar Consulta SQL

Insertar CODE, HTML o PHP:
[I]DROP TABLE IF EXISTS sigparsed;[/I]

luego volvemos a crear nuevamente la tabla sigparsed desde el phpmyadmin o desde el panel de control -> Mantenimiento -> Ejecutar Consulta SQL

Insertar CODE, HTML o PHP:
CREATE TABLE IF NOT EXISTS `sigparsed` (
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `signatureparsed` mediumtext,
  `hasimages` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`,`styleid`,`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ya que no te funciona reparando la tabla es la unica forma que puede funcionarte nuevamente otra opcion es que si tienes un backup de tu base de datos que hayas hecho en algun momento puedes eliminar la tabla y sustituirla por tu backup (esto se hace si tuvieses un backup del mysql de tu foro). Suerte
 

Flareon

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
5 Feb 2013
Mensajes
8
Pase ambas querys y me dice 0 rows affected.. :S el problema persiste
 

Flareon

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
5 Feb 2013
Mensajes
8
Sigo con el problema cada vez q abro un post tira ese error :s
 

CarcaBot

Épsilon
Verificación en dos pasos activada
Desde
5 Ago 2008
Mensajes
910
el vbulletin nulled que tienes instalado esta obsoleto ya te lo dije via skype. suerte null
 

Flareon

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Desde
5 Feb 2013
Mensajes
8
el vbulletin nulled que tienes instalado esta obsoleto ya te lo dije via skype. suerte null

Disculpame vi tu MP pero jamas te agregue al Skype. Te habras confundido de persona

- - - - - - - - - - doble respuesta - - - - - - - - - -

Alguien mas tiene idea como puedo solucionar este error?

Tambien al querer entrar al perfil de cualquier usuario tira esto :

MySQL Error : Incorrect file format 'sigpic'
Error Number : 130


Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions, IF(userlist1.friend = 'yes', 1, 0) AS isfriend, IF (userlist1.friend = 'pending' OR userlist1.friend = 'denied', 1, 0) AS ispendingfriend, IF(userlist1.userid IS NOT NULL, 1, 0) AS u_iscontact_of_bbuser, IF (userlist2.friend = 'pending', 1, 0) AS requestedfriend, IF(userlist2.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo_chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)LEFT JOIN userlist AS userlist1 ON (userlist1.relationid = user.userid AND userlist1.type = 'buddy' AND userlist1.userid = 80898)LEFT JOIN userlist AS userlist2 ON (userlist2.userid = user.userid AND userlist2.type = 'buddy' AND userlist2.relationid = 80898)
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
WHERE user.userid = 80898;
 
Arriba