الويب العربي

الويب العربي (http://www.arabwebtalk.com/index.php)
-   قسم المنتديات (http://www.arabwebtalk.com/forumdisplay.php?f=112)
-   -   الرجاء الحل العاجل لمشكلة Invalid SQL (http://www.arabwebtalk.com/showthread.php?t=126432)

عافوك يا قلبي 10-11-2009 07:22 AM

الرجاء الحل العاجل لمشكلة 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

T®oY 10-11-2009 07:26 AM

ازرع الامر التالى

كود PHP:

  ALTER TABLE `usergroupADD `maxnewthreadINT(10UNSIGNED DEFAULT '0' NOT NULL


موفق

عافوك يا قلبي 10-11-2009 07:31 AM

مشكور اخوي ولكن نفس المشكله طلع لي مشكله ثانيه لاجيت احدث مجموعه معينه

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

T®oY 10-11-2009 08:16 AM

نفذ الامر التالى

كود PHP:

 ALTER TABLE `usergroupADD `maxnewtimeINT11 ) DEFAULT '0' NOT NULL 


واذا ظهرت اى اخطاء اخرى نفذ الامرين التالين

كود PHP:

 ALTER TABLE `usergroupADD `maxnewpostINT11 ) DEFAULT '0' NOT NULL 


كود PHP:

   ALTER TABLE `usergroupADD `maxnewposttimeINT11 ) DEFAULT '0' NOT NULL 


تحياتى ,,

عافوك يا قلبي 10-11-2009 09:01 AM

اخوي نجحت 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

T®oY 10-11-2009 08:45 PM

ازرع الامر

كود PHP:

 DROP TABLE 'posttemplate' 

ثم بعد ذلك اعد رفع منتج ادوات المودة مره اخرى

تحياتى ,,

عافوك يا قلبي 10-11-2009 09:58 PM

شكرا على ردك مره اخرى

ما استطعت زرع هذا الامر ظهر لي خطأ

خطأ
إستعلام-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

T®oY 11-11-2009 04:52 AM

تاكد من نسخ الكود بالكامل

كود PHP:

   DROP TABLE 'posttemplate'


عافوك يا قلبي 12-11-2009 07:11 AM

مرحبااا تعبتك معي اخي

ظهرت مشكله اخرى

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

عافوك يا قلبي 15-11-2009 04:29 AM

هل من حل يااخوان هل من مساعده


جميع الأوقات بتوقيت مكة المكرمة. الساعة الآن » 08:21 AM.

Powered by vBulletin
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © ArabWebTalk.Com 2004-2012