Database error in vBulletin 3.7.3:

pidro

عضو جديد
25 أكتوبر 2008
161
0
0
lتاتيني رسالة الى عنواني بريدي تتضمن
ما معناها


Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT username from user where
userid=;

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 2
Error Number : 1064
Request Date : Wednesday, December 31st 2008 @ 01:18:14 AM
Error Date : Wednesday, December 31st 2008 @ 01:18:14 AM
Script : http://sharktimes-algeria.com/vb/register.php?do=addmember
Referrer : http://sharktimes-algeria.com/vb/register.php
IP Address : 93.100.106.193
Username : zacpanic
Classname : vB_Database
MySQL Version :
 

ENG MUHAMED

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


PHP:
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 
            ");


وردلنا خبر
 

pidro

عضو جديد
25 أكتوبر 2008
161
0
0
وجد هذان فايهما استبدل
$this->dbobject->query_write("
UPDATE " . TABLE_PREFIX . "visitormessage SET
postusername = '" . $this->dbobject->escape_string($this->existing['username']) . "',
postuserid = 0
WHERE postuserid = " . $this->existing['userid'] . "
");
$this->dbobject->query_write("
DELETE FROM " . TABLE_PREFIX . "visitormessage
WHERE userid = " . $this->existing['userid'] . "
 

ENG MUHAMED

[ADMIN]
طاقم الإدارة
25 فبراير 2008
10,079
43
48
support-ar.net
وجد هذان فايهما استبدل
$this->dbobject->query_write("
UPDATE " . TABLE_PREFIX . "visitormessage SET
postusername = '" . $this->dbobject->escape_string($this->existing['username']) . "',
postuserid = 0
WHERE postuserid = " . $this->existing['userid'] . "
");
$this->dbobject->query_write("
DELETE FROM " . TABLE_PREFIX . "visitormessage
WHERE userid = " . $this->existing['userid'] . "
؟؟؟؟؟؟؟؟؟؟؟؟