x

Main chapters

  1. LimeSurvey Cloud vs LimeSurvey CE
  2. LimeSurvey Cloud - Quick start guide
  3. LimeSurvey CE - Installation
  4. How to design a good survey (Guide)
  5. Getting started
  6. LimeSurvey configuration
  7. Introduction - Surveys
  8. View survey settings
  9. View survey menu
  10. View survey structure
  11. Introduction - Questions
  12. Introduction - Question Groups
  13. Introduction - Surveys - Management
  14. Survey toolbar options
  15. Multilingual survey
  16. Quick start guide - ExpressionScript
  17. Advanced features
  18. General FAQ
  19. Troubleshooting
  20. Workarounds
  21. License
  22. Version change log
  23. Plugins - Advanced
 Actions

Upgrading from a previous version/zh-hans: Difference between revisions

From LimeSurvey Manual

← Older edit
FuzzyBot (talk | contribs)
Bots
33,956 edits
Updating to match new version of source page
FuzzyBot (talk | contribs)
Bots
33,956 edits
Updating to match new version of source page
 
Line 1: Line 1:
<languages /> <div style="float:right;"><div class="simplebox">Additional pages:{toc}</div></div>__TOC__
<languages /> <div lang="en" dir="ltr" class="mw-content-ltr">
<div style="float:right;"><div class="simplebox">Additional pages:{toc}</div></div>__TOC__
</div>


<span id="Before_you_start..."></span>
=开始之前...=
=开始之前...=


Line 18: Line 21:
*'''升级之后请清空浏览器缓存与cookies！'''
*'''升级之后请清空浏览器缓存与cookies！'''


<div lang="en" dir="ltr" class="mw-content-ltr">
<span style='color:#FF0000'>... read this because it is very important: '''Always backup the files and the database of your current installation!'''</span>
<span style='color:#FF0000'>... read this because it is very important: '''Always backup the files and the database of your current installation!'''</span>
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
You can do this using a database administration tool like [https://www.phpmyadmin.net phpMyAdmin] and a file manager!  
You can do this using a database administration tool like [https://www.phpmyadmin.net phpMyAdmin] and a file manager!  
If you don't know how to do this, you should not proceed further and ask someone who knows.
If you don't know how to do this, you should not proceed further and ask someone who knows.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
==Recommendation to use ComfortUpdate==
==Recommendation to use ComfortUpdate==
'''The easiest/safest way to upgrade is to use our [[ComfortUpdate]] service.'''
'''The easiest/safest way to upgrade is to use our [[ComfortUpdate]] service.'''
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
=Upgrade instructions (from 2.x or newer to any later version)=
=Upgrade instructions (from 2.x or newer to any later version)=
</div>


Please follow these instructions:
<div lang="en" dir="ltr" class="mw-content-ltr">
*Backup your files and database ([[Upgrading from a previous version#Before you start...|did we already mention that?]]).
Please follow these steps:
*Delete all the old files/folders except for:
</div>
**/application/config/security.php -'''Important!! This is the key to all encrypted data in LimeSurvey (version 4 and later)'''
<div lang="en" dir="ltr" class="mw-content-ltr">
**/application/config/config.php;
#Log out of the administration
**/upload directory
#Backup your files and database
 
#Delete all the old files/folders except for:
<div class="simplebox">[[File:help.png]]'''Note:''' If you have any customized templates in /upload/templates, make sure you 'refresh' those with any changes that come with the new LimeSurvey version. The easiest way to check for such changes is to file-compare your old template with the new version of the default template. If you see any differences other than your customizations, a refresh is needed.</div>
##/application/config/security.php - '''Important!! This is the key to all encrypted data in LimeSurvey (version 4 and later)'''
*Copy the new files from the new LimeSurvey package to the existing location.
##/application/config/config.php;
*Open the admin page in your browser (e.g. https://www.example.com/limesurvey/admin) and check if a database scheme upgrade is necessary.
##/upload directory
*After the upgrade: '''Clear your browser cache and cookies!'''
#Copy the new files from the new LimeSurvey package to the existing location.
 
#Now clear your browser cache and cookies.
=Instructions for older versions=
#Open the admin page in your browser (e.g. https://www.example.com/limesurvey/admin). If a database scheme upgrade is necessary you will be prompted to confirm it.
 
#Done!
Unfortunately, there are a couple of things to consider, so please read the following instructions carefully.
 
==Upgrading from version 1.50 or later to any later 2.xx version==
*[https://www.limesurvey.org/about-limesurvey/download Download] the latest version of LimeSurvey
*Backup your files and database ([[Upgrading from a previous version#Before you start...|did we already mention that?]]).
* Replace all the installation directory files
** Delete all old files in the existing installation directory
** Upload and unpack the new files of the new version into the same installation directory
** If your previous version is older than 1.90, copy any customized templates to /upload/templates - you will also need to rename each template directory whose name matches an existing template in /templates
** Copy your /upload directory back to the old location
** Double-check the '''permissions''' set on the directories (write access to '''/tmp''', '''/upload''', and their subdirectories is required) as described in the [[Installation#Set directory permissions|installation wiki]]
** Open http://<yourdomain>/<yourlimesurveydir>/admin in your browser and follow the instructions (You will find the database data in the old config.php). The existing database will be automatically detected and if necessary, upgraded after confirmation.
* Check if any special manual checks apply as listed below
* '''Now, clear your browser cache and cookies''' and you are good to go
 
{{Alert|title=Attention|text=Please note that the template structure has changed with the update from 2.0x to 2.50 or later. Your old templates will not be working anymore as the template system is now using responsive templates.}}
 
<div class="simplebox">'''Special checks after an upgrade''':
*'''from any earlier version to 2.xx''': Proper question codes are mandatory now. After upgrading the installation, check the survey logic of all surveys and correct the codes where necessary
*'''from a version earlier than v1.53''': When upgrading from a version before v1.53 to the latest version, please check the '''global user rights''' of each user. There was a new '''superadmin''' right introduced in v1.53 that can give a user the same privilege as the master administration account created during the installation. The upgrade script is guessing to whom this permission should be given in the older versions.  As this is not perfect, it should be carefully checked.
*'''from any earlier version to v2.06''': From 2.05 to 2.06, some unused permissions when editing global permissions for 'surveys' were activated. For example, if a user had only the 'create' permission in 2.05, the other permissions located to the right of 'create' would also get activated with the update to 2.06 (View/read, Update, Delete, Import, Export). Please check whether the admin users got any other global permissions besides the 'original' ones after the update. If yes, please edit them accordingly.
</div>
</div>


==Upgrading from version 1.50 or later to any later 1.xx version==
<div lang="en" dir="ltr" class="mw-content-ltr">
*[https://www.limesurvey.org/about-limesurvey/download Download] the desired version of LimeSurvey
<div class="simplebox">[[File:help.png]]'''Note:''' Between major versions (for example from version 3 to 4) the template/design themes change usually completely. Old survey design templates/themes will usually not work anymore.</div>
* Backup your files and database ([[Upgrading from a previous version#Before you start...|did we already mention that?]]).
* Replace all the installation directory files
** Delete all old files in the existing installation directory
** Upload and unpack the new code version into the same installation directory
** Edit or replace the '''config.php''' file:
*** If your previous version was < 1.70: Edit the new '''config.php''' in order to reflect the changes from the backup '''config.php''' file. '''Do not just overwrite the new '''config.php''' with your old one!'''
*** If your previous version was >= 1.70: Simply replace the new '''config.php''' with your backup '''config.php''' file (as the file format has not changed)
** If your previous version was older than 1.90: Copy any customized templates to /upload/templates - you will also need to rename each template directory whose name matches an existing template in /templates
** Copy your /upload directory back to the old location
** Double-check the '''permissions''' set on the directories of LimeSurvey (write access to '''/tmp''', '''/upload''', and to their subdirectories is required) as described in the [[Installation#Set Directory permissions|installation wiki]]
* Finish the installation/upgrade process
** Once you open the URL to your LimeSurvey administration, the database tables will be updated after confirmation
** Remove or rename the /admin/install directory as/if instructed by the installation script
** Check if any special manual checks apply (as listed below)
 
<div class="simplebox">'''Special checks after an upgrade''':
*'''From a version earlier than v1.53''': When upgrading from a version before v1.53 to the latest version, please check the '''global user rights''' of each user. There was a new '''superadmin''' right introduced in v1.53 that can give a user the same privilege as the master administration account created during the install. The upgrade script is guessing to whom this permission should be given in the older versions.  As this is not perfect, it should be carefully checked.
</div>
</div>


==Upgrading from a version earlier than v1.50 (v1.0 through v1.44)==
<div lang="en" dir="ltr" class="mw-content-ltr">
 
Since the data structure and a lot of other things were changed, '''upgrading from any version previous to v1.50 is <u>NOT</u> possible'''. If you have old survey structure files with an *.sql extension, the only way to get these into a newer version is to install [http://www.limesurvey.org/en/archived-releases/289-limesurvey150zip version 1.50], import the .sql file(s) there, then upgrade that version to the most recent LimeSurvey version. Check the page related to [[Transferring an installation|how an installation can be transferred]] for more details.
 
= Upgrading using CLI =
= Upgrading using CLI =
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
You can upgrade the database via the PHP CLI: <code>php application/commands/console.php updatedb</code>. This allows you to set up an auto-upgrade system via command line (for example, in a crontab), although it is not recommended.
You can upgrade the database via the PHP CLI: <code>php application/commands/console.php updatedb</code>. This allows you to set up an auto-upgrade system via command line (for example, in a crontab), although it is not recommended.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
= Failed database upgrade after manual update/ComfortUpdate=
= Failed database upgrade after manual update/ComfortUpdate=
Sometimes, even though you did everything correct, things don't work out they are supposed to during database upgrade.
Sometimes, even though you did everything correct, things don't work out they are supposed to during database upgrade.
That may happen because of various reasons: Different database versions, unexpected data formats or contents, unusual configurations or anything else that did not show up in our tests (yes, we test a lot!)
That may happen because of various reasons: Different database versions, unexpected data formats or contents, unusual configurations or anything else that did not show up in our tests (yes, we test a lot!)
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
If you have an error during database update and your LimeSurvey instance ends up in an unusable state, you want to go back to the previous version.
If you have an error during database update and your LimeSurvey instance ends up in an unusable state, you want to go back to the previous version.
This assumes that you still have the database and file backup, either from your regular backup or the one created by Comfortupdate.
This assumes that you still have the database and file backup, either from your regular backup or the one created by Comfortupdate.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
Please execute the following steps:
Please execute the following steps:
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
*Backup the existing LimeSurvey directory and database (yes, again - we will call this the 2nd backup)
*Backup the existing LimeSurvey directory and database (yes, again - we will call this the 2nd backup)
*Restore files to the existing directory (just overwriting them is fine) from the original (1st) backup.
*Restore files to the existing directory (just overwriting them is fine) from the original (1st) backup.
*Delete the old database and restore the database from the original (1st) backup.
*Delete the old database and restore the database from the original (1st) backup.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
That's it. Everything should be back to normal.
That's it. Everything should be back to normal.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
'''A note about reporting this issue:'''
'''A note about reporting this issue:'''
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
If you run into a problem like this, please always report this in our bug tracker at https://bugs.limesurvey.org
If you run into a problem like this, please always report this in our bug tracker at https://bugs.limesurvey.org
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
A bug not reported is a bug not fixed. Please don't just rely on other people reporting it. If you see that the bug is already reported, you can also help to raise the bug priority by marking it as 'Yes, this bug affects me' in the bug tracker.
A bug not reported is a bug not fixed. Please don't just rely on other people reporting it. If you see that the bug is already reported, you can also help to raise the bug priority by marking it as 'Yes, this bug affects me' in the bug tracker.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
=FAQ=
=FAQ=
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
==Can I upgrade even if I have active surveys?==
==Can I upgrade even if I have active surveys?==
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
Yes, you can. Exceptions may be mentioned in the thorough instructions above. We strongly advise to test your surveys after upgrade to check if your design templates still work alright.
Yes, you can. Exceptions may be mentioned in the thorough instructions above. We strongly advise to test your surveys after upgrade to check if your design templates still work alright.
</div>


<div lang="en" dir="ltr" class="mw-content-ltr">
==How to convert *.sql/*.csv survey structure files to the latest LimeSurvey version?==
==How to convert *.sql/*.csv survey structure files to the latest LimeSurvey version?==
</div>


<div class="mw-translate-fuzzy">
<div class="mw-translate-fuzzy">

Latest revision as of 12:07, 25 February 2025

Other languages:
Additional pages:{toc}

开始之前...

... 请仔细阅读本信息，这非常重要： 记得在升级之前将当前的文件与数据库做好备份！！

你可以用 phpMyAdmin 和文件管理器等工具进行备份工作。如果不确定如何进行备份，最好找个懂备份的人，或者使用 ComfortUpdate 进行舒适更新。

快速升级（适用于小版本更新）

以下步骤适用于小版本更新（如1.86到1.87）

  • 备份文件与数据库（上面说过一次了）
  • 删除旧文件和目录，但以下三个别删：
    • /config.php
    • /templates 目录
    • /upload 目录
  • 将新版LimeSurvey软件包中的内容复制到当前目录下。注意别把 config.php 覆盖了（就算不小心误操作，你也应该有这个文件的备份吧）。其他的都可以覆盖。
  • 升级之后请清空浏览器缓存与cookies！

... read this because it is very important: Always backup the files and the database of your current installation!

You can do this using a database administration tool like phpMyAdmin and a file manager! If you don't know how to do this, you should not proceed further and ask someone who knows.

Recommendation to use ComfortUpdate

The easiest/safest way to upgrade is to use our ComfortUpdate service.

Upgrade instructions (from 2.x or newer to any later version)

Please follow these steps:

  1. Log out of the administration
  2. Backup your files and database
  3. Delete all the old files/folders except for:
    1. /application/config/security.php - Important!! This is the key to all encrypted data in LimeSurvey (version 4 and later)
    2. /application/config/config.php;
    3. /upload directory
  4. Copy the new files from the new LimeSurvey package to the existing location.
  5. Now clear your browser cache and cookies.
  6. Open the admin page in your browser (e.g. https://www.example.com/limesurvey/admin). If a database scheme upgrade is necessary you will be prompted to confirm it.
  7. Done!
Note: Between major versions (for example from version 3 to 4) the template/design themes change usually completely. Old survey design templates/themes will usually not work anymore.

Upgrading using CLI

You can upgrade the database via the PHP CLI: php application/commands/console.php updatedb. This allows you to set up an auto-upgrade system via command line (for example, in a crontab), although it is not recommended.

Failed database upgrade after manual update/ComfortUpdate

Sometimes, even though you did everything correct, things don't work out they are supposed to during database upgrade. That may happen because of various reasons: Different database versions, unexpected data formats or contents, unusual configurations or anything else that did not show up in our tests (yes, we test a lot!)

If you have an error during database update and your LimeSurvey instance ends up in an unusable state, you want to go back to the previous version. This assumes that you still have the database and file backup, either from your regular backup or the one created by Comfortupdate.

Please execute the following steps:

  • Backup the existing LimeSurvey directory and database (yes, again - we will call this the 2nd backup)
  • Restore files to the existing directory (just overwriting them is fine) from the original (1st) backup.
  • Delete the old database and restore the database from the original (1st) backup.

That's it. Everything should be back to normal.

A note about reporting this issue:

If you run into a problem like this, please always report this in our bug tracker at https://bugs.limesurvey.org

A bug not reported is a bug not fixed. Please don't just rely on other people reporting it. If you see that the bug is already reported, you can also help to raise the bug priority by marking it as 'Yes, this bug affects me' in the bug tracker.

FAQ

Can I upgrade even if I have active surveys?

Yes, you can. Exceptions may be mentioned in the thorough instructions above. We strongly advise to test your surveys after upgrade to check if your design templates still work alright.

How to convert *.sql/*.csv survey structure files to the latest LimeSurvey version?

升级常见问题

支持PHP4的LimeSurvey最高版本是哪个？

最后一个支持PHP4的版本是1.82+。

我有活动的问卷，是否可以执行升级？

可以。上面已经对一些特殊情况进行了说明。我们强烈建议在升级后测试一下问卷，以确认你的模板能够正常显示与使用。

Survey theme incompatibility

With certain major version updates any custom survey themes will not be compatible, anymore:

  • Update from LimeSurvey 2.6 or lower to LimeSurvey 2.50
  • Update from LimeSurvey 5.x or lower to LimeSurvey 6.x

Error "Multiple primary key defined" when updating MySQL database

If you encounter this error, please check the setting sql_generate_invisible_primary_key in your MySQL server variables. This is most likely set to ON, but should be set to OFF. Then restore your database from the backup (as explained above) and try again.

Retrieved from "http://www.limesurvey.org/manual/index.php?title=Upgrading_from_a_previous_version/zh-hans&oldid=379759"