مشاكل وحلول قواعد البيانات
 

بسم الله الرحمن الرحيم


سوف يكون هذا الموضوع شامل باذن الله وخاص بمشاكل قواعد البيانات والحلول لها



فكل من يواجه مشكله بقواعد البيانات يقوم بوضع المشكله



وباذن الله سوف اقوم بوضع الحل له فى وقت وجيز باذن الله



والله الموفق

هذه بعض المشاكل فى القواعد والحلول لها



المشكله


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



الحل
ازرع الامرين من خلال phpmy admin

الامر الاول

ALTER TABLE `forum` ADD `lastthread` CHAR( 250 ) NOT NULL ;

الامر الثانى

ALTER TABLE `forum` ADD `lastthreadid` INT( 10 ) NOT NULL ;


================================================== ==========

المشكله

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



الحل


قم بعمل اصلاح لقاعده البيانات rapair

وقم بعمل تحديث للعدادات


================================================== ==========


المشكله
Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "32%" OR u.downloads LIKE "%32%" OR u.downloads LIKE "%32" ORDER BY u.username ASC
mysql error: Unknown column 'u.downloads' in 'where clause'

mysql error number: 1054


الحل


ازرع الامر التالي


ALTER TABLE `user` ADD `downloads` text NOT NULL;


================================================== =========



المشكلة

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


الحل


قم بعمل اصلاح لقواعد البيانات


================================================== =========


Invalid SQL:

SELECT
user.username, (user.options &amp; 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 &gt; 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



الحل

ازرع الامرين


الامر الاول

DELETE FROM session;


الامر الثانى


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',
dcilocation varchar(255) NOT NULL default '',
althash varchar(32) NOT NULL default '',
baddcilocation 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
****** : http://www.3jaib.net/vb/index.php?styleid=17
Referrer : http://www.3jaib.net/vb/admincp/temp...hp?do=mo dify
IP Address : 82.148.97.67
Username :
Classname : vb_database



الحل



ازرع الامر هذا من phpmyadmin


ALTER TABLE `language` ADD INDEX ( `phrasegroup_global` )




===========================================


ملحوظه :

اذا لم تجد مشكلتك من المشاكل التى ذكرت قم بكتابه مشكلتك وسوف اعطى لك الحل باذن الله



لا تنسونا من صالح الدعاء

وايضا قبل كل شىء


انصحكم بزياره الرابط التالى


http://www.arabwebtalk.com/showthread.php?t=85965


وقراءه الشرح وكيفيه معرفه خطأ قاعده البيانات


تحياتى

المشكلة

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT
SUM(IF(readtime <> 0, 1, 0)) AS confirmed,
SUM(IF(readtime = 0, 1, 0)) AS unconfirmed
FROM pmreceipt
WHERE userid = 19472;


طبعآ هذا الكلام كله بعد الترقية




ومشكلة ثانية بعد الترقية جيت بحدث تحديث أسماء الأعضاء تطلعي مشكلة ثانية اللي هي



Database error in vBulletin 3.6.3:

Invalid SQL:

UPDATE pmreceipt SET
tousername = 'admin'
WHERE touserid = 1;

MySQL Error : Table 'w_vb.pmreceipt' doesn't exist
Error Number : 1146
Date : Monday, November 27th 2006 @ 03:20:36 AM
Script : http://www.00000.com/vb/admincp/misc...pdateuserna mes
Referrer : http://www.0000.com/vb/admincp/misc.php?do=chooser
IP Address :
Username : admin
Classname :



الحل


CREATE TABLE `pmreceipt` (
`pmid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`touserid` int(10) unsigned NOT NULL default '0',
`tousername` varchar(100) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`sendtime` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
`denied` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pmid`),
KEY `userid` (`userid`),
KEY `touserid` (`touserid`)
) TYPE=MyISAM;




مشكلتين وهما عند دخول لوحة التحكم

تظهر هذا


MySQL Error : Table 'lolo4_lolo4.adminmessage' doesn't exist
Error Number : 1146
Date : Wednesday, August 23rd 2006 @ 08:48:06 PM
Script : http://www.xxxx.net/vbp/admincp/index.php?do=home
Referrer : http://www.xxxx.net/vbp/admincp/index.php?do=nav
IP Address : 62.135.25.36
Username : admin
Classname : vb_database</textarea></form>


والثانية هذا عند تعديل ملف لأى عضو بعد لما اضغط حفظ يطلع لى هذا الرسالة

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Wednesday, August 23rd 2006 @ 09:13:45 PM
Script : http://www.xxxxx.net/vbp/admincp/user.php?do=updat e
Referrer : http://www.xxxx.net/vbp/admincp/use...=edit&amp;u= 134
IP Address : 62.135.25.36
Username : admin
Classname : vb_database</textarea></form>


الحل


الاولي اكيد وانته ترقي تجازوت خطوة وهو جدول رسائل الادمن وها جدول جديد بالنسخة
نفذ الامر

كود:

DROP TABLE IF EXISTS adminmessage;
CREATE TABLE `adminmessage` (
`adminmessageid` int(10) unsigned NOT NULL auto_increment,
`varname` varchar(250) NOT NULL default '',
`dismissable` smallint(5) unsigned NOT NULL default '0',
`script` varchar(50) NOT NULL default '',
`action` varchar(20) NOT NULL default '',
`execurl` mediumtext NOT NULL,
`method` enum('get','post') NOT NULL default 'post',
`dateline` int(10) unsigned NOT NULL default '0',
`status` enum('undone','done','dismissed') NOT NULL default 'undone',
`statususerid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`adminmessageid`),
KEY `script_action` (`script`,`action`),
KEY `varname` (`varname`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;



الثاني نفذ


كود:

ALTER TABLE `user` ADD `warnings` INT(10) UNSIGNED DEFAULT '0' NOT NULL;





===================================

المشكله



Database error in vBulletin 3.6.0:

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,
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,
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(displaygroupid=0, user.usergroupid, 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 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 = 39 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 39 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,20537,20538,20539,20560,20561,20566,20567,20570 ,20572,20573)
ORDER BY post.dateline;

MySQL Error : Unknown column 'customavatar.width' in 'field list'
Error Number : 1054
Date : Monday, October 16th 2006 @ 07:56:26 AM
****** : http://www.xxxxx.com/vb/showthread.p...hreadid= 2637
Referrer :
IP Address : 63.146.104.148
Username : xxxxx
Classname : vb_database



الحل


نفذ الامرين هذا


ALTER TABLE `customavatar` ADD `width` smallint(5) unsigned NOT NULL default '0';

ALTER TABLE `customavatar` ADD `height` smallint(5) unsigned NOT NULL default '0';



تحياتى

مجهود طيب وجميل منك اخوي

تحيتي