عندى مشكلة خطيرة بالمنتدى منو يساعدنى

[نبض الامارات]

عندى مشكلة عويصة بالمنتدى وما لاقيلها حل ياريت الاقى حل هنى المشكلة كل ما افتح موضوع بالمنتدى تطلعلى رسالة
Database error in vBulletin 3.6.1:

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.useri d) AS hascustomavatar, customavatar.dateline AS avatardateline,customavat ar.width AS avwidth,customavatar.heig ht AS avheight,
level,
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,
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.reputatio nlevelid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
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 = 14)

WHERE post.postid IN (0,5065)
ORDER BY post.dateline;

MySQL Error : Table ءءءءءءءءءءء.post_parsed' doesn't exist
Error Number : 1146
Date : Saturday, September 30th 2006 @ 05:22:31 PM
Script : http://www.nabduae.com/vb/showthread.php?t=969
Referrer :
IP Address : ءءءءءءءءءءءءءء
Username : ءءءءءءءءءءء
Classname :ءءءdatabase

[المودة]

جرب تنفيذ هذا الإستعلام لقاعدة بيانات المنتدى :

DROP TABLE IF EXISTS `postparsed`;
CREATE TABLE `postparsed` (
  `postid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `hasimages` smallint(6) NOT NULL default '0',
  `pagetext_html` mediumtext,
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`postid`,`styleid`,`languageid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

تحياتي .

[نبض الامارات]

اخوى ابو راشد اولا شكرا على اهتمامك بس انا سويت الى خبرتنى علية والمشكلة بعدها وهالى ظهرلى يوم حطيتها نفس الشى

الخاص بك تم تنفيذه بنجاح SQL-إستعلامإستعلام-SQL:DROP TABLE IF EXISTS `postparsed` ;# MySQL قام بإرجاع نتيجة إعداد فارغه (مثلاً. صف صفري).
CREATE TABLE `postparsed` (
`postid` int( 10 ) unsigned NOT NULL default '0',
`dateline` int( 10 ) unsigned NOT NULL default '0',
`hasimages` smallint( 6 ) NOT NULL default '0',
`pagetext_html` mediumtext,
`styleid` smallint( 5 ) unsigned NOT NULL default '0',
`languageid` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `postid` , `styleid` , `languageid` ) ,
KEY `dateline` ( `dateline` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;# MySQL قام بإرجاع نتيجة إعداد فارغه (مثلاً. صف صفري).

والى يطلعلى بالمنتدى
Database error in vBulletin 3.6.1:

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.useri d) AS hascustomavatar, customavatar.dateline AS avatardateline,customavat ar.width AS avwidth,customavatar.heig ht AS avheight,
level,
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,
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.reputatio nlevelid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
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 = 14)

WHERE post.postid IN (0,4843,4844,4855,4993)
ORDER BY post.dateline;

MySQL Error : Table 'nabduae_vb.post_parsed' doesn't exist
Error Number : 1146
Date : Saturday, September 30th 2006 @ 09:11:38 PM
Script : http://www.nabduae.com/vb/showthread.php?t=901
Referrer :
IP Address : ءءءءءءءء
Username : ءءءءءءء
Classname : ءء_database

[نبض الامارات]

اخوى ابو راشد شو الحل ما رديت على