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

**star top** · 23-08-2009

كود:

 
<!--
Database error in vBulletin 3.7.4:
 
Invalid SQL:
 
		SELECT 
			userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
			language.phrasegroup_global AS phrasegroup_global,
			language.options AS lang_options,
			language.languagecode AS lang_code,
			language.charset AS lang_charset,
			language.locale AS lang_locale,
			language.imagesoverride AS lang_imagesoverride,
			language.dateoverride AS lang_dateoverride,
			language.timeoverride AS lang_timeoverride,
			language.registereddateoverride AS lang_registereddateoverride,
			language.calformat1override AS lang_calformat1override,
			language.calformat2override AS lang_calformat2override,
			language.logdateoverride AS lang_logdateoverride,
			language.decimalsep AS lang_decimalsep,
			language.thousandsep AS lang_thousandsep
			
		FROM user AS user
		LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
		LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 3, user.languageid)) 
		
		WHERE user.userid = 1;
 
MySQL Error   : Table 'language' is marked as crashed and last (automatic?) repair failed
Error Number  : 1195
Request Date  : Sunday, August 23rd 2009 @ 09:30:49 AM
Error Date    : Sunday, August 23rd 2009 @ 09:30:49 AM
Script        : http://www.fgfg/vb/login.php?do=login
Referrer      : http://www.fgfgf/vb/admincp/
IP Address    :
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

سويت تحديث ومافيه فايده
واذا دخلت للوحه التحكم يطلع ذي

كود:

<!--
Database error in vBulletin :
 
Invalid SQL:
 
			SELECT *
			FROM datastore
			WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','maxloggedin','acpstats','mailqueue','pluginlistadmin');
 
MySQL Error   : Table 'datastore' is marked as crashed and last (automatic?) repair failed
Error Number  : 1195
Request Date  : Sunday, August 23rd 2009 @ 09:41:04 AM
Error Date    : Sunday, August 23rd 2009 @ 09:41:04 AM
Script        : http://wwwsdfdgg/vb/admincp/
Referrer      : 
IP Address    :
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

ومبروك عليكم الشهر الفضيل

**احباب طيار** · 23-08-2009

وجربت زرعت الامر كذا

كود PHP:
CREATE TABLE IF NOT EXISTS `forumprefixset` (
`prefixid` varchar(25) NOT NULL,
`usergroupid` smallint(5) unsigned NOT NULL,
KEY `prefixusergroup` (`prefixid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

الان تغير الخطا واصبح

Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT forumprefixset.*
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
ORDER BY prefixset.displayorder;
MySQL Error : Unknown column 'forumprefixset.prefixsetid' in 'on clause'
Error Number : 1054
Request Date : Saturday, August 22nd 2009 @ 11:32:12 PM
Error Date : Saturday, August 22nd 2009 @ 11:32:12 PM
Script : http://www.xxxxx/vb/admincp/index.php
Referrer :
IP Address : xxxx
Username :xxx
Classname : vB_Database
MySQL Version : 5.0.81-community-log

**hagryyy** · 20-10-2009

السلام عليكم ..

لدي مشكله عند تعديل او اضافه اي مجموعه اعضاء باللوحه ..

شيكت على الجداول شيكت على الملفات صحيحه ..

نص الخطا

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'مـشــرف',
`description` = '',
`usertitle` = 'مـشــرف',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12579319',
`genericpermissions` = '1491607179',
`maxnewthread` = '',
`maxnewtime` = '',
`maxnewpost` = '',
`maxnewposttime` = '',
`attachlimit` = '0',
`pmquota` = '70',
`pmpermissions` = '0',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '250000',
`avatarmaxwidth` = '180',
`avatarmaxheight` = '190',
`avatarmaxsize` = '20000000',
`signaturepermissions` = '138495',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '2000',
`sigmaxchars` = '1000',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1000',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '51063',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '250000'
WHERE usergroupid=7;

MySQL Error : Unknown column 'maxnewthread' in 'field list'
Error Number : 1054
Request Date : Monday, October 19th 2009 @ 07:42:52 PM
Error Date : Monday, October 19th 2009 @ 07:42:52 PM
Script : http://www. .com/vb/admincp/usergroup.php?do=update
Referrer : http://www. .com/vb/admincp/usergroup.php?do=edit&usergroupid=7
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community

**ahmed-samara** · 20-10-2009

المشاركة الأصلية كتبت بواسطة star top مشاهدة المشاركة

كود:

 
<!--
Database error in vBulletin 3.7.4:
 
Invalid SQL:
 
        SELECT 
            userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
            language.phrasegroup_global AS phrasegroup_global,
            language.options AS lang_options,
            language.languagecode AS lang_code,
            language.charset AS lang_charset,
            language.locale AS lang_locale,
            language.imagesoverride AS lang_imagesoverride,
            language.dateoverride AS lang_dateoverride,
            language.timeoverride AS lang_timeoverride,
            language.registereddateoverride AS lang_registereddateoverride,
            language.calformat1override AS lang_calformat1override,
            language.calformat2override AS lang_calformat2override,
            language.logdateoverride AS lang_logdateoverride,
            language.decimalsep AS lang_decimalsep,
            language.thousandsep AS lang_thousandsep
            
        FROM user AS user
        LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
        LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 3, user.languageid)) 
        
        WHERE user.userid = 1;
 
MySQL Error   : Table 'language' is marked as crashed and last (automatic?) repair failed
Error Number  : 1195
Request Date  : Sunday, August 23rd 2009 @ 09:30:49 AM
Error Date    : Sunday, August 23rd 2009 @ 09:30:49 AM
Script        : http://www.fgfg/vb/login.php?do=login
Referrer      : http://www.fgfgf/vb/admincp/
IP Address    :
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

سويت تحديث ومافيه فايده
واذا دخلت للوحه التحكم يطلع ذي

كود:

<!--
Database error in vBulletin :
 
Invalid SQL:
 
            SELECT *
            FROM datastore
            WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','maxloggedin','acpstats','mailqueue','pluginlistadmin');
 
MySQL Error   : Table 'datastore' is marked as crashed and last (automatic?) repair failed
Error Number  : 1195
Request Date  : Sunday, August 23rd 2009 @ 09:41:04 AM
Error Date    : Sunday, August 23rd 2009 @ 09:41:04 AM
Script        : http://wwwsdfdgg/vb/admincp/
Referrer      : 
IP Address    :
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

ومبروك عليكم الشهر الفضيل

المشكلة عزيزي من ملف اللغه قم بأستبدال واحد جديد

المشاركة الأصلية كتبت بواسطة احباب طيار مشاهدة المشاركة

وجربت زرعت الامر كذا

كود PHP:
CREATE TABLE IF NOT EXISTS `forumprefixset` (
`prefixid` varchar(25) NOT NULL,
`usergroupid` smallint(5) unsigned NOT NULL,
KEY `prefixusergroup` (`prefixid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

الان تغير الخطا واصبح

Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT forumprefixset.*
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
ORDER BY prefixset.displayorder;
MySQL Error : Unknown column 'forumprefixset.prefixsetid' in 'on clause'
Error Number : 1054
Request Date : Saturday, August 22nd 2009 @ 11:32:12 PM
Error Date : Saturday, August 22nd 2009 @ 11:32:12 PM
Script : http://www.xxxxx/vb/admincp/index.php
Referrer :
IP Address : xxxx
Username :xxx
Classname : vB_Database
MySQL Version : 5.0.81-community-log

عزيزي لماذا قمت بزرع الامر قم بحذف الجدول كامل وان شاء الله تنحل معاك

المشاركة الأصلية كتبت بواسطة hagryyy مشاهدة المشاركة

السلام عليكم ..

لدي مشكله عند تعديل او اضافه اي مجموعه اعضاء باللوحه ..

شيكت على الجداول شيكت على الملفات صحيحه ..

نص الخطا

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'مـشــرف',
`description` = '',
`usertitle` = 'مـشــرف',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12579319',
`genericpermissions` = '1491607179',
`maxnewthread` = '',
`maxnewtime` = '',
`maxnewpost` = '',
`maxnewposttime` = '',
`attachlimit` = '0',
`pmquota` = '70',
`pmpermissions` = '0',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '250000',
`avatarmaxwidth` = '180',
`avatarmaxheight` = '190',
`avatarmaxsize` = '20000000',
`signaturepermissions` = '138495',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '2000',
`sigmaxchars` = '1000',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1000',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '51063',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '250000'
WHERE usergroupid=7;

MySQL Error : Unknown column 'maxnewthread' in 'field list'
Error Number : 1054
Request Date : Monday, October 19th 2009 @ 07:42:52 PM
Error Date : Monday, October 19th 2009 @ 07:42:52 PM
Script : http://www. .com/vb/admincp/usergroup.php?do=update
Referrer : http://www. .com/vb/admincp/usergroup.php?do=edit&usergroupid=7
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community

ازرع من خلال phpmyadmin

كود:

ALTER TABLE `usergroup` ADD `maxnewthread` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

**hagryyy** · 20-10-2009

اخوي احمد .. سويت الامر وطلع لي خطا اخر
اللي هو يقول ( maxnewtime ) وكان اول
maxnewthread

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'عـضــو',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12317183',
`genericpermissions` = '1345853123',
`maxnewthread` = '0',
`maxnewtime` = '',
`maxnewpost` = '',
`maxnewposttime` = '',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '250000',
`avatarmaxwidth` = '180',
`avatarmaxheight` = '190',
`avatarmaxsize` = '2000000',
`signaturepermissions` = '138495',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '2000',
`sigmaxchars` = '1000',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1000',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '18295',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '250000'
WHERE usergroupid=2;

MySQL Error : Unknown column 'maxnewtime' in 'field list'
Error Number : 1054
Request Date : Tuesday, October 20th 2009 @ 11:26:51 AM
Error Date : Tuesday, October 20th 2009 @ 11:26:51 AM
Script : http://www..com/vb/admincp/usergroup.php?do=update
Referrer : http://www..com/vb/admincp/usergroup...&usergroupid=2
IP Address :
Username :

Classname : vB_Database
MySQL Version : 5.0.81-community

**ahmed-samara** · 20-10-2009

المشاركة الأصلية كتبت بواسطة hagryyy مشاهدة المشاركة

اخوي احمد .. سويت الامر وطلع لي خطا اخر
اللي هو يقول ( maxnewtime ) وكان اول
maxnewthread

اوكي قم بزرع هذا الاوامر

كود:

ALTER TABLE `usergroup` ADD `maxnewthread` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE `usergroup` ADD `maxnewtime` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE `usergroup` ADD `maxnewpost` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE `usergroup` ADD `maxnewposttime` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

**hagryyy** · 21-10-2009

شكرك اخوي احمد .. الف شكر

**شبكة أقتصاديات** · 30-10-2009

الاخ احمد

قام احد الاطفال بزرع تروجان بموقعي و بحثت عنه ولم اجدة هل هناك طريقة لمعرفة مكان التروجان علما ان رساله هذا الموقع قد يضر بجهازك لم تظهر بمحرك بحث قوقل ارجو القاء نظرة على الرابط
http://www.google.com/safebrowsing/d...%3D85658&hl=ar

**ahmed-samara** · 31-10-2009

المشاركة الأصلية كتبت بواسطة hagryyy مشاهدة المشاركة

شكرك اخوي احمد .. الف شكر

اهلا بيك , وبالتوفيق

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

الاخ احمد

قام احد الاطفال بزرع تروجان بموقعي و بحثت عنه ولم اجدة هل هناك طريقة لمعرفة مكان التروجان علما ان رساله هذا الموقع قد يضر بجهازك لم تظهر بمحرك بحث قوقل ارجو القاء نظرة على الرابط
http://www.google.com/safebrowsing/d...%3D85658&hl=ar

مثل هذا المشكلة قد قمت بموضع حلول لها للأخوان وهذا امثله ,

http://www.swalif.net/softs/swalif59/softs270442/

http://www.swalif.net/softs/swalif59/softs270902/

http://www.swalif.net/softs/swalif59/softs271914/

**ahmed-samara** · 31-10-2009

المشاركة الأصلية كتبت بواسطة hagryyy مشاهدة المشاركة

شكرك اخوي احمد .. الف شكر

اهلا بيك , وبالتوفيق

**Djoudi.net** · 11-12-2009

هذا الخطأ ما عرفتكيف حله يأتني دائماعلى البريد

أرجوا المساعدة

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN(23,13,5,17,18,34,)
ORDER BY 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 ')
ORDER BY lastpost DESC
LIMIT 0, 10' at line 9
Error Number : 1064
Request Date : Thursday, December 10th 2009 @ 08:33:33 PM
Error Date : Thursday, December 10th 2009 @ 08:33:33 PM
Script : http://www.albaidha.net/vb/forumdisplay.php?f=14
Referrer :
IP Address : 66.249.68.243
Username : غير مسجل
Classname : vB_Database
MySQL Version :

**ahmed-samara** · 11-12-2009

المشاركة الأصلية كتبت بواسطة Djoudi.net مشاهدة المشاركة

هذا الخطأ ما عرفتكيف حله يأتني دائماعلى البريد

أرجوا المساعدة

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN(23,13,5,17,18,34,)
ORDER BY 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 ')
ORDER BY lastpost DESC
LIMIT 0, 10' at line 9
Error Number : 1064
Request Date : Thursday, December 10th 2009 @ 08:33:33 PM
Error Date : Thursday, December 10th 2009 @ 08:33:33 PM
Script : http://www.albaidha.net/vb/forumdisplay.php?f=14
Referrer :
IP Address : 66.249.68.243
Username : غير مسجل
Classname : vB_Database
MySQL Version :

قم بحذف هاك اخر 10 مواضيع وركب واحد نظيف عزيزي , بالتوفيق

**web-enter** · 19-12-2009

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT * FROM usergroup ORDER BY title;
MySQL Error : Table 'xxxxxx_vb8creeryza.usergroup' doesn't exist
Error Number : 1146
Request Date : Saturday, December 19th 2009 @ 03:44:16 PM
Error Date : Saturday, December 19th 2009 @ 03:44:16 PM
Script : http://www.xxxxxx.net/avb/install/fi...ade.php?step=1
Referrer : http://www.xxxxx.net/avb/install/finalupgrade.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.85-community

لما اقي تطلع لي هذي العبارة ولا اعلم ما السبب

**ahmed-samara** · 19-12-2009

المشاركة الأصلية كتبت بواسطة web-enter مشاهدة المشاركة

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT * FROM usergroup ORDER BY title;
MySQL Error : Table 'xxxxxx_vb8creeryza.usergroup' doesn't exist
Error Number : 1146
Request Date : Saturday, December 19th 2009 @ 03:44:16 PM
Error Date : Saturday, December 19th 2009 @ 03:44:16 PM
Script : http://www.xxxxxx.net/avb/install/fi...ade.php?step=1
Referrer : http://www.xxxxx.net/avb/install/finalupgrade.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.85-community

لما اقي تطلع لي هذي العبارة ولا اعلم ما السبب

اخي الكريم, يبدو ان جدول المجموعات الاعضاء تم حذفه , وتأكد من قاعده البيانات phpmyadmin ان الجدول مفقود ام متواجد ,اذا غير متواجد قم بتنفيذ هذا الامر ,

هذا الجدول usergroup

كود:


CREATE TABLE IF NOT EXISTS `usergroup` (
  `usergroupid` smallint(5) unsigned NOT NULL auto_increment,
  `title` char(100) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `usertitle` char(100) NOT NULL default '',
  `passwordexpires` smallint(5) unsigned NOT NULL default '0',
  `passwordhistory` smallint(5) unsigned NOT NULL default '0',
  `pmquota` smallint(5) unsigned NOT NULL default '0',
  `pmsendmax` smallint(5) unsigned NOT NULL default '5',
  `opentag` char(100) NOT NULL default '',
  `closetag` char(100) NOT NULL default '',
  `canoverride` smallint(5) unsigned NOT NULL default '0',
  `ispublicgroup` smallint(5) unsigned NOT NULL default '0',
  `forumpermissions` int(10) unsigned NOT NULL default '0',
  `pmpermissions` int(10) unsigned NOT NULL default '0',
  `calendarpermissions` int(10) unsigned NOT NULL default '0',
  `wolpermissions` int(10) unsigned NOT NULL default '0',
  `adminpermissions` int(10) unsigned NOT NULL default '0',
  `genericpermissions` int(10) unsigned NOT NULL default '0',
  `genericpermissions2` int(10) unsigned NOT NULL default '0',
  `genericoptions` int(10) unsigned NOT NULL default '0',
  `signaturepermissions` int(10) unsigned NOT NULL default '0',
  `visitormessagepermissions` int(10) unsigned NOT NULL default '0',
  `attachlimit` int(10) unsigned NOT NULL default '0',
  `avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
  `avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
  `avatarmaxsize` int(10) unsigned NOT NULL default '0',
  `profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
  `profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
  `profilepicmaxsize` int(10) unsigned NOT NULL default '0',
  `sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
  `sigpicmaxheight` smallint(5) unsigned NOT NULL default '0',
  `sigpicmaxsize` int(10) unsigned NOT NULL default '0',
  `sigmaximages` smallint(5) unsigned NOT NULL default '0',
  `sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0',
  `sigmaxchars` smallint(5) unsigned NOT NULL default '0',
  `sigmaxrawchars` smallint(5) unsigned NOT NULL default '0',
  `sigmaxlines` smallint(5) unsigned NOT NULL default '0',
  `usercsspermissions` int(10) unsigned NOT NULL default '0',
  `albumpermissions` int(10) unsigned NOT NULL default '0',
  `albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
  `albumpicmaxheight` smallint(5) unsigned NOT NULL default '0',
  `albumpicmaxsize` int(10) unsigned NOT NULL default '0',
  `albummaxpics` int(10) unsigned NOT NULL default '0',
  `albummaxsize` int(10) unsigned NOT NULL default '0',
  `socialgrouppermissions` int(10) unsigned NOT NULL default '0',
  `pmthrottlequantity` int(10) unsigned NOT NULL default '0',
  `groupiconmaxsize` int(10) unsigned NOT NULL default '0',
  `maximumsocialgroups` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`usergroupid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `usergroup`
--

INSERT INTO `usergroup` (`usergroupid`, `title`, `description`, `usertitle`, `passwordexpires`, `passwordhistory`, `pmquota`, `pmsendmax`, `opentag`, `closetag`, `canoverride`, `ispublicgroup`, `forumpermissions`, `pmpermissions`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions`, `genericpermissions2`, `genericoptions`, `signaturepermissions`, `visitormessagepermissions`, `attachlimit`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaximages`, `sigmaxsizebbcode`, `sigmaxchars`, `sigmaxrawchars`, `sigmaxlines`, `usercsspermissions`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `socialgrouppermissions`, `pmthrottlequantity`, `groupiconmaxsize`, `maximumsocialgroups`) VALUES
(1, 'ÒæÇÑ', '', 'ÒæÇÑ', 0, 0, 50, 0, '', '', 0, 0, 655421, 0, 1, 0, 0, 33554432, 0, 96, 0, 16, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 192, 600, 600, 100000, 100, 0, 64, 0, 65535, 0),
(2, 'ãÔÊÑß ÇáÏÚã ÇáÝäí', '', 'ãÔÊÑß ÇáÏÚã ÇáÝäí', 0, 0, 50, 5, '', '', 0, 0, 12317183, 3, 63, 1, 0, 1579685063, 1, 62, 137215, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 63, 255, 600, 600, 100000, 100, 0, 55159, 0, 65535, 5),
(3, 'íäÊÙÑ ÇáÊÝÚíá', '', '', 0, 0, 50, 1, '', '', 0, 0, 655375, 0, 1, 0, 0, 33554499, 0, 56, 0, 16, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 192, 600, 600, 100000, 100, 0, 64, 0, 65535, 5),
(4, '(COPPA) Users Awaiting Moderation', '', '', 0, 0, 50, 1, '', '', 0, 0, 655375, 0, 1, 0, 0, 33554499, 0, 56, 0, 16, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 192, 600, 600, 100000, 100, 0, 64, 0, 65535, 5),
(5, 'ãÓÄÇá ÇÞÓÇã ÇáÏÚã', '', 'ãÓÄÇá ÇÞÓÇã ÇáÏÚã', 0, 0, 50, 0, '', '', 0, 0, 16777215, 7, 63, 15, 1, 1609520879, 1, 63, 237567, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 63, 255, 600, 600, 100000, 100, 0, 65535, 0, 65535, 5),
(6, 'ÇÏÇÑÉ ÎÏãÉ ÓÇÚÏ', '', 'ÇÏÇÑÉ ÎÏãÉ ÓÇÚÏ', 180, 360, 50, 5, '', '', 0, 0, 16777215, 7, 63, 31, 3, 2147483583, 1, 55, 237567, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 0, 7, 0, 0, 0, 63, 255, 600, 600, 100000, 100, 0, 65535, 0, 65535, 5),
(7, 'ÇáÏÚã ÇáÝäí', '', 'ÇáÏÚã ÇáÝäí', 0, 0, 50, 5, '', '', 0, 0, 12317183, 7, 63, 15, 0, 1609504463, 1, 62, 237567, 63, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 63, 255, 600, 600, 100000, 100, 0, 65535, 0, 65535, 5),
(8, 'Banned Users', '', 'Banned', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 80, 80, 20000, 100, 100, 65535, 500, 100, 10000, 4, 7, 500, 1000, 0, 0, 0, 600, 600, 100000, 100, 0, 0, 0, 65535, 5);

**alsultan88** · 21-12-2009

Invalid SQL:
SELECT forumid FROM thread WHERE threadid =;
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, December 15th 2009 @ 04:51:04 AM
Error Date : Tuesday, December 15th 2009 @ 04:51:04 AM
Script : http://www.ramocafe.com/showthread.php?p=378475
Referrer :
IP Address : 66.249.71.178
Username :
Classname : vB_Database
MySQL Version :

هل ممكن حل لهذا الخطأ
يضهر عند الدخول للرابط الموجود ضمن الخطأ ولا اعلم من وين جايبن هالرابط انا مركب في بي سيو وهالروابط ما عندي
بس من خلال الايبي ارى انها عناكب تزور هذه الروابط

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

أدوات الموضوع

بحث في الموضوع

المواضيع المتشابهه

قــواعــد بيانات منتديات من 2000 الى 10000 عضو واكثر

ضوابط المشاركة