View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18972 | Bug reports | Security | public | 2023-07-20 01:02 | 2023-11-28 15:52 |
Reporter | cjactx85 | Assigned To | DenisChenu | ||
Priority | none | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 6.1.x | ||||
Summary | 18972: Unable to view or modify survey permissions | ||||
Description | When attempting to manipulate survey permissions; the functions to access the permissions section appear to be defective and do not load pages to modify survey permissions. | ||||
Steps To Reproduce | Steps to reproduceOpen a survey; and under settings choose "Survey Permissions". Expected resultAbility to assign permissions to different roles or users. Actual resultWith Config set to "Debug = 1" in config.php. CException Permission and its behaviors do not have a method or closure named "getUserDetails". wwwroot/limesurvey/vendor/yiisoft/yii/framework/base/CComponent.php(266) 254 public function __call($name,$parameters) Stack Trace 56 // FIXME this HTML stuff MUST BE IN VIEWS!! #2 110 elseif($param->isDefaultValueAvailable()) #4 78 $oMethod = new ReflectionMethod($this, $sDefault); #5 303 { #6 281 @see runAction #7 260 { #8 197 } #9 277 { #10 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) #11 180 public function run() #12 156 require_once APPPATH . 'core/LSYii_Application' . EXT; 2023-07-19 22:53:16 Apache Yii Framework/1.1.28 | ||||
Tags | No tags attached. | ||||
Bug heat | 258 | ||||
Complete LimeSurvey version number (& build) | 6.1.8+230717 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | mysql 5.5 | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | 8.0 | ||||
related to | 18676 | assigned | DenisChenu | Group list menu freez browser |
I ended up identifying that during the upgrade process; the menuentries were not reset; even after instructing the system to reset default; the menuentries table ended up with old and new entries. I dropped the menuentries table, and loaded in a version from a fresh install and was able to get access to all of the menu items. |
|
Thanks for the information :) |
|
You are welcome; I am attaching the two tables for comparison, the clean version after a fresh install, and the version created post upgrade and post reset-menus. bad_lime_surveymenu_entries(1).sql (16,500 bytes)
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- Results of lime_surveymenu_entries table after "reset" menus was performed. -- -------------------------------------------------------- -- -- Table structure for table `lime_surveymenu_entries` -- CREATE TABLE `lime_surveymenu_entries` ( `id` int NOT NULL, `menu_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `ordering` int DEFAULT '0', `name` varchar(168) COLLATE utf8mb4_unicode_ci DEFAULT '', `title` varchar(168) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_title` varchar(168) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_description` text COLLATE utf8mb4_unicode_ci, `menu_icon` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_icon_type` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_class` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_link` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `action` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `partial` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `classes` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `permission` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `permission_grade` varchar(192) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` mediumtext COLLATE utf8mb4_unicode_ci, `getdatamethod` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `language` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en-GB', `active` tinyint(1) NOT NULL DEFAULT '0', `changed_at` datetime DEFAULT NULL, `changed_by` int NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `created_by` int NOT NULL DEFAULT '0', `showincollapse` int DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `lime_surveymenu_entries` -- INSERT INTO `lime_surveymenu_entries` (`id`, `menu_id`, `user_id`, `ordering`, `name`, `title`, `menu_title`, `menu_description`, `menu_icon`, `menu_icon_type`, `menu_class`, `menu_link`, `action`, `template`, `partial`, `classes`, `permission`, `permission_grade`, `data`, `getdatamethod`, `language`, `active`, `changed_at`, `changed_by`, `created_at`, `created_by`, `showincollapse`) VALUES (60, 4, NULL, 1, 'overview', 'Survey overview', 'Overview', 'Open the general survey overview', 'list', 'fontawesome', '', 'surveyAdministration/view', '', '', '', '', '', '', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (64, 4, NULL, 5, 'theme_options', 'Theme options', 'Theme options', 'Edit theme options for this survey', 'paint-brush', 'fontawesome', '', 'themeOptions/updateSurvey', '', '', '', '', 'themes', 'read', '{\"render\": {\"link\": { \"pjaxed\": true, \"data\": {\"sid\": [\"survey\",\"sid\"], \"gsid\":[\"survey\",\"gsid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (65, 4, NULL, 6, 'presentation', 'Presentation & navigation settings', 'Presentation', 'Edit presentation and navigation settings', 'eye-slash', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_presentation_panel', '', 'surveylocale', 'read', NULL, 'tabPresentationNavigation', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (68, 4, NULL, 9, 'publication', 'Publication & access control settings', 'Publication & access', 'Edit settings for publication and access control', 'key', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_publication_panel', '', 'surveylocale', 'read', NULL, 'tabPublicationAccess', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (77, 5, NULL, 9, 'surveypermissions', 'Edit survey permissions', 'Survey permissions', 'Edit permissions for this survey', 'lock', 'fontawesome', '', 'surveyPermissions/index', '', '', '', '', 'surveysecurity', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (66, 4, NULL, 7, 'tokens', 'Survey participant settings', 'Participant settings', 'Set additional options for survey participants', 'users', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_tokens_panel', '', 'surveylocale', 'read', NULL, 'tabTokens', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (75, 5, NULL, 7, 'quotas', 'Edit quotas', 'Quotas', 'Edit quotas for this survey.', 'tasks', 'fontawesome', '', 'quotas/index', '', '', '', '', 'quotas', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (76, 5, NULL, 8, 'assessments', 'Edit assessments', 'Assessments', 'Edit and look at the assessements for this survey.', 'comment-o', 'fontawesome', '', 'assessment/index', '', '', '', '', 'assessments', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (67, 4, NULL, 8, 'notification', 'Notification and data management settings', 'Notifications & data', 'Edit settings for notification and data management', 'feed', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_notification_panel', '', 'surveylocale', 'read', NULL, 'tabNotificationDataManagement', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (78, 5, NULL, 10, 'emailtemplates', 'Email templates', 'Email templates', 'Edit the templates for invitation, reminder and registration emails', 'envelope-square', 'fontawesome', '', 'admin/emailtemplates/sa/index/', '', '', '', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (79, 5, NULL, 11, 'panelintegration', 'Edit survey panel integration', 'Panel integration', 'Define panel integrations for your survey', 'link', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_integration_panel', '', 'surveylocale', 'read', '{\"render\": {\"link\": { \"pjaxed\": false}}}', 'tabPanelIntegration', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (80, 5, NULL, 12, 'resources', 'Add/edit resources (files/images) for this survey', 'Resources', 'Add/edit resources (files/images) for this survey', 'file', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_resources_panel', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', 'tabResourceManagement', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (21, 2, NULL, 1, 'generalsettings_collapsed', 'General survey settings', 'General settings', 'Open general survey settings', 'gears', 'fontawesome', '', '', 'updatesurveylocalesettings_generalsettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_generaloptions_panel', '', 'surveysettings', 'read', NULL, '_generalTabEditSurvey', 'en-GB', 1, '2018-03-01 15:00:56', 0, '2018-03-01 15:00:56', 0, 0), (22, 2, NULL, 2, 'surveypermissions_collapsed', 'Edit survey permissions', 'Survey permissions', 'Edit permissions for this survey', 'lock', 'fontawesome', '', 'admin/surveypermission/sa/view/', '', '', '', '', 'surveysecurity', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-03-01 15:00:56', 0, '2018-03-01 15:00:56', 0, 0), (23, 2, NULL, 3, 'quotas_collapsed', 'Edit quotas', 'Survey quotas', 'Edit quotas for this survey.', 'tasks', 'fontawesome', '', 'admin/quotas/sa/index/', '', '', '', '', 'quotas', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-03-01 15:00:56', 0, '2018-03-01 15:00:56', 0, 0), (24, 2, NULL, 5, 'assessments_collapsed', 'Edit assessments', 'Assessments', 'Edit and look at the assessements for this survey.', 'comment-o', 'fontawesome', '', 'admin/assessments/sa/index/', '', '', '', '', 'assessments', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-03-01 15:00:56', 0, '2018-03-01 15:00:56', 0, 0), (25, 2, NULL, 7, 'emailtemplates_collapsed', 'Email templates', 'Email templates', 'Edit the templates for invitation, reminder and registration emails', 'envelope-square', 'fontawesome', '', 'admin/emailtemplates/sa/index/', '', '', '', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-03-01 15:00:56', 0, '2018-03-01 15:00:56', 0, 0), (27, 2, NULL, 8, 'tokens_collapsed', 'Survey participant settings', 'Participant settings', 'Set additional options for survey participants', 'user', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_tokens_panel', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '_tabTokens', 'en-GB', 1, '2018-03-01 15:00:56', 0, '2018-03-01 15:00:56', 0, 0), (86, 7, NULL, 1, 'plugins', 'Simple plugin settings', 'Simple plugins', 'Edit simple plugin settings', 'plug', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_plugins_panel', '', 'surveysettings', 'read', '{\"render\": {\"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', 'pluginTabSurvey', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 0), (61, 4, NULL, 2, 'generalsettings', 'General survey settings', 'General settings', 'Open general survey settings', 'gears', 'fontawesome', '', '', 'updatesurveylocalesettings_generalsettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_generaloptions_panel', '', 'surveysettings', 'read', NULL, 'generalTabEditSurvey', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (62, 4, NULL, 3, 'surveytexts', 'Survey text elements', 'Text elements', 'Survey text elements', 'file-text-o', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/tab_edit_view', '', 'surveylocale', 'read', NULL, 'getTextEditData', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (63, 4, NULL, 4, 'datasecurity', 'Privacy policy settings', 'Privacy policy', 'Edit privacy policy settings', 'shield', 'fontawesome', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/tab_edit_view_datasecurity', '', 'surveylocale', 'read', NULL, 'getDataSecurityEditData', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (69, 5, NULL, 1, 'listQuestions', 'List questions', 'List questions', 'List questions', 'list', 'fontawesome', '', 'questionAdministration/listQuestions', '', '', '', '', 'surveycontent', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (70, 5, NULL, 2, 'listSurveyGroups', 'Group list', 'Group list', 'List question groups', 'th-list', 'fontawesome', '', 'admin/survey/sa/listquestiongroups', '', '', '', '', 'surveycontent', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (87, 2, NULL, 4, 'reorder', 'Reorder questions/question groups', 'Reorder questions/question groups', 'Reorder questions/question groups', 'reorder', 'fontawesome', '', 'surveyAdministration/organize/', '', '', '', '', 'surveycontent', 'update', '{\"render\": {\"link\": {\"data\": {\"surveyid\": [\"survey\", \"sid\"]}}}}', '', 'en-GB', 1, '2021-12-02 10:12:18', 0, '2021-12-02 10:12:18', 0, 1), (72, 5, NULL, 4, 'responses', 'Responses', 'Responses', 'Responses', 'icon-browse', 'iconclass', '', 'responses/browse', '', '', '', '', 'responses', 'read', '{\"render\": {\"isActive\": true, \"link\": {\"data\": {\"surveyId\": [\"survey\", \"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (73, 5, NULL, 5, 'participants', 'Survey participants', 'Survey participants', 'Go to survey participant and token settings', 'user', 'fontawesome', '', 'admin/tokens/sa/index/', '', '', '', '', 'tokens', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (74, 5, NULL, 6, 'statistics', 'Statistics', 'Statistics', 'Statistics', 'bar-chart', 'fontawesome', '', 'admin/statistics/sa/index/', '', '', '', '', 'statistics', 'read', '{\"render\": {\"isActive\": true, \"link\": {\"data\": {\"surveyid\": [\"survey\", \"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (81, 6, NULL, 1, 'activateSurvey', 'Activate survey', 'Activate survey', 'Activate survey', 'play', 'fontawesome', '', 'surveyAdministration/activate', '', '', '', '', 'surveyactivation', 'update', '{\"render\": {\"isActive\": false, \"link\": {\"data\": {\"iSurveyID\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (82, 6, NULL, 2, 'deactivateSurvey', 'Stop this survey', 'Stop this survey', 'Stop this survey', 'stop', 'fontawesome', '', 'surveyAdministration/deactivate', '', '', '', '', 'surveyactivation', 'update', '{\"render\": {\"isActive\": true, \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (83, 6, NULL, 3, 'testSurvey', 'Go to survey', 'Go to survey', 'Go to survey', 'cog', 'fontawesome', '', 'survey/index/', '', '', '', '', '', '', '{\"render\": {\"link\": {\"external\": true, \"data\": {\"sid\": [\"survey\",\"sid\"], \"newtest\": \"Y\", \"lang\": [\"survey\",\"language\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (84, 6, NULL, 4, 'surveyLogicFile', 'Survey logic file', 'Survey logic file', 'Survey logic file', 'sitemap', 'fontawesome', '', 'admin/expressions/sa/survey_logic_file/', '', '', '', '', 'surveycontent', 'read', '{\"render\": { \"link\": {\"data\": {\"sid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (85, 6, NULL, 5, 'cpdb', 'Central participant database', 'Central participant database', 'Central participant database', 'users', 'fontawesome', '', 'admin/participants/sa/displayParticipants', '', '', '', '', 'tokens', 'read', '{\"render\": {\"link\": {}}}', '', 'en-GB', 1, '2018-09-11 10:51:05', 0, '2018-09-11 10:51:05', 0, 1), (88, 2, NULL, 6, 'failedemail', 'Failed email notifications', 'Failed email notifications', 'View and resend failed email notifications', 'envelope-square', 'fontawesome', '', 'failedEmail/index/', '', '', '', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, '2023-03-03 21:56:13', 0, '2023-03-03 21:56:13', 0, 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `lime_surveymenu_entries` -- ALTER TABLE `lime_surveymenu_entries` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `lime_surveymenu_entries_name` (`name`), ADD KEY `lime_idx1_surveymenu_entries` (`menu_id`), ADD KEY `lime_idx5_surveymenu_entries` (`menu_title`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `lime_surveymenu_entries` -- ALTER TABLE `lime_surveymenu_entries` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; clean_lime_surveymenu_entries.sql (13,899 bytes)
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -------------------------------------------------------- -- -- Table structure for table `lime_surveymenu_entries` -- CREATE TABLE `lime_surveymenu_entries` ( `id` int NOT NULL, `menu_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `ordering` int DEFAULT '0', `name` varchar(168) COLLATE utf8mb4_unicode_ci DEFAULT '', `title` varchar(168) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_title` varchar(168) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_description` text COLLATE utf8mb4_unicode_ci, `menu_icon` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_icon_type` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_class` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_link` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `action` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `partial` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `classes` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `permission` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `permission_grade` varchar(192) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` mediumtext COLLATE utf8mb4_unicode_ci, `getdatamethod` varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `language` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en-GB', `showincollapse` int DEFAULT '0', `active` int NOT NULL DEFAULT '0', `changed_at` datetime DEFAULT NULL, `changed_by` int NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `created_by` int NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `lime_surveymenu_entries` -- INSERT INTO `lime_surveymenu_entries` (`id`, `menu_id`, `user_id`, `ordering`, `name`, `title`, `menu_title`, `menu_description`, `menu_icon`, `menu_icon_type`, `menu_class`, `menu_link`, `action`, `template`, `partial`, `classes`, `permission`, `permission_grade`, `data`, `getdatamethod`, `language`, `showincollapse`, `active`, `changed_at`, `changed_by`, `created_at`, `created_by`) VALUES (1, 1, NULL, 1, 'overview', 'Survey overview', 'Overview', 'Open the general survey overview', 'ri-bar-chart-horizontal-line', 'remix', '', 'surveyAdministration/view', '', '', '', '', '', '', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (2, 1, NULL, 2, 'generalsettings', 'General survey settings', 'General settings', 'Open general survey settings', 'ri-tools-line', 'remix', '', '', 'updatesurveylocalesettings_generalsettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_generaloptions_panel', '', 'surveysettings', 'read', NULL, 'generalTabEditSurvey', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (3, 1, NULL, 3, 'surveytexts', 'Survey text elements', 'Text elements', 'Survey text elements', 'ri-text-spacing', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/tab_edit_view', '', 'surveylocale', 'read', NULL, 'getTextEditData', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (4, 1, NULL, 4, 'datasecurity', 'Privacy policy settings', 'Privacy policy', 'Edit privacy policy settings', 'ri-shield-line', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/tab_edit_view_datasecurity', '', 'surveylocale', 'read', NULL, 'getDataSecurityEditData', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (5, 1, NULL, 5, 'theme_options', 'Theme options', 'Theme options', 'Edit theme options for this survey', 'ri-contrast-drop-fill', 'remix', '', 'themeOptions/updateSurvey', '', '', '', '', 'surveysettings', 'update', '{\"render\": {\"link\": { \"pjaxed\": true, \"data\": {\"surveyid\": [\"survey\",\"sid\"], \"gsid\":[\"survey\",\"gsid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (6, 1, NULL, 6, 'presentation', 'Presentation & navigation settings', 'Presentation', 'Edit presentation and navigation settings', 'ri-slideshow-line', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_presentation_panel', '', 'surveylocale', 'read', NULL, 'tabPresentationNavigation', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (7, 1, NULL, 7, 'tokens', 'Survey participant settings', 'Participant settings', 'Set additional options for survey participants', 'ri-body-scan-fill', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_tokens_panel', '', 'surveylocale', 'read', NULL, 'tabTokens', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (8, 1, NULL, 8, 'notification', 'Notification and data management settings', 'Notifications & data', 'Edit settings for notification and data management', 'ri-notification-line', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_notification_panel', '', 'surveylocale', 'read', NULL, 'tabNotificationDataManagement', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (9, 1, NULL, 9, 'publication', 'Publication & access control settings', 'Publication & access', 'Edit settings for publication and access control', 'ri-key-line', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_publication_panel', '', 'surveylocale', 'read', NULL, 'tabPublicationAccess', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (10, 1, NULL, 10, 'surveypermissions', 'Edit survey permissions', 'Survey permissions', 'Edit permissions for this survey', 'ri-lock-password-line', 'remix', '', 'surveyPermissions/index', '', '', '', '', 'surveysecurity', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (11, 2, NULL, 1, 'listQuestions', 'Question list', 'Question list', 'List questions', '', 'remix', '', 'questionAdministration/listQuestions', '', '', '', '', 'surveycontent', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (12, 2, NULL, 2, 'listQuestionGroups', 'Group list', 'Group list', 'List question groups', '', 'remix', '', 'questionGroupsAdministration/listquestiongroups', '', '', '', '', 'surveycontent', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (13, 2, NULL, 3, 'reorder', 'Reorder questions & groups', 'Reorder questions & groups', 'Reorder questions & groups', 'reorder', 'fontawesome', '', 'surveyAdministration/organize/', '', '', '', '', 'surveycontent', 'update', '{\"render\": {\"link\": {\"data\": {\"surveyid\": [\"survey\", \"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (14, 2, NULL, 4, 'participants', 'Survey participants', 'Survey participants', 'Go to survey participant and token settings', '', 'remix', '', 'admin/tokens/sa/index/', '', '', '', '', 'tokens', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (15, 2, NULL, 5, 'emailtemplates', 'Email templates', 'Email templates', 'Edit the templates for invitation, reminder and registration emails', '', 'remix', '', 'admin/emailtemplates/sa/index/', '', '', '', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (16, 2, NULL, 6, 'failedemail', 'Failed email notifications', 'Failed email notifications', 'View and resend failed email notifications', '', 'remix', '', 'failedEmail/index/', '', '', '', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (17, 2, NULL, 7, 'quotas', 'Edit quotas', 'Quotas', 'Edit quotas for this survey.', '', 'remix', '', 'quotas/index/', '', '', '', '', 'quotas', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (18, 2, NULL, 8, 'assessments', 'Edit assessments', 'Assessments', 'Edit and look at the assessements for this survey.', '', 'remix', '', 'assessment/index', '', '', '', '', 'assessments', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (19, 2, NULL, 9, 'panelintegration', 'Edit survey panel integration', 'Panel integration', 'Define panel integrations for your survey', '', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_integration_panel', '', 'surveylocale', 'read', '{\"render\": {\"link\": { \"pjaxed\": false}}}', 'tabPanelIntegration', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (20, 2, NULL, 10, 'responses', 'Responses', 'Responses', 'Responses', '', 'remix', '', 'responses/browse/', '', '', '', '', 'responses', 'read', '{\"render\": {\"isActive\": true, \"link\": {\"data\": {\"surveyId\": [\"survey\", \"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (21, 2, NULL, 11, 'statistics', 'Statistics', 'Statistics', 'Statistics', '', 'remix', '', 'admin/statistics/sa/index/', '', '', '', '', 'statistics', 'read', '{\"render\": {\"isActive\": true, \"link\": {\"data\": {\"surveyid\": [\"survey\", \"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (22, 2, NULL, 12, 'resources', 'Add/edit resources (files/images) for this survey', 'Resources', 'Add/edit resources (files/images) for this survey', '', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_resources_panel', '', 'surveylocale', 'read', '{\"render\": { \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', 'tabResourceManagement', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (23, 2, NULL, 13, 'plugins', 'Simple plugin settings', 'Simple plugins', 'Edit simple plugin settings', '', 'remix', '', '', 'updatesurveylocalesettings', 'editLocalSettings_main_view', '/admin/survey/subview/accordion/_plugins_panel', '', 'surveysettings', 'read', '{\"render\": {\"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', 'pluginTabSurvey', 'en-GB', 0, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (24, 3, NULL, 1, 'activateSurvey', 'Activate survey', 'Activate survey', 'Activate survey', 'ri-play-fill', 'remix', '', 'surveyAdministration/activate', '', '', '', '', 'surveyactivation', 'update', '{\"render\": {\"isActive\": false, \"link\": {\"data\": {\"iSurveyID\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (25, 3, NULL, 2, 'deactivateSurvey', 'Stop survey', 'Stop survey', 'Stop this survey', 'ri-stop-fill', 'remix', '', 'surveyAdministration/deactivate', '', '', '', '', 'surveyactivation', 'update', '{\"render\": {\"isActive\": true, \"link\": {\"data\": {\"surveyid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (26, 3, NULL, 3, 'testSurvey', 'Go to survey', 'Go to survey', 'Go to survey', 'ri-settings-5-fill', 'remix', '', 'survey/index/', '', '', '', '', '', '', '{\"render\": {\"link\": {\"external\": true, \"data\": {\"sid\": [\"survey\",\"sid\"], \"newtest\": \"Y\", \"lang\": [\"survey\",\"language\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (27, 3, NULL, 4, 'surveyLogicFile', 'Survey logic file', 'Survey logic file', 'Survey logic file', 'ri-git-branch-fill', 'remix', '', 'admin/expressions/sa/survey_logic_file/', '', '', '', '', 'surveycontent', 'read', '{\"render\": { \"link\": {\"data\": {\"sid\": [\"survey\",\"sid\"]}}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0), (28, 3, NULL, 5, 'cpdb', 'Central participant database', 'Central participant database', 'Central participant database', 'ri-group-fill', 'remix', '', 'admin/participants/sa/displayParticipants', '', '', '', '', 'tokens', 'read', '{\"render\": {\"link\": {}}}', '', 'en-GB', 1, 1, '2023-07-20 09:13:43', 0, '2023-07-20 09:13:43', 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `lime_surveymenu_entries` -- ALTER TABLE `lime_surveymenu_entries` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `lime_surveymenu_entries_name` (`name`), ADD KEY `lime_idx1_surveymenu_entries` (`menu_id`), ADD KEY `lime_idx5_surveymenu_entries` (`menu_title`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `lime_surveymenu_entries` -- ALTER TABLE `lime_surveymenu_entries` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
We already have JIRA ticket for the menuentries not reset https://limesurvey.atlassian.net/browse/CR-1277. |
|
Great :) |
|
@tibor.pacalat : seems no issue between last 5 to master. |
|
As per the comments, this is kind of solved. |
|
Yes : it's due to bad update of the menu. |
|
This issue has already been fixed. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2023-07-20 01:02 | cjactx85 | New Issue | |
2023-07-20 16:18 | cjactx85 | Note Added: 76198 | |
2023-07-20 16:18 | cjactx85 | Bug heat | 250 => 252 |
2023-07-21 10:58 | DenisChenu | Relationship added | related to 18676 |
2023-07-21 10:58 | DenisChenu | Note Added: 76209 | |
2023-07-21 10:58 | DenisChenu | Bug heat | 252 => 254 |
2023-07-21 15:01 | cjactx85 | Note Added: 76228 | |
2023-07-21 15:01 | cjactx85 | File Added: bad_lime_surveymenu_entries(1).sql | |
2023-07-21 15:01 | cjactx85 | File Added: clean_lime_surveymenu_entries.sql | |
2023-07-28 12:07 | tibor.pacalat | Note Added: 76339 | |
2023-07-28 12:07 | tibor.pacalat | Bug heat | 254 => 256 |
2023-07-28 14:30 | cjactx85 | Note Added: 76344 | |
2023-07-28 15:27 | DenisChenu | Note Added: 76346 | |
2023-08-07 23:35 | gabrieljenik | Assigned To | => DenisChenu |
2023-08-07 23:35 | gabrieljenik | Status | new => assigned |
2023-08-07 23:35 | gabrieljenik | Note Added: 76472 | |
2023-08-07 23:35 | gabrieljenik | Bug heat | 256 => 258 |
2023-10-19 18:04 | DenisChenu | Note Added: 77794 | |
2023-11-28 15:52 | tibor.pacalat | Status | assigned => closed |
2023-11-28 15:52 | tibor.pacalat | Resolution | open => fixed |
2023-11-28 15:52 | tibor.pacalat | Note Added: 78771 |