I am not sure which directories to place the custom templates from the upload directory of version 2.**. I added more details in # 12 below.
Challenges during setup.
1. I got an index error so I gave the user index permission.
2. I got errors about tables. So, I removed the tables that I created.
Code:
DROP TABLE survey_report_2, tmp2
3. I Can't update the datbase because tutorials and tutorials_entry_relation exists.
So, I removed the 2 tutorial tables
4. An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition;
there can be only one auto column and it must be defined as a key. The SQL statement executed was: ALTER TABLE survey_labels DROP PRIMARY KEY
File updatedb_helper.php, line 538.
I copied the values from id to lid. Made lid auto increment and the primary key
Code:
update labels set lid = id
Code:
SELECT * FROM labels
# lid, code, title, sortorder, language, assessment_value, id
1 1 Never 0 en 0 1
5. It's complaining about the tutorial tables I removed.
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'starrevi_survey.survey_tutorials' doesn't exist. The SQL statement executed was: CREATE UNIQUE INDEX `idx1_tutorials` ON `survey_tutorials` (`name`)
File updatedb_helper.php, line 1054.
6. The id column was automatically added to the labels table.
7. An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'map_tutorial_users' already exists. The SQL statement executed was: CREATE TABLE `map_tutorial_users` ( `tid` int NOT NULL, `uid` int DEFAULT NULL, `taken` int DEFAULT 1 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
File updatedb_helper.php, line 1040.
Remove survey_map_tutorial_users
Code:
DROP TABLE map_tutorial_users
8. An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'tutorial_entry_relation' already exists. The SQL statement executed was: CREATE TABLE `tutorial_entry_relation` ( `teid` int NOT NULL, `tid` int NOT NULL, `uid` int DEFAULT NULL, `sid` int DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
File updatedb_helper.php, line 1049.
Code:
Drop table tutorial_entry_relation
9. An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'map_tutorial_users' already exists. The SQL statement executed was: CREATE TABLE `map_tutorial_users` ( `tid` int NOT NULL, `uid` int DEFAULT NULL, `taken` int DEFAULT 1 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
File updatedb_helper.php, line 1040.
Code:
Drop table map_tutorial_users
10. Trying to look at the stats from a survey
Error: Malformed JSON: Field files_js must be either a JSON array or the string "inherit". Found "inherit".
11. From the config page. I chose Template: bootstrap and Screen: Question
Unable to find template "./subviews/content/.twig" (looked into: /srv/www/survey/public_html/themes/survey/bootswatch/views, /srv/www/survey/public_html/themes/survey/vanilla/views).
12. I am not sure where to place the custom template files from the upload directory in version 2.**
Copying the files from upload/themes/survey/ to upload/themes/survey/ did not work.
I am not sure if frontend_helper.php is needed in the upload dir.
Updated:
I noticed an insatll button on the template config page. So, I clicked on it but I got a message, "Theme 'Cross_Compatible' has been uninstalled because it's not compatible with this LimeSurvey version". I hope I can get them to work because I hired someone to create the templates.
Error: Can't find a template for 'custom' in xpath '//viewdirectory'.