[ فهــرس ســوالـف ] لحل مــشـــاكــل قــواعــد البـيـانـات

[ALMANDOOS]

انا عندي عدة مشاكل بالمنتدى

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(11)
/home/....../public_html/vb/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Friday, December 1st 2006 @ 11:19:45 PM
Script :
http://www.....com/vb/login.php?do=l...ee7b602a4d6053
Referrer : http://www.......com/vb/index.php
IP Address : ..........
Username :
Classname : vb_database


---------------------------------------------------
المشكله الثانيه

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(11)
/home/com/public_html/vb/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Friday, December 1st 2006 @ 11:19:36 PM
Script : http://www......com/vb/profile.php?do=editavatar
Referrer : http://www.......com/vb/usercp.php
IP Address : ......
Username :
Classname : vb_database
___________________________

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(11)
/home/com/public_html/vb/includes/class_core.php on line 279

اغلب المشاكل من ملف
class_core.php

وش الحل
الله يعطيكم العافيه

[sami1706]

انا عندي عدة مشاكل بالمنتدى

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(11)
/home/....../public_html/vb/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Friday, December 1st 2006 @ 11:19:45 PM
Script :
http://www.....com/vb/login.php?do=l...ee7b602a4d6053
Referrer : http://www.......com/vb/index.php
IP Address : ..........
Username :
Classname : vb_database


---------------------------------------------------
المشكله الثانيه

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(11)
/home/com/public_html/vb/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Friday, December 1st 2006 @ 11:19:36 PM
Script : http://www......com/vb/profile.php?do=editavatar
Referrer : http://www.......com/vb/usercp.php
IP Address : ......
Username :
Classname : vb_database
___________________________

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(11)
/home/com/public_html/vb/includes/class_core.php on line 279

اغلب المشاكل من ملف
class_core.php

وش الحل
الله يعطيكم العافيه

وقع تحديث في السيرفر اصبر شوي على بال ما يتعدل وضع السيرفر ولو استمرت المشكلة معاك أكثر راجع المستضيف

[lyaleena]

مشكور اخوي

[avip]

ياهلا والله فيكم اخوااني

الصراحه خدمه ولا اروووع ماشاء الله

انا عندي مشكلة بسيطه في قواعد البيانات ما ادري شو اللي صااير

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=;

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
Date : Saturday, December 2nd 2006 @ 10:55:52 AM
Script : http://www.XXXX.com/vb/showthread.php?t=131&page=3
Referrer : http://www.XXXX.com/vb/forumdisplay....ysprune=-1&f=3
IP Address : 22.102.95.144
Username : XXXX
Classname : vb_database

ويسلموووو^_^

[dr-php]

ياهلا والله فيكم اخوااني

الصراحه خدمه ولا اروووع ماشاء الله

انا عندي مشكلة بسيطه في قواعد البيانات ما ادري شو اللي صااير



ويسلموووو^_^

سويـ تعطيلـ للهاكاتـ وشوفـ

[خالد-الحربي]

لدي مشكله بعد رفع الباك يب للمنتدى


ظهرت لي هذي المشكله

انظر الصوره على الرابط

http://www.stooop.com/2006/11/4ebdf92fd6.jpg


المشكله الحروف العربيه باسماء الاعضاء و بياناتهم قلبت الى رموز

وجاني الخطا هذا بااخر شىء يوم رفعت الباك يب عن طريق bigdump


Error at the line 4218: INSERT INTO `word` (`wordid`, `title`) VALUES


Query: INSERT INTO `word` (`wordid`, `title`) VALUES


MySQL: Duplicate entry '&#199;&#225;&#205;&#222;&#225;' for key 2


ما الحل و جزاك الله خير

[avip]

اخوي مشكله عاااجله ياريت احصل الحل

المنتدى تسكر فجأة والخطأ اللي يرسلي اياه في البريد هو:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User
hatfycom_avipvb has already more than 'max_user_connections' active connections
/home/hatfycom/public_html/vb/includes/class_core.php on line 271

MySQL Error :
Error Number :
Date : Saturday, December 2nd 2006 @ 01:23:40 PM
Script : http://www.XXXXX.com/vb/showthread.php?t=131&page=3
Referrer :
http://66.29.68.66:2095/3rdparty/squ...startMessage=1
IP Address : 88.108.95.144
Username :
Classname : vb_database

ياليت القى الحل بسرعه لان المنتدى مغلق احين ووجود خطأ في قاعده البيانت يعطيني

النسخه 3.6.0

وسلامتكم

الممـــــ AvIp ــــيــز

[القيروان]

اخوي احمد سمارا ممكن الحل

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT thread.*, stamps.title AS stamptitle, stamps.stampid, stamps.url, stamps.icon
FROM thread AS thread
LEFT JOIN stamps AS stamps ON(stamps.stampid = thread.stampid)
WHERE thread.stampid > 0
ORDER BY stamps.stampid;

MySQL Error : Table 'geroan_upgrade354.stamps' doesn't exist
Error Number : 1146
Date : Saturday, December 2nd 2006 @ 01:27:18 PM
Script : http://www.****.com/vb/admincp/stamp.php?do=show
Referrer : http://www.****.com/vb/admincp/index.php?do=nav
IP Address :
Username : Classname : vb_database

[ahmed-samara]

اخوي مشكله عاااجله ياريت احصل الحل

المنتدى تسكر فجأة والخطأ اللي يرسلي اياه في البريد هو:



ياليت القى الحل بسرعه لان المنتدى مغلق احين ووجود خطأ في قاعده البيانت يعطيني

النسخه 3.6.0

وسلامتكم

الممـــــ AvIp ــــيــز

انتظر لأني مافى قاعدة اساسا انتظر يمكن المستضيف بيعمل ريسترت للسيرفر

[ahmed-samara]

اخوي احمد سمارا ممكن الحل

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT thread.*, stamps.title AS stamptitle, stamps.stampid, stamps.url, stamps.icon
FROM thread AS thread
LEFT JOIN stamps AS stamps ON(stamps.stampid = thread.stampid)
WHERE thread.stampid > 0
ORDER BY stamps.stampid;

MySQL Error : Table 'geroan_upgrade354.stamps' doesn't exist
Error Number : 1146
Date : Saturday, December 2nd 2006 @ 01:27:18 PM
Script : http://www.****.com/vb/admincp/stamp.php?do=show
Referrer : http://www.****.com/vb/admincp/index.php?do=nav
IP Address :
Username : Classname : vb_database

امسح هاك الاختام اخي الفاضل لأني المشكلة من

Table 'geroan_upgrade354.stamps' doesn't exist
وهذا يعني هاك الأختام مسبب مشاكل للمنتدي منتظر ردك اخوي

[ahmed-samara]

لدي مشكله بعد رفع الباك يب للمنتدى


ظهرت لي هذي المشكله

انظر الصوره على الرابط

http://www.stooop.com/2006/11/4ebdf92fd6.jpg


المشكله الحروف العربيه باسماء الاعضاء و بياناتهم قلبت الى رموز

وجاني الخطا هذا بااخر شىء يوم رفعت الباك يب عن طريق bigdump


Error at the line 4218: INSERT INTO `word` (`wordid`, `title`) VALUES


Query: INSERT INTO `word` (`wordid`, `title`) VALUES


MySQL: Duplicate entry '&Ccedil;&aacute;&Iacute;&THORN;&aacute;' for key 2



ما الحل و جزاك الله خير

راجع الموضوع هذا اخي الفاضل
http://www.swalif.net/softs/showthread.php?t=179873

[Rewish-Maxer]

مشكلة اخواني تعبتني اتمني اجد الحل

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
    <title>منتديات  Database Error</title>
    <meta **********="Content-Type" content="text/html; charset=ISO-8859-1" />
    <style type="text/css">
    <!--    
    body { background-color: white; color: black; }
    #container { width: 400px; }
    #message   { width: 400px; color: black; background-color: #FFFFCC; }
    #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
    .bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }
    a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
    a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
    -->
    </style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
    <td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
    <td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
    <td class="bodytext" colspan="2">The منتديات database has encountered a problem.</td>
</tr>
<tr>
    <td colspan="2"><hr /></td>
</tr>
<tr>
    <td class="bodytext" colspan="2">
        Please try the following:
        <ul>
            <li>Load the page again by clicking the <a href="#" onclick="******.******** = ******.********;">*******</a> button in your web browser.</li>
            <li>Open the <a href="/">www.aser-al7b.com</a> home page, then try to open another page.</li>
            <li>Click the <a href="java******:history.back(1)">Back</a> button to try another link.</li>
        </ul>
    </td>
</tr>
<tr>
    <td class="bodytext" colspan="2">The [url]www.xxxxx.com[/url] forum technical staff have been notified of the error, though you may <a href="mailto:webmaster@xxxxx.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
    <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.6.0:

Invalid SQL:

        SELECT
            announcement.announcementid, startdate, title, announcement.views,
            user.username, user.userid, user.usertitle, user.customtitle
            , NOT ISNULL(announcementread.announcementid) AS readannounce
        FROM announcement AS announcement
        LEFT JOIN announcementread AS announcementread ON (announcementread.announcementid = announcement.announcementid AND announcementread.userid = 1)
        LEFT JOIN user AS user ON(user.userid = announcement.userid)
        WHERE startdate &lt;= 1160075737
            AND enddate &gt;= 1160075737
            AND forumid IN (48,1,-1)
        ORDER BY startdate DESC, announcement.announcementid DESC
        LIMIT 1;

MySQL Error  : Column 'title' in field list is ambiguous
Error Number : 1052
Date         : Thursday, October 5th 2006 @ 10:15:37 PM
******       : [url]http://www.xxxxxx.com/vb/forumdisplay.php?f=48[/url]
Referrer     : [url]http://www.xxxxxx.com/vb/[/url]
IP Address   : 196.204.249.161
Username     : XXXXXX
Classname    : vb_database</textarea></form>

</body>
</html> 

[القيروان]

اشكرك اخوي احمد وتم حذف الهاك وجميع ملفاته

[ahmed-samara]

مشكلة اخواني تعبتني اتمني اجد الحل

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
    <title>منتديات  Database Error</title>
    <meta **********="Content-Type" content="text/html; charset=ISO-8859-1" />
    <style type="text/css">
    <!--    
    body { background-color: white; color: black; }
    #container { width: 400px; }
    #message   { width: 400px; color: black; background-color: #FFFFCC; }
    #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
    .bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }
    a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
    a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
    -->
    </style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
    <td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
    <td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
    <td class="bodytext" colspan="2">The منتديات database has encountered a problem.</td>
</tr>
<tr>
    <td colspan="2"><hr /></td>
</tr>
<tr>
    <td class="bodytext" colspan="2">
        Please try the following:
        <ul>
            <li>Load the page again by clicking the <a href="#" onclick="******.******** = ******.********;">*******</a> button in your web browser.</li>
            <li>Open the <a href="/">www.aser-al7b.com</a> home page, then try to open another page.</li>
            <li>Click the <a href="java******:history.back(1)">Back</a> button to try another link.</li>
        </ul>
    </td>
</tr>
<tr>
    <td class="bodytext" colspan="2">The [url]www.xxxxx.com[/url] forum technical staff have been notified of the error, though you may <a href="mailto:webmaster@xxxxx.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
    <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.6.0:

Invalid SQL:

        SELECT
            announcement.announcementid, startdate, title, announcement.views,
            user.username, user.userid, user.usertitle, user.customtitle
            , NOT ISNULL(announcementread.announcementid) AS readannounce
        FROM announcement AS announcement
        LEFT JOIN announcementread AS announcementread ON (announcementread.announcementid = announcement.announcementid AND announcementread.userid = 1)
        LEFT JOIN user AS user ON(user.userid = announcement.userid)
        WHERE startdate &lt;= 1160075737
            AND enddate &gt;= 1160075737
            AND forumid IN (48,1,-1)
        ORDER BY startdate DESC, announcement.announcementid DESC
        LIMIT 1;

MySQL Error  : Column 'title' in field list is ambiguous
Error Number : 1052
Date         : Thursday, October 5th 2006 @ 10:15:37 PM
******       : [url]http://www.xxxxxx.com/vb/forumdisplay.php?f=48[/url]
Referrer     : [url]http://www.xxxxxx.com/vb/[/url]
IP Address   : 196.204.249.161
Username     : XXXXXX
Classname    : vb_database</textarea></form>

</body>
</html> 

الحل

ادخل على forumdisplay.php

وابحث عن :

, title, 

واستبدله ب :

, announcement.title, 

تحياتي لك اخي الفاضل وخبرني بالنتيحة

[ahmed-samara]

اشكرك اخوي احمد وتم حذف الهاك وجميع ملفاته

العفو اخوي وياهلا فيك