مشكلة في قاعدة البيانات مستعجل ارجو الدخول

شوان

عضو جديد
13 سبتمبر 2008
74
0
0
بلاد الهوى
www.al7ra.com
بسم الله الرحمن الرحيم ....

خبراء الدعم العربي ارجو حل مشكلة قاعدة بياناتي عند الضفط على صورة الالبوم بعد رفعها

والمصدر

PHP:
Database error in vBulletin 3.8.5:

Invalid SQL:

            SELECT SQL_CALC_FOUND_ROWS
                picturecomment.*, user.*, picturecomment.ipaddress AS messageipaddress
                ,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
                ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
                
            FROM picturecomment AS picturecomment
            LEFT JOIN user AS user ON (picturecomment.postuserid = user.userid)
            LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
            LEFT JOIN deletionlog AS deletionlog ON (picturecomment.commentid = deletionlog.primaryid AND deletionlog.type = 'picturecomment')
            
            WHERE picturecomment.pictureid = 24
                AND (picturecomment.state IN ('visible','moderation','deleted'))
            
                
            ORDER BY picturecomment.dateline
            LIMIT 0, 10;

MySQL Error   : Unknown column 'picturecomment.pictureid' in 'where clause'
Error Number  : 1054
Request Date  : Monday, 22.03.2010 @ 10:09:59
Error Date    : Monday, 22.03.2010 @ 10:09:59
Script        : http://www.al7ra.com/vb/album.php?albumid=1&pictureid=24
Referrer      : http://www.al7ra.com/vb/album.php?do=editpictures&albumid=1&pictureids[]=24
Username      : شآعر القمر
Classname     : vB_Database
MySQL Version : 5.0.89-community


واشكر كل من يساعدني
 

ENG MUHAMED

[ADMIN]
طاقم الإدارة
25 فبراير 2008
10,079
43
48
support-ar.net
وعليكم السلام

قم بزرع الامر التالى بقاعده البيانات للمنتدى

PHP:
ALTER TABLE picturecomment ADD pictureid INT UNSIGNED NOT NULL DEFAULT '0';?

وبالتوفيق