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

السلام عليكم

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


المشكله
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:
ALTER TABLE `forum` ADD `lastthread` CHAR( 250 ) NOT NULL ;
رمز PHP:
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

الحل

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

=================================================
المشكله
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


الحل
ازرع الامر التالي
رمز PHP:
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;

========================================
المشكلة