database query error on clicking navigation menu and member menu

Hi everyone. Can someone help?

When I click on the navigation menu and the member menu in the admin panel I get a database query error.

Thanks to anyone that can help!

Heres the debug report:

Query:
SELECT `ID`, `Name`, `Movable` FROM `sys_menu_top` WHERE `Active`=1 AND `Type`='top' ORDER BY `Order`
Mysql error:
Unknown column 'Movable' in 'field list'
Found error in the file '/home/russj/public_html/administration/nav_menu_compose.php' at line 130.
Called 'db_res' function with erroneous argument #0.

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] => /home/russj/public_html/inc/classes/BxDolDb.php
            [line] => 236
            [function] => error
            [class] => BxDolDb
            [type] => ->
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [host] => localhost
                    [port] => 
                    [socket] => 
[EDITED BY ZARCON TO REMOVE DATABASE USERNAME/PASSWORD] [link] => Resource id #45 [current_res] => [current_arr_type] => 1 [oParams] => BxDolParams Object ( [_oDb] => BxDolDb Object *RECURSION* [_oCache] => BxDolCacheFile Object ( [sPath] => /home/russj/public_html/cache/ [_error] => ) [_sCacheFile] => sys_options.php [_aParams] => Array ( [anon_mode] => on [autoApproval_ifJoin] => on [autoApproval_ifProfile] => on [cmdDay] => 10 [currency_code] => USD [currency_sign] => $ [time_format_php] => H:i [short_date_format_php] => d.m.Y [date_format_php] => d.m.Y H:i [time_format] => %H:%i [short_date_format] => %d.%m.%Y [date_format] => %d.%m.%Y %H:%i [db_clean_msg] => 180 [db_clean_profiles] => 180 [db_clean_views] => 180 [db_clean_vkiss] => 90 [default_country] => UK [enable_contact_form] => on [enable_gd] => on [enable_match] => on [view_match_percent] => on [enable_promotion_membership] => [enable_watermark] => [enable_zip_loc] => on [expire_notification_days] => 1 [expire_notify_once] => on [featured_num] => 6 [lang_default] => en [match_percent] => 85 [max_inbox_message_size] => 1500 [member_online_time] => 1 [MetaDescription] => Dating and social networking for doctors, nurses and all healthcare employees [MetaKeyWords] => nhs, health, healthcare, relationships, singles, fun, social, nurses, doctors, nhs-dating, nhs-dating.co.uk, dating, social, networking, community [msgs_per_start] => 20 [enable_inbox_notify] => [news_enable] => 1 [newusernotify] => on [promotion_membership_days] => 7 [search_start_age] => 18 [search_end_age] => 75 [sys_calendar_starts_sunday] => [top_members_max_num] => 12 [track_profile_view] => on [transparent1] => 0 [votes] => on [Water_Mark] => [zodiac] => [php_date_format] => F j, Y [tags_non_parsable] => nhs, health, healthcare, dating, relationships, singles, fun, social, nurses, doctors, nhs-dating, nhs-dating.co.uk [tags_last_parse_time] => 0 [tags_min_rating] => 2 [autoApproval_ifNoConfEmail] => on [enable_flash_promo] => on [custom_promo_code] => [license_code] => 849L898Z69 [license_expiration] => 0 [license_checksum] => 115adaea465e55ce7f7eec4cfa37f9e0 [sys_html_fields] => a:3:{s:6:"system";a:4:{i:0;s:12:"POST.message";i:1;s:15:"REQUEST.message";i:2;s:12:"POST.CmtText";i:3;s:15:"REQUEST.CmtText";}s:19:"system_profile_html";a:4:{i:0;s:20:"POST.DescriptionMe.0";i:1;s:20:"POST.DescriptionMe.1";i:2;s:23:"REQUEST.DescriptionMe.0";i:3;s:23:"REQUEST.DescriptionMe.1";}s:5:"blogs";a:4:{i:0;s:13:"POST.PostText";i:1;s:16:"REQUEST.PostText";i:2;s:16:"POST.Description";i:3;s:19:"REQUEST.Description";}} [sys_json_fields] => [sys_exceptions_fields] => a:1:{s:22:"system_email_templates";a:128:{i:0;s:22:"POST.t_Activation_Body";i:1;s:25:"REQUEST.t_Activation_Body";i:2;s:25:"POST.t_Activation_Subject";i:3;s:28:"REQUEST.t_Activation_Subject";i:4;s:22:"POST.t_Activation_Body";i:5;s:25:"REQUEST.t_Activation_Body";i:6;s:25:"POST.t_Activation_Subject";i:7;s:28:"REQUEST.t_Activation_Subject";i:8;s:22:"POST.t_AdminEmail_Body";i:9;s:25:"REQUEST.t_AdminEmail_Body";i:10;s:25:"POST.t_AdminEmail_Subject";i:11;s:28:"REQUEST.t_AdminEmail_Subject";i:12;s:28:"POST.t_bx_photos_report_Body";i:13;s:31:"REQUEST.t_bx_photos_report_Body";i:14;s:31:"POST.t_bx_photos_report_Subject";i:15;s:34:"REQUEST.t_bx_photos_report_Subject";i:16;s:27:"POST.t_bx_photos_share_Body";i:17;s:30:"REQUEST.t_bx_photos_share_Body";i:18;s:30:"POST.t_bx_photos_share_Subject";i:19;s:33:"REQUEST.t_bx_photos_share_Subject";i:20;s:19:"POST.t_Compose_Body";i:21;s:22:"REQUEST.t_Compose_Body";i:22;s:22:"POST.t_Compose_Subject";i:23;s:25:"REQUEST.t_Compose_Subject";i:24;s:24:"POST.t_Confirmation_Body";i:25;s:27:"REQUEST.t_Confirmation_Body";i:26;s:27:"POST.t_Confirmation_Subject";i:27;s:30:"REQUEST.t_Confirmation_Subject";i:28;s:21:"POST.t_CupidMail_Body";i:29;s:24:"REQUEST.t_CupidMail_Body";i:30;s:24:"POST.t_CupidMail_Subject";i:31;s:27:"REQUEST.t_CupidMail_Subject";i:32;s:18:"POST.t_Forgot_Body";i:33;s:21:"REQUEST.t_Forgot_Body";i:34;s:21:"POST.t_Forgot_Subject";i:35;s:24:"REQUEST.t_Forgot_Subject";i:36;s:21:"POST.t_FreeEmail_Body";i:37;s:24:"REQUEST.t_FreeEmail_Body";i:38;s:24:"POST.t_FreeEmail_Subject";i:39;s:27:"REQUEST.t_FreeEmail_Subject";i:40;s:25:"POST.t_FriendRequest_Body";i:41;s:28:"REQUEST.t_FriendRequest_Body";i:42;s:28:"POST.t_FriendRequest_Subject";i:43;s:31:"REQUEST.t_FriendRequest_Subject";i:44;s:25:"POST.t_MemExpiration_Body";i:45;s:28:"REQUEST.t_MemExpiration_Body";i:46;s:28:"POST.t_MemExpiration_Subject";i:47;s:31:"REQUEST.t_MemExpiration_Subject";i:48;s:19:"POST.t_Message_Body";i:49;s:22:"REQUEST.t_Message_Body";i:50;s:22:"POST.t_Message_Subject";i:51;s:25:"REQUEST.t_Message_Subject";i:52;s:23:"POST.t_MessageCopy_Body";i:53;s:26:"REQUEST.t_MessageCopy_Body";i:54;s:26:"POST.t_MessageCopy_Subject";i:55;s:29:"REQUEST.t_MessageCopy_Subject";i:56;s:21:"POST.t_Rejection_Body";i:57;s:24:"REQUEST.t_Rejection_Body";i:58;s:24:"POST.t_Rejection_Subject";i:59;s:27:"REQUEST.t_Rejection_Subject";i:60;s:32:"POST.t_sbsBlogpostsComments_Body";i:61;s:35:"REQUEST.t_sbsBlogpostsComments_Body";i:62;s:35:"POST.t_sbsBlogpostsComments_Subject";i:63;s:38:"REQUEST.t_sbsBlogpostsComments_Subject";i:64;s:29:"POST.t_sbsBlogpostsRates_Body";i:65;s:32:"REQUEST.t_sbsBlogpostsRates_Body";i:66;s:32:"POST.t_sbsBlogpostsRates_Subject";i:67;s:35:"REQUEST.t_sbsBlogpostsRates_Subject";i:68;s:31:"POST.t_sbsFeedbackComments_Body";i:69;s:34:"REQUEST.t_sbsFeedbackComments_Body";i:70;s:34:"POST.t_sbsFeedbackComments_Subject";i:71;s:37:"REQUEST.t_sbsFeedbackComments_Subject";i:72;s:31:"POST.t_sbsFeedbackComments_Body";i:73;s:34:"REQUEST.t_sbsFeedbackComments_Body";i:74;s:34:"POST.t_sbsFeedbackComments_Subject";i:75;s:37:"REQUEST.t_sbsFeedbackComments_Subject";i:76;s:28:"POST.t_sbsFeedbackRates_Body";i:77;s:31:"REQUEST.t_sbsFeedbackRates_Body";i:78;s:31:"POST.t_sbsFeedbackRates_Subject";i:79;s:34:"REQUEST.t_sbsFeedbackRates_Subject";i:80;s:28:"POST.t_sbsFeedbackRates_Body";i:81;s:31:"REQUEST.t_sbsFeedbackRates_Body";i:82;s:31:"POST.t_sbsFeedbackRates_Subject";i:83;s:34:"REQUEST.t_sbsFeedbackRates_Subject";i:84;s:30:"POST.t_sbsProfileComments_Body";i:85;s:33:"REQUEST.t_sbsProfileComments_Body";i:86;s:33:"POST.t_sbsProfileComments_Subject";i:87;s:36:"REQUEST.t_sbsProfileComments_Subject";i:88;s:26:"POST.t_sbsProfileEdit_Body";i:89;s:29:"REQUEST.t_sbsProfileEdit_Body";i:90;s:29:"POST.t_sbsProfileEdit_Subject";i:91;s:32:"REQUEST.t_sbsProfileEdit_Subject";i:92;s:27:"POST.t_sbsProfileRates_Body";i:93;s:30:"REQUEST.t_sbsProfileRates_Body";i:94;s:30:"POST.t_sbsProfileRates_Subject";i:95;s:33:"REQUEST.t_sbsProfileRates_Subject";i:96;s:34:"POST.t_sbs_bx_photos_comments_Body";i:97;s:37:"REQUEST.t_sbs_bx_photos_comments_Body";i:98;s:37:"POST.t_sbs_bx_photos_comments_Subject";i:99;s:40:"REQUEST.t_sbs_bx_photos_comments_Subject";i:100;s:31:"POST.t_sbs_bx_photos_rates_Body";i:101;s:34:"REQUEST.t_sbs_bx_photos_rates_Body";i:102;s:34:"POST.t_sbs_bx_photos_rates_Subject";i:103;s:37:"REQUEST.t_sbs_bx_photos_rates_Subject";i:104;s:22:"POST.t_SpamReport_Body";i:105;s:25:"REQUEST.t_SpamReport_Body";i:106;s:25:"POST.t_SpamReport_Subject";i:107;s:28:"REQUEST.t_SpamReport_Subject";i:108;s:24:"POST.t_Subscription_Body";i:109;s:27:"REQUEST.t_Subscription_Body";i:110;s:27:"POST.t_Subscription_Subject";i:111;s:30:"REQUEST.t_Subscription_Subject";i:112;s:22:"POST.t_TellFriend_Body";i:113;s:25:"REQUEST.t_TellFriend_Body";i:114;s:25:"POST.t_TellFriend_Subject";i:115;s:28:"REQUEST.t_TellFriend_Subject";i:116;s:29:"POST.t_TellFriendProfile_Body";i:117;s:32:"REQUEST.t_TellFriendProfile_Body";i:118;s:32:"POST.t_TellFriendProfile_Subject";i:119;s:35:"REQUEST.t_TellFriendProfile_Subject";i:120;s:17:"POST.t_VKiss_Body";i:121;s:20:"REQUEST.t_VKiss_Body";i:122;s:20:"POST.t_VKiss_Subject";i:123;s:23:"REQUEST.t_VKiss_Subject";i:124;s:25:"POST.t_VKiss_visitor_Body";i:125;s:28:"REQUEST.t_VKiss_visitor_Body";i:126;s:28:"POST.t_VKiss_visitor_Subject";i:127;s:31:"REQUEST.t_VKiss_visitor_Subject";}} [enable_dolphin_footer] => on [enable_modrewrite] => on [cupid_last_cron] => 0 [reg_by_inv_only] => [main_div_width] => 998px [promoWidth] => 998 [boonexAffID] => [ipBlacklistMode] => 1 [ipListGlobalType] => 0 [enable_member_store_ip] => on [site_email] => russell@drsandnurses.com [site_title] => DrsandNurses.com [site_email_notify] => russell@drsandnurses.com [enable_tiny_in_comments] => [enable_global_couple] => [enable_new_dhtml_popups] => on [galleryFiles_user] => 2 [galleryFiles_keyword] => 2 [enable_cache_system] => on [nav_menu_elements_on_line_usr] => 12 [nav_menu_elements_on_line_gst] => 12 [enable_guest_comments] => [enable_cmts_profile_delete] => on [permalinks_browse] => on [promo_relocation_link_visitor] => join.php [promo_relocation_link_member] => member.php [leaders_male_types] => year,month,week,day [leaders_female_types] => year,month,week,day [useLikeOperator] => on [ext_nav_menu_top_position] => bottom [ext_nav_menu_enabled] => on [sys_ps_enabled_group_1] => on [sys_ps_group_1_title] => Default [sys_ps_enabled_group_2] => on [sys_ps_group_2_title] => Me Only [sys_ps_enabled_group_3] => on [sys_ps_group_3_title] => Public [sys_ps_enabled_group_4] => on [sys_ps_group_4_title] => Members [sys_ps_enabled_group_5] => on [sys_ps_group_5_title] => Friends [sys_ps_enabled_group_6] => [sys_ps_group_6_title] => Faves [sys_ps_enabled_group_7] => [sys_ps_group_7_title] => Contacts [sys_make_album_cover_last] => on [sys_album_auto_app] => on [sys_album_default_name] => Hidden [sys_user_info_timeout] => 3 [template] => uni [enable_template] => on [sys_template_cache_enable] => on [sys_template_cache_image_enable] => [sys_template_cache_image_max_size] => 5 [sys_template_cache_css_enable] => on [sys_template_cache_js_enable] => on [sys_main_logo] => 1271795297.jpg [tags_perpage_browse] => 40 [tags_show_limit] => 50 [sys_ftp_login] => [sys_ftp_password] => [sys_ftp_dir] => [categ_perpage_browse] => 30 [categ_show_limit] => 50 [categ_show_columns] => 5 [sys_security_impact_threshold_log] => 13 [sys_security_impact_threshold_block] => 27 [friends_per_page] => 14 [sys_tmp_version] => 7.0.0 [permalinks_module_chat] => on [shoutbox_update_time] => 5000 [shoutbox_allowed_messages] => 15 [shoutbox_procces_smiles] => on [shoutbox_clean_oldest] => 1300 [bx_avatar_permalinks] => on [bx_avatar_quality] => 85 [bx_avatar_site_avatars] => on [bx_photos_activation] => on [category_auto_app_bx_photos] => on [bx_photos_allowed_exts] => jpg png gif [bx_photos_profile_album_name] => {nickname}'s photos [bx_photos_mode_index] => top [bx_photos_number_all] => 12 [bx_photos_number_index] => 8 [bx_photos_number_top] => 4 [bx_photos_number_user] => 4 [bx_photos_number_related] => 4 [bx_photos_number_previous_rated] => 4 [bx_photos_number_browse] => 12 [bx_photos_number_albums_browse] => 8 [bx_photos_number_albums_home] => 4 [bx_photos_icon_width] => 32 [bx_photos_icon_height] => 32 [bx_photos_thumb_width] => 64 [bx_photos_thumb_height] => 64 [bx_photos_file_width] => 600 [bx_photos_file_height] => 600 [bx_photos_browse_width] => 140 [bx_photos_browse_height] => 140 [bx_photos_flickr_photo_api] => [bx_photos_album_slideshow_on] => on [bx_photos_album_slideshow_height] => 600 [bx_photos_rss_feed_on] => on [bx_photos_permalinks] => on [permalinks_module_membership] => on [mbp_type] => [permalinks_module_payment] => on [pmt_default_currency_sign] => $ [pmt_default_currency_code] => GBP [blogAutoApproval] => on [blog_step] => 10 [max_blogs_on_home] => 3 [max_blog_preview] => 256 [bx_blogs_iconsize] => 45 [bx_blogs_thumbsize] => 110 [bx_blogs_bigthumbsize] => 340 [bx_blogs_imagesize] => 800 [permalinks_blogs] => on ) [_error] => ) [_error] => ) [args] => Array ( [0] => Database query error [1] => [2] => SELECT `ID`, `Name`, `Movable` FROM `sys_menu_top` WHERE `Active`=1 AND `Type`='top' ORDER BY `Order` ) ) [2] => Array ( [file] => /home/russj/public_html/inc/db.inc.php [line] => 43 [function] => res [class] => BxDolDb [type] => -> [object] => BxDolDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] =>
[EDITED BY ZARCON TO REMOVE DATABASE USERNAME/PASSWORD]

 [link] => Resource id #45 [current_res] => [current_arr_type] => 1 [oParams] => BxDolParams Object ( [_oDb] => BxDolDb Object *RECURSION* [_oCache] => BxDolCacheFile Object ( [sPath] => /home/russj/public_html/cache/ [_error] => ) [_sCacheFile] => sys_options.php [_aParams] => Array ( [anon_mode] => on [autoApproval_ifJoin] => on [autoApproval_ifProfile] => on [cmdDay] => 10 [currency_code] => USD [currency_sign] => $ [time_format_php] => H:i [short_date_format_php] => d.m.Y [date_format_php] => d.m.Y H:i [time_format] => %H:%i [short_date_format] => %d.%m.%Y [date_format] => %d.%m.%Y %H:%i [db_clean_msg] => 180 [db_clean_profiles] => 180 [db_clean_views] => 180 [db_clean_vkiss] => 90 [default_country] => UK [enable_contact_form] => on [enable_gd] => on [enable_match] => on [view_match_percent] => on [enable_promotion_membership] => [enable_watermark] => [enable_zip_loc] => on [expire_notification_days] => 1 [expire_notify_once] => on [featured_num] => 6 [lang_default] => en [match_percent] => 85 [max_inbox_message_size] => 1500 [member_online_time] => 1 [MetaDescription] => Dating and social networking for doctors, nurses and all healthcare employees [MetaKeyWords] => nhs, health, healthcare, relationships, singles, fun, social, nurses, doctors, nhs-dating, nhs-dating.co.uk, dating, social, networking, community [msgs_per_start] => 20 [enable_inbox_notify] => [news_enable] => 1 [newusernotify] => on [promotion_membership_days] => 7 [search_start_age] => 18 [search_end_age] => 75 [sys_calendar_starts_sunday] => [top_members_max_num] => 12 [track_profile_view] => on [transparent1] => 0 [votes] => on [Water_Mark] => [zodiac] => [php_date_format] => F j, Y [tags_non_parsable] => nhs, health, healthcare, dating, relationships, singles, fun, social, nurses, doctors, nhs-dating, nhs-dating.co.uk [tags_last_parse_time] => 0 [tags_min_rating] => 2 [autoApproval_ifNoConfEmail] => on [enable_flash_promo] => on [custom_promo_code] => [license_code] => 849L898Z69 [license_expiration] => 0 [license_checksum] => 115adaea465e55ce7f7eec4cfa37f9e0 [sys_html_fields] => a:3:{s:6:"system";a:4:{i:0;s:12:"POST.message";i:1;s:15:"REQUEST.message";i:2;s:12:"POST.CmtText";i:3;s:15:"REQUEST.CmtText";}s:19:"system_profile_html";a:4:{i:0;s:20:"POST.DescriptionMe.0";i:1;s:20:"POST.DescriptionMe.1";i:2;s:23:"REQUEST.DescriptionMe.0";i:3;s:23:"REQUEST.DescriptionMe.1";}s:5:"blogs";a:4:{i:0;s:13:"POST.PostText";i:1;s:16:"REQUEST.PostText";i:2;s:16:"POST.Description";i:3;s:19:"REQUEST.Description";}} [sys_json_fields] => [sys_exceptions_fields] => a:1:{s:22:"system_email_templates";a:128:{i:0;s:22:"POST.t_Activation_Body";i:1;s:25:"REQUEST.t_Activation_Body";i:2;s:25:"POST.t_Activation_Subject";i:3;s:28:"REQUEST.t_Activation_Subject";i:4;s:22:"POST.t_Activation_Body";i:5;s:25:"REQUEST.t_Activation_Body";i:6;s:25:"POST.t_Activation_Subject";i:7;s:28:"REQUEST.t_Activation_Subject";i:8;s:22:"POST.t_AdminEmail_Body";i:9;s:25:"REQUEST.t_AdminEmail_Body";i:10;s:25:"POST.t_AdminEmail_Subject";i:11;s:28:"REQUEST.t_AdminEmail_Subject";i:12;s:28:"POST.t_bx_photos_report_Body";i:13;s:31:"REQUEST.t_bx_photos_report_Body";i:14;s:31:"POST.t_bx_photos_report_Subject";i:15;s:34:"REQUEST.t_bx_photos_report_Subject";i:16;s:27:"POST.t_bx_photos_share_Body";i:17;s:30:"REQUEST.t_bx_photos_share_Body";i:18;s:30:"POST.t_bx_photos_share_Subject";i:19;s:33:"REQUEST.t_bx_photos_share_Subject";i:20;s:19:"POST.t_Compose_Body";i:21;s:22:"REQUEST.t_Compose_Body";i:22;s:22:"POST.t_Compose_Subject";i:23;s:25:"REQUEST.t_Compose_Subject";i:24;s:24:"POST.t_Confirmation_Body";i:25;s:27:"REQUEST.t_Confirmation_Body";i:26;s:27:"POST.t_Confirmation_Subject";i:27;s:30:"REQUEST.t_Confirmation_Subject";i:28;s:21:"POST.t_CupidMail_Body";i:29;s:24:"REQUEST.t_CupidMail_Body";i:30;s:24:"POST.t_CupidMail_Subject";i:31;s:27:"REQUEST.t_CupidMail_Subject";i:32;s:18:"POST.t_Forgot_Body";i:33;s:21:"REQUEST.t_Forgot_Body";i:34;s:21:"POST.t_Forgot_Subject";i:35;s:24:"REQUEST.t_Forgot_Subject";i:36;s:21:"POST.t_FreeEmail_Body";i:37;s:24:"REQUEST.t_FreeEmail_Body";i:38;s:24:"POST.t_FreeEmail_Subject";i:39;s:27:"REQUEST.t_FreeEmail_Subject";i:40;s:25:"POST.t_FriendRequest_Body";i:41;s:28:"REQUEST.t_FriendRequest_Body";i:42;s:28:"POST.t_FriendRequest_Subject";i:43;s:31:"REQUEST.t_FriendRequest_Subject";i:44;s:25:"POST.t_MemExpiration_Body";i:45;s:28:"REQUEST.t_MemExpiration_Body";i:46;s:28:"POST.t_MemExpiration_Subject";i:47;s:31:"REQUEST.t_MemExpiration_Subject";i:48;s:19:"POST.t_Message_Body";i:49;s:22:"REQUEST.t_Message_Body";i:50;s:22:"POST.t_Message_Subject";i:51;s:25:"REQUEST.t_Message_Subject";i:52;s:23:"POST.t_MessageCopy_Body";i:53;s:26:"REQUEST.t_MessageCopy_Body";i:54;s:26:"POST.t_MessageCopy_Subject";i:55;s:29:"REQUEST.t_MessageCopy_Subject";i:56;s:21:"POST.t_Rejection_Body";i:57;s:24:"REQUEST.t_Rejection_Body";i:58;s:24:"POST.t_Rejection_Subject";i:59;s:27:"REQUEST.t_Rejection_Subject";i:60;s:32:"POST.t_sbsBlogpostsComments_Body";i:61;s:35:"REQUEST.t_sbsBlogpostsComments_Body";i:62;s:35:"POST.t_sbsBlogpostsComments_Subject";i:63;s:38:"REQUEST.t_sbsBlogpostsComments_Subject";i:64;s:29:"POST.t_sbsBlogpostsRates_Body";i:65;s:32:"REQUEST.t_sbsBlogpostsRates_Body";i:66;s:32:"POST.t_sbsBlogpostsRates_Subject";i:67;s:35:"REQUEST.t_sbsBlogpostsRates_Subject";i:68;s:31:"POST.t_sbsFeedbackComments_Body";i:69;s:34:"REQUEST.t_sbsFeedbackComments_Body";i:70;s:34:"POST.t_sbsFeedbackComments_Subject";i:71;s:37:"REQUEST.t_sbsFeedbackComments_Subject";i:72;s:31:"POST.t_sbsFeedbackComments_Body";i:73;s:34:"REQUEST.t_sbsFeedbackComments_Body";i:74;s:34:"POST.t_sbsFeedbackComments_Subject";i:75;s:37:"REQUEST.t_sbsFeedbackComments_Subject";i:76;s:28:"POST.t_sbsFeedbackRates_Body";i:77;s:31:"REQUEST.t_sbsFeedbackRates_Body";i:78;s:31:"POST.t_sbsFeedbackRates_Subject";i:79;s:34:"REQUEST.t_sbsFeedbackRates_Subject";i:80;s:28:"POST.t_sbsFeedbackRates_Body";i:81;s:31:"REQUEST.t_sbsFeedbackRates_Body";i:82;s:31:"POST.t_sbsFeedbackRates_Subject";i:83;s:34:"REQUEST.t_sbsFeedbackRates_Subject";i:84;s:30:"POST.t_sbsProfileComments_Body";i:85;s:33:"REQUEST.t_sbsProfileComments_Body";i:86;s:33:"POST.t_sbsProfileComments_Subject";i:87;s:36:"REQUEST.t_sbsProfileComments_Subject";i:88;s:26:"POST.t_sbsProfileEdit_Body";i:89;s:29:"REQUEST.t_sbsProfileEdit_Body";i:90;s:29:"POST.t_sbsProfileEdit_Subject";i:91;s:32:"REQUEST.t_sbsProfileEdit_Subject";i:92;s:27:"POST.t_sbsProfileRates_Body";i:93;s:30:"REQUEST.t_sbsProfileRates_Body";i:94;s:30:"POST.t_sbsProfileRates_Subject";i:95;s:33:"REQUEST.t_sbsProfileRates_Subject";i:96;s:34:"POST.t_sbs_bx_photos_comments_Body";i:97;s:37:"REQUEST.t_sbs_bx_photos_comments_Body";i:98;s:37:"POST.t_sbs_bx_photos_comments_Subject";i:99;s:40:"REQUEST.t_sbs_bx_photos_comments_Subject";i:100;s:31:"POST.t_sbs_bx_photos_rates_Body";i:101;s:34:"REQUEST.t_sbs_bx_photos_rates_Body";i:102;s:34:"POST.t_sbs_bx_photos_rates_Subject";i:103;s:37:"REQUEST.t_sbs_bx_photos_rates_Subject";i:104;s:22:"POST.t_SpamReport_Body";i:105;s:25:"REQUEST.t_SpamReport_Body";i:106;s:25:"POST.t_SpamReport_Subject";i:107;s:28:"REQUEST.t_SpamReport_Subject";i:108;s:24:"POST.t_Subscription_Body";i:109;s:27:"REQUEST.t_Subscription_Body";i:110;s:27:"POST.t_Subscription_Subject";i:111;s:30:"REQUEST.t_Subscription_Subject";i:112;s:22:"POST.t_TellFriend_Body";i:113;s:25:"REQUEST.t_TellFriend_Body";i:114;s:25:"POST.t_TellFriend_Subject";i:115;s:28:"REQUEST.t_TellFriend_Subject";i:116;s:29:"POST.t_TellFriendProfile_Body";i:117;s:32:"REQUEST.t_TellFriendProfile_Body";i:118;s:32:"POST.t_TellFriendProfile_Subject";i:119;s:35:"REQUEST.t_TellFriendProfile_Subject";i:120;s:17:"POST.t_VKiss_Body";i:121;s:20:"REQUEST.t_VKiss_Body";i:122;s:20:"POST.t_VKiss_Subject";i:123;s:23:"REQUEST.t_VKiss_Subject";i:124;s:25:"POST.t_VKiss_visitor_Body";i:125;s:28:"REQUEST.t_VKiss_visitor_Body";i:126;s:28:"POST.t_VKiss_visitor_Subject";i:127;s:31:"REQUEST.t_VKiss_visitor_Subject";}} [enable_dolphin_footer] => on [enable_modrewrite] => on [cupid_last_cron] => 0 [reg_by_inv_only] => [main_div_width] => 998px [promoWidth] => 998 [boonexAffID] => [ipBlacklistMode] => 1 [ipListGlobalType] => 0 [enable_member_store_ip] => on [site_email] => russell@drsandnurses.com [site_title] => DrsandNurses.com [site_email_notify] => russell@drsandnurses.com [enable_tiny_in_comments] => [enable_global_couple] => [enable_new_dhtml_popups] => on [galleryFiles_user] => 2 [galleryFiles_keyword] => 2 [enable_cache_system] => on [nav_menu_elements_on_line_usr] => 12 [nav_menu_elements_on_line_gst] => 12 [enable_guest_comments] => [enable_cmts_profile_delete] => on [permalinks_browse] => on [promo_relocation_link_visitor] => join.php [promo_relocation_link_member] => member.php [leaders_male_types] => year,month,week,day [leaders_female_types] => year,month,week,day [useLikeOperator] => on [ext_nav_menu_top_position] => bottom [ext_nav_menu_enabled] => on [sys_ps_enabled_group_1] => on [sys_ps_group_1_title] => Default [sys_ps_enabled_group_2] => on [sys_ps_group_2_title] => Me Only [sys_ps_enabled_group_3] => on [sys_ps_group_3_title] => Public [sys_ps_enabled_group_4] => on [sys_ps_group_4_title] => Members [sys_ps_enabled_group_5] => on [sys_ps_group_5_title] => Friends [sys_ps_enabled_group_6] => [sys_ps_group_6_title] => Faves [sys_ps_enabled_group_7] => [sys_ps_group_7_title] => Contacts [sys_make_album_cover_last] => on [sys_album_auto_app] => on [sys_album_default_name] => Hidden [sys_user_info_timeout] => 3 [template] => uni [enable_template] => on [sys_template_cache_enable] => on [sys_template_cache_image_enable] => [sys_template_cache_image_max_size] => 5 [sys_template_cache_css_enable] => on [sys_template_cache_js_enable] => on [sys_main_logo] => 1271795297.jpg [tags_perpage_browse] => 40 [tags_show_limit] => 50 [sys_ftp_login] => [sys_ftp_password] => [sys_ftp_dir] => [categ_perpage_browse] => 30 [categ_show_limit] => 50 [categ_show_columns] => 5 [sys_security_impact_threshold_log] => 13 [sys_security_impact_threshold_block] => 27 [friends_per_page] => 14 [sys_tmp_version] => 7.0.0 [permalinks_module_chat] => on [shoutbox_update_time] => 5000 [shoutbox_allowed_messages] => 15 [shoutbox_procces_smiles] => on [shoutbox_clean_oldest] => 1300 [bx_avatar_permalinks] => on [bx_avatar_quality] => 85 [bx_avatar_site_avatars] => on [bx_photos_activation] => on [category_auto_app_bx_photos] => on [bx_photos_allowed_exts] => jpg png gif [bx_photos_profile_album_name] => {nickname}'s photos [bx_photos_mode_index] => top [bx_photos_number_all] => 12 [bx_photos_number_index] => 8 [bx_photos_number_top] => 4 [bx_photos_number_user] => 4 [bx_photos_number_related] => 4 [bx_photos_number_previous_rated] => 4 [bx_photos_number_browse] => 12 [bx_photos_number_albums_browse] => 8 [bx_photos_number_albums_home] => 4 [bx_photos_icon_width] => 32 [bx_photos_icon_height] => 32 [bx_photos_thumb_width] => 64 [bx_photos_thumb_height] => 64 [bx_photos_file_width] => 600 [bx_photos_file_height] => 600 [bx_photos_browse_width] => 140 [bx_photos_browse_height] => 140 [bx_photos_flickr_photo_api] => [bx_photos_album_slideshow_on] => on [bx_photos_album_slideshow_height] => 600 [bx_photos_rss_feed_on] => on [bx_photos_permalinks] => on [permalinks_module_membership] => on [mbp_type] => [permalinks_module_payment] => on [pmt_default_currency_sign] => $ [pmt_default_currency_code] => GBP [blogAutoApproval] => on [blog_step] => 10 [max_blogs_on_home] => 3 [max_blog_preview] => 256 [bx_blogs_iconsize] => 45 [bx_blogs_thumbsize] => 110 [bx_blogs_bigthumbsize] => 340 [bx_blogs_imagesize] => 800 [permalinks_blogs] => on ) [_error] => ) [_error] => ) [args] => Array ( [0] => SELECT `ID`, `Name`, `Movable` FROM `sys_menu_top` WHERE `Active`=1 AND `Type`='top' ORDER BY `Order` ) ) [3] => Array ( [file] => /home/russj/public_html/administration/nav_menu_compose.php [line] => 130 [function] => db_res [args] => Array ( [0] => SELECT `ID`, `Name`, `Movable` FROM `sys_menu_top` WHERE `Active`=1 AND `Type`='top' ORDER BY `Order` ) ) )
Called script: /administration/nav_menu_compose.php
Request parameters:
Array
(
    [__utmz] => 107611479.1308088125.3.3.utmcsr=twitter.com|utmccn=(referral)|utmcmd=referral|utmcct=/

[EDITED BY ZARCON TO REMOVE USERNAME/PASSWORD]
[__utma] => 107611479.69287999.1308004100.1308084494.1308088125.3 [__utmc] => 107611479 [__utmb] => 107611479.2.10.1308088125 )
Quote · 14 Jun 2011

For some reason your table is broken.

I attached a file for the fix.

Upload that on your dolphin root directory and run the file like

http://YOURDOMAIN/fix.php

It should solve the issue, or at least it will add the missing column "Movable".

fix.php · 220B · 251 downloads
Web Development, Multimedia Design and Social Media.
Quote · 15 Jun 2011

Yes, it is obvious the Field Movable is missing from the table sys_top_menu per the error.

However before just sticking it in there as YoibLab as provided a script to do, i must ask did you recently upgrade dolphin?

The field Movable did not exist in Dolphin 7.0.0 or 7.0.1. It was added as of dolphin 7.0.2 along with some other fields that did not exist in prior versions.

So it would be important to know if a upgrade was done to dolphin from version 7.0.0 or 7.0.1 to a newer version. If so, then it would be apparent to me that the upgrade was not successful. In which case a different course of action would be recommended.

There is also another possibility. One line in your debug output shown above shows this.

[sys_tmp_version] => 7.0.0

This could indicate your running dolphin version 7.0.0, and because that version of dolphin is not suppose to have that field, then running YobiLabs fix would be a mistake. So in this case perhaps you recently installed a mod that is not compatible with your version of dolphin

But before proceeding, you should provide us with more information. Such as the version of dolphin your currently running and any upgrades or mod installs recently done.

Sorry for the long-winded post, but without knowing your version of dolphin, running that fix YobiLab provided should not be done because as i mentioned, dolphin 7.0.0 and 7.0.1 is not suppose to have that field.

https://www.deanbassett.com
Quote · 15 Jun 2011

Hi guys thanks so much for your help.

I tried using the script to add the table movable but this didnt fix it. I do know that my version of Dolphin is 7.02.

You think my upgrade didnt go well? Can I do it again, or modify it slightly?

 

Thanks again

Quote · 15 Jun 2011

You mean that after having used that script you are receiving the very same error?

this is not possible.

You should have received another kind of error!

Maybe more columns are missing and not only the Movable one.

Yes I really thing your upgrade did not go fine.

IF you have a backup of your site, restore it, and the upgrade again in a proper way.

Regards

Web Development, Multimedia Design and Social Media.
Quote · 15 Jun 2011

When you change in the database you also need to clear your cache folders.  but as deano said just might be an upgrade gone bad.

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 16 Jun 2011

Hello just add new field Movable (type integer)  to sys_menu_top table via your phpmyadmin 

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 16 Jun 2011

 

Hello just add new field Movable (type integer)  to sys_menu_top table via your phpmyadmin 

 I have even provided a script to do that.

Please read the previous posts before replying..

Web Development, Multimedia Design and Social Media.
Quote · 16 Jun 2011

Hi, thanks everyone.

 

I now get this msg

Query:
SELECT `ID`, `Name` FROM `sys_menu_top` WHERE `Type`!='system' AND (`Clonable`='1' OR (`Clonable`='0' AND `Active`='0'))
Mysql error:
Unknown column 'Clonable' in 'where clause'
Do I have to add a column called Clonable?
Thanks
Quote · 16 Jun 2011

I added field Clonable and the Navigation menu now works!!

The member menu still doesnt work though? it is still asking for movable field in field list but that is definately there?

 

thanks everyone

Quote · 16 Jun 2011

Double check field names.

Make sure the Movable field is spelled correctly and is in proper case. Movable with a capital M

The field names are case-sensitive on Linux systems.

And the member menu is not the same as the navigation menu. The navigation menus table is sys_menu_top and the member menu is sys_menu_member. So also make sure you read the error carefully to make sure you looking at the proper table.


https://www.deanbassett.com
Quote · 16 Jun 2011

Thanks, I added Clonable and Movable to the sys_menu_member and it all works!

 

Thanks so much everyone!

Quote · 16 Jun 2011

 

Thanks, I added Clonable and Movable to the sys_menu_member and it all works!

 

Thanks so much everyone!

 Just for future reference - You might want to make sure you are not posting CLEAR username and passwords to your database. I edited your code to remove them for you.

Nothing to see here
Quote · 16 Jun 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.