Challenges while Upgrading to LimeSurvye 3.1

More
7 months 3 weeks ago - 7 months 3 weeks ago #163027 by Kevin
Kevin created the topic: Challenges while Upgrading to LimeSurvye 3.1
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.
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
update labels set lid = id
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
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.
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.
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'.
Last Edit: 7 months 3 weeks ago by Kevin.

Please Log in or Create an account to join the conversation.

More
7 months 3 weeks ago #163028 by LouisGac
LouisGac replied the topic: Challenges while Upgrading to LimeSurvye 3.1
For now, LS3 is not offered in the comfortUpdate as an upgrade for 2.x
It will be the case pretty soon, so hold on.

It's a great thing that you're trying to create a custom survey theme. I'd rather suggest you to do it on the base of a clean LS 3.x installation. If the person you hired experienced difficulties to do it, tell him that he can come to the forum to ask for help, or even open some bug reports. I will personally help him (I wrote the new theme engine) . This will help us to prepare the documentation.

For now, you can also read this article:
manual.limesurvey.org/New_Template_System_in_LS3.x
The following user(s) said Thank You: Kevin

Please Log in or Create an account to join the conversation.

More
7 months 3 weeks ago - 7 months 3 weeks ago #163058 by Kevin
Kevin replied the topic: Challenges while Upgrading to LimeSurvey 3.1
Thanks very much for your reply and for all of the hard work that you and others have done on the software. I created a script to update the files instead of using comfort update. I can't find my previous postings where someone helped (maybe it was you) but I changed a line in the config file and placed custom files in the upload directory. I was attempting to use buttons for a mobile device like others have used. I can do some coding but I dont know enough about how to make things look good with css, bootstrap, etc.. Thanks.
Last Edit: 7 months 3 weeks ago by Kevin.

Please Log in or Create an account to join the conversation.

More
7 months 3 weeks ago #163064 by Kevin
Kevin replied the topic: Challenges while Upgrading to LimeSurvey 3.1
I am unable to select a question type (yes/no, text box, etc.) while attempting to add a question to a copied survey.

Please Log in or Create an account to join the conversation.

More
7 months 3 weeks ago #163076 by jelo
jelo replied the topic: Challenges while Upgrading to LimeSurvey 3.1
You might report this via the Bugtracker.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
7 months 3 weeks ago #163099 by Kevin
Kevin replied the topic: Challenges while Upgrading to LimeSurvey 3.1
Thanks. I attempted to submit it in bug tracker but I can't determine how to submit a bug. I don't see add new or anything relevant.

For anyone seeing this:
limesurvey3.1.0+180124
Using a survey from version 2.67.3+170728
Firefox and Chrome were both used
Edit question and create new question.
Question Type: Highlight Yes / No or any value.
The button to select is not highlighted so it cannot be selected.

Please Log in or Create an account to join the conversation.

More
7 months 3 weeks ago #163126 by holch
holch replied the topic: Challenges while Upgrading to LimeSurvey 3.1
When you log in (same credentials as in the forum) you see a "report issue" in the top right corner just next to your username.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #163179 by jelo
jelo replied the topic: Challenges while Upgrading to LimeSurvey 3.1
Sometimes the tracker seems to be in guestmode. So people are having no submitrights.

You might need to logout as guest and login with your user-credentials via bugs.limesurvey.org/login_page.php

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #163240 by Gequinn
Gequinn replied the topic: Challenges while Upgrading to LimeSurvye 3.1

Kevin wrote: 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).


I'm also having this exact issue and I've been unable to find out why and searching the forums has not yielded me any results. It seems to be looking for a nonexistent file.

Attachments:

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #163242 by LouisGac
LouisGac replied the topic: Challenges while Upgrading to LimeSurvye 3.1
this bug has been fixed in latest version.

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #163245 by Gequinn
Gequinn replied the topic: Challenges while Upgrading to LimeSurvye 3.1
I'm using Version 3.1.1+180130 - it was released today. Is there another version that's come out since the time I've upgraded?

I upgraded from 3.1.0+180124 to 3.1.1+180130 this morning. I was having the same issue in 3.1.0+180124 as well.

Before that I was using 2.67.3+170728 without any issues.

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago - 7 months 2 weeks ago #163449 by Big_Lemon
Big_Lemon replied the topic: Challenges while Upgrading to LimeSurvye 3.1
Same Issue for me with Ubuntu 16.04:

"Unable to find template "./subviews/content/.twig" (looked into: /var/www/html/limesurvey/themes/survey/fruity/views, /var/www/html/limesurvey/themes/survey/vanilla/views)."

with: Limesurvey Version 3.1.1+180130

Any Solutions so far? :/
Last Edit: 7 months 2 weeks ago by Big_Lemon.

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #163501 by mzzvtr
mzzvtr replied the topic: Challenges while Upgrading to LimeSurvye 3.1
Version 3.1.1+180130

Hello to all members.

I had the above version installed on our Uni server this morning as an upgrade from the 3.1.0 version that presented some inconveniences, unfortunately without any successful improvements.

Problem: when clicking on the "Preview question" or "Preview question groups" buttons I get the same screen as "Execute survey" button (just the screenshot), which wasn't the case in previous versions of the 2.x.x release.

I just installed the same (xampp based) version on my notebook so as to make sure the mishap wasn't due to the Uni environment, but I experienced precisely the same results.

Unfortunately I can't bring code evidence for the above mentioned due to my poor confidence with codes. I apologize for that.

Thanks for reading.

Valter

Thanks for reading.

Please Log in or Create an account to join the conversation.

More
7 months 4 days ago #164141 by benchzh
benchzh replied the topic: Challenges while Upgrading to LimeSurvye 3.1
Hi
We updated from version 2.7 to version 3.3 and had the same error while trying to import our custom templates.
Error: Can't find a template for 'custom' in xpath '//viewdirectory'.
So, what would be the solution to this problem?
Silvia

Please Log in or Create an account to join the conversation.

More
7 months 4 days ago #164162 by jelo
jelo replied the topic: Challenges while Upgrading to LimeSurvye 3.1

benchzh wrote: had the same error while trying to import our custom templates.

LS 3.X has a new template-system. Templates created in earlier versions than LS 3 won't work when importing them. manual.limesurvey.org/New_Template_Syste...gs_on_our_TO-DO_list

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!