الرجاء الحل العاجل لمشكلة Invalid SQL
السلام عليكم ورحمة الله وبركاته
اريد حل لمشكلة Invalid SQL عند تحديث مجموعه معينه Database error in vBulletin 3.8.4: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'دعم فني', `description` = 'دعم فني', `usertitle` = '', `opentag` = '<input type=\"text\" name=\"T1\" size=\"17\" class=\"yellow\" value=\"', `closetag` = '\" readonly style=\"border-style:dotted; border-width:1px; width: 90\">', `passwordexpires` = '0', `passwordhistory` = '0', `ispublicgroup` = '1', `canoverride` = '1', `forumpermissions` = '16777215', `genericpermissions` = '1592786943', `maxnewthread` = '', `maxnewtime` = '', `maxnewpost` = '', `maxnewposttime` = '', `attachlimit` = '1000000', `pmquota` = '25', `pmpermissions` = '7', `pmsendmax` = '5', `pmthrottlequantity` = '3', `calendarpermissions` = '63', `wolpermissions` = '29', `adminpermissions` = '1', `genericpermissions2` = '1', `genericoptions` = '63', `profilepicmaxwidth` = '600', `profilepicmaxheight` = '600', `profilepicmaxsize` = '25000', `avatarmaxwidth` = '180', `avatarmaxheight` = '250', `avatarmaxsize` = '20000', `signaturepermissions` = '237053', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '600', `sigpicmaxsize` = '99999', `sigmaxrawchars` = '0', `sigmaxchars` = '0', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '0', `albumpermissions` = '255', `albumpicmaxwidth` = '600', `albumpicmaxheight` = '600', `albumpicmaxsize` = '99999999', `albummaxpics` = '100', `albummaxsize` = '999999', `usercsspermissions` = '63', `visitormessagepermissions` = '63', `socialgrouppermissions` = '65535', `maximumsocialgroups` = '0', `groupiconmaxsize` = '0' WHERE usergroupid=11; MySQL Error : Unknown column 'maxnewthread' in 'field list' Error Number : 1054 Request Date : Tuesday, November 10th 2009 @ 06:15:50 AM Error Date : Tuesday, November 10th 2009 @ 06:15:50 AM Script : http://xxxxxx/vb/admincp/usergroup.php?do=update Referrer : http://xxxxxx/vb/admincp/usergroup.p...e rgroupid=11 IP Address : xxxxxx Username : xxxxx Classname : vB_Database MySQL Version : 5.0.81-community-log |
ازرع الامر التالى
كود PHP:
موفق |
مشكور اخوي ولكن نفس المشكله طلع لي مشكله ثانيه لاجيت احدث مجموعه معينه
Database error in vBulletin 3.8.4: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'دعم فني', `description` = 'دعم فني', `usertitle` = '', `opentag` = '<input type=\"text\" name=\"T1\" size=\"17\" class=\"yellow\" value=\"', `closetag` = '\" readonly style=\"border-style:dotted; border-width:1px; width: 90\">', `passwordexpires` = '0', `passwordhistory` = '0', `ispublicgroup` = '1', `canoverride` = '1', `forumpermissions` = '16777215', `genericpermissions` = '1592786943', `maxnewthread` = '0', `maxnewtime` = '', `maxnewpost` = '', `maxnewposttime` = '', `attachlimit` = '1000000', `pmquota` = '25', `pmpermissions` = '7', `pmsendmax` = '5', `pmthrottlequantity` = '3', `calendarpermissions` = '63', `wolpermissions` = '29', `adminpermissions` = '1', `genericpermissions2` = '1', `genericoptions` = '63', `profilepicmaxwidth` = '600', `profilepicmaxheight` = '600', `profilepicmaxsize` = '25000', `avatarmaxwidth` = '180', `avatarmaxheight` = '250', `avatarmaxsize` = '20000', `signaturepermissions` = '237053', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '600', `sigpicmaxsize` = '99999', `sigmaxrawchars` = '0', `sigmaxchars` = '0', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '0', `albumpermissions` = '255', `albumpicmaxwidth` = '600', `albumpicmaxheight` = '600', `albumpicmaxsize` = '99999999', `albummaxpics` = '100', `albummaxsize` = '999999', `usercsspermissions` = '63', `visitormessagepermissions` = '63', `socialgrouppermissions` = '65535', `maximumsocialgroups` = '0', `groupiconmaxsize` = '0' WHERE usergroupid=11; MySQL Error : Unknown column 'maxnewtime' in 'field list' Error Number : 1054 Request Date : Tuesday, November 10th 2009 @ 06:29:58 AM Error Date : Tuesday, November 10th 2009 @ 06:29:58 AM Script : http://xxxxxx/vb/admincp/usergroup.php?do=update Referrer : http://xxxxxx/vb/admincp/usergroup.p...e rgroupid=11 IP Address : xxxxx Username :xxxxx Classname : vB_Database MySQL Version : 5.0.81-community-log |
نفذ الامر التالى
كود PHP:
واذا ظهرت اى اخطاء اخرى نفذ الامرين التالين كود PHP:
كود PHP:
تحياتى ,, |
اخوي نجحت 100%
الله يعطيك العافيه بس لو تحل لي مشكله اخيره وهي Database error in vBulletin 3.8.4: Invalid SQL: CREATE TABLE `posttemplate` ( `pid` int(15) NOT NULL auto_increment, `userid` int(15) NOT NULL default '0', `parentid` int(15) NOT NULL default '0', `type` enum('category','template') NOT NULL default 'category', `title` varchar(255) NOT NULL, `content` mediumtext NOT NULL, PRIMARY KEY (`pid`), KEY `userid` (`userid`) ) Type=MyISAM; MySQL Error : Table 'posttemplate' already exists Error Number : 1050 Request Date : Tuesday, November 10th 2009 @ 08:00:20 AM Error Date : Tuesday, November 10th 2009 @ 08:00:21 AM Script : http://xxxxxx/vb/admincp/plugin.php?do=productimpo rt Referrer : http://xxxxxx/vb/admincp/plugin.php?do=productadd IP Address : xxxxxx Username : xxxxx Classname : vB_Database MySQL Version : 5.0.81-community-log |
ازرع الامر
كود PHP:
تحياتى ,, |
شكرا على ردك مره اخرى
ما استطعت زرع هذا الامر ظهر لي خطأ خطأ إستعلام-SQL: DROP TABLE 'posttemplate' MySQL قال: #1064 - 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 ''posttemplate'' at line 1 |
تاكد من نسخ الكود بالكامل
كود PHP:
|
مرحبااا تعبتك معي اخي
ظهرت مشكله اخرى Database error in vBulletin 3.8.4: Invalid SQL: ALTER TABLE `usergroup` ADD `vbmwaextraedit4_permissions` INT( 10 ) UNSIGNED NOT NULL DEFAULT '18';; MySQL Error : Duplicate column name 'vbmwaextraedit4_permissions' Error Number : 1060 Request Date : Thursday, November 12th 2009 @ 06:05:19 AM Error Date : Thursday, November 12th 2009 @ 06:05:19 AM Script : http://xxxxx/vb/admincp/plugin.php?do=productimpor t Referrer : http://xxxxxx/vb/admincp/plugin.php?do=productadd IP Address : xxxxxxx Username : xxxxxxx Classname : vB_Database MySQL Version : 5.0.81-community-log |
هل من حل يااخوان هل من مساعده
|
جميع الأوقات بتوقيت مكة المكرمة. الساعة الآن » 05:26 AM. |
Powered by vBulletin
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © ArabWebTalk.Com 2004-2012