عرض للطباعة
:mwalat15:السلام عليكم ..
عندي مشكله في المنتدى وهي ان لما اجي بفتح الاقسام ماتفتح عندي يطلع لي هذه الصفحه
علما بان الصفحه الرئيسيه تفتح اوك والمواضيع اوك .. فقط المشكله بالاقسام ,,
والسبب اني حذفت stamps من قاعدة البيانات في لوحة الموقع السي بانل
هل في طريقه الى استرجاع stamps ولا ؟؟
ارجوووو تشوفو ليي حل ..
ولكم جزيل الشكر ,, واعذب التحيه ..
طيب انسخ ما بداخل المربع الأصفر هنا
هذا الي داخل المربع
كود:
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, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, thread.stampid, stamps.title, stamps.icon AS stampicon, stamps.color, post.pagetext AS previewbbcode
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN stamps AS stamps ON(thread.stampid = stamps.stampid)
WHERE thread.threadid IN (0,4820,4791,4759,4767,4429,4658,4026,4264,4254,4116,4230,4153,4154,4200,4118,3966,3923,3888,3972,1061,1234,7,1240)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table 'lmasco_vb.stamps' doesn't exist
Error Number : 1146
Request Date : Monday, August 3rd 2009 @ 06:11:39 PM
Error Date : Monday, August 3rd 2009 @ 06:11:39 PM
Script : http://www.l-mas.com/vb/forumdisplay.php?f=49
Referrer : http://www.l-mas.com/vb/
أنت موجود عندك هاك الاختام فقم بحذفة
:mwalat4:يعطيك العافيه اخوووي
حذفت هاك الاختام وزبط عندي
تحياتي لك يالغالي