TaXeNu
عدد المشاركات : 185 التقييم : 560 تاريخ التسجيل : 08/04/2010 الموقع : موقعي معروف :$
| موضوع: حلول ومشاكل قواعد البيانات 27/10/10, 12:44 pm | |
| السلام عليكم هنا ان شاء الله تجد مشاكل وحلول قواعد البيانات المشكله Invalid SQL: SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount FROM forum AS forum
mysql error: Unknown column 'lastthread' in 'field list'
mysql error number: 1054
Date: Monday 30th of May 2005 10:57:27 AMالحل ازرع ها الامرين رمز PHP: [COLOR="Green"]ALTER TABLE `forum` ADD `lastthread` CHAR( 250 ) NOT NULL ;[/COLOR] رمز PHP: [COLOR="green"]ALTER TABLE `forum` ADD `lastthreadid` INT( 10 ) NOT NULL ;[/COLOR] ================================================== ====== المشكلة : Invalid SQL: SELECT whoviewed FROM thread WHERE threadid = 5879 mysql error: Unknown column 'whoviewed' in 'field list'
mysql error number: 1054
Date: Tuesday 31st of May 2005 02:02:03 PMالحل اعمل اصلاح للجداول وقاعدة البيانات================================================= المشكله Invalid SQL: SELECT u.userid, u.username FROM user uWHERE u.downloads LIKE "32%" OR u.downloads LIKE "%32%" OR u.downloadsLIKE "%32" ORDER BY u.username ASC mysql error: Unknown column 'u.downloads' in 'where clause'
mysql error number: 1054الحل ازرع الامر التالي رمز PHP: [COLOR="Green"]ALTER TABLE `user` ADD `downloads` text NOT NULL;[/COLOR] ================================================== = المشكلة Database error in vBulletin 3.0.7: Invalid SQL: UPDATE poll SET votes = '1|||0|||0|||0', voters = voters + 1, lastvote = 1118582446 WHERE pollid = 2 mysql error: Unknown column 'lastvote' in 'field list' mysql error number: 1054 Date: Sunday 12th of June 2005 10:20:46 AMالحل ازرع الامر التالي ALTER TABLE `poll` ADD `lastvote` INT(15) DEFAULT '0' NOT NULL;======================================== المشكلة Database error in vBulletin :
Link-ID == false, connect failed mysql error:
mysql error number: 0
Date: Monday 13th of March 2006 03:16:31 AMالحل قاعدة البيانات فصله من السيرفر========================================= المشكله Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg, post.pagetext AS preview, thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid, thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach, hiddencount , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN (0,1478,1394,1447,1489,1487,1485,1481,1370,1476,13 59,1421,1424,1269,1387,1231,1348,1239,1437,1417,14 48,91,460,420,507,1395) ORDER BY sticky DESC, thread.lastpost DESC;
MySQL Error : Can't open file: 'post.MYI'. (errno: 144) Error Number : 1016 Date : Sunday, March 5th 2006 @ 09:16:17 AMالحل اصلاح قواعد البيانات والجداولوقالبآ ما يجيك هذا الخطاء Can't open file:xxxMYI================================================ المشكلة Invalid SQL:
SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1141921235 ORDER BY username ASC;
MySQL Error : Can't open file: 'session.MYI' (errno: 145) Error Number : 1016 Date : Thursday, March 9th 2006 @ 08:35:36 AMالحل ازرع الامرين رمز PHP: DELETE FROM session; رمز PHP: CREATE TABLE session ( sessionhash varchar(32) NOT NULL default '', userid int(10) unsigned NOT NULL default '0', host varchar(15) NOT NULL default '', lastactivity int(10) unsigned NOT NULL default '0', styleid smallint(5) unsigned NOT NULL default '0', location varchar(255) NOT NULL default '', althash varchar(32) NOT NULL default '', badlocation tinyint(3) unsigned NOT NULL default '0', inforum smallint(5) unsigned NOT NULL default '0', inthread int(10) unsigned NOT NULL default '0', incalendar int(10) unsigned NOT NULL default '0', loggedin smallint(5) unsigned NOT NULL default '0', idhash varchar(32) NOT NULL default '', useragent varchar(100) NOT NULL default '', bypass smallint(6) NOT NULL default '0', PRIMARY KEY (sessionhash) ) TYPE=HEAP; ============================ المشكلة ======== Database error in vBulletin 3.5.4: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_holiday AS phrasegroup_holiday, language.phrasegroup_global AS phrasegroup_global, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid =user.userid) INNER JOIN language AS language ON (language.languageid =IF(user.languageid = 0, 5, user.languageid)) WHERE user.userid = 358; MySQL Error : Unknown column 'language.phrasegroup_global' in 'field list' Error Number : 1054 Date : Saturday, May 20th 2006 @ 08:16:50 AM ****** : [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]Referrer : [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]IP Address : 82.148.97.67 Username : Classname : vb_database ======================= الحل ازرع ها الامر رمز PHP: ALTER TABLE `language` ADD INDEX ( `phrasegroup_global` ) | |
|