[مشكلة] مشكلة في لوحة تحكم الاعضاء

الحالة
مغلق و غير مفتوح للمزيد من الردود.

R.C.P

عضو جديد
8 نوفمبر 2010
11
0
0
السلام عليكم

اخواني عند دخولي الى لوحة التحكم لتغيير الصور الرمزية والتوقيع ... الخ

يضهر لي خطا

وهذا هو مضمونه



Database error in vBulletin 3.8.6:

Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
d.*, gm.*, user.*,
gm.ipaddress AS itemipaddress, d.lastpost AS lastpost, d.lastpostid AS lastpostid ,deletionlog.userid AS del_userid, deletionlog.username AS del_username,
deletionlog.reason AS del_reason ,IF(d.lastpost <= discussionread.readtime,1,0) AS is_read, discussionread.readtime AS readtime ,subscribediscussion.emailupdate
FROM discussion AS d
INNER JOIN groupmessage AS gm
ON (gm.gmid = d.firstpostid)
LEFT JOIN user AS user ON (gm.postuserid = user.userid) LEFT JOIN discussionread AS discussionread
ON (discussionread.discussionid = d.discussionid
AND discussionread.userid = 1) INNER JOIN subscribediscussion AS subscribediscussion
ON (subscribediscussion.discussionid = d.discussionid
AND subscribediscussion.userid = 1) LEFT JOIN deletionlog AS deletionlog
ON (gm.gmid = deletionlog.primaryid AND deletionlog.type = 'groupmessage')

WHERE 1=1 AND (gm.state IN ('visible','moderation','deleted'))
ORDER BY d.lastpost ASC;

MySQL Error : Table 'iqhawks_vb.groupmessage' doesn't exist
Error Number : 1146
Request Date : Thursday, September 1st 2011 @ 07:46:57 AM
Error Date : Thursday, September 1st 2011 @ 07:46:58 AM
Script : http://www.iqhawks.com/vb/usercp.php
Referrer : http://www.iqhawks.com/vb/showthread.php?t=9720
IP Address : 109.127.96.43
Username : Black Hawk
Classname : vB_Database
MySQL Version : 5.1.52-cll

 

Abdul Rahim

[ أعضاء فى القلب ]
30 مايو 2011
3,386
23
0
وعليكم السلام ورحمة الله وبركاته

المشكلة من جدول groupmessage مفقود

إزرع هذا الأمر:
PHP:
CREATE TABLE `groupmessage` (
  `gmid` int(10) unsigned NOT NULL auto_increment,
  `discussionid` int(10) unsigned NOT NULL default '0',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `state` enum('visible','moderation','deleted') NOT NULL default 'visible',
  `title` varchar(255) NOT NULL default '',
  `pagetext` mediumtext,
  `ipaddress` int(10) unsigned NOT NULL default '0',
  `allowsmilie` smallint(5) unsigned NOT NULL default '0',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gmid`),
  KEY `postuserid` (`postuserid`,`discussionid`,`state`),
  KEY `discussionid` (`discussionid`,`dateline`,`state`),
  FULLTEXT KEY `gm_ft` (`title`,`pagetext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 

R.C.P

عضو جديد
8 نوفمبر 2010
11
0
0
والله ابداع ياخي عبد الرحمن الله يزيدك علم ومعرفة ان شاء الله
بارك الله فيك انحلت المشكلة بعد زرع الامر
الله يجزيك خير
 

Abdul Rahim

[ أعضاء فى القلب ]
30 مايو 2011
3,386
23
0
وياك يا الغلى وبالتوفيق

يغلق للإنتهاء
 
الحالة
مغلق و غير مفتوح للمزيد من الردود.