| |||||||
| المدوّنات | البحث | مشاركات اليوم | اجعل كافة المشاركات مقروءة |
 |
| | LinkBack | أدوات الموضوع |
| |||||
| ماذا تعني هذه الرسائل من قاعدة البيانات وكيف حلها كود: Database error in vBulletin 3.6.5: Invalid SQL: SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM user ORDER BY posts DESC LIMIT 0,; MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Error Number : 1064 Date : Tuesday, May 29th 2007 @ 11:21:54 PM Script : http://aaaa.org/vb/topXstats.php Referrer : IP Address : 1111111111111111 Username : ÛíÑ ãÓÌá Classname : vb_database ايضا جاء الاستفسار التالي كود: Invalid SQL:
SELECT
IF(votenum >= 2, votenum, 0) AS votenum,
IF(votenum >= 2 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, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, thread.stampid, stamps.title, stamps.icon AS stampicon, stamps.color
FROM thread AS thread
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2132 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN stamps AS stamps ON(thread.stampid = stamps.stampid)
WHERE thread.threadid IN (0,21081,7242,18456,20512,27132,27631,13122,10464,27322,25343,27073,4238,23908,25210,8266,26694,23753,20030,25374,25334,18366,25155,24757,20769,5642)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table 'xxxxxxx_vb3.stamps' doesn't exist
Error Number : 1146
Date : Monday, May 28th 2007 @ 01:20:22 AM
Script : http://www.xxxxxxx.com/vb/forumdisplay.php?f=45
Referrer : http://www.xxxxxxx.com/vb/
IP Address : 1111111111111111111111
Username : äÇÕÑ ÇáÔåÑí
Classname : vb_database كود: Database error in vBulletin 3.6.5:
Invalid SQL:
UPDATE administrator SET
navprefs = ''
WHERE userid = 1;
MySQL Error : Unknown column 'navprefs' in 'field list'
Error Number : 1054
Date : Monday, May 28th 2007 @ 01:17:16 AM
Script : http://www.xxxxxxx.com/vb/admincp/index.php?do=buildnavprefs&nojs=0&prefs=&dowhat=expand&id=vbulletin_24
Referrer : http://www.xxxxxxx.com/vb/admincp/index.php?do=nav
IP Address : 111111111111111111
Username : ÇÍãÏ ÇáÚáæí
Classname : vb_database
__________________ رحمك الله يا عبدالرحمن | |||||
|
| |||||
|
بالنسبه للخطأ الاول قم بزراعة هذا الامر في قاعدة البيانات كود PHP: بالنسبه للخطأ الثاني جرب تعمل إصلاح لقاعدة البيانات
__________________ الله لا إله إلا أنت سبحانك إني كٌنت من الظالمين | |||||
|
| |||||
|
شوف أخي الكريم في الخطأ الاول حقل infractiongroupid ناقص من جدول infractiongroup لذلك وضعت لك الامر الاول ليتم إضافة هذا الحقل و إعداداته كالتالي int(10) NOT NULL auto_increment; بمعني حقل رقمي مكون من 10 خانات لا يمكن ان يكون خالي ذات تعدد تلقائي و في حل المشكله الخاصه بالخطأ الثالث هو نفس فكرة حل مشكلة الخطأ الاول و هو فقدان حقل navprefs من جدول administrator بالتوفيق أخي العزيز و اي اسأله أنا حاضر
__________________ الله لا إله إلا أنت سبحانك إني كٌنت من الظالمين | |||||
|
| |||||
|
بالنسبة للأمر الأول أعطاني الخطأ التالي إستعلام-SQL: ALTER TABLE `infractiongroup` ADD `infractiongroupid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT MySQL قال: مستندات وثائقيه #1060 - Duplicate column name 'infractiongroupid' فياليت التوجيه
__________________ رحمك الله يا عبدالرحمن | |||||
|
| |||||
|
عادي يا غالي هذه المشكله تحدث معي كثيراً عند إضافة أوامر اصلاح قواعد البيانات لا تقلق من شأنها فقط أدخل علي جدول infractiongroup و تأكد أنه تم إضافة حقل infractiongroupid بمراجعة اسماء الحقول المضافه
__________________ الله لا إله إلا أنت سبحانك إني كٌنت من الظالمين | |||||
|
| |||||
|
طيب أخوي الأمر الثالث تم بنجاح اصلاح الجداول تم بالشكل التالي ولكن ظهرت مشكلة لثلاث جداول تقريبا فمال الحل بارك الله فيك Op Msg_type Msg_text xxxxxxx_vb3.access repair status OK xxxxxxx_vb3.adminhelp repair status OK xxxxxxx_vb3.administrator repair status OK xxxxxxx_vb3.adminlog repair status OK xxxxxxx_vb3.adminmessage repair status OK xxxxxxx_vb3.adminutil repair status OK xxxxxxx_vb3.announcement repair status OK xxxxxxx_vb3.announcementread repair status OK xxxxxxx_vb3.attachment repair status OK xxxxxxx_vb3.attachmentpermission repair status OK xxxxxxx_vb3.attachmenttype repair status OK xxxxxxx_vb3.attachmentviews repair status OK xxxxxxx_vb3.avatar repair status OK xxxxxxx_vb3.bbcode repair status OK xxxxxxx_vb3.calendar repair status OK xxxxxxx_vb3.calendarcustomfield repair status OK xxxxxxx_vb3.calendarmoderator repair status OK xxxxxxx_vb3.calendarpermission repair status OK xxxxxxx_vb3.cpsession repair note The storage engine for the table doesn't support r... xxxxxxx_vb3.cron repair status OK xxxxxxx_vb3.cronlog repair status OK xxxxxxx_vb3.customavatar repair status OK xxxxxxx_vb3.customprofilepic repair status OK xxxxxxx_vb3.datastore repair status OK xxxxxxx_vb3.deletionlog repair status OK xxxxxxx_vb3.editlog repair status OK xxxxxxx_vb3.event repair status OK xxxxxxx_vb3.externalcache repair status OK xxxxxxx_vb3.faq repair status OK xxxxxxx_vb3.forum repair status OK xxxxxxx_vb3.forumpermission repair status OK xxxxxxx_vb3.forumread repair status OK xxxxxxx_vb3.holiday repair status OK xxxxxxx_vb3.icon repair status OK xxxxxxx_vb3.imagecategory repair status OK xxxxxxx_vb3.imagecategorypermission repair status OK xxxxxxx_vb3.infraction repair status OK xxxxxxx_vb3.infractionban repair status OK xxxxxxx_vb3.infractiongroup repair status OK xxxxxxx_vb3.infractionlevel repair status OK xxxxxxx_vb3.language repair status OK xxxxxxx_vb3.mailqueue repair status OK xxxxxxx_vb3.moderation repair status OK xxxxxxx_vb3.moderator repair status OK xxxxxxx_vb3.moderatorlog repair status OK xxxxxxx_vb3.passwordhistory repair status OK xxxxxxx_vb3.paymentapi repair status OK xxxxxxx_vb3.paymentinfo repair status OK xxxxxxx_vb3.paymenttransaction repair status OK xxxxxxx_vb3.phrase repair status OK xxxxxxx_vb3.phrasetype repair status OK xxxxxxx_vb3.plugin repair status OK xxxxxxx_vb3.pm repair status OK xxxxxxx_vb3.pmreceipt repair status OK xxxxxxx_vb3.pmtext repair status OK xxxxxxx_vb3.podcast repair status OK xxxxxxx_vb3.podcastitem repair status OK xxxxxxx_vb3.poll repair status OK xxxxxxx_vb3.pollvote repair status OK xxxxxxx_vb3.post repair status OK xxxxxxx_vb3.posthash repair status OK xxxxxxx_vb3.postindex repair status OK xxxxxxx_vb3.postparsed repair status OK xxxxxxx_vb3.product repair status OK xxxxxxx_vb3.productcode repair status OK xxxxxxx_vb3.productdependency repair status OK xxxxxxx_vb3.profilefield repair status OK xxxxxxx_vb3.ranks repair status OK xxxxxxx_vb3.regimage repair status OK xxxxxxx_vb3.reminder repair status OK xxxxxxx_vb3.reputation repair status OK xxxxxxx_vb3.reputationlevel repair status OK xxxxxxx_vb3.rssfeed repair status OK xxxxxxx_vb3.rsslog repair status OK xxxxxxx_vb3.search repair status OK xxxxxxx_vb3.session repair note The storage engine for the table doesn't support r... xxxxxxx_vb3.setting repair status OK xxxxxxx_vb3.settinggroup repair status OK xxxxxxx_vb3.sigparsed repair status OK xxxxxxx_vb3.sigpic repair status OK xxxxxxx_vb3.smilie repair status OK xxxxxxx_vb3.stats repair status OK xxxxxxx_vb3.strikes repair status OK xxxxxxx_vb3.style repair status OK xxxxxxx_vb3.subscribeevent repair status OK xxxxxxx_vb3.subscribeforum repair status OK xxxxxxx_vb3.subscribethread repair status OK xxxxxxx_vb3.subscription repair status OK xxxxxxx_vb3.subscriptionlog repair status OK xxxxxxx_vb3.subscriptionpermission repair status OK xxxxxxx_vb3.tachyforumpost repair status OK xxxxxxx_vb3.tachythreadpost repair status OK xxxxxxx_vb3.template repair status OK xxxxxxx_vb3.templatehistory repair status OK xxxxxxx_vb3.thread repair status OK xxxxxxx_vb3.threadrate repair status OK xxxxxxx_vb3.threadread repair status OK xxxxxxx_vb3.threadredirect repair status OK xxxxxxx_vb3.threadviews repair status OK xxxxxxx_vb3.upgradelog repair status OK Table Op Msg_type Msg_text xxxxxxx_vb3.user repair status OK xxxxxxx_vb3.useractivation repair status OK xxxxxxx_vb3.userban repair status OK xxxxxxx_vb3.userfield repair status OK xxxxxxx_vb3.usergroup repair status OK xxxxxxx_vb3.usergroupleader repair status OK xxxxxxx_vb3.usergrouprequest repair status OK xxxxxxx_vb3.usernote repair status OK xxxxxxx_vb3.userpromotion repair status OK xxxxxxx_vb3.usertextfield repair status OK xxxxxxx_vb3.usertitle repair status OK xxxxxxx_vb3.word repair status OK
__________________ رحمك الله يا عبدالرحمن | |||||
|
|
| |
| |
| أدوات الموضوع | |
| |
المواضيع المتشابهه | ||||
| الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
| اذا عرفت كلمة السر لقاعدة البيانات واسم قاعدة البيانات ماذا يمكن ان يفعل ؟ | beshoo | تطوير الويب | 22 | 11-08-2002 12:34 PM |
| و أخيراً الطريقة الصحيحة و الكاملة لنسخ و نقل قاعدة البيانات | سفير الشوق | تطوير الويب | 16 | 11-07-2001 08:18 PM |
| دعم بيرل وسي جي آي و pl في سيرفر اباتشي | تطوير الويب | 6 | 29-01-2001 03:10 PM | |
| أين أجد برنامج يعمل لي قاعدة البيانات البسيطة هذه ..أرجوكم | Number1 | تطوير الويب | 0 | 15-01-2001 03:58 AM |
| تركيب vB | تطوير الويب | 9 | 07-08-2000 06:41 AM | |
