- Posts: 37
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
error: The active record cannot be inserted to database because it is not new.
- ROSt52
- Topic Author
- Offline
- Junior Member
Less
More
10 years 1 month ago #105541
by ROSt52
error: The active record cannot be inserted to database because it is not new. was created by ROSt52
I created a survey, base language is English, second language is Japanese.
The survey was created through the import of txt file. ( TAB separated csv file and renamed txt. A method I used frequently for only English surveys successfully.)
Observations:
Question groups
Adding of new, editing of new and old (=imported) questions groups is possible.
Questions
Adding of new and editing of new questions is possible.
Editing of old (=imported) question is not possible. Following error message occurs:
Internal Server Error
The active record cannot be inserted to database because it is not new.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.
2014-02-25 05:39:47
Re-exporting the survey into an txt file and comparing parameter of new and old (=imported) questions did not show any difference.
Your help is highly appreciated.
The survey was created through the import of txt file. ( TAB separated csv file and renamed txt. A method I used frequently for only English surveys successfully.)
Observations:
Question groups
Adding of new, editing of new and old (=imported) questions groups is possible.
Questions
Adding of new and editing of new questions is possible.
Editing of old (=imported) question is not possible. Following error message occurs:
Internal Server Error
The active record cannot be inserted to database because it is not new.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.
2014-02-25 05:39:47
Re-exporting the survey into an txt file and comparing parameter of new and old (=imported) questions did not show any difference.
Your help is highly appreciated.
The topic has been locked.
- emimarz
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 2
10 years 1 month ago #105575
by emimarz
Replied by emimarz on topic error: The active record cannot be inserted to database because it is not new.
can you send the file?
The topic has been locked.
- ROSt52
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 37
- Thank you received: 1
10 years 1 month ago #105631
by ROSt52
Replied by ROSt52 on topic error: The active record cannot be inserted to database because it is not new.
Hi emimarz,
I attached the file. (TAB separared CSV file renamed TXT) If you don't have Japanese fonts in your PC you will most likely see only "wing dings" instead of Japanese characters. For Windows machines there is an Asian language support package available; I assume the same for others OS.
Also there are a few not yet translated English terms in the Japanese part of the survey.
Thanks in advance for looking into this matter especially as I ran into a LimeSurvey bug while trying another approach:
www.limesurvey.org/en/forum/design-issue...-entry-are-not-saved
I am in general willing to contribute to bilingual testing English-Japanese
I attached the file. (TAB separared CSV file renamed TXT) If you don't have Japanese fonts in your PC you will most likely see only "wing dings" instead of Japanese characters. For Windows machines there is an Asian language support package available; I assume the same for others OS.
Also there are a few not yet translated English terms in the Japanese part of the survey.
Thanks in advance for looking into this matter especially as I ran into a LimeSurvey bug while trying another approach:
www.limesurvey.org/en/forum/design-issue...-entry-are-not-saved
I am in general willing to contribute to bilingual testing English-Japanese
Attachments:
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- emimarz
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 2
10 years 1 month ago #105677
by emimarz
Replied by emimarz on topic error: The active record cannot be inserted to database because it is not new.
Hi ROSt52,
I going to tell you, What did I do
I press the button plus to add a new survey and import that file
I imported and create a new question on the first group
I edit a question old and the new one
My tests finish successfully
I could find the error, try do the same on your local host
Regards
Emiliano
I going to tell you, What did I do
I press the button plus to add a new survey and import that file
I imported and create a new question on the first group
I edit a question old and the new one
My tests finish successfully
I could find the error, try do the same on your local host
Regards
Emiliano
The following user(s) said Thank You: ROSt52
The topic has been locked.
- ROSt52
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 37
- Thank you received: 1
10 years 1 month ago - 10 years 1 month ago #105703
by ROSt52
Replied by ROSt52 on topic error: The active record cannot be inserted to database because it is not new.
Hi emimarz,
As I upgrade to version Version 2.00+ Build 131206, I follow your advice and it seems that the survey works now. I interpret the result in the way that the bug is solved in the latest version.
If you are interested, please also have a look at:
www.limesurvey.org/en/forum/design-issue...-entry-are-not-saved .
Thanks for your help!
As I upgrade to version Version 2.00+ Build 131206, I follow your advice and it seems that the survey works now. I interpret the result in the way that the bug is solved in the latest version.
If you are interested, please also have a look at:
www.limesurvey.org/en/forum/design-issue...-entry-are-not-saved .
Thanks for your help!
Last edit: 10 years 1 month ago by ROSt52.
The topic has been locked.
- DenisChenu
- Online
- LimeSurvey Community Team
Less
More
- Posts: 13635
- Thank you received: 2491
10 years 1 month ago #105775
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic error: The active record cannot be inserted to database because it is not new.
Hi,
There are some fix for multilingual TSV export in 2.05. Before 2.05, TSV and multilingual are broken
And strangely : here you have a lot of question before the first group in tour file.
Can you try with;
- export lss in 2.00
- import lss in 2.05
- export tsv from 2.05
?
There are some fix for multilingual TSV export in 2.05. Before 2.05, TSV and multilingual are broken
And strangely : here you have a lot of question before the first group in tour file.
Can you try with;
- export lss in 2.00
- import lss in 2.05
- export tsv from 2.05
?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- ROSt52
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 37
- Thank you received: 1
10 years 1 month ago #105936
by ROSt52
Replied by ROSt52 on topic error: The active record cannot be inserted to database because it is not new.
Hi Denis,
I will make a test tomorrow with 2.05. My brother installed last night all updates.
What is a "tour file" and what means "here you have a lot of question before the first group in tour file"?
For me the most important export/import format is TSV because this is the only format I can open, edit the content, and import. (I use LibreOffice for that.)
I will make a test tomorrow with 2.05. My brother installed last night all updates.
What is a "tour file" and what means "here you have a lot of question before the first group in tour file"?
For me the most important export/import format is TSV because this is the only format I can open, edit the content, and import. (I use LibreOffice for that.)
The topic has been locked.
- DenisChenu
- Online
- LimeSurvey Community Team
Less
More
- Posts: 13635
- Thank you received: 2491
10 years 1 month ago #105937
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic error: The active record cannot be inserted to database because it is not new.
Sorry : in Your file .... (the t is just next the y in azerty)
When you look the TSV file : you have some question BEFORE the first group. It can broke survey.
When you look the TSV file : you have some question BEFORE the first group. It can broke survey.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- ROSt52
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 37
- Thank you received: 1
10 years 1 month ago #106299
by ROSt52
Replied by ROSt52 on topic error: The active record cannot be inserted to database because it is not new.
Hi Denis,
Using the version Version 2.05+ Build 140302 I could export an English (single language) survey into a TSV file. I could change the language (en to ja) information, file name and import it into a new survey.
The new survey works fine.
Some problems I experienced last year while importing TSV files where gone; fortunately. Thanks for your help and discussion
ROSt.
Using the version Version 2.05+ Build 140302 I could export an English (single language) survey into a TSV file. I could change the language (en to ja) information, file name and import it into a new survey.
The new survey works fine.
Some problems I experienced last year while importing TSV files where gone; fortunately. Thanks for your help and discussion
ROSt.
The topic has been locked.