السلام عليكم ورحمة الله
اخواني قمت بحذف هاك المتجر بالخطأ وأثناء الحذف قمت بإيقاف هذه الخطوة حتى لا أفقده
فوجدت هذا الخطأ عند فتح أي قسم
Database error in vBulletin 3.6.5:
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, 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
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
,post.pagetext,thread.vbp_titledisplayflags,thread .vbp_titletextcolor,thread.vbp_titleglowcolor,thre ad.vbp_titleshadowcolor,thread.vbp_titlefonttype
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 = 2 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)
WHERE thread.threadid IN (0)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'thread.vbp_titledisplayflags' in 'field list'
Error Number : 1054
Date : Thursday, April 12th 2007 @ 02:31:28 PM
Script : http://www.anaemarati.com/vb/forumdisplay.php?f=33
Referrer : http://www.anaemarati.com/vb/index.php
IP Address : ******
Username : رميـ عالي مستواه ـثي
Classname : vb_data****
سويت إصلاح وتحسين للجداول لكن لا فائدة
قمت بتعطيل المتجر فزالت المشكلة
أرجو منكم الحل
ولكن أتمنى أن يكون هنالك حل آخر غير حذف المنتج وإعادة تركيبه حتى لا نفقد البيانات