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

[كويتي]

يعطيكم العافية

عند محاولة دخول المنتدى ، وبعد ترقيته للاصدار الاخير .. تظهر هالرسالة :

Content Encoding Error (content_encoding_error)


Server response could not be decoded using encoding type returned by server.
This is typically caused by a Web Site presenting a content encoding header of one type, and then encoding the data differently.

For assistance, contact your network support team.


واذا حاولت ادخل لوحة التحكم ينقلني لملف الlogin وتظهر رسالة بعدم وجود الصفحة رغم ان النسخة كاملة ومافي شي ناقصها وجربت اكثر من نسخة ونفس الشي .. حتى ان صفحة الدخول للوحة التحكم تظهر كلها بيضاء من غير الوان او تنسيق ..

ارجوا المساعدة وشكراً

[Emichat.Com]

عندي مشكلة

يوم اطرش حق كل الاعضاء رسالة خاصة من لوحة تحكم الإدارة

يطرش حق 1500 عضو وعقب يعطيني داتا بيس ايرور

[© بندر ©]

يعطيكم العافية ..

سمارا .. عندي هالمشكلة

Database error in vBulletin

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (0Array,809);

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Date : Tuesday, January 16th 2007 @ 11:59:18 AM
Script : http://www.XXXX.com/vb/online.php
Referrer :
IP Address :
Username :
Classname : vb_database


تطلع عندي احياناً ...

بارك الله فيك .. حل

[ابو نوف]

اخوي هذااا الخطا ظهر لي بعد ماعدلت في خيارات المنتدى كان كل شي تمام الان مو شغال شي
هذا الخطا يظهر في الرئيسيه
//////////////////////////////////
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 10;

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 ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 10' at line 6
Error Number : 1064
Date : Tuesday, January 16th 2007 @ 11:44:09 PM
Script :
Referrer : http://www.m7bobti.com/vb/admincp/index.php?do=head
IP Address :
Username :
Classname : vb_database

اتوقع ياخوان الخطا نتج لاني غيرت
كلمات مفاتيح البحث
أدخل كلمات مفاتيح البحث لكافة الصفحات. هذا يستخدم بواسطة محركات البحث لفهرسة صفحاتك بعمق وبعلاقة أكثر بمحتواها.

خطأ:
1
وصف الميتا/ Meta
أدخل وصف meta لكافة الصفحات. هذا يستخدم بواسطة محركات البحث لفهرسة صفحاتك بعمق وبعلاقة أكثر بمحتواها.

اتوقع كذاا وانتظر ردكم المنتدى متعطل

[ابو نوف]

رجعتهااا مافي فايده

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

[Bad Maind]

مشكله عند ارسال بريد للاعضاء

Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1169324578, location = '/vb/admincp/email.php?do=dosendmail&amp;do=dosendmail', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '9402a55b2a041a8ef6680b40db364d2d';

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Saturday, January 20th 2007 @ 02:23:19 PM
Script : http://www.XXX.com/vb/admincp/email.php?do=dosendmail
Referrer : http://www.XXX.com/vb/admincp/email.php?do=dosendmail
IP Address : 84.36.29.192
Username : admin
Classname : vb_database

[Sc®iPt]

مشكله عند ارسال بريد للاعضاء

Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1169324578, location = '/vb/admincp/email.php?do=dosendmail&amp;do=dosendmail', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '9402a55b2a041a8ef6680b40db364d2d';

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Saturday, January 20th 2007 @ 02:23:19 PM
Script : http://www.XXX.com/vb/admincp/email.php?do=dosendmail
Referrer : http://www.XXX.com/vb/admincp/email.php?do=dosendmail
IP Address : 84.36.29.192
Username : admin
Classname : vb_database

يوجد فشل عند الأتصال بالقـاعده فيمـا معناه أنك مضطر تصبر شوي ..حتى يخف الضغط على قواعد البيانات عند المستضيـف لتتمكن من الأرسـال

حاول انك تراجع نفس الشركة المستضيفه وخليهم يسوون ريستارت للماي سيكويل + السيرفر مره واحدهـ

.. والله أعـلم

[hagryyy]

السلام عليكم .. واجهتني مشلكه ..

وانا احدث العدادات للترقية الجديده

طلع لي خطا

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT wordid, title
FROM word
WHERE title LIKE 'توقفت';

MySQL Error : User 'sh-lovec_vb5' has exceeded the 'max_questions' resource (current value: 50000)
Error Number : 1226
Date : Monday, January 22nd 2007 @ 01:41:20 PM
Script : http://xxxxxxxxxx/admincp/misc.php?d...tat=9300&pp=50
Referrer :
IP Address : xxxxxxxxx
Username : xxxxxxx
Classname : vb_database

مع اني احط التحديث يبدا من العداد 50 عشان اخفف عل السيرفر ..

لان المستضيف اااااااااانس يرد عليك .. ولاتقدر تنقل من عنده لان البلا من البيك اب اللي ماينسحب كامل .. الخ

وش الحل .. ؟

ويوم جيت بسوي اصلاح للجداول طلع لي خطا وسيم ..

Fatal error: Call to undefined function: pma_reloadnavigation() in /usr/local/apache/htdocs/phpMyAdmin-2.6.3/header.inc.php on line 133

[avip]

Database error in vBulletin :

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

MySQL Error :
Error Number :
Date : Thursday, January 25th 2007 @ 01:14:03 AM
Script : http://www.mysite.org/forumdisplay.php?f=6

السلام عليكم

دايما مزعجين بالاوامر ههههههه

اخواني ماعليكم امارة حد يعرف هاي المشكلة من وين ؟؟ وكيف الحل؟؟



عندي سؤال ثاني بالنسبة لتفريغ الجداول شو هي الجداول المطلوبه نفرغها؟؟

والله يعطيكم العافيه....

[serag777]

[foxuae.com]

ياليت تحل لي هل المشكله

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(0, 1, 'الدعم الفني', 64, 'رد: اقتـــــــراح جـــــــديـــــــد', 'لااالااااااااااااااا', 0, 1, 66601, 4374, 1169851729, '82.32.195.179', 0);

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Friday, January 26th 2007 @ 04:48:49 PM
Script : http://www..net/vb/newreply.php?do=postreply&t=4374
Referrer : http://www..net/vb/newreply.php?do=postreply&t=4374
IP Address : 82.32.195.179
Username : Classname : vb_database

[sami1706]

ياليت تحل لي هل المشكله

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(0, 1, 'الدعم الفني', 64, 'رد: اقتـــــــراح جـــــــديـــــــد', 'لااالااااااااااااااا', 0, 1, 66601, 4374, 1169851729, '82.32.195.179', 0);

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Friday, January 26th 2007 @ 04:48:49 PM
Script : http://www..net/vb/newreply.php?do=postreply&t=4374
Referrer : http://www..net/vb/newreply.php?do=postreply&t=4374
IP Address : 82.32.195.179
Username : Classname : vb_database

ازرع لا هنت الأمر التالي :

ALTER TABLE `post` CHANGE `postid` `postid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 

[foxuae.com]

تسلم اخوووي

بس ظهر لي هل المشكله عند اضع موضوع جديد

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO thread
(postusername, postuserid, title, iconid, visible, forumid, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('الدعم الفني', 64, 'تجربه', 25, 1, 26, '924, 3783, 1566, 1848', 1169855765, 1, 0, 1169855765, 'الدعم الفني', 0, 0, 0);

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Friday, January 26th 2007 @ 05:56:06 PM
Script : http://www.a.net/vb/newthread.php?do=postthread&f=26
Referrer : http://www..net/vb/newthread.php?do=newthread&f=26
IP Address : 82.32.195.179
Username :
Classname : vb_database

[foxuae.com]

و هذي بعد المشكله عند الحذف

Database error in vBulletin 3.6.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO moderatorlog
(`userid`, `dateline`, `type`, `forumid`, `threadid`, `postid`, `pollid`, `attachmentid`, `ipaddress`, `action`)
VALUES
('64', '1169856198', '18', '26', '4374', '66629', '0', '0', '82.32.195.179', 'a:2:{i:0;s:36:\"رد: اقتـــــــراح جـــــــديـــــــد\";i:1;s:11:\"الدعم الفني\";}');

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Friday, January 26th 2007 @ 06:03:18 PM
Script : http://www..net/vb/inlinemod.php?t=4...&postids=66629
Referrer : http://www.a.net/vb/inlinemod.php?threadid=4374&p=66629
IP Address : 82.32.195.179
Username :
Classname : vb_database

[sami1706]

عندك مشكلة في الترقيم الأوتوماتيكي في القاعدة
ازرع هذه الأوامر كلها دفة واحدة

ALTER TABLE `adminhelp` CHANGE `adminhelpid` `adminhelpid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `adminlog` CHANGE `adminlogid` `adminlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `announcement` CHANGE `announcementid` `announcementid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `attachment` CHANGE `attachmentid` `attachmentid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `avatar` CHANGE `avatarid` `avatarid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `bbcode` CHANGE `bbcodeid` `bbcodeid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `calendar` CHANGE `calendarid` `calendarid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `calendarcustomfield` CHANGE `calendarcustomfieldid` `calendarcustomfieldid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `calendarmoderator` CHANGE `calendarmoderatorid` `calendarmoderatorid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `calendarpermission` CHANGE `calendarpermissionid` `calendarpermissionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `cron` CHANGE `cronid` `cronid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `cronlog` CHANGE `cronlogid` `cronlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `event` CHANGE `eventid` `eventid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `forum` CHANGE `forumid` `forumid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `forumpermission` CHANGE `forumpermissionid` `forumpermissionid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `holiday` CHANGE `holidayid` `holidayid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `icon` CHANGE `iconid` `iconid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `imagecategory` CHANGE `imagecategoryid` `imagecategoryid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `language` CHANGE `languageid` `languageid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `mailqueue` CHANGE `mailqueueid` `mailqueueid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `moderator` CHANGE `moderatorid` `moderatorid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `moderatorlog` CHANGE `moderatorlogid` `moderatorlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `paymentapi` CHANGE `paymentapiid` `paymentapiid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `paymentinfo` CHANGE `paymentinfoid` `paymentinfoid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `paymenttransaction` CHANGE `paymenttransactionid` `paymenttransactionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `phrase` CHANGE `phraseid` `phraseid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `plugin` CHANGE `pluginid` `pluginid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `pm` CHANGE `pmid` `pmid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `pmtext` CHANGE `pmtextid` `pmtextid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `poll` CHANGE `pollid` `pollid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `pollvote` CHANGE `pollvoteid` `pollvoteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `post` CHANGE `postid` `postid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `productcode` CHANGE `productcodeid` `productcodeid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `profilefield` CHANGE `profilefieldid` `profilefieldid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `ranks` CHANGE `rankid` `rankid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `reminder` CHANGE `reminderid` `reminderid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `reputation` CHANGE `reputationid` `reputationid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `reputationlevel` CHANGE `reputationlevelid` `reputationlevelid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `rssfeed` CHANGE `rssfeedid` `rssfeedid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `search` CHANGE `searchid` `searchid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `smilie` CHANGE `smilieid` `smilieid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `style` CHANGE `styleid` `styleid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `subscribeevent` CHANGE `subscribeeventid` `subscribeeventid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `subscribeforum` CHANGE `subscribeforumid` `subscribeforumid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `subscribethread` CHANGE `subscribethreadid` `subscribethreadid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscription` CHANGE `subscriptionid` `subscriptionid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `subscriptionlog` CHANGE `subscriptionlogid` `subscriptionlogid` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `template` CHANGE `templateid` `templateid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `templatehistory` CHANGE `templatehistoryid` `templatehistoryid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `thread` CHANGE `threadid` `threadid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `threadrate` CHANGE `threadrateid` `threadrateid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `upgradelog` CHANGE `upgradelogid` `upgradelogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `user` CHANGE `userid` `userid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `useractivation` CHANGE `useractivationid` `useractivationid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `usergroup` CHANGE `usergroupid` `usergroupid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `usergroupleader` CHANGE `usergroupleaderid` `usergroupleaderid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `usergrouprequest` CHANGE `usergrouprequestid` `usergrouprequestid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `usernote` CHANGE `usernoteid` `usernoteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `usertitle` CHANGE `usertitleid` `usertitleid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `userpromotion` CHANGE `userpromotionid` `userpromotionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `word` CHANGE `wordid` `wordid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;