Welcome, Guest
Username: Password: Remember me

TOPIC: I can't create a chinese survey

I can't create a chinese survey 3 years 8 months ago #58484

  • wangdotnet
  • wangdotnet's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
I want to create a Chinese survey(Base Language is simpled Chinese ) ,but the survey can't be saved. How to create a Chinese survey?
I try to execute the error sql ,but the data was successfully inserted into the datatable.
version:1.90+ Build 9642 ,SQL Server2000
error message :

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 ) VALUES ( 13448, 'zh-Hans', 'test', '', '', ' ', '', '', 'Invitation to participate in survey', '鎮ㄥソ锛� {FIRSTNAME},

鐜伴個璇锋偍鍙傚姞涓€涓皟鏌ャ€�

璇ヨ皟鏌ョ殑鍚嶅瓧涓猴細
"{SURVEYNAME}"

"{SURVEYDESCRIPTION}"

纭鍙傚姞锛岃鐐瑰嚮涓嬮潰鐨勮繛鎺ャ€�

{ADMINNAME} ({ADMINEMAIL})

鐐瑰嚮杩欓噷鍋氳皟鏌ワ細
{SURVEYURL}

濡傛灉鎮ㄤ笉鎯冲弬涓庢湰璋冩煡锛屽苟涓斾笉鍐嶅笇鏈涙帴鏀堕個璇凤紝璇风偣鍑讳笅闈㈤摼鎺ワ細
{OPTOUTURL}', 'Reminder to participate in survey', '鎮ㄥソ锛� {FIRSTNAME},

鏈€杩戞垜浠個璇锋偍鍙傚姞涓€椤硅皟鏌ャ€�

鎴戜滑娉ㄦ剰鍒版偍灏氭湭瀹屾垚杩欓」璋冩煡锛屽鏋滄偍鎯冲弬涓庣殑璇濓紝璇ラ」璋冩煡杩樺湪杩涜涓€�

璋冩煡鏍囬锛�
"{SURVEYNAME}"

"{SURVEYDESCRIPTION}"

纭鍙傚姞锛岃鐐瑰嚮涓嬮潰鐨勯摼鎺ャ€�


{ADMINNAME} ({ADMINEMAIL})

鐐瑰嚮杩欓噷鍋氳皟鏌ワ細
{SURVEYURL}

濡傛灉鎮ㄤ笉鎯冲弬涓庢湰璋冩煡锛屽苟涓斾笉鍐嶅笇鏈涙帴鏀堕個璇凤紝璇风偣鍑讳笅闈㈤摼鎺ワ細
{OPTOUTURL}', 'Survey Registration Confirmation', '鎮ㄥソ {FIRSTNAME},

鎮ㄦ垨鑰呭叾浠栦汉鐢ㄦ偍鐨勯偖浠跺湴鍧€娉ㄥ唽鍙備笌浜嗗悕涓簕SURVEYNAME}鐨勫湪绾胯皟鏌ャ€�

瑕佸畬鎴愯繖涓皟鏌ワ紝璇风偣鍑讳笅闈㈢殑URL:

{SURVEYURL}

濡傛灉鎮ㄦ湁鍏朵粬闂锛屾垨鑰呮偍娌℃湁娉ㄥ唽鍙備笌骞惰涓鸿繖灏侀偖浠舵湁璇紝璇烽€氳繃{ADMINEMAIL}鑱旂郴{ADMINNAME}銆�', 'Confirmation of completed survey', 'Dear {FIRSTNAME},

This email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.

If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.

Sincerely,

{ADMINNAME}', 1 )
[Microsoft][ODBC SQL Server Driver]语法错误或违反访问规则
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 8 months ago #58507

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5425
  • Thank you received: 307
  • Karma: 252
It seems that the MS SQL driver has a problem with the current charset.

Maybe you can use a different MS SQL driver or a different database?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 3 weeks ago #68355

  • credochen
  • credochen's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
i have the same problem with you?Have you solved?
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 3 weeks ago #68366

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5425
  • Thank you received: 307
  • Karma: 252
Which Limesurvey version did you test?

Which database do you use?

Can you explain the problem in more detail?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 3 weeks ago #68369

  • credochen
  • credochen's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
my version is 1.91+Build 11232
my database is 'sql server2005'
when i try to create a new Chinese survey,i have the same problem with "wangdotnet"

I am Chinese,and poor in English,So i can not have a detail description,sorry.
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 3 weeks ago #68411

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 824
  • Thank you received: 116
  • Karma: 93
Which db driver do you use in config.php?
If your webserver is running on Windows I strongly recommend to use 'mssqlnative' together with the official PHP MSSQL driver from Microsoft.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 3 weeks ago #68418

  • credochen
  • credochen's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
when i use mssqlnative and run limesurvey,it show errors.
my database is sqlserver2005.

Code display:
Can't connect to LimeSurvey database. Reason: SQLState: IMSSP Error Code: -49 Message: This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server. Neither of those ODBC Drivers are currently installed. Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver for x86: go.microsoft.com/fwlink/?LinkId=163712 SQLState: IM002 Error Code: 0 Message: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 SQLState: IMSSP Error Code: -49 Message: This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server. Neither of those ODBC Drivers are currently installed. Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver for x86: go.microsoft.com/fwlink/?LinkId=163712 SQLState: IM002 Error Code: 0 Message: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 SQLState: IMSSP Error Code: -49 Message: This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server. Neither of those ODBC Drivers are currently installed. Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver for x86: go.microsoft.com/fwlink/?LinkId=163712 SQLState: IM002 Error Code: 0 Message: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
Last Edit: 3 years 3 weeks ago by Mazi.
The administrator has disabled public write access.

Re: I can't create a chinese survey 3 years 3 weeks ago #68419

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5425
  • Thank you received: 307
  • Karma: 252
Well, "Neither of those ODBC Drivers are currently installed." should be a good hint.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.131 seconds
Donation Image