مشكله عند تغير او تعديل اسم عضو Error in /admincp/user.php

ENG MUHAMED

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

User.php Database Error
Error in /admincp/user.php when trying to edit username
Database error in vBulletin 3.7.4

Invalid SQL:

UPDATE;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Request Date : Tuesday, November 4th 2008 @ 06:54:08 PM
Error Date : Tuesday, November 4th 2008 @ 06:54:08 PM
Script : http://mysite.org/admincp/user.php?do=update
Referrer : http://mysite.org/admincp/user.php?do=edit&u=17
IP Address :
Username : ENG MUHAMED
Classname : vB_Database
MySQL Version : 5.0.22


الحل

تعديل على مجلد class_dm_user.php
بداخل مجلد includes
على المسار التالى
includes/class_dm_user.php

ابحث عن
PHP:
            // visitormessage 'postusername'
            $this->dbobject->query_write("

                UPDATE " . TABLE_PREFIX , "visitormessage
                SET postusername = '" . $this->dbobject->escape_string($username) . "'
            ");

استبدله ب

PHP:
            // visitormessage 'postusername'
            $this->dbobject->query_write("

                UPDATE " . TABLE_PREFIX . "visitormessage
                SET postusername = '" . $this->dbobject->escape_string($username) . "'
                WHERE postuserid = $userid
            ");


او استبدال الملف كامل بنسخه احدث وبالتوفيق للجميع
💕