حل مشكله LIMIT' at line 3 Error Number : 1064

E

ENG MUHAMED

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

السلام عليكم و رحمة الله و بركاته

حل مشكله LIMIT' at line 3 Error Number : 1064

 نــص الايرور كالتالي :
PHP: 
Database error in vBulletin 3.7.4:
Invalid SQL:
     SELECT threadid, title, forumid
     FROM thread
     WHERE postuserid = '39' AND forumid NOT IN()
     
     LIMIT;
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 ')
     
     LIMIT' at line 3
Error Number  : 1064
Request Date  : Wednesday, May 27th 2009 @ 07:19:11 AM
Error Date    : Wednesday, May 27th 2009 @ 07:19:11 AM
Script        : http://www.Example.com/vb/showthread.php?t=349
 Referrer      : http://www.Example.com/vb/showthread.php?t=340
 IP Address    : 74.31.61.177
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.77-community
​


الحل


طريقـة التعـديل ::


اتبع الصور


a00fd0ce68.bmp



bdd62416ed.bmp



اضغط على ( تعديل ) كما هو موضح بالصورة

وبعدها قم بمسح الكود الموجود

4a5af3d776.bmp



والصق الكود التالى


PHP: 
//arabdeaf.net### 
global $db; 
$this_hack_userid = $this->post[userid]; 
if($post[userid] !=0){  
$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$this_hack_userid"); 
$personal1=$db->query_first("SELECT SUM(views) AS personalviews FROM thread WHERE postuserid=$post[userid] AND open!='10'"); 
$personal= 2*$post[posts]+$personal1[personalviews]; 
if ($personal1 == ""): 
$personal1 = "0";endif; 
global $db;$personal1=$db->query_first("SELECT SUM(views) AS personalviews FROM thread WHERE postuserid=$post[userid] AND open!='10'"); 
$personal= 2*$post[posts]+$personal1[personalviews]; 
if ($personal1 == ""): 
$personal1 = "0";endif; 
$attachment = $db->query_first("SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid=$post[userid] "); 
$attachcoun = $attachment[total]; 
$usertherd_pro_fetch = $db->fetch_array($user_theard_query); 
$usertherdcoun = $usertherd_pro_fetch[total]; 
$userpostdcoun = $post[posts] - $usertherdcoun ;}    
//arabdeaf.net###
​
وحفظ

والله الموفق

​
 
يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.
أعلى أسفل