DaMaK
10-21-2006, 08:49 PM
Hello,
I tried installing v2.0 rc1 to vB version 3.62. And i get an error.
When i pressed continue after selecting install on install page this happened.
Database error in vBulletin 3.6.2:
Invalid SQL:
INSERT INTO vb_adv_setting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder)
VALUES
(
'global_header_replace',
'adv_global',
'',
'',
'textarea',
1
),(
'global_navbar_replace',
'adv_global',
'memberlist.php\nusercp.php\nregister.php\nfaq.php\ncalendar.php\nsearch.php\nlo gin.php\nforumdisplay.php\nprofile.php\nprivate.php\nsubscription.php\nmember.ph p\nonline.php',
'',
'textarea',
2
),(
'global_footer_replace',
'adv_global',
'archive\nsendmessage.php\nprofile.php',
'',
'textarea',
3
),(
'links_maxtitlelength',
'adv_links_addlink',
'50',
'',
'',
1
),(
'links_maxdesclength',
'adv_links_addlink',
'1000',
'',
'',
2
),(
'links_maxkeywords',
'adv_links_addlink',
'8',
'',
'',
3
),(
'links_maxkeywordlength',
'adv_links_addlink',
'15',
'',
'',
4
),(
'links_newlinkemail',
'adv_links_addlink',
'',
'',
'',
5
),(
'links_newlinkemail_all',
'adv_links_addlink',
'0',
'',
'yesno',
6
),(
'links_autofill',
'adv_links_addlink',
'1',
'',
'yesno',
7
),(
'links_verifynew',
'adv_links_addlink',
'1',
'',
'yesno',
8
),(
'links_allowdupes',
'adv_links_addlink',
'0',
'',
'yesno',
9
),(
'links_imageverify',
'adv_links_addlink',
'1',
'',
'<div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\"><label for=\\\"$setting[varname]_0\\\">No</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">Yes, but only for guests</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\"><label for=\\\"$setting[varname]_2\\\">Yes, enable for all usergroups</label></div>',
10
),(
'links_recipcheck',
'adv_links_addlink',
'0',
'',
'<div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\"><label for=\\\"$setting[varname]_0\\\">No</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">Yes, but do not require the link</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\"><label for=\\\"$setting[varname]_2\\\">Yes, require a reciprocal link</label></div>',
11
),(
'links_recipcheck_url',
'adv_links_addlink',
'',
'',
'',
12
),(
'links_deforder',
'adv_links_browselinks',
'name',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\">\n<option \" . iif($setting[value] == \'title\', \'selected=\\\"selected\\\"\'). \" value=\\\"name\\\">Name</option>\n<option \" . iif($setting[value] == \'dateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"dateline\\\">Date Posted</option>\n<option \" . iif($setting[value] == \'lastpostdateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"lastpostdateline\\\">Last Post</option>\n<option \" . iif($setting[value] == \'rating\', \'selected=\\\"selected\\\"\'). \" value=\\\"rating\\\">Rating</option>\n<option \" . iif($setting[value] == \'views\', \'selected=\\\"selected\\\"\'). \" value=\\\"views\\\">Number of Views</option>\n<option \" . iif($setting[value] == \'posts\', \'selected=\\\"selected\\\"\'). \" value=\\\"posts\\\">Number of Posts</option>\n</select>\n',
1
),(
'links_defdirection',
'adv_links_browselinks',
'ASC',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\">\n<option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">Descending</option>\n<option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">Ascending</option>\n</select>',
2
),(
'links_perpage',
'adv_links_browselinks',
'25',
'',
'',
3
),(
'links_desclength_browse',
'adv_links_browselinks',
'250',
'',
'',
4
),(
'links_hotviews',
'adv_links_browselinks',
'150',
'',
'',
5
),(
'links_hotposts',
'adv_links_browselinks',
'10',
'',
'',
6
),(
'links_browsedropdown',
'adv_links_browselinks',
'1',
'',
'yesno',
7
),(
'links_catsorder',
'adv_links_categorybit',
'displayorder',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\"> <option \" . iif($setting[value] == \'displayorder\', \'selected=\\\"selected\\\"\'). \" value=\\\"displayorder\\\">Display Order</option> <option \" . iif($setting[value] == \'title\', \'selected=\\\"selected\\\"\'). \" value=\\\"title\\\">Alphabetically</option></select>',
1
),(
'links_catsdir',
'adv_links_categorybit',
'ASC',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\">\n<option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">Descending</option>\n<option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">Ascending</option>\n</select>',
2
),(
'links_lastlink_maxlength',
'adv_links_categorybit',
'20',
'',
'',
3
),(
'links_catdepth',
'adv_links_categorybit',
'2',
'',
'',
4
),(
'links_showsubcats',
'adv_links_categorybit',
'1',
'',
'yesno',
5
),(
'links_showmodcolumn',
'adv_links_categorybit',
'0',
'',
'yesno',
6
),(
'links_showlinkcount',
'adv_links_categorybit',
'0',
'',
'yesno',
7
),(
'links_showcatowner',
'adv_links_categorybit',
'1',
'',
'yesno',
8
),(
'links_showonoff',
'adv_links_categorybit',
'1',
'',
'yesno',
9
),(
'links_catdepth_index',
'adv_links_index',
'2',
'',
'',
1
),(
'links_newonhome',
'adv_links_index',
'5',
'',
'',
2
),(
'links_randonhome',
'adv_links_index',
'5',
'',
'',
3
),(
'links_home_excats',
'adv_links_index',
'',
'',
'catselect',
4
),(
'links_showstats',
'adv_links_index',
'1',
'',
'yesno',
5
),(
'links_version',
'adv_links_main',
'2.0 RC1',
'',
'hidden',
0
),(
'links_active',
'adv_links_main',
'1',
'',
'yesno',
1
),(
'links_closedmessage',
'adv_links_main',
'We are sorry, but the links directory is closed for maintenance. Please check back soon.',
'',
'textarea',
2
),(
'links_newlinklimit',
'adv_links_main',
'1,3,7,14,30,60',
'',
'',
3
),(
'links_poplinklimit',
'adv_links_main',
'20',
'',
'',
4
),(
'links_poplinks_votelimit',
'adv_links_main',
'2',
'',
'',
5
),(
'links_allowrating',
'adv_links_main',
'1',
'',
'yesno',
6
),(
'links_allowfav',
'adv_links_main',
'1',
'',
'yesno',
7
),(
'links_linktous',
'adv_links_main',
'1',
'',
'yesno',
8
),(
'links_allowsubscribe',
'adv_links_main',
'1',
'',
'yesno',
9
),(
'links_enable_dirjump',
'adv_links_main',
'1',
'',
'yesno',
10
),(
'links_navbarhomelink',
'adv_links_main',
'0',
'',
'<div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\"><label for=\\\"$setting[varname]_0\\\">None</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">Homepage</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\"><label for=\\\"$setting[varname]_2\\\">Forum Home</label></div>',
11
),(
'links_remotesite',
'adv_links_main',
'f',
'f',
'f',
f
),(
'links_allowreplies',
'adv_links_posting',
'1',
'',
'yesno',
1
),(
'links_update_postcount',
'adv_links_posting',
'0',
'',
'yesno',
2
),(
'links_allowicons',
'adv_links_posting',
'1',
'',
'yesno',
3
),(
'links_allowsmilie',
'adv_links_posting',
'1',
'',
'yesno',
4
),(
'links_quotetitle',
'adv_links_posting',
'1',
'',
'yesno',
5
),(
'links_post_imageverify',
'adv_links_posting',
'1',
'',
'yesno',
6
),(
'links_repliesperpage',
'adv_links_showlink',
'25',
'',
'',
1
),(
'links_urlcutoff',
'adv_links_showlink',
'65',
'',
'',
2
),(
'links_convertkeywords',
'adv_links_showlink',
'1',
'',
'yesno',
3
),(
'links_showquickreply',
'adv_links_showlink',
'1',
'',
'yesno',
4
),(
'links_title',
'adv_links_title_paths',
'Links Directory',
'',
'',
1
),(
'links_homeurl',
'adv_links_title_paths',
'',
'',
'',
2
),(
'links_uploaddir',
'adv_links_title_paths',
'',
'',
'',
3
),(
'links_uploadurl',
'adv_links_title_paths',
'',
'',
'',
4
),(
'links_allow_user_cats',
'adv_links_usercats',
'0',
'',
'<div class=\\\"smallfont\\\"><input \" . iif($setting[\'value\'] == 0, \'checked=\"checked\"\'). \" type=\\\"radio\\\" id=\\\"allow_user_cats_0\\\" name=\\\"setting[$setting[varname]]\\\" value=\\\"0\\\" /> <label for=\\\"allow_user_cats_0\\\">No</label></div>\n<div class=\\\"smallfont\\\"><input \" . iif($setting[\'value\'] == 1, \'checked=\"checked\"\'). \"type=\\\"radio\\\" id=\\\"allow_user_cats_1\\\" name=\\\"setting[$setting[varname]]\\\" value=\\\"1\\\" /> <label for=\\\"allow_user_cats_1\\\">Yes (User owns the category)</label></div>\n<div class=\\\"smallfont\\\"><input \" . iif($setting[\'value\'] == 2, \'checked=\"checked\"\'). \"type=\\\"radio\\\" id=\\\"allow_user_cats_2\\\" name=\\\"setting[$setting[varname]]\\\" value=\\\"2\\\" /> <label for=\\\"allow_user_cats_2\\\">Yes (User does NOT own the category)</label></label></div>',
1
),(
'links_usercat_titlemax',
'adv_links_usercats',
'50',
'',
'',
2
),(
'links_usercat_descmax',
'adv_links_usercats',
'250',
'',
'',
3
),(
'links_newcatsattop',
'adv_links_usercats',
'0',
'',
'yesno',
4
),(
'links_usercats_password',
'adv_links_usercats',
'0',
'',
'yesno',
5
),(
'links_usercat_edit',
'adv_links_usercats',
'0',
'',
'yesno',
6
),(
'links_usercats_delete',
'adv_links_usercats',
'0',
'',
'yesno',
7
),(
'links_usercats_empty',
'adv_links_usercats',
'0',
'',
'yesno',
8
),(
'links_usercats_modopts',
'adv_links_usercats',
'0',
'',
'yesno',
9
),(
'links_usercats_defaultopts',
'adv_links_usercats',
'a:4:{s:10:\"allow_view\";s:1:\"2\";s:14:\"allow_newlinks\";s:1:\"2\";s:11:\"allow_reply\";s:1:\"2\";s:12:\"allow_rating\";s:1:\"2\";}',
'',
'<table width=\\\"100%\\\"> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow View</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_view1\\\"><input id=\\\"allow_view1\\\" \" . iif($setting[\'value\'][\'allow_view\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_view]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_view0\\\"><input id=\\\"allow_view0\\\" \" . iif($setting[\'value\'][\'allow_view\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_view]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_view2\\\"><input id=\\\"allow_view2\\\" \" . iif($setting[\'value\'][\'allow_view\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_view]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow New Links</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_newlinks1\\\"><input id=\\\"allow_newlinks1\\\" \" . iif($setting[\'value\'][\'allow_newlinks\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_newlinks]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_newlinks0\\\"><input id=\\\"allow_newlinks0\\\" \" . iif($setting[\'value\'][\'allow_newlinks\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_newlinks]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_newlinks2\\\"><input id=\\\"allow_newlinks2\\\" \" . iif($setting[\'value\'][\'allow_newlinks\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_newlinks]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow Replies</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_reply1\\\"><input id=\\\"allow_reply1\\\" \" . iif($setting[\'value\'][\'allow_reply\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_reply]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_reply0\\\"><input id=\\\"allow_reply0\\\" \" . iif($setting[\'value\'][\'allow_reply\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_reply]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_reply2\\\"><input id=\\\"allow_reply2\\\" \" . iif($setting[\'value\'][\'allow_reply\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_reply]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow Rating</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_rating1\\\"><input id=\\\"allow_rating1\\\" \" . iif($setting[\'value\'][\'allow_rating\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_rating]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_rating0\\\"><input id=\\\"allow_rating0\\\" \" . iif($setting[\'value\'][\'allow_rating\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_rating]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_rating2\\\"><input id=\\\"allow_rating2\\\" \" . iif($setting[\'value\'][\'allow_rating\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_rating]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> </table> ',
10
);
MySQL Error : Unknown column 'f' in 'field list'
Error Number : 1054
I also got CPMS v. 2.2.1 installed
----------
Sorry for the long msg. I tried unistalling and reinstalling a few times, but no luck.
I tried installing v2.0 rc1 to vB version 3.62. And i get an error.
When i pressed continue after selecting install on install page this happened.
Database error in vBulletin 3.6.2:
Invalid SQL:
INSERT INTO vb_adv_setting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder)
VALUES
(
'global_header_replace',
'adv_global',
'',
'',
'textarea',
1
),(
'global_navbar_replace',
'adv_global',
'memberlist.php\nusercp.php\nregister.php\nfaq.php\ncalendar.php\nsearch.php\nlo gin.php\nforumdisplay.php\nprofile.php\nprivate.php\nsubscription.php\nmember.ph p\nonline.php',
'',
'textarea',
2
),(
'global_footer_replace',
'adv_global',
'archive\nsendmessage.php\nprofile.php',
'',
'textarea',
3
),(
'links_maxtitlelength',
'adv_links_addlink',
'50',
'',
'',
1
),(
'links_maxdesclength',
'adv_links_addlink',
'1000',
'',
'',
2
),(
'links_maxkeywords',
'adv_links_addlink',
'8',
'',
'',
3
),(
'links_maxkeywordlength',
'adv_links_addlink',
'15',
'',
'',
4
),(
'links_newlinkemail',
'adv_links_addlink',
'',
'',
'',
5
),(
'links_newlinkemail_all',
'adv_links_addlink',
'0',
'',
'yesno',
6
),(
'links_autofill',
'adv_links_addlink',
'1',
'',
'yesno',
7
),(
'links_verifynew',
'adv_links_addlink',
'1',
'',
'yesno',
8
),(
'links_allowdupes',
'adv_links_addlink',
'0',
'',
'yesno',
9
),(
'links_imageverify',
'adv_links_addlink',
'1',
'',
'<div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\"><label for=\\\"$setting[varname]_0\\\">No</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">Yes, but only for guests</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\"><label for=\\\"$setting[varname]_2\\\">Yes, enable for all usergroups</label></div>',
10
),(
'links_recipcheck',
'adv_links_addlink',
'0',
'',
'<div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\"><label for=\\\"$setting[varname]_0\\\">No</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">Yes, but do not require the link</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\"><label for=\\\"$setting[varname]_2\\\">Yes, require a reciprocal link</label></div>',
11
),(
'links_recipcheck_url',
'adv_links_addlink',
'',
'',
'',
12
),(
'links_deforder',
'adv_links_browselinks',
'name',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\">\n<option \" . iif($setting[value] == \'title\', \'selected=\\\"selected\\\"\'). \" value=\\\"name\\\">Name</option>\n<option \" . iif($setting[value] == \'dateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"dateline\\\">Date Posted</option>\n<option \" . iif($setting[value] == \'lastpostdateline\', \'selected=\\\"selected\\\"\'). \" value=\\\"lastpostdateline\\\">Last Post</option>\n<option \" . iif($setting[value] == \'rating\', \'selected=\\\"selected\\\"\'). \" value=\\\"rating\\\">Rating</option>\n<option \" . iif($setting[value] == \'views\', \'selected=\\\"selected\\\"\'). \" value=\\\"views\\\">Number of Views</option>\n<option \" . iif($setting[value] == \'posts\', \'selected=\\\"selected\\\"\'). \" value=\\\"posts\\\">Number of Posts</option>\n</select>\n',
1
),(
'links_defdirection',
'adv_links_browselinks',
'ASC',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\">\n<option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">Descending</option>\n<option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">Ascending</option>\n</select>',
2
),(
'links_perpage',
'adv_links_browselinks',
'25',
'',
'',
3
),(
'links_desclength_browse',
'adv_links_browselinks',
'250',
'',
'',
4
),(
'links_hotviews',
'adv_links_browselinks',
'150',
'',
'',
5
),(
'links_hotposts',
'adv_links_browselinks',
'10',
'',
'',
6
),(
'links_browsedropdown',
'adv_links_browselinks',
'1',
'',
'yesno',
7
),(
'links_catsorder',
'adv_links_categorybit',
'displayorder',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\"> <option \" . iif($setting[value] == \'displayorder\', \'selected=\\\"selected\\\"\'). \" value=\\\"displayorder\\\">Display Order</option> <option \" . iif($setting[value] == \'title\', \'selected=\\\"selected\\\"\'). \" value=\\\"title\\\">Alphabetically</option></select>',
1
),(
'links_catsdir',
'adv_links_categorybit',
'ASC',
'',
'<select class=\\\"bginput\\\" name=\\\"setting[$setting[varname]]\\\">\n<option \" . iif($setting[value] == \'DESC\', \'selected=\\\"selected\\\"\'). \" value=\\\"DESC\\\">Descending</option>\n<option \" . iif($setting[value] == \'ASC\', \'selected=\\\"selected\\\"\'). \" value=\\\"ASC\\\">Ascending</option>\n</select>',
2
),(
'links_lastlink_maxlength',
'adv_links_categorybit',
'20',
'',
'',
3
),(
'links_catdepth',
'adv_links_categorybit',
'2',
'',
'',
4
),(
'links_showsubcats',
'adv_links_categorybit',
'1',
'',
'yesno',
5
),(
'links_showmodcolumn',
'adv_links_categorybit',
'0',
'',
'yesno',
6
),(
'links_showlinkcount',
'adv_links_categorybit',
'0',
'',
'yesno',
7
),(
'links_showcatowner',
'adv_links_categorybit',
'1',
'',
'yesno',
8
),(
'links_showonoff',
'adv_links_categorybit',
'1',
'',
'yesno',
9
),(
'links_catdepth_index',
'adv_links_index',
'2',
'',
'',
1
),(
'links_newonhome',
'adv_links_index',
'5',
'',
'',
2
),(
'links_randonhome',
'adv_links_index',
'5',
'',
'',
3
),(
'links_home_excats',
'adv_links_index',
'',
'',
'catselect',
4
),(
'links_showstats',
'adv_links_index',
'1',
'',
'yesno',
5
),(
'links_version',
'adv_links_main',
'2.0 RC1',
'',
'hidden',
0
),(
'links_active',
'adv_links_main',
'1',
'',
'yesno',
1
),(
'links_closedmessage',
'adv_links_main',
'We are sorry, but the links directory is closed for maintenance. Please check back soon.',
'',
'textarea',
2
),(
'links_newlinklimit',
'adv_links_main',
'1,3,7,14,30,60',
'',
'',
3
),(
'links_poplinklimit',
'adv_links_main',
'20',
'',
'',
4
),(
'links_poplinks_votelimit',
'adv_links_main',
'2',
'',
'',
5
),(
'links_allowrating',
'adv_links_main',
'1',
'',
'yesno',
6
),(
'links_allowfav',
'adv_links_main',
'1',
'',
'yesno',
7
),(
'links_linktous',
'adv_links_main',
'1',
'',
'yesno',
8
),(
'links_allowsubscribe',
'adv_links_main',
'1',
'',
'yesno',
9
),(
'links_enable_dirjump',
'adv_links_main',
'1',
'',
'yesno',
10
),(
'links_navbarhomelink',
'adv_links_main',
'0',
'',
'<div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_0\\\" type=\\\"radio\\\" \" . iif($setting[value] == 0, \'checked=\\\"checked\\\"\'). \" value=\\\"0\\\"><label for=\\\"$setting[varname]_0\\\">None</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_1\\\" type=\\\"radio\\\" \" . iif($setting[value] == 1, \'checked=\\\"checked\\\"\'). \" value=\\\"1\\\"><label for=\\\"$setting[varname]_1\\\">Homepage</label></div><div class=\\\"smallfont\\\"><input name=\\\"setting[$setting[varname]]\\\" id=\\\"$setting[varname]_2\\\" type=\\\"radio\\\" \" . iif($setting[value] == 2, \'checked=\\\"checked\\\"\'). \" value=\\\"2\\\"><label for=\\\"$setting[varname]_2\\\">Forum Home</label></div>',
11
),(
'links_remotesite',
'adv_links_main',
'f',
'f',
'f',
f
),(
'links_allowreplies',
'adv_links_posting',
'1',
'',
'yesno',
1
),(
'links_update_postcount',
'adv_links_posting',
'0',
'',
'yesno',
2
),(
'links_allowicons',
'adv_links_posting',
'1',
'',
'yesno',
3
),(
'links_allowsmilie',
'adv_links_posting',
'1',
'',
'yesno',
4
),(
'links_quotetitle',
'adv_links_posting',
'1',
'',
'yesno',
5
),(
'links_post_imageverify',
'adv_links_posting',
'1',
'',
'yesno',
6
),(
'links_repliesperpage',
'adv_links_showlink',
'25',
'',
'',
1
),(
'links_urlcutoff',
'adv_links_showlink',
'65',
'',
'',
2
),(
'links_convertkeywords',
'adv_links_showlink',
'1',
'',
'yesno',
3
),(
'links_showquickreply',
'adv_links_showlink',
'1',
'',
'yesno',
4
),(
'links_title',
'adv_links_title_paths',
'Links Directory',
'',
'',
1
),(
'links_homeurl',
'adv_links_title_paths',
'',
'',
'',
2
),(
'links_uploaddir',
'adv_links_title_paths',
'',
'',
'',
3
),(
'links_uploadurl',
'adv_links_title_paths',
'',
'',
'',
4
),(
'links_allow_user_cats',
'adv_links_usercats',
'0',
'',
'<div class=\\\"smallfont\\\"><input \" . iif($setting[\'value\'] == 0, \'checked=\"checked\"\'). \" type=\\\"radio\\\" id=\\\"allow_user_cats_0\\\" name=\\\"setting[$setting[varname]]\\\" value=\\\"0\\\" /> <label for=\\\"allow_user_cats_0\\\">No</label></div>\n<div class=\\\"smallfont\\\"><input \" . iif($setting[\'value\'] == 1, \'checked=\"checked\"\'). \"type=\\\"radio\\\" id=\\\"allow_user_cats_1\\\" name=\\\"setting[$setting[varname]]\\\" value=\\\"1\\\" /> <label for=\\\"allow_user_cats_1\\\">Yes (User owns the category)</label></div>\n<div class=\\\"smallfont\\\"><input \" . iif($setting[\'value\'] == 2, \'checked=\"checked\"\'). \"type=\\\"radio\\\" id=\\\"allow_user_cats_2\\\" name=\\\"setting[$setting[varname]]\\\" value=\\\"2\\\" /> <label for=\\\"allow_user_cats_2\\\">Yes (User does NOT own the category)</label></label></div>',
1
),(
'links_usercat_titlemax',
'adv_links_usercats',
'50',
'',
'',
2
),(
'links_usercat_descmax',
'adv_links_usercats',
'250',
'',
'',
3
),(
'links_newcatsattop',
'adv_links_usercats',
'0',
'',
'yesno',
4
),(
'links_usercats_password',
'adv_links_usercats',
'0',
'',
'yesno',
5
),(
'links_usercat_edit',
'adv_links_usercats',
'0',
'',
'yesno',
6
),(
'links_usercats_delete',
'adv_links_usercats',
'0',
'',
'yesno',
7
),(
'links_usercats_empty',
'adv_links_usercats',
'0',
'',
'yesno',
8
),(
'links_usercats_modopts',
'adv_links_usercats',
'0',
'',
'yesno',
9
),(
'links_usercats_defaultopts',
'adv_links_usercats',
'a:4:{s:10:\"allow_view\";s:1:\"2\";s:14:\"allow_newlinks\";s:1:\"2\";s:11:\"allow_reply\";s:1:\"2\";s:12:\"allow_rating\";s:1:\"2\";}',
'',
'<table width=\\\"100%\\\"> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow View</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_view1\\\"><input id=\\\"allow_view1\\\" \" . iif($setting[\'value\'][\'allow_view\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_view]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_view0\\\"><input id=\\\"allow_view0\\\" \" . iif($setting[\'value\'][\'allow_view\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_view]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_view2\\\"><input id=\\\"allow_view2\\\" \" . iif($setting[\'value\'][\'allow_view\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_view]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow New Links</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_newlinks1\\\"><input id=\\\"allow_newlinks1\\\" \" . iif($setting[\'value\'][\'allow_newlinks\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_newlinks]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_newlinks0\\\"><input id=\\\"allow_newlinks0\\\" \" . iif($setting[\'value\'][\'allow_newlinks\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_newlinks]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_newlinks2\\\"><input id=\\\"allow_newlinks2\\\" \" . iif($setting[\'value\'][\'allow_newlinks\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_newlinks]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow Replies</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_reply1\\\"><input id=\\\"allow_reply1\\\" \" . iif($setting[\'value\'][\'allow_reply\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_reply]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_reply0\\\"><input id=\\\"allow_reply0\\\" \" . iif($setting[\'value\'][\'allow_reply\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_reply]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_reply2\\\"><input id=\\\"allow_reply2\\\" \" . iif($setting[\'value\'][\'allow_reply\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_reply]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> <tr> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\">Allow Rating</td> <td class=\\\"smallfont\\\" nowrap=\\\"nowrap\\\"><label for=\\\"allow_rating1\\\"><input id=\\\"allow_rating1\\\" \" . iif($setting[\'value\'][\'allow_rating\'] == 1, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_rating]\\\" type=\\\"radio\\\" value=\\\"1\\\" />Yes</label> <label for=\\\"allow_rating0\\\"><input id=\\\"allow_rating0\\\" \" . iif($setting[\'value\'][\'allow_rating\'] == 0, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_rating]\\\" type=\\\"radio\\\" value=\\\"0\\\" />No</label> <label for=\\\"allow_rating2\\\"><input id=\\\"allow_rating2\\\" \" . iif($setting[\'value\'][\'allow_rating\'] == 2, \'checked=\"checked\"\'). \" name=\\\"setting[$setting[varname]][allow_rating]\\\" type=\\\"radio\\\" value=\\\"2\\\" />User Choice</label></td> </tr> </table> ',
10
);
MySQL Error : Unknown column 'f' in 'field list'
Error Number : 1054
I also got CPMS v. 2.2.1 installed
----------
Sorry for the long msg. I tried unistalling and reinstalling a few times, but no luck.