Tweet
DELETE FROM post_parsed
WHERE dateline < 1160388203;
I have been seeing tons of database errors eversince the upgrade. site seems to be working ok, but the errors have me concerned. Does anyone know what any of this means?
here is one of the errors ----------------------
MySQL Error : Table 'chevythunder.post_parsed' doesn't exist
Error Number : 1146
another error------------------------------------
Invalid SQL:
SELECT text, languageid
FROM phrase
WHERE phrasetypeid = 2000
AND varname = 'search' AND languageid IN (-1, 0, 1);
MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
another error -----------------------------------------------
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,
level,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
WHERE post.postid IN (0,2989,2992,2993,2994,3004,3005,4050)
ORDER BY post.dateline;
MySQL Error : Table 'chevythunder.post_parsed' doesn't exist
Error Number : 1146
WHERE dateline < 1160388203;
I have been seeing tons of database errors eversince the upgrade. site seems to be working ok, but the errors have me concerned. Does anyone know what any of this means?
here is one of the errors ----------------------
MySQL Error : Table 'chevythunder.post_parsed' doesn't exist
Error Number : 1146
another error------------------------------------
Invalid SQL:
SELECT text, languageid
FROM phrase
WHERE phrasetypeid = 2000
AND varname = 'search' AND languageid IN (-1, 0, 1);
MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
another error -----------------------------------------------
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,
level,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
WHERE post.postid IN (0,2989,2992,2993,2994,3004,3005,4050)
ORDER BY post.dateline;
MySQL Error : Table 'chevythunder.post_parsed' doesn't exist
Error Number : 1146
Comment