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

Eng Ahmed · 26 يونيو 2008

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

السلام عليكم اخواني اعضاء الدعم العربي التطويري

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

المشكله

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

الحل

الحل
ازرع ها الامرين

كود:

[COLOR=Green]ALTER TABLE `forum` ADD `lastthread` CHAR( 250 ) NOT NULL ;[/COLOR]

كود:

[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 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

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

[color="Green"]ALTER TABLE `user` ADD `downloads` text NOT NULL;[/color]

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

المشكلة

Database error in vBulletin 3.x.x:

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.x.x:

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
****** : http://www.3jaib.net/vb/index.php?styleid=17
Referrer : http://www.3jaib.net/vb/admincp/template.php?do=modify
IP Address : 82.148.97.67
Username :
Classname : vb_database

=======================
الحل
ازرع ها الامر

PHP:

ALTER TABLE `language` ADD INDEX ( `phrasegroup_global` )[/php
]

[CENTER]
[B]==================================================[/B]
المشكلة[QUOTE]
[COLOR=Red]Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT imagecategorypermission.imagecategoryid, usergroupid
FROM imagecategorypermission AS imagecategorypermission, imagecategory AS imagecategory
WHERE imagetype = 2
AND imagecategorypermission.imagecategoryid = imagecategory.imagecategoryid
ORDER BY imagecategory.displayorder;

MySQL Error : Table 'al7alem_7alem.imagecategorypermission' doesn't exist
Error Number : 1146
Date : Friday, March 17th 2006 @ 08:51:43 PM
Script : [URL]http://www.al7alem.com/vb/editpost.p...tpost&p=109084[/URL]
Referrer : [URL]http://www.al7alem.com/vb/showthread...084#post109084[/URL]
IP Address : 212.138.47.23
Username : al7alem
Classname : vb_database[/COLOR]
[/QUOTE]

الحل

ازرع ها الجدولين
 	

 	[LEFT] 		 			 [CODE]CREATE TABLE `imagecategory` ( 
  `imagecategoryid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(255) NOT NULL default '', 
  `imagetype` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`imagecategoryid`) 
) TYPE=MyISAM AUTO_INCREMENT=4 ;[/CODE][COLOR=#000000][COLOR=#007700]  
[/COLOR][COLOR=#0000BB][/COLOR] [/COLOR]  		 	[/LEFT]
 
الثاني
[CODE]

 	 		 			 CREATE TABLE `imagecategorypermission` ( 
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  KEY `imagecategoryid` (`imagecategoryid`,`usergroupid`) 
) TYPE=MyISAM;  [/CODE
]
[B]==================================================

[/B]المشكلة[QUOTE]

[COLOR=Red]Database error in vBulletin 3.0.13:

Invalid SQL: 
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 76
mysql error: Unknown column 'avatardata' in 'field list'

mysql error number: 1054

Date: Monday 13th of March 2006 03:28:16 PM
Script: [URL]http://www.7baib.net/vb/member.php?userid=76[/URL]
Referer: [URL]http://www.7baib.net/vb/showthread.php?t=4841[/URL]
Username: 
IP Address: 212.138.113.12[/COLOR]
[/QUOTE]
الحل
 	 [CODE] 	 		 			 ALTER TABLE `user` ADD `avatardata` INT(10) UNSIGNED DEFAULT '0' NOT NULL;[/CODE]

[B]==================================================
[/B]اذا جاك هذا الخطاء
محل الاكسات راح يكون اسم ملف

[COLOR=Red]Table 'xxxx_xxxxx' doesn't exist[/COLOR]


معاتها في جدول مفقود لديك


[B]==================================================


[/B]

[/CENTER]
[/LEFT]


[/CENTER]
[/RIGHT]
[/CENTER]
 [/CENTER]
 [/CENTER]

Eng Ahmed · 26 يونيو 2008

المشكلة

Database Error

There seems to have been a slight problem with the اااااااااااااااااااااااdatabase.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT maxnewthreadtime AS time FROM usergroup
WHERE usergroupid=6

mysql error: Unknown column 'maxnewthreadtime' in 'field list'

mysql error number: 1054

Date: Monday 05th of September 2005 11:54:10 AM
Script: http://www.xxxxxxx.com/vb/newthread....thread&f=2
Referer: http://www.xxxxxxxx.com/vb/forumdisplay.php?f=2
Username: xxxxxxxxx
IP Address: 233.235.90.171

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

كود:

[COLOR=#000000][COLOR=#0000bb]ALTER TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]usergroup[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]maxnewthreadtime[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]INT[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]UNSIGNED [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#dd0000]'0' [/COLOR][COLOR=#0000bb]NOT NULL[/COLOR][COLOR=#007700];  [/COLOR][/COLOR]

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

المشكلة

حذف جدول word

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT wordid, title FROM word WHERE title IN ('','مشاركة','قلق،','بكاء','،','نرفزة','،','أعراض' ,'متلازمة','ما','قبل','الدوره','الشهريّه','فما','ه و','هذا','المرض؟','شكرا','يا','أم','الطيب','على',' هذا','الموضوع');

MySQL Error : Table 'at3ad_vb.word' doesn't exist
Error Number : 1146

ازرع الجدول

PHP:

 	 		 			 CREATE TABLE `word` ( 
  `wordid` int(10) unsigned NOT NULL auto_increment, 
  `title` char(50) NOT NULL default '', 
  PRIMARY KEY  (`wordid`), 
  UNIQUE KEY `title` (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

Eng Ahmed · 26 يونيو 2008

عند اضافة مرفقات واختار استعراض واظغط على زر رفع المرفقات يظهر لي الخطأ هذا

Database error in vBulletin 3.x.x:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO moderatorlog
(`userid`, `dateline`, `type`, `forumid`, `threadid`, `postid`, `pollid`, `attachmentid`, `ipaddress`, `action`)
VALUES
('4015', '1143071453', '12', '39', '0', '0', '0', '447', '212.138.47.17', '');

MySQL Error : Unknown column 'ipaddress' in 'field list'
Error Number : 1054
Date : Wednesday, March 22nd 2006 @ 06:50:54 PM
Script : http://www.sh4bl.com/vb/newattachment.php
Referrer : http://www.sh4bl.com/vb/newattachmen...6b88a800670c41
IP Address : 212.138.47.17
Username :
Classname : vb_database

ازرع ها الامر

كود:

ALTER TABLE `moderatorlog` ADD `ipaddress` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

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

المشكلة

Database error in vBulletin 3.x.x

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Monday, November 7th 2005 @ 05:49:20 PM

الحل

كلم المستضيف ملف tmp ممتلئ
================================================
المشكلة

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

SELECT username, userid, birthday
FROM user
WHERE (birthday LIKE '03-29-%' OR birthday LIKE '03-30-%')
AND usergroupid IN (0, 6, 7, 2, 5)
AND showbirthday = 2
AND lastactivity >= 1141125827;

MySQL Error : Unknown column 'showbirthday' in 'where clause'
Error Number : 1054
Date : Thursday, March 30th 2006 @ 01:23:47 PM
Script : http://www.al-amasi.com/vbno/
Referrer :
IP Address : 212.138.47.17
Username : admin
Classname : vb_database

ازرع ها الامر

كود:

ALTER TABLE `user` ADD `showbirthday` MEDIUMBLOB NOT NULL;

او هذا

كود:

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

أسير العيون · 26 يوليو 2008

شرح جميل

يعطيك العافية

lokmen · 27 أبريل 2009

وماحل هذه المشكلة

الخطوة 2 الاتصال بقاعدة البيانات
محاولة الاتصال بقاعدة البيانات
connect failed: Unexpected error from the database.
Error رقم: 1046
error وصف الخطا: Cannot use database
please ensure that the database and server is correctly configured and try again.

للنسخة3.8.1
مع العلم اني تاكدت من تعديل ملف الكونفيغ مرات عديدة
وقمت بالتحقق من قاعدة البيانات

البحث

البحث

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

Eng Ahmed

ادارة المنتدى

Eng Ahmed

ادارة المنتدى

Eng Ahmed

ادارة المنتدى

أسير العيون

عضو جديد

lokmen

عضو جديد