x

Основные главы

  1. LimeSurvey Cloud против LimeSurvey CE
  2. LimeSurvey Cloud — Краткое руководство
  3. LimeSurvey CE - Установка
  4. Как разработать хороший опрос (Руководство)
  5. Начиная
  6. Конфигурация LimeSurvey
  7. Введение - Опросы
  8. Просмотр настроек опроса
  9. Посмотреть меню опроса
  10. Посмотреть структуру опроса
  11. Введение - Вопросы
  12. Введение — группы вопросов
  13. Введение - Опросы - Менеджмент
  14. Параметры панели инструментов опроса
  15. Многоязычный опрос
  16. Краткое руководство — ExpressionScript
  17. Расширенные возможности
  18. Общие вопросы и ответы
  19. Поиск неисправностей
  20. Обходные пути
  21. Лицензия
  22. Журнал изменений версий
  23. Плагины - Расширенный
 Actions

Upgrading from a previous version/ru: Difference between revisions

From LimeSurvey Manual

← Older edit
Created page with "<div style="float:right;"><div class="simplebox">Дополнительные страницы:{toc}</div></div>__ОГЛАВЛЕНИЕ__"
FuzzyBot (talk | contribs)
Bots
33,956 edits
Updating to match new version of source page
 
(38 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<languages /> <div style="float:right;"><div class="simplebox">Дополнительные страницы:{toc}</div></div>__ОГЛАВЛЕНИЕ__
<languages /> <div style="float:right;"><div class="simplebox">Дополнительные страницы:{toc}</div></div>__ОГЛАВЛЕНИЕ__


=Before you start...=
<span id="Before_you_start..."></span>
=Перед началом...=


<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'>... прочтите, потому что это очень важно: '''Всегда делайте резервную копию файлов и базы данных текущей установки!'''</span>


You can do this using a database adminstration tool like [http://www.phpmyadmin.net phpMyAdmin] etc. and a file manager! If you don't know how to do this you should better not proceed but ask someone who knows or use the [[ComfortUpdate]] instead.
<div class="mw-translate-fuzzy">
Вы можете сделать это при помощи инструментов администрирования БД, например, [http://www.phpmyadmin.net phpMyAdmin] и файл-менеджера! Если Вы не знаете как это сделать, то Вам не следует продолжать самостоятельно, а попросить кого либо кто знает или воспользоваться вместо этого  [[ComfortUpdate|комфортным обновлением]].
</div>


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


You can use these instructions if you are doing a minor upgrade  (for example from 2.00 to 2.01)
<span id="Upgrade_instructions_(from_2.x_or_newer_to_any_later_version)"></span>
*Backup your files and database (did we already mention that?)
<div class="mw-translate-fuzzy">
*Delete all the old files/directory except for
=Быстрый способ(для обновления с минорных версий)=
</div>
 
<div class="mw-translate-fuzzy">
Вы можете использовать данные инструкции, если Вы делаете обновление с минорной версии (например, с 2.00 до 2.01)
*сделайте резервную копию файлов и базы данных(мы ведь уже обсуждали это, не так ли?)
*удалите все старые файлы/директории, за исключением
**/application/config/config.php
**/application/config/config.php
**/upload directory
**/upload каталога
*Copy the new files from the new LimeSurvey package to the existing location.
*скопируйте новые файлы из архива с LimeSurvey в существующую директорию
*'''After the upgrade: Clear your browser cache and cookies!'''
*'''После обновления: очистите кэш браузера и куки!'''
</div>
<div lang="en" dir="ltr" class="mw-content-ltr">
#Log out of the administration
#Backup your files and database
#Delete all the old files/folders except for:
##/application/config/security.php - '''Important!! This is the key to all encrypted data in LimeSurvey (version 4 and later)'''
##/application/config/config.php;
##/upload directory
#Copy the new files from the new LimeSurvey package to the existing location.
#Now clear your browser cache and cookies.
#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!
</div>
 
<div lang="en" dir="ltr" class="mw-content-ltr">
<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>
</div>
 
<div lang="en" dir="ltr" class="mw-content-ltr">
= 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.
</div>
 
<div lang="en" dir="ltr" class="mw-content-ltr">
= 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!)
</div>


=The thorough way (for big version jumps)=
<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.
This assumes that you still have the database and file backup, either from your regular backup or the one created by Comfortupdate.
</div>


Unfortunately there are a couple of things to consider, so please scan the following instruction closely.
<div lang="en" dir="ltr" class="mw-content-ltr">
Please execute the following steps:
</div>


==Upgrading from version 1.50 or later to any later 2.xx version==
<div lang="en" dir="ltr" class="mw-content-ltr">
#[http://www.limesurvey.org/download Download] the latest version of LimeSurvey.
*Backup the existing LimeSurvey directory and database (yes, again - we will call this the 2nd backup)
# Prepare and backup the old installation
*Restore files to the existing directory (just overwriting them is fine) from the original (1st) backup.
## Backup your installation directory files and SQL-based database just in case.
*Delete the old database and restore the database from the original (1st) backup.
### At the command-line level, make a '''.zip''' or similar archive of the whole installation directory tree of files. For example in Linux tar cvzf foo.tgz cps100 will tar and zip the whole of the cps100 directory.
</div>
### Using phpMyAdmin or similar to export all tables; or use the according '''LimeSurvey Administration''' button [[File:button-export-sql.png]] to backup the entire database
## Copy your '''config.php''' file, modified '''template''' directories and the /upload directory separately for quick access later.
# 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
## 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 (write access to '''/tmp''', '''/upload''' and and their subdirectories is required) as described in [[Installation#Set_Directory_permissions|Installation]]
## Open http://<yourdomain>/<yourlimesurveydir>/admin in your browser and follow the instructions (you can use the old config.php as reference). 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!'''
# You are done (:biggrin:).


<div class="simplebox">'''Special checks after an upgrade''':
<div lang="en" dir="ltr" class="mw-content-ltr">
*'''from any earlier version to 2.xx''': The '''templates''' have been changed in a lot of places. Please check your customized templates if they are still looking right. If not you will have to edit your templates accordingly (check out the original templates to see what was changed). The upgrade process tries to replace the template.js inclusion by the placeholder {TEMPLATEJS}. If you have javascript issue with your custom template, verify if your template have the placeholder {TEMPLATEJS} in startpage.pstpl.
That's it. Everything should be back to normal.
*'''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 who to give this right to in the older versions.  As this is not perfect, it should be carefully checked.</div>
</div>


==Upgrading from version 1.50 or later to any later 1.xx version==
<div lang="en" dir="ltr" class="mw-content-ltr">
#[http://www.limesurvey.org/download Download] the desired version of LimeSurvey.
'''A note about reporting this issue:'''
# Prepare and backup the old installation
</div>
## Backup your installation directory files and SQL-based database just in case.
### At the command-line level, make a '''.zip''' or similar archive of the whole installation directory tree of files. e.g. tar cvzf foo.tgz cps100 will tar and zip the whole of the cps100 directory
### Using phpMyAdmin or similar to export all tables; or using the '''LimeSurvey Administration''' button [[File:button-export-sql.png]] to backup the entire database
## Copy your '''config.php''' file ,modified '''template''' directories and the /upload directory separately for quick access later.
# 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''' to reflect changed settings in 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''' (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 (write access to '''/tmp''', '''/upload''' and and their subdirectories is required) as described in [[Installation#Set Directory permissions|Installation]]
# Finishing the installation
## 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
# You are done (:biggrin:). If you notice any problems after the upgrade: Clear your browser cache and cookies!


<div class="simplebox">'''Special checks after an upgrade''':
<div lang="en" dir="ltr" class="mw-content-ltr">
*'''from any earlier version to 1.92''': The '''templates''' have been changed in a lot of places. Please check your customized templates if they are still looking right. If not you will have to edit your templates accordingly (check out the original templates to see what was changed)<br />
If you run into a problem like this, please always report this in our bug tracker at https://bugs.limesurvey.org
*'''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 who to give this right to 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">
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>


Since the data structure and a lot of other things were changed, '''upgrading from any version previous to v1.50 is NOT possible'''.  If you have old survey structure files with a *.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. See the also then page [[Transferring an installation]] for more details.
<span id="FAQ"></span>
=Обновление: часто задаваемые вопросы=


=Upgrade FAQ=
<span id="Can_I_upgrade_even_if_I_have_active_surveys?"></span>
==Могу ли я обновиться в то время как у меня есть активные опросы?==


==What is the most actual LimeSurvey version that still supports PHP4?==
Да, Вы можете. Исключения в данном случае указаны в указанной выше инструкции. Мы настоятельно рекомендуем проверить Ваши шаблоны на работоспособность.


The last release offering PHP4 support was version 1.82+.
<span id="How_to_convert_*.sql/*.csv_survey_structure_files_to_the_latest_LimeSurvey_version?"></span>
<div class="mw-translate-fuzzy">
==Какой самый лучший способ портирования структуры *.sql файлов в последнюю версию LimeSurvey?==
</div>


==Can I upgrade even if I have active surveys?==
<div class="mw-translate-fuzzy">
Установить версию 1.50, импортировать файл и экспортировать структуру опросов в новый .csv формат. Последняя версия сможет прочитать структуру опроса в .csv формате.
</div>


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.
==Survey theme incompatibility==
With certain major version updates any custom survey themes will not be compatible, anymore:


==What is best way to port LimeSurvey *.sql survey structure files to the latest version?==
* Update from LimeSurvey 2.6 or lower to LimeSurvey 2.50
* Update from LimeSurvey 5.x or lower to LimeSurvey 6.x


Install version 1.50, import the file and export the survey structure to the newer .csv format. The latest version still can read the .csv survey structure format.
==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.

Latest revision as of 12:07, 25 February 2025

Other languages:
Дополнительные страницы:{toc}

__ОГЛАВЛЕНИЕ__

Перед началом...

... прочтите, потому что это очень важно: Всегда делайте резервную копию файлов и базы данных текущей установки!

Вы можете сделать это при помощи инструментов администрирования БД, например, phpMyAdmin и файл-менеджера! Если Вы не знаете как это сделать, то Вам не следует продолжать самостоятельно, а попросить кого либо кто знает или воспользоваться вместо этого комфортным обновлением.

Recommendation to use ComfortUpdate

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

Быстрый способ(для обновления с минорных версий)

Вы можете использовать данные инструкции, если Вы делаете обновление с минорной версии (например, с 2.00 до 2.01)

  • сделайте резервную копию файлов и базы данных(мы ведь уже обсуждали это, не так ли?)
  • удалите все старые файлы/директории, за исключением
    • /application/config/config.php
    • /upload каталога
  • скопируйте новые файлы из архива с LimeSurvey в существующую директорию
  • После обновления: очистите кэш браузера и куки!
  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.

Обновление: часто задаваемые вопросы

Могу ли я обновиться в то время как у меня есть активные опросы?

Да, Вы можете. Исключения в данном случае указаны в указанной выше инструкции. Мы настоятельно рекомендуем проверить Ваши шаблоны на работоспособность.

Какой самый лучший способ портирования структуры *.sql файлов в последнюю версию LimeSurvey?

Установить версию 1.50, импортировать файл и экспортировать структуру опросов в новый .csv формат. Последняя версия сможет прочитать структуру опроса в .csv формате.

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/ru&oldid=379757"