Profiles Map Failed - Please help!

Reply·Subscribe

mazurkeAdvanced

7 posts

0

Hi, I have been running dolphin successfully with no problems so far until today. I tried to install the Profiles Map mod but when I try to install thru admin>tools>modules I get the following message, any help in fixing this would be greatly appreciated, thanks in advance -

Installation of: Profiles Map Failed

-- Changing database:
-- -- There are errors in the following MySQL queries:
-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, 6, 'Profiles Map', '_bx_map_world_map', 'modules/?r=map_profiles/', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'bx_people.png', '', 0, '');

Quote · 7 Apr 2010

mazurkeAdvanced

7 posts

0

Also now when I try to install the sites module I get an error, please can anyone help as my sites getting pretty popular and a fresh install would really kill off my community. This is the error msg I get when I try install the sites module:

Installation of: Sites Failed

-- Changing database:
-- -- There are errors in the following MySQL queries:
-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, 0, 'Sites', '_bx_sites', 'modules/?r=sites/view/', '', 'non,memb', '', '', '', 0, 0, 1, 'system', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, 0, 'Sites', '_bx_sites', 'modules/?r=sites/home/|modules/?r=sites/', @iMaxMenuOrder, 'non,memb', '', '', '', 1, 1, 1, 'top', 'modules/boonex/sites/|bx_sites.png', '', 1, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesHome', '_bx_sites_home_top_menu_sitem', 'modules/?r=sites/home/', 0, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesAll', '_bx_sites_all_top_menu_sitem', 'modules/?r=sites/browse/all', 1, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesAdmin', '_bx_sites_admin_top_menu_sitem', 'modules/?r=sites/browse/admin', 2, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesUsers', '_bx_sites_profile_top_menu_sitem', 'modules/?r=sites/browse/users', 3, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesTop', '_bx_sites_top_top_menu_sitem', 'modules/?r=sites/browse/top', 4, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesPopular', '_bx_sites_popular_top_menu_sitem', 'modules/?r=sites/browse/popular', 5, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesFeatured', '_bx_sites_featured_top_menu_sitem', 'modules/?r=sites/browse/featured', 8, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, 'bx_sites');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesTags', '_bx_sites_tags_top_menu_sitem', 'modules/?r=sites/tags', 9, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, 'bx_sites');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesCategories', '_bx_sites_categories_top_menu_sitem', 'modules/?r=sites/categories', 10, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesHoN', '_bx_sites_hon_top_menu_sitem', 'modules/?r=sites/hon', 11, 'memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesCalendar', '_bx_sites_calendar_top_menu_sitem', 'modules/?r=sites/calendar', 12, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, @iCatRoot, 'SitesSearch', '_bx_sites_search_top_menu_sitem', 'modules/?r=sites/search', 13, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'modules/boonex/sites/|bx_sites.png', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, 9, 'Sites', '_bx_sites_menu_my_sites_profile', 'modules/?r=sites/browse/user/{profileNick}', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', '', 0, '');

-- -- Error: Column count doesn't match value count at row 1

INSERT INTO `sys_menu_top` VALUES(NULL, 4, 'Sites', '_bx_sites_menu_my_sites_profile', 'modules/?r=sites/browse/my', @iCatProfileOrder, 'memb', '', '', '', 1, 1, 1, 'custom', '', '', 0, '');

Quote · 16 May 2010

ZarconMasterBosun

3565 posts

1

Have you added any type of modification to the sys_menu_top table? This could be from add OR removing fields. The script is looking for specific set (number) of fields in the table, if they do not match, you will get this error.

So in a nutshell, there are either too many values or not enough values for the sys_menu_top table

VALUES(NULL, 6, 'Profiles Map', '_bx_map_world_map', 'modules/?r=map_profiles/', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'bx_people.png', '', 0, '');

Nothing to see here

Quote · 16 May 2010

mazurkeAdvanced

7 posts

0

Hey Zarcon thanks for the reply, where would I find the sys_menu_top? The only thing I can think i've modified in the sql tables is I removed some of the site stats fields like videos and sounds as they're not relevent to my site www.mymodelbook.com

Quote · 16 May 2010

ZarconMasterBosun

3565 posts

0

If you go to your phpMyAdmin (or however you access your database) you will see a table called sys_menu_top. You can click structure to verify the fields available for that table. I would suggest making sure that all columns exist for the values.

Nothing to see here

Quote · 16 May 2010