الخطــأ :

Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
advanced, volatile, validationcode, blacklist, product)
VALUES
(
'templateversion',
'version',
'4.0.8',
'4.0.8',
'free',
'',
1,
0,
1,
'',
0,
'vbulletin'
),
(
'default_route_segment',
'version',
'content',
'content',
'free',
'',
5,
0,
1,
'',
0,
'vbulletin'
),
(
'subscriptionmethods',
'version',
'0',
'0',
'boolean',
'yesno',
10,
0,
1,
'',
1,
'vbulletin'
),
(
'attachfile',
'version',
'',
'',
'free',
'radioiped\r\n0|no\r\n1|yes(,)userid/userid.attach\r\n2|yes(,)u/s/e/r/i/d/userid.attach',
20,
0,
1,
'',
1,
'vbulletin'
),
(
'hv_type',
'version',
'Recaptcha',
'Image',
'free',
'radioiped\r\n0|disabled\r\nImage|image_verification\r\n Question|question_verification\r\nRecaptcha|recapt cha',
20,
0,
1,
'',
0,
'vbulletin'
),
(
'hv_recaptcha_publickey',
'version',
'',
'',
'free',
'',
22,
0,
1,
'',
0,
'vbulletin'
),
(
'hv_recaptcha_privatekey',
'version',
'',
'',
'free',
'',
24,
0,
1,
'',
0,
'vbulletin'
),
(
'hv_recaptcha_theme',
'version',
'white',
'white',
'free',
'radioiped\r\nred|recaptcha_red\r\nwhite|recaptcha_white \r\nblackglass|recaptcha_blackglass\r\nclean|recap tcha_clean',
25,
0,
1,
'',
0,
'vbulletin'
),
(
'regimagetype',
'version',
'GDttf',
'GD',
'free',
'<div class=\\\"smallfont\\\">\r\n <label for=\\\"rb_setting[regimagetype]GDttf_0\\\">\r\n <input type=\\\"radio\\\"\r\n name=\\\"setting[$setting[varname]]\\\"\r\n id=\\\"rb_setting[regimagetype]GDttf_0\\\"\r\n value=\\\"GDttf\\\"\r\n \" . ($setting[\'value\'] == \'GDttf\' ? \' checked=\"checked\"\' : \'\') . \"\r\n />GD<br />\r\n <img src=\\\"../image.php?hash=test&amp;i=gd\\\" alt=\\\"GD\\\" width=\\\"201\\\" height=\\\"61\\\" border=\\\"0\\\" style=\\\"padding: 1px\\\" />\r\n </label>\r\n</div>\r\n\r\n\" . (!empty($vbulletin->options[\'magickpath\']) ? \"\r\n<div class=\\\"smallfont\\\" style=\\\"margin-top:1em\\\">\r\n <label for=\\\"rb_setting[regimagetype]Magick_0\\\">\r\n <input type=\\\"radio\\\"\r\n name=\\\"setting[$setting[varname]]\\\"\r\n id=\\\"rb_setting[regimagetype]Magick_0\\\"\r\n value=\\\"Magick\\\"\r\n \" . ($setting[\'value\'] == \'Magick\' ? \' checked=\"checked\"\' : \'\') . \"\r\n />ImageMagick<br />\r\n <img src=\\\"../image.php?hash=test&amp;i=im\\\" alt=\\\"ImageMagick\\\" width=\\\"201\\\" height=\\\"61\\\" border=\\\"0\\\" style=\\\"padding: 1px\\\" />\r\n </label>\r\n</div>\r\n\" : \'\') . \"',
29,
0,
1,
'',
0,
'vbulletin'
),
(
'attachpath',
'version',
'/path/to/your/attachment/directory',
'/path/to/your/attachment/directory',
'free',
'',
30,
0,
1,
'',
1,
'vbulletin'
),
(
'regimageoption',
'version',
'15',
'15',
'bitfield',
'bitfield:nocache|regimageoptions',
30,
0,
1,
'',
0,
'vbulletin'
),
(
'usefileavatar',
'version',
'0',
'',
'boolean',
'yesno',
40,
0,
1,
'',
1,
'vbulletin'
),
(
'avatarpath',
'version',
'./customavatars',
'./customavatars',
'free',
'',
50,
0,
1,
'',
1,
'vbulletin'
),
(
'avatarurl',
'version',
'customavatars',
'customavatars',
'free',
'',
60,
0,
1,
'',
1,
'vbulletin'
),
(
'profilepicpath',
'version',
'./customprofilepics',
'./customprofilepics',
'free',
'',
70,
0,
1,
'',
1,
'vbulletin'
),
(
'profilepicurl',
'version',
'customprofilepics',
'customprofilepics',
'free',
'',
80,
0,
1,
'',
1,
'vbulletin'
),
(
'sigpicpath',
'version',
'./signaturepics',
'./signaturepics',
'free',
'',
90,
0,
1,
'',
1,
'vbulletin'
),
(
'sigpicurl',
'version',
'signaturepics',
'signaturepics',
'free',
'',
100,
0,
1,
'',
1,
'vbulletin'
),
(
'fulltextsearch',
'version',
'1',
'0',
'boolean',
'yesno',
110,
0,
1,
'',
1,
'vbulletin'
),
(
'searchimplementation',
'version',
'vBDBSearch_Core',
'vBDBSearch_Core',
'free',
'',
110,
0,
1,
'',
0,
'vbulletin'
),
(
'album_dataloc',
'version',
'db',
'db',
'free',
'radioiped\r\ndb|DB\r\nfs|File System\r\nfs_directthumb|File System with Direct Thumbs',
120,
0,
1,
'',
0,
'vbulletin'
),
(
'album_picpath',
'version',
'',
'',
'free',
'',
130,
0,
1,
'',
0,
'vbulletin'
),
(
'album_thumbpath',
'version',
'',
'',
'free',
'',
140,
0,
1,
'',
0,
'vbulletin'
),
(
'album_thumburl',
'version',
'',
'',
'free',
'',
150,
0,
1,
'',
0,
'vbulletin'
),
(
'usefilegroupicon',
'version',
'0',
'0',
'boolean',
'yesno',
160,
0,
1,
'',
1,
'vbulletin'
),
(
'groupiconpath',
'version',
'./customgroupicons',
'./customgroupicons',
'free',
'',
165,
0,
1,
'',
1,
'vbulletin'
),
(
'groupiconurl',
'version',
'customgroupicons',
'customgroupicons',
'free',
'',
170,
0,
1,
'',
1,
'vbulletin'
);

MySQL Error : Duplicate entry 'templateversion' for key 1

في الغالب هذا الخطأ يكون في الترقيه ، فإذا كان الخطأ يواجهك من خلال الترقيه
تجاوز هذهـ الخطوه للخطوه التاليه من خلال الرابـط

الخطــأ :

Invalid SQL:

REPLACE INTO stylevardfn
(stylevarid, styleid, stylevargroup, product, datatype, validation, failsafe)
VALUES
('albumedit_blockrow_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumedit_maineditor_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumedit_maineditor_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumedit_maineditor_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumedit_thumbnailedit_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumlist_blockbody_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumlist_entry_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumlist_entry_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumlist_entry_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumlist_image_shadow_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_margin', -1, 'Album', 'vbulletin', 'size', '', ''),('album_content_width', -1, 'Album', 'vbulletin', 'size', '', ''),('picturelink_img_shadow_color', -1, 'Album', 'vbulletin', 'color', '', ''),('picturelink_margin', -1, 'Album', 'vbulletin', 'size', '', '');

MySQL Error : Unknown column 'styleid' in 'field list'
Error Number : 1054

الحــــــــل :

ALTER TABLE `stylevardfn` ADD `styleid` SMALLINT UNSIGNED NOT NULL DEFAULT '0'