Welcome, Guest
Username: Password: Remember me

TOPIC: error: The active record cannot be inserted to database because it is not new.

error: The active record cannot be inserted to database because it is not new. 5 months 4 days ago #105541

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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 administrator has disabled public write access.

error: The active record cannot be inserted to database because it is not new. 5 months 4 days ago #105575

  • emimarz
  • emimarz's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 21
  • Thank you received: 5
  • Karma: 1
can you send the file?
The administrator has disabled public write access.

error: The active record cannot be inserted to database because it is not new. 5 months 3 days ago #105631

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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
Attachments:
The administrator has disabled public write access.
The following user(s) said Thank You: DenisChenu

error: The active record cannot be inserted to database because it is not new. 5 months 3 days ago #105677

  • emimarz
  • emimarz's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 21
  • Thank you received: 5
  • Karma: 1
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
The administrator has disabled public write access.
The following user(s) said Thank You: ROSt52

error: The active record cannot be inserted to database because it is not new. 5 months 2 days ago #105703

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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!
Last Edit: 5 months 2 days ago by ROSt52.
The administrator has disabled public write access.

error: The active record cannot be inserted to database because it is not new. 4 months 4 weeks ago #105775

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6222
  • Thank you received: 791
  • Karma: 238
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
?
The administrator has disabled public write access.

error: The active record cannot be inserted to database because it is not new. 4 months 3 weeks ago #105936

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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.)
The administrator has disabled public write access.

error: The active record cannot be inserted to database because it is not new. 4 months 3 weeks ago #105937

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6222
  • Thank you received: 791
  • Karma: 238
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.
The administrator has disabled public write access.

error: The active record cannot be inserted to database because it is not new. 4 months 2 weeks ago #106299

  • ROSt52
  • ROSt52's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 57
  • Thank you received: 1
  • Karma: 0
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.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.119 seconds
Donation Image