مشكلة في استعراض المشاركات الجديده او البحث بعد تركيب هاك الموده
السلام عليكم ورحمة الله وبركاته
لدي مشكلة عند استعراض المواضيع الجديده في المنتدى
فعند الضغط عى المشاركات الجديدة تظهر لي هذه الرساله
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,
thread.replycount, IF(thread.views<=thread.r eplycount, replycount+1, thread.views) AS views,
thread.lastpost, thread.lastposter, thread.lastpostid
,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.su bscribethreadid) AS issubscribed
, attachment.thumbnail_file size AS thumbsize , MIN(attachment.attachment id) AS attachmentid , attachment.thumbnail_file size AS thumbsize , MIN(attachment.attachment id) AS attachmentid , post.pagetext AS previewbbcode
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread
ON(subscribethread.thread id = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png')) LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(53867, 53746, 53750, 53597, 13824);
MySQL Error : Not unique table/alias: 'attachment'
Error Number : 1066
Request Date : Wednesday, October 28th 2009 @ 06:30:11 AM
Error Date : Wednesday, October 28th 2009 @ 06:30:12 AM
Script : http://www.-------.com/vb/search.php?searchid=63916
Referrer : http://www.---------.com/vb/index.php
IP Address : 188.54.72.159
Username :admin
Classname : vB_Database
MySQL Version : 4.1.22-standard
وايضاً عند البحث في المنتدى
عند تعطيل هاكات الموده للإدارة واللتحرير تعمل الروابط بشكل سليم
رد مع اقتباس
مواقع النشر (المفضلة)