ياااخوان Database error اثناء تشطيب مجلة الفي بي ادفانسد ..! لو سمحتم معنى ذا الخطأ ؟

[المصمم 2005]

السلام عليكم ورحمة الله وبركاتة :

اخواني اثناء تثبيت او تشطيب مجلة الفي بي ادفانسد ظهر لي هذا الخطأ :


Invalid SQL:

INSERT INTO product
(productid, title, description, version, active)
VALUES (
'adv_cmps',
'vBadvanced CMPS',
'vBadvanced Content Management & Portal System',
'3.0 RC1',
1
);

MySQL Error : Duplicate entry 'adv_cmps' for key 1
Error Number : 1062
Date : Saturday, June 16th 2007 @ 08:03:57 AM
Script : http://www.****/vb/****/vbacmps_install.php
Referrer : http://www.****/vb/****/vbacmps_install.php
IP Address : *****
Username : *****
Classname : *****


ممكن القى احد مر عليه هذا الخطا او احد يعرفة او فهم معناه

بإنتظاركم .
تحياتي .

[المصمم 2005]

ويااخوان كيف الواحد يختار انه يرفع يرفع ملفات بصيغة Binary mode او ب ASCII mode
مع العلم اني ارفع بالاف تي بي او من لوحة التحكم احيانا .

تحياتي .

[المصمم 2005]

يااخوان هذا الخطأ الحقيقي وهو طوووويل :

Database error in vBulletin 3.6.7:

Invalid SQL:

INSERT INTO adv_setting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder, serialize)
VALUES
(
'portal_calendarid',
'adv_portal_calendar',
'1',
'',
'calendarselect',
10,
'0'
),(
'portal_calendar_birthdays',
'adv_portal_calendar',
'0',
'',
'yesno',
20,
'0'
),(
'portal_calendar_cache',
'adv_portal_calendar',
'12',
'',
'',
30,
'0'
),(
'portal_threadids',
'adv_portal_latestthreads',
'a:0:{}',
'',
'threadselect',
10,
'1'
),(
'portal_threads_forumids',
'adv_portal_latestthreads',
'',
'',
'forumselect',
20,
'1'
),(
'portal_threads_maxthreads',
'adv_portal_latestthreads',
'10',
'',
'',
30,
'0'
),(
'portal_threads_cutoffdate',
'adv_portal_latestthreads',
'30',
'',
'',
40,
'0'
),(
'portal_threads_maxchars',
'adv_portal_latestthreads',
'25',
'',
'',
50,
'0'
),(
'portal_threads_maxwordchars',
'adv_portal_latestthreads',
'20',
'',
'',
60,
'0'
),(
'portal_threads_orderby',
'adv_portal_latestthreads',
'lastpost',
'',
'<select name=\\\"$name\\\" \" . $jsdefault_onchange . \" tabindex=\\\"1\\\">\n <option \" . iif($setting[value] == \'lastpost\', \'selected=\\\"selected\\\"\'). \" value=\\\"lastpost\\\">$vbphrase[last_post]</option>\n <option \" . iif($setting[value] == \'dateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"dateline\\\">$vbphrase[date_created]</option>\n <option \" . iif($setting[value] == \'title\', \'selected=\\\"selected\\\"\'). \" value=\\\"title\\\">$vbphrase[thread_title]</option>\n <option \" . iif($setting[value] == \'voteavg\', \'selected=\\\"selected\\\"\'). \" value=\\\"voteavg\\\">$vbphrase[rating]</option>\n <option \" . iif($setting[value] == \'replycount\', \'selected=\\\"selected\\\"\'). \" value=\\\"replycount\\\">$vbphrase[replies]</option>\n <option \" . iif($setting[value] == \'views\', \'selected=\\\"selected\\\"\'). \" value=\\\"views\\\">$vbphrase[views]</option>\n</select>',
70,
'0'
),(
'portal_threads_direction',
'adv_portal_latestthreads',
'DESC',
'',
'<select name=\\\"$name\\\" \" . $jsdefault_onchange . \" tabindex=\\\"1\\\">\n <option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">$vbphrase[ascending]</option>\n <option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">$vbphrase[descending]</option>\n</select>',
80,
'0'
),(
'portal_threads_expanded',
'adv_portal_latestthreads',
'2',
'',
'<div class=\\\"smallfont\\\">\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_0\\\">$vbphrase[lean]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">$vbphrase[expanded]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_2\\\">$vbphrase[dynamic]</label>\n</div>',
90,
'0'
),(
'portal_applypermissions',
'adv_portal_latestthreads',
'1',
'',
'yesno',
100,
'0'
),(
'portal_threads_threadstarter',
'adv_portal_latestthreads',
'1',
'',
'yesno',
110,
'0'
),(
'portal_threads_showdate',
'adv_portal_latestthreads',
'1',
'',
'yesno',
120,
'0'
),(
'portal_threads_views',
'adv_portal_latestthreads',
'1',
'',
'yesno',
130,
'0'
),(
'portal_threads_replies',
'adv_portal_latestthreads',
'1',
'',
'yesno',
140,
'0'
),(
'portal_threads_lastpost',
'adv_portal_latestthreads',
'1',
'',
'yesno',
150,
'0'
),(
'portal_threads_showforum',
'adv_portal_latestthreads',
'0',
'',
'yesno',
160,
'0'
),(
'portal_threads_showpreview',
'adv_portal_latestthreads',
'1',
'',
'yesno',
170,
'0'
),(
'portal_threads_showicon',
'adv_portal_latestthreads',
'1',
'',
'yesno',
180,
'0'
),(
'portal_threads_showsubscribed',
'adv_portal_latestthreads',
'1',
'',
'yesno',
190,
'0'
),(
'portal_threads_showrating',
'adv_portal_latestthreads',
'1',
'',
'yesno',
200,
'0'
),(
'portal_threads_stickyicon',
'adv_portal_latestthreads',
'0',
'',
'yesno',
210,
'0'
),(
'portal_threads_multipage',
'adv_portal_latestthreads',
'0',
'',
'yesno',
220,
'0'
),(
'portal_threads_showpaperclip',
'adv_portal_latestthreads',
'1',
'',
'yesno',
230,
'0'
),(
'portal_navigation_excludepages',
'adv_portal_navigation',
'',
'',
'pageselect',
10,
'1'
),(
'portal_navigation_mark1',
'adv_portal_navigation',
'&raquo;',
'',
'',
20,
'0'
),(
'portal_navigation_mark2',
'adv_portal_navigation',
'&gt;',
'',
'',
30,
'0'
),(
'portal_navigation_addpages',
'adv_portal_navigation',
'a:3:{i:0;a:4:{s:5:\"order\";s:1:\"1\";s:5:\"level\";s:1:\"1\";s:4:\"link\";s:38:\"{$vbulletin->options[bburl]}/index.php\";s:4:\"text\";s:5:\"Forum\";}i:1;a:4:{s:5:\"order\";s:1:\"2\";s:5:\"level\";s:1:\"2\";s:4 :\"link\";s:39:\"{$vbulletin->options[bburl]}/usercp.php\";s:4:\"text\";s:7:\"User CP\";}i:2;a:4:{s:5:\"order\";s:1:\"3\";s:5:\"level\";s:1:\"2\";s:4:\"link\";s:36:\"{$vbulletin->options[bburl]}/faq.php\";s:4:\"text\";s:3:\"FAQ\";}}',
'',
'pageselect_add',
40,
'1'
),(
'portal_threadids',
'adv_portal_news',
'a:0:{}',
'',
'threadselect',
10,
'1'
),(
'portal_news_forumid',
'adv_portal_news',
'',
'',
'forumselect',
20,
'1'
),(
'portal_news_maxposts',
'adv_portal_news',
'5',
'',
'',
30,
'0'
),(
'portal_news_cutoffdate',
'adv_portal_news',
'60',
'',
'',
40,
'0'
),(
'portal_news_maxchars',
'adv_portal_news',
'500',
'',
'',
50,
'0'
),(
'portal_news_dateformat',
'adv_portal_news',
'M d, Y - g:i A',
'',
'',
60,
'0'
),(
'portal_news_orderby',
'adv_portal_news',
'postdateline',
'',
'<select name=\\\"$name\\\" \" . $jsdefault_onchange . \" tabindex=\\\"1\\\">\n <option \" . iif($setting[value] == \'lastpost\', \'selected=\\\"selected\\\"\'). \" value=\\\"lastpost\\\">$vbphrase[last_post]</option>\n <option \" . iif($setting[value] == \'postdateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"postdateline\\\">$vbphrase[date_created]</option>\n <option \" . iif($setting[value] == \'title\', \'selected=\\\"selected\\\"\'). \" value=\\\"title\\\">$vbphrase[thread_title]</option>\n <option \" . iif($setting[value] == \'voteavg\', \'selected=\\\"selected\\\"\'). \" value=\\\"voteavg\\\">$vbphrase[rating]</option>\n <option \" . iif($setting[value] == \'replycount\', \'selected=\\\"selected\\\"\'). \" value=\\\"replycount\\\">$vbphrase[replies]</option>\n <option \" . iif($setting[value] == \'views\', \'selected=\\\"selected\\\"\'). \" value=\\\"views\\\">$vbphrase[views]</option>\n</select>',
70,
'0'
),(
'portal_news_direction',
'adv_portal_news',
'DESC',
'',
'<select name=\\\"$name\\\" \" . $jsdefault_onchange . \" tabindex=\\\"1\\\">\n <option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">$vbphrase[ascending]</option>\n <option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">$vbphrase[descending]</option>\n</select>',
80,
'0'
),(
'portal_news_showattachments',
'adv_portal_news',
'0',
'',
'<div class=\\\"smallfont\\\">\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_0\\\">$vbphrase[no]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">$vbphrase[yes_first_attach_only]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_2\\\">$vbphrase[yes_all_attachments]</label>\n</div>',
90,
'0'
),(
'portal_applypermissions',
'adv_portal_news',
'1',
'',
'yesno',
100,
'0'
),(
'portal_news_allowreplies',
'adv_portal_news',
'1',
'',
'yesno',
110,
'0'
),(
'portal_news_showavatar',
'adv_portal_news',
'1',
'',
'yesno',
120,
'0'
),(
'portal_news_showicon',
'adv_portal_news',
'1',
'',
'yesno',
130,
'0'
),(
'portal_news_showrating',
'adv_portal_news',
'1',
'',
'yesno',
140,
'0'
),(
'portal_news_showsubscribed',
'adv_portal_news',
'1',
'',
'yesno',
150,
'0'
),(
'portal_news_showprintable',
'adv_portal_news',
'1',
'',
'yesno',
160,
'0'
),(
'portal_news_showsendfriend',
'adv_portal_news',
'1',
'',
'yesno',
170,
'0'
),(
'portal_news_showsignature',
'adv_portal_news',
'0',
'',
'yesno',
180,
'0'
),(
'portal_news_sticky',
'adv_portal_news',
'0',
'',
'yesno',
190,
'0'
),(
'portal_news_legacy',
'adv_portal_news',
'1',
'',
'yesno',
200,
'0'
),(
'portal_news_attachpaperclip',
'adv_portal_news',
'0',
'',
'yesno',
210,
'0'
),(
'portal_news_bbcode_attach',
'adv_portal_news',
'1',
'',
'yesno',
220,
'0'
),(
'portal_news_postcache',
'adv_portal_news',
'1',
'',
'yesno',
230,
'0'
),(
'portal_news_enablehtml',
'adv_portal_news',
'0',
'',
'yesno',
240,
'0'
),(
'portal_news_enablevbcode',
'adv_portal_news',
'1',
'',
'yesno',
250,
'0'
),(
'portal_news_enablevbimage',
'adv_portal_news',
'1',
'',
'yesno',
260,
'0'
),(
'portal_news_enablesmilies',
'adv_portal_news',
'1',
'',
'yesno',
270,
'0'
),(
'portal_news_enablearchive',
'adv_portal_newsarchive',
'5',
'',
'',
10,
'0'
),(
'portal_archive_maxchars',
'adv_portal_newsarchive',
'25',
'',
'',
20,
'0'
),(
'portal_archive_expanded',
'adv_portal_newsarchive',
'2',
'',
'<div class=\\\"smallfont\\\">\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_0\\\">$vbphrase[lean]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">$vbphrase[expanded]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_2\\\">$vbphrase[dynamic]</label>\n</div>',
30,
'0'
),(
'portal_news_archivepreview',
'adv_portal_newsarchive',
'1',
'',
'yesno',
40,
'0'
),(
'portal_archive_threadstarter',
'adv_portal_newsarchive',
'1',
'',
'yesno',
50,
'0'
),(
'portal_archive_showdate',
'adv_portal_newsarchive',
'1',
'',
'yesno',
60,
'0'
),(
'portal_archive_showviews',
'adv_portal_newsarchive',
'1',
'',
'yesno',
70,
'0'
),(
'portal_archive_showreplies',
'adv_portal_newsarchive',
'1',
'',
'yesno',
80,
'0'
),(
'portal_newsarchive_lastpost',
'adv_portal_newsarchive',
'1',
'',
'yesno',
90,
'0'
),(
'portal_newsarchive_showforum',
'adv_portal_newsarchive',
'0',
'',
'yesno',
100,
'0'
),(
'portal_archive_showrating',
'adv_portal_newsarchive',
'0',
'',
'yesno',
110,
'0'
),(
'portal_archive_showicon',
'adv_portal_newsarchive',
'1',
'',
'yesno',
120,
'0'
),(
'portal_archive_showsubscribed',
'adv_portal_newsarchive',
'1',
'',
'yesno',
130,
'0'
),(
'portal_archive_stickyicon',
'adv_portal_newsarchive',
'0',
'',
'yesno',
140,
'0'
),(
'portal_archive_multipage',
'adv_portal_newsarchive',
'0',
'',
'yesno',
150,
'0'
),(
'portal_archive_attachpaperclip',
'adv_portal_newsarchive',
'0',
'',
'yesno',
160,
'0'
),(
'portal_threadids',
'adv_portal_poll',
'',
'',
'threadselect',
10,
'1'
),(
'portal_poll_forumid',
'adv_portal_poll',
'',
'',
'forumselect',
20,
'1'
),(
'portal_poll_cutoffdate',
'adv_portal_poll',
'30',
'',
'',
30,
'0'
),(
'portal_poll_orderby',
'adv_portal_poll',
'dateline',
'',
'<select name=\\\"$name\\\" \" . $jsdefault_onchange . \" tabindex=\\\"1\\\">\n <option \" . iif($setting[value] == \'dateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"dateline\\\">$vbphrase[date_created]</option>\n <option \" . iif($setting[value] == \'votedate\', \'selected=\\\"selected\\\"\'). \" value=\\\"votedate\\\">$vbphrase[last_vote]</option>\n <option \" . iif($setting[value] == \'rand\', \'selected=\\\"selected\\\"\'). \" value=\\\"rand\\\">$vbphrase[random]</option>\n</select>',
40,
'0'
),(
'portal_poll_direction',
'adv_portal_poll',
'DESC',
'',
'<select name=\\\"$name\\\" \" . $jsdefault_onchange . \" tabindex=\\\"1\\\">\n <option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">$vbphrase[ascending]</option>\n <option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">$vbphrase[descending]</option>\n</select>',
50,
'0'
),(
'portal_applypermissions',
'adv_portal_poll',
'1',
'',
'yesno',
60,
'0'
),(
'portal_poll_allowreplies',
'adv_portal_poll',
'1',
'',
'yesno',
70,
'0'
),(
'portal_poll_allowsmilies',
'adv_portal_poll',
'1',
'',
'yesno',
80,
'0'
),(
'portal_stats_updatefrequency',
'adv_portal_stats',
'24',
'',
'',
10,
'0'
),(
'portal_welcome_lastvisit_date',
'adv_portal_welcomeblock',
'm-d-y',
'',
'',
10,
'0'
),(
'portal_welcome_lastvisit_time',
'adv_portal_welcomeblock',
'g:i a',
'',
'',
20,
'0'
),(
'portal_noavatarurl',
'adv_portal_welcomeblock',
'{$vbulletin->options[bburl]}/images/misc/noavatar.gif',
'',
'',
30,
'0'
),(
'portal_welcome_expanded',
'adv_portal_welcomeblock',
'2',
'',
'<div class=\\\"smallfont\\\">\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_0\\\">$vbphrase[lean]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">$vbphrase[expanded]</label><br />\n <input name=\\\"$name\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . $jsdefault_onchange . \" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\" tabindex=\\\"1\\\"><label for=\\\"$setting[varname]_2\\\">$vbphrase[dynamic]</label>\n</div>',
40,
'0'
),(
'portal_welcome_newpms',
'adv_portal_welcomeblock',
'1',
'',
'yesno',
50,
'0'
),(
'portal_welcome_avatar',
'adv_portal_welcomeblock',
'1',
'',
'yesno',
60,
'0'
),(
'portal_welcome_newposts',
'adv_portal_welcomeblock',
'1',
'',
'yesno',
70,
'0'
),(
'portal_welcome_rep',
'adv_portal_welcomeblock',
'1',
'',
'yesno',
80,
'0'
),(
'portal_welcome_rank',
'adv_portal_welcomeblock',
'0',
'',
'yesno',
90,
'0'
),(
'portal_version',
'adv_portal_main',
'3.0 RC1',
'',
'hidden',
0,
'0'
),(
'portal_integrate',
'adv_portal_main',
'a:4:{s:11:\"vbfilenames\";a:0:{}s:11:\"otfilenames\";a:0:{}s:10:\"thisscript\";a:0:{}s:8:\"vba_page \";i:0;}',
'',
'hidden',
0,
'1'
),(
'portal_homeurl',
'adv_portal_main',
'/cmps_index.php',
'',
'',
10,
'0'
),(
'portal_pagevar',
'adv_portal_main',
'pageid',
'',
'',
20,
'0'
),(
'portal_column_array',
'adv_portal_main',
'a:3:{i:1;s:4:\"left\";i:2;s:6:\"center\";i:3;s:5:\"right\";}',
'',
'location_input',
30,
'1'
),(
'portal_outputglobals',
'adv_portal_main',
'',
'',
'textarea',
40,
'0'
),(
'portal_replace*****',
'adv_portal_main',
'0',
'',
'yesno',
50,
'0'
),(
'portal_use_module_function',
'adv_portal_main',
'1',
'',
'yesno',
60,
'0'
),(
'portal_leftcolwidth',
'adv_portal_style',
'175',
'',
'',
10,
'0'
),(
'portal_rightcolwidth',
'adv_portal_style',
'175',
'',
'',
20,
'0'
),(
'portal_colspacing',
'adv_portal_style',
'15',
'',
'',
30,
'0'
),(
'portal_vspace',
'adv_portal_style',
'15',
'',
'',
40,
'0'
),(
'portal_blockbullet',
'adv_portal_style',
'&raquo;',
'',
'',
50,
'0'
),(
'portal_shownavbar',
'adv_portal_style',
'1',
'',
'yesno',
60,
'0'
),(
'portal_collapsemods',
'adv_portal_style',
'1',
'',
'yesno',
70,
'0'
);

MySQL Error : Unknown column 'varname' in 'field list'
Error Number : 1054
Date : Saturday, June 16th 2007 @ 08:42:52 AM
Script : http://*****/vb/*****/vbacmps_install.php
Referrer : http://*****/vb/*****/vbacmps_install.php
IP Address : ******
Username : *****
Classname : *****



انتظركم .
تحياتي .

[المصمم 2005]

افااااااااااااااا
وين الشباب :looking: