عندى مشكلة خطيرة بالمنتدى منو يساعدنى
عندى مشكلة عويصة بالمنتدى وما لاقيلها حل ياريت الاقى حل هنى المشكلة كل ما افتح موضوع بالمنتدى تطلعلى رسالة
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
رد: عندى مشكلة خطيرة بالمنتدى منو يساعدنى
اخوى ابو راشد شو الحل ما رديت على