View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06755 | Bug reports | Survey editing | public | 2012-10-23 10:10 | 2012-12-01 15:41 |
| Reporter | DenisChenu | Assigned To | |||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | unable to reproduce | ||
| Summary | 06755: Unable to add attribute to question | ||||
| Description | When trying to add question attribute and click to "showadanced settings on question", nothing happen | ||||
| Steps To Reproduce | Add a question and click to advanced settings | ||||
| Additional Information | http://lsgit-dev/index.php/admin/question/ajaxquestionattributes?class=undefined&qid=1&sid=221727 class is undefined, don't look more but think class have to be question_type in Yii 2.0. | ||||
| Tags | No tags attached. | ||||
| Attached Files | LimeSurvey_sondagespro_gitdev_dump_2012-10-26.sql (38,595 bytes)
--
-- LimeSurvey Database Dump of `sondagespro_gitdev`
-- Date of Dump: 26-Oct-2012
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_answers`
--
DROP TABLE IF EXISTS `lime_answers`;
CREATE TABLE `lime_answers` (
`qid` int(11) NOT NULL DEFAULT '0',
`code` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`answer` text COLLATE utf8_unicode_ci NOT NULL,
`sortorder` int(11) NOT NULL,
`assessment_value` int(11) NOT NULL DEFAULT '0',
`language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`scale_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`qid`,`code`,`language`,`scale_id`),
KEY `answers_idx2` (`sortorder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_answers`
--
INSERT INTO `lime_answers` (`qid`,`code`,`answer`,`sortorder`,`assessment_value`,`language`,`scale_id`) VALUES
("1", "A1", "Un exemple d\'option de réponse", "1", "0", "fr", "0"),
("1", "A2", "Nouvelle option pour la réponse", "2", "1", "fr", "0");
-- --------------------------------------------------------
--
-- Table structure for table `lime_assessments`
--
DROP TABLE IF EXISTS `lime_assessments`;
CREATE TABLE `lime_assessments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL DEFAULT '0',
`scope` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`gid` int(11) NOT NULL DEFAULT '0',
`name` text COLLATE utf8_unicode_ci NOT NULL,
`minimum` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`maximum` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`message` text COLLATE utf8_unicode_ci NOT NULL,
`language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
PRIMARY KEY (`id`,`language`),
KEY `assessments_idx2` (`sid`),
KEY `assessments_idx3` (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_assessments`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_conditions`
--
DROP TABLE IF EXISTS `lime_conditions`;
CREATE TABLE `lime_conditions` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`qid` int(11) NOT NULL DEFAULT '0',
`cqid` int(11) NOT NULL DEFAULT '0',
`cfieldname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`method` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`scenario` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`cid`),
KEY `conditions_idx2` (`qid`),
KEY `conditions_idx3` (`cqid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_conditions`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_defaultvalues`
--
DROP TABLE IF EXISTS `lime_defaultvalues`;
CREATE TABLE `lime_defaultvalues` (
`qid` int(11) NOT NULL DEFAULT '0',
`scale_id` int(11) NOT NULL DEFAULT '0',
`sqid` int(11) NOT NULL DEFAULT '0',
`language` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`specialtype` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`defaultvalue` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`qid`,`specialtype`,`language`,`scale_id`,`sqid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_defaultvalues`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_expression_errors`
--
DROP TABLE IF EXISTS `lime_expression_errors`;
CREATE TABLE `lime_expression_errors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`errortime` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`sid` int(11) DEFAULT NULL,
`gid` int(11) DEFAULT NULL,
`qid` int(11) DEFAULT NULL,
`gseq` int(11) DEFAULT NULL,
`qseq` int(11) DEFAULT NULL,
`type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`eqn` text COLLATE utf8_unicode_ci,
`prettyprint` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_expression_errors`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_failed_login_attempts`
--
DROP TABLE IF EXISTS `lime_failed_login_attempts`;
CREATE TABLE `lime_failed_login_attempts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`last_attempt` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`number_attempts` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_failed_login_attempts`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_groups`
--
DROP TABLE IF EXISTS `lime_groups`;
CREATE TABLE `lime_groups` (
`gid` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL DEFAULT '0',
`group_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`group_order` int(11) NOT NULL DEFAULT '0',
`description` text COLLATE utf8_unicode_ci,
`language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`randomization_group` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`grelevance` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`gid`,`language`),
KEY `groups_idx2` (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_groups`
--
INSERT INTO `lime_groups` (`gid`,`sid`,`group_name`,`group_order`,`description`,`language`,`randomization_group`,`grelevance`) VALUES
("1", "221727", "Groupe", "0", "", "fr", "", "");
-- --------------------------------------------------------
--
-- Table structure for table `lime_labels`
--
DROP TABLE IF EXISTS `lime_labels`;
CREATE TABLE `lime_labels` (
`lid` int(11) NOT NULL DEFAULT '0',
`code` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`title` text COLLATE utf8_unicode_ci,
`sortorder` int(11) NOT NULL,
`language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`assessment_value` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`lid`,`sortorder`,`language`),
KEY `labels_code_idx` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_labels`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_labelsets`
--
DROP TABLE IF EXISTS `lime_labelsets`;
CREATE TABLE `lime_labelsets` (
`lid` int(11) NOT NULL AUTO_INCREMENT,
`label_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`languages` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'en',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_labelsets`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_participant_attribute`
--
DROP TABLE IF EXISTS `lime_participant_attribute`;
CREATE TABLE `lime_participant_attribute` (
`participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`attribute_id` int(11) NOT NULL,
`value` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`participant_id`,`attribute_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_participant_attribute`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_participant_attribute_names`
--
DROP TABLE IF EXISTS `lime_participant_attribute_names`;
CREATE TABLE `lime_participant_attribute_names` (
`attribute_id` int(11) NOT NULL AUTO_INCREMENT,
`attribute_type` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`visible` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`attribute_id`,`attribute_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_participant_attribute_names`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_participant_attribute_names_lang`
--
DROP TABLE IF EXISTS `lime_participant_attribute_names_lang`;
CREATE TABLE `lime_participant_attribute_names_lang` (
`attribute_id` int(11) NOT NULL,
`attribute_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`attribute_id`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_participant_attribute_names_lang`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_participant_attribute_values`
--
DROP TABLE IF EXISTS `lime_participant_attribute_values`;
CREATE TABLE `lime_participant_attribute_values` (
`value_id` int(11) NOT NULL AUTO_INCREMENT,
`attribute_id` int(11) NOT NULL,
`value` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_participant_attribute_values`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_participant_shares`
--
DROP TABLE IF EXISTS `lime_participant_shares`;
CREATE TABLE `lime_participant_shares` (
`participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`share_uid` int(11) NOT NULL,
`date_added` datetime NOT NULL,
`can_edit` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`participant_id`,`share_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_participant_shares`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_participants`
--
DROP TABLE IF EXISTS `lime_participants`;
CREATE TABLE `lime_participants` (
`participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`firstname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`lastname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
`language` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`blacklisted` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
`owner_uid` int(11) NOT NULL,
PRIMARY KEY (`participant_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_participants`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_question_attributes`
--
DROP TABLE IF EXISTS `lime_question_attributes`;
CREATE TABLE `lime_question_attributes` (
`qaid` int(11) NOT NULL AUTO_INCREMENT,
`qid` int(11) NOT NULL DEFAULT '0',
`attribute` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8_unicode_ci,
`language` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`qaid`),
KEY `question_attributes_idx2` (`qid`),
KEY `question_attributes_idx3` (`attribute`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_question_attributes`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_question_type_groups`
--
DROP TABLE IF EXISTS `lime_question_type_groups`;
CREATE TABLE `lime_question_type_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`order` int(11) NOT NULL,
`system` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
UNIQUE KEY `order` (`order`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_question_type_groups`
--
INSERT INTO `lime_question_type_groups` (`id`,`name`,`order`,`system`) VALUES
("1", "Single choice questions", "1", "Y"),
("2", "Arrays", "2", "Y"),
("3", "Mask questions", "3", "Y"),
("4", "Text questions", "4", "Y"),
("5", "Multiple choice questions", "5", "Y");
-- --------------------------------------------------------
--
-- Table structure for table `lime_question_types`
--
DROP TABLE IF EXISTS `lime_question_types`;
CREATE TABLE `lime_question_types` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`order` int(11) NOT NULL,
`group` int(11) NOT NULL,
`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`class` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`legacy` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`system` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
PRIMARY KEY (`tid`),
UNIQUE KEY `order` (`order`,`group`),
UNIQUE KEY `Name` (`name`),
UNIQUE KEY `legacy` (`legacy`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_question_types`
--
INSERT INTO `lime_question_types` (`tid`,`order`,`group`,`name`,`class`,`legacy`,`system`) VALUES
("1", "1", "1", "5 point choice", "FiveList", "5", "Y"),
("2", "2", "1", "List (dropdown)", "Select", "!", "Y"),
("3", "3", "1", "List (radio)", "List", "L", "Y"),
("4", "4", "1", "List with comment", "CommentList", "O", "Y"),
("5", "1", "2", "Array", "RadioArray", "F", "Y"),
("6", "2", "2", "Array (10 point choice)", "TenRadioArray", "B", "Y"),
("7", "3", "2", "Array (5 point choice)", "FiveRadioArray", "A", "Y"),
("8", "4", "2", "Array (Increase/Same/Decrease)", "IDRadioArray", "E", "Y"),
("9", "5", "2", "Array (Numbers)", "NumberArray", ":", "Y"),
("10", "6", "2", "Array (Texts)", "TextArray", ";", "Y"),
("11", "7", "2", "Array (Yes/No/Uncertain)", "YNRadioArray", "C", "Y"),
("12", "8", "2", "Array by column", "ColumnRadioArray", "H", "Y"),
("13", "9", "2", "Array dual scale", "DualRadioArray", "1", "Y"),
("14", "1", "3", "Date/Time", "Date", "D", "Y"),
("15", "2", "3", "Equation", "Equation", "*", "Y"),
("16", "3", "3", "File upload", "File", "|", "Y"),
("17", "4", "3", "Gender", "Gender", "G", "Y"),
("18", "5", "3", "Language switch", "Language", "I", "Y"),
("19", "6", "3", "Multiple numerical input", "Multinumerical", "K", "Y"),
("20", "7", "3", "Numerical input", "Numerical", "N", "Y"),
("21", "8", "3", "Ranking", "Ranking", "R", "Y"),
("22", "9", "3", "Text display", "Display", "X", "Y"),
("23", "10", "3", "Yes/No", "YN", "Y", "Y"),
("24", "1", "4", "Huge free text", "HugeText", "U", "Y"),
("25", "2", "4", "Long free text", "LongText", "T", "Y"),
("26", "3", "4", "Multiple short text", "Multitext", "Q", "Y"),
("27", "4", "4", "Short free text", "ShortText", "S", "Y"),
("28", "1", "5", "Multiple choice", "Check", "M", "Y"),
("29", "2", "5", "Multiple choice with comments", "CommentCheck", "P", "Y");
-- --------------------------------------------------------
--
-- Table structure for table `lime_questions`
--
DROP TABLE IF EXISTS `lime_questions`;
CREATE TABLE `lime_questions` (
`qid` int(11) NOT NULL AUTO_INCREMENT,
`parent_qid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`gid` int(11) NOT NULL DEFAULT '0',
`tid` int(11) NOT NULL DEFAULT '0',
`type` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'T',
`title` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`question` text COLLATE utf8_unicode_ci NOT NULL,
`preg` text COLLATE utf8_unicode_ci,
`help` text COLLATE utf8_unicode_ci,
`other` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`mandatory` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`question_order` int(11) NOT NULL,
`language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`scale_id` int(11) NOT NULL DEFAULT '0',
`same_default` int(11) NOT NULL DEFAULT '0' COMMENT 'Saves if user set to use the same default value across languages in default options dialog',
`relevance` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`qid`,`language`),
KEY `questions_idx2` (`sid`),
KEY `questions_idx3` (`gid`),
KEY `questions_idx4` (`tid`),
KEY `parent_qid_idx` (`parent_qid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_questions`
--
INSERT INTO `lime_questions` (`qid`,`parent_qid`,`sid`,`gid`,`tid`,`type`,`title`,`question`,`preg`,`help`,`other`,`mandatory`,`question_order`,`language`,`scale_id`,`same_default`,`relevance`) VALUES
("1", "0", "221727", "1", "3", "L", "QQ", "", "", "", "N", "N", "1", "fr", "0", "0", "1");
-- --------------------------------------------------------
--
-- Table structure for table `lime_quota`
--
DROP TABLE IF EXISTS `lime_quota`;
CREATE TABLE `lime_quota` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`qlimit` int(11) DEFAULT NULL,
`action` int(11) DEFAULT NULL,
`active` int(11) NOT NULL DEFAULT '1',
`autoload_url` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `quota_idx2` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_quota`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_quota_languagesettings`
--
DROP TABLE IF EXISTS `lime_quota_languagesettings`;
CREATE TABLE `lime_quota_languagesettings` (
`quotals_id` int(11) NOT NULL AUTO_INCREMENT,
`quotals_quota_id` int(11) NOT NULL DEFAULT '0',
`quotals_language` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`quotals_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`quotals_message` text COLLATE utf8_unicode_ci NOT NULL,
`quotals_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`quotals_urldescrip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`quotals_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_quota_languagesettings`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_quota_members`
--
DROP TABLE IF EXISTS `lime_quota_members`;
CREATE TABLE `lime_quota_members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT NULL,
`qid` int(11) DEFAULT NULL,
`quota_id` int(11) DEFAULT NULL,
`code` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sid` (`sid`,`qid`,`quota_id`,`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_quota_members`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_saved_control`
--
DROP TABLE IF EXISTS `lime_saved_control`;
CREATE TABLE `lime_saved_control` (
`scid` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL DEFAULT '0',
`srid` int(11) NOT NULL DEFAULT '0',
`identifier` text COLLATE utf8_unicode_ci NOT NULL,
`access_code` text COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(320) COLLATE utf8_unicode_ci DEFAULT NULL,
`ip` text COLLATE utf8_unicode_ci NOT NULL,
`saved_thisstep` text COLLATE utf8_unicode_ci NOT NULL,
`status` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`saved_date` datetime NOT NULL,
`refurl` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`scid`),
KEY `saved_control_idx2` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_saved_control`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_sessions`
--
DROP TABLE IF EXISTS `lime_sessions`;
CREATE TABLE `lime_sessions` (
`id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`expire` int(11) DEFAULT NULL,
`data` longtext COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_sessions`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_settings_global`
--
DROP TABLE IF EXISTS `lime_settings_global`;
CREATE TABLE `lime_settings_global` (
`stg_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`stg_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`stg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_settings_global`
--
INSERT INTO `lime_settings_global` (`stg_name`,`stg_value`) VALUES
("DBVersion", "164"),
("SessionName", "ls785377276813944"),
("sitename", "LimeSurvey Yii 2.1"),
("siteadminname", "Sondages pro"),
("siteadminemail", "contact@sondages.pro"),
("siteadminbounce", "contact@sondages.pro"),
("defaultlang", "fr");
-- --------------------------------------------------------
--
-- Table structure for table `lime_survey_links`
--
DROP TABLE IF EXISTS `lime_survey_links`;
CREATE TABLE `lime_survey_links` (
`participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`token_id` int(11) NOT NULL,
`survey_id` int(11) NOT NULL,
`date_created` datetime DEFAULT NULL,
`date_invited` datetime DEFAULT NULL,
`date_completed` datetime DEFAULT NULL,
PRIMARY KEY (`participant_id`,`token_id`,`survey_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_survey_links`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_survey_permissions`
--
DROP TABLE IF EXISTS `lime_survey_permissions`;
CREATE TABLE `lime_survey_permissions` (
`sid` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`permission` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`create_p` int(11) NOT NULL DEFAULT '0',
`read_p` int(11) NOT NULL DEFAULT '0',
`update_p` int(11) NOT NULL DEFAULT '0',
`delete_p` int(11) NOT NULL DEFAULT '0',
`import_p` int(11) NOT NULL DEFAULT '0',
`export_p` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`,`uid`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_survey_permissions`
--
INSERT INTO `lime_survey_permissions` (`sid`,`uid`,`permission`,`create_p`,`read_p`,`update_p`,`delete_p`,`import_p`,`export_p`) VALUES
("221727", "1", "surveyactivation", "0", "0", "1", "0", "0", "0"),
("221727", "1", "surveycontent", "1", "1", "1", "1", "1", "1"),
("221727", "1", "tokens", "1", "1", "1", "1", "1", "1"),
("221727", "1", "surveysettings", "0", "1", "1", "0", "0", "0"),
("221727", "1", "surveylocale", "0", "1", "1", "0", "0", "0"),
("221727", "1", "quotas", "1", "1", "1", "1", "0", "0"),
("221727", "1", "responses", "1", "1", "1", "1", "1", "1"),
("221727", "1", "statistics", "0", "1", "0", "0", "0", "0"),
("221727", "1", "survey", "0", "1", "0", "1", "0", "0"),
("221727", "1", "surveysecurity", "1", "1", "1", "1", "0", "0"),
("221727", "1", "translations", "0", "1", "1", "0", "0", "0"),
("221727", "1", "assessments", "1", "1", "1", "1", "0", "0");
-- --------------------------------------------------------
--
-- Table structure for table `lime_survey_url_parameters`
--
DROP TABLE IF EXISTS `lime_survey_url_parameters`;
CREATE TABLE `lime_survey_url_parameters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL,
`parameter` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`targetqid` int(11) DEFAULT NULL,
`targetsqid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_survey_url_parameters`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_surveys`
--
DROP TABLE IF EXISTS `lime_surveys`;
CREATE TABLE `lime_surveys` (
`sid` int(11) NOT NULL,
`owner_id` int(11) NOT NULL,
`admin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`active` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`expires` datetime DEFAULT NULL,
`startdate` datetime DEFAULT NULL,
`adminemail` varchar(320) COLLATE utf8_unicode_ci DEFAULT NULL,
`anonymized` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`faxto` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`format` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`savetimings` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`template` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'default',
`language` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`additional_languages` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`datestamp` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`usecookie` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`allowregister` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`allowsave` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`autonumber_start` int(11) NOT NULL DEFAULT '0',
`autoredirect` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`allowprev` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`printanswers` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`ipaddr` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`refurl` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`datecreated` date DEFAULT NULL,
`publicstatistics` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`publicgraphs` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`listpublic` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`htmlemail` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`sendconfirmation` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`tokenanswerspersistence` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`assessments` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`usecaptcha` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`usetokens` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`bounce_email` varchar(320) COLLATE utf8_unicode_ci DEFAULT NULL,
`attributedescriptions` text COLLATE utf8_unicode_ci,
`emailresponseto` text COLLATE utf8_unicode_ci,
`emailnotificationto` text COLLATE utf8_unicode_ci,
`tokenlength` int(11) NOT NULL DEFAULT '15',
`showxquestions` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
`showgroupinfo` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'B',
`shownoanswer` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
`showqnumcode` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'X',
`bouncetime` int(11) DEFAULT NULL,
`bounceprocessing` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
`bounceaccounttype` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
`bounceaccounthost` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`bounceaccountpass` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`bounceaccountencryption` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
`bounceaccountuser` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`showwelcome` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
`showprogress` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
`allowjumps` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
`navigationdelay` int(11) NOT NULL DEFAULT '0',
`nokeyboard` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
`alloweditaftercompletion` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
`googleanalyticsstyle` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`googleanalyticsapikey` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_surveys`
--
INSERT INTO `lime_surveys` (`sid`,`owner_id`,`admin`,`active`,`expires`,`startdate`,`adminemail`,`anonymized`,`faxto`,`format`,`savetimings`,`template`,`language`,`additional_languages`,`datestamp`,`usecookie`,`allowregister`,`allowsave`,`autonumber_start`,`autoredirect`,`allowprev`,`printanswers`,`ipaddr`,`refurl`,`datecreated`,`publicstatistics`,`publicgraphs`,`listpublic`,`htmlemail`,`sendconfirmation`,`tokenanswerspersistence`,`assessments`,`usecaptcha`,`usetokens`,`bounce_email`,`attributedescriptions`,`emailresponseto`,`emailnotificationto`,`tokenlength`,`showxquestions`,`showgroupinfo`,`shownoanswer`,`showqnumcode`,`bouncetime`,`bounceprocessing`,`bounceaccounttype`,`bounceaccounthost`,`bounceaccountpass`,`bounceaccountencryption`,`bounceaccountuser`,`showwelcome`,`showprogress`,`allowjumps`,`navigationdelay`,`nokeyboard`,`alloweditaftercompletion`,`googleanalyticsstyle`,`googleanalyticsapikey`) VALUES
("221727", "1", "", "N", NULL, NULL, "", "N", "", "G", "N", "default", "fr", NULL, "N", "N", "N", "Y", "0", "N", "N", "N", "N", "N", "2012-10-23", "N", "N", "N", "Y", "Y", "N", "N", "D", "N", "contact@sondages.pro", "a:0:{}", "", "", "15", "Y", "B", "Y", "X", NULL, "N", NULL, NULL, NULL, NULL, NULL, "Y", "Y", "N", "0", "N", "N", NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_surveys_languagesettings`
--
DROP TABLE IF EXISTS `lime_surveys_languagesettings`;
CREATE TABLE `lime_surveys_languagesettings` (
`surveyls_survey_id` int(11) NOT NULL,
`surveyls_language` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`surveyls_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`surveyls_description` text COLLATE utf8_unicode_ci,
`surveyls_welcometext` text COLLATE utf8_unicode_ci,
`surveyls_endtext` text COLLATE utf8_unicode_ci,
`surveyls_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`surveyls_urldescription` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`surveyls_email_invite_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`surveyls_email_invite` text COLLATE utf8_unicode_ci,
`surveyls_email_remind_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`surveyls_email_remind` text COLLATE utf8_unicode_ci,
`surveyls_email_register_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`surveyls_email_register` text COLLATE utf8_unicode_ci,
`surveyls_email_confirm_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`surveyls_email_confirm` text COLLATE utf8_unicode_ci,
`surveyls_dateformat` int(11) NOT NULL DEFAULT '1',
`surveyls_attributecaptions` text COLLATE utf8_unicode_ci,
`email_admin_notification_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email_admin_notification` text COLLATE utf8_unicode_ci,
`email_admin_responses_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email_admin_responses` text COLLATE utf8_unicode_ci,
`surveyls_numberformat` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`surveyls_survey_id`,`surveyls_language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_surveys_languagesettings`
--
INSERT INTO `lime_surveys_languagesettings` (`surveyls_survey_id`,`surveyls_language`,`surveyls_title`,`surveyls_description`,`surveyls_welcometext`,`surveyls_endtext`,`surveyls_url`,`surveyls_urldescription`,`surveyls_email_invite_subj`,`surveyls_email_invite`,`surveyls_email_remind_subj`,`surveyls_email_remind`,`surveyls_email_register_subj`,`surveyls_email_register`,`surveyls_email_confirm_subj`,`surveyls_email_confirm`,`surveyls_dateformat`,`surveyls_attributecaptions`,`email_admin_notification_subj`,`email_admin_notification`,`email_admin_responses_subj`,`email_admin_responses`,`surveyls_numberformat`) VALUES
("221727", "fr", "Test timed", "", "", "", "", "", "Invitation à participer à un questionnaire", "Cher(e) {FIRSTNAME},\n\nVous avez été invité à participer à un questionnaire.\n\nCelui-ci est intitulé :\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nPour participer, veuillez cliquer sur le lien ci-dessous.\n\nCordialement,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nCliquez ici pour remplir ce questionnaire :\n{SURVEYURL}\n\nSi vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}", "Rappel pour participer à un questionnaire", "Cher(e) {FIRSTNAME},\n\nVous avez été invité à participer à un questionnaire récemment.\n\nNous avons pris en compte que vous n\'avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.\n\nLe questionnaire est intitulé :\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nPour participer, veuillez cliquer sur le lien ci-dessous.\n\nCordialement,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nCliquez ici pour faire le questionnaire:\n{SURVEYURL}\n\nSi vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :\n{OPTOUTURL}", "Confirmation d\'enregistrement au questionnaire", "Cher(e){FIRSTNAME},\n\nVous (ou quelqu\'un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.\n\nPour compléter ce questionnaire, cliquez sur le lien suivant :\n\n{SURVEYURL}\n\nSi vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce courriel est une erreur, veuillez contacter {ADMINNAME} sur {ADMINEMAIL}", "Confirmation de votre participation à notre questionnaire", "Cher(e) {FIRSTNAME},\n\nCe courriel vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.\n\nSi vous avez des questions à propos de ce courriel, veuillez contacter {ADMINNAME} sur {ADMINEMAIL}.\n\nCordialement,\n\n{ADMINNAME}", "1", "a:0:{}", "Soumission de réponse pour le questionnaire {SURVEYNAME}", "Bonjour,\n\nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.\n\nCliquer sur le lien suivant pour recharger votre questionnaire :\n{RELOADURL}\n\nCliquer sur le lien suivant pour voir la réponse :\n{VIEWRESPONSEURL}\n\nCliquer sur le lien suivant pour éditer la réponse :\n{EDITRESPONSEURL}\n\nVisualiser les statistiques en cliquant ici :\n{STATISTICSURL}\n\nles réponses suivantes ont été données par le participant :\n{ANSWERTABLE}", "Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats", "Bonjour,\n\nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.\n\nCliquer sur le lien suivant pour recharger votre questionnaire :\n{RELOADURL}\n\nCliquer sur le lien suivant pour voir la réponse :\n{VIEWRESPONSEURL}\n\nCliquez sur le lien suivant pour éditer la réponse individuelle :\n{EDITRESPONSEURL}\n\nVisualiser les statistiques en cliquant ici :\n{STATISTICSURL}\n\n\nles réponses suivantes ont été données par le participant :\n{ANSWERTABLE}", "0");
-- --------------------------------------------------------
--
-- Table structure for table `lime_templates`
--
DROP TABLE IF EXISTS `lime_templates`;
CREATE TABLE `lime_templates` (
`folder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`creator` int(11) NOT NULL,
PRIMARY KEY (`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_templates`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_templates_rights`
--
DROP TABLE IF EXISTS `lime_templates_rights`;
CREATE TABLE `lime_templates_rights` (
`uid` int(11) NOT NULL,
`folder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`use` int(11) NOT NULL,
PRIMARY KEY (`uid`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_templates_rights`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_user_groups`
--
DROP TABLE IF EXISTS `lime_user_groups`;
CREATE TABLE `lime_user_groups` (
`ugid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`owner_id` int(11) NOT NULL,
PRIMARY KEY (`ugid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_user_groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_user_in_groups`
--
DROP TABLE IF EXISTS `lime_user_in_groups`;
CREATE TABLE `lime_user_in_groups` (
`ugid` int(11) NOT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`ugid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_user_in_groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_users`
--
DROP TABLE IF EXISTS `lime_users`;
CREATE TABLE `lime_users` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` blob NOT NULL,
`full_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`parent_id` int(11) NOT NULL,
`lang` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(320) COLLATE utf8_unicode_ci DEFAULT NULL,
`create_survey` int(11) NOT NULL DEFAULT '0',
`create_user` int(11) NOT NULL DEFAULT '0',
`participant_panel` int(11) NOT NULL DEFAULT '0',
`delete_user` int(11) NOT NULL DEFAULT '0',
`superadmin` int(11) NOT NULL DEFAULT '0',
`configurator` int(11) NOT NULL DEFAULT '0',
`manage_template` int(11) NOT NULL DEFAULT '0',
`manage_label` int(11) NOT NULL DEFAULT '0',
`htmleditormode` varchar(7) COLLATE utf8_unicode_ci DEFAULT 'default',
`templateeditormode` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
`questionselectormode` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
`one_time_pw` blob,
`dateformat` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`uid`),
UNIQUE KEY `users_name` (`users_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `lime_users`
--
INSERT INTO `lime_users` (`uid`,`users_name`,`password`,`full_name`,`parent_id`,`lang`,`email`,`create_survey`,`create_user`,`participant_panel`,`delete_user`,`superadmin`,`configurator`,`manage_template`,`manage_label`,`htmleditormode`,`templateeditormode`,`questionselectormode`,`one_time_pw`,`dateformat`) VALUES
("1", "shnoulle", "a69688d10e8c9e7ffa561b656958517df54d4b9295254259aec0ae0842e7354a", "Sondages pro", "0", "fr", "contact@sondages.pro", "1", "1", "1", "1", "1", "1", "1", "1", "popup", "none", "none", NULL, "1");
| ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 121023 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | FF14 | ||||
| Database type & version | Mysql 5 | ||||
| Server OS (if known) | debian/linux | ||||
| Webserver software & version (if known) | apache | ||||
| PHP Version | PHP Version 5.3 | ||||
| Git branch / Pull Request URL | |||||
|
I can't seem to reproduce this at the moment.
|
|
|
I look again, maybe a bad time :) |
|
|
I'm sure it's a bug. The problem is, I'm guessing your table got corrupted or something. I'll have to track that down... and a SQL dump would help. |
|
|
It's a yesterday install . |
|
|
Fix me! ;) |
|
|
Today it's OK. No change made by myself in DB |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-10-23 10:10 | DenisChenu | New Issue | |
| 2012-10-23 10:10 | DenisChenu | Status | new => assigned |
| 2012-10-23 10:10 | DenisChenu | Assigned To | => user16774 |
| 2012-10-24 15:16 | c_schmitz | Project | Bug reports => @10@ |
| 2012-10-26 16:22 |
|
Note Added: 21715 | |
| 2012-10-26 16:28 | DenisChenu | Note Added: 21716 | |
| 2012-10-26 16:30 |
|
Note Added: 21717 | |
| 2012-10-26 16:54 | DenisChenu | File Added: LimeSurvey_sondagespro_gitdev_dump_2012-10-26.sql | |
| 2012-10-26 16:54 | DenisChenu | Note Added: 21718 | |
| 2012-11-26 22:25 | c_schmitz | Note Added: 22561 | |
| 2012-12-01 15:41 | DenisChenu | Note Added: 22788 | |
| 2012-12-01 15:41 | DenisChenu | Status | assigned => closed |
| 2012-12-01 15:41 | DenisChenu | Resolution | open => unable to reproduce |
| 2012-12-01 15:41 | DenisChenu | Fixed in Version | => 2.1 |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |