Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
en:2.0:probleme_beim_update [2015/10/07 22:53] – created thomas-rcven:2.0:probleme_beim_update [2023/07/15 18:36] (current) fasse
Line 1: Line 1:
 ====== Problems during Updating ====== ====== Problems during Updating ======
-==== Indication ==== +===== Indication ===== 
-If the update of your database running on an error or do you have to experience problems with Admidio so describing your problem to check out our [[http: //forum.admidio.org | Forum]]. The procedure described here will help further only with serious problems that can on the one hand be due to a change / update your database by your hoster (eg change of [[http://de.wikipedia.org/wiki/MyISAM|MyISAM]] on [[http://de.wikipedia.org/wiki/InnoDB|InnoDB]] was) or triggered by a faulty update of earlier Admidio versions. Before you apply this procedure must first be clarified whether this possibly is not an error in our update script, otherwise the error will occur again, even with the described procedure.+If the update of your database running on an error or do you have to experience problems with Admidio so describing your problem to check out our [[https://www.admidio.org/forum | Forum]]. If you have created a backup of your database before the update, [[en:2.0:datenbankbackup_erstellen_und_wiederherstellen#how_do_i_set_a_database_backup_restore|try to restore the backup]] in the first step. The procedure described here will help further only with serious problems that can on the one hand be due to a change / update your database by your hoster (eg change of [[http://de.wikipedia.org/wiki/MyISAM|MyISAM]] on [[http://de.wikipedia.org/wiki/InnoDB|InnoDB]] was) or triggered by a faulty update of earlier Admidio versions. Before you apply this procedure must first be clarified whether this possibly is not an error in our update script, otherwise the error will occur again, even with the described procedure. 
  
-==== Preparations ====+===== Preparations =====
 With the procedure described here, we build the database structure of your current version before upgrading to completely new, then play your data again and thereafter again the update to try again to the new version. With the procedure described here, we build the database structure of your current version before upgrading to completely new, then play your data again and thereafter again the update to try again to the new version.
   * For this purpose, you should, as with all adjustments to the database, before making a full backup of your Admidio database. If you run in trouble you can rely on this backup.    * For this purpose, you should, as with all adjustments to the database, before making a full backup of your Admidio database. If you run in trouble you can rely on this backup. 
-  * Next, you should download Admidio again in ** your currently used version ** of our [[http://sourceforge.net/projects/admidio/files/|Sourceforge project page]]. These are here, however, only in the most recent bugfix version available, which should be no problem, however. This version can unpack you anywhere locally on your hard drive. We now need the resulting file, you can take in mind for later access: ** adm_install / db_scripts / db.sql **+  * Next, you should download Admidio again in ** your currently used version ** of our [[http://sourceforge.net/projects/admidio/files/|Sourceforge project page]]. These are here, however, only in the most recent bugfix version available, which should be no problem, however. This version can unpack you anywhere locally on your hard drive. We now need the resulting file, you can take in mind for later access: ''www.your-admidio-folder.org/adm_program/installation/db_scripts/db.sql''
   * In the file, we need to make only a small change. All //% PREFIX% // must be replaced by the table prefix that you have specified during the initial installation. Just take a look in the database to which Prefix start the tables. Our default prefix is **adm** , then the tables are called, for example, //adm_announcements// or //adm_files//.   * In the file, we need to make only a small change. All //% PREFIX% // must be replaced by the table prefix that you have specified during the initial installation. Just take a look in the database to which Prefix start the tables. Our default prefix is **adm** , then the tables are called, for example, //adm_announcements// or //adm_files//.
  
-==== Update database structure ==== +===== Update database structure ===== 
-Now we will update the database structure of your Admidio installation. The next steps, we will describe with reference to the Software [[http://de.wikipedia.org/wiki/Phpmyadmin|phpMyAdmin]]. They can also be made with a different database software.+Now we will update the database structure of your Admidio installation. We will describe the further steps using the software [[http://de.wikipedia.org/wiki/Phpmyadmin|phpMyAdmin]]. Of course, these can also be done with other database software. 
  
-The following things have to be carried out in sequence+The following things must now be done one after the other
-  - It now must to be started a backup of Admidio database, but at this time to secure ** without ** the database structure. For this purposechoose among phpMyAdmin below **Export all Admidio tables and remove the **tick in structure**. In addition the foreign key must not be checked while doing the import. For this purpose, the setting ** foreign key check has to be set disable ** must be set. . Both settings are shown in the following screenshot \\ {{: de: 2.0: Documentation: phpMyAdminexport_einstellungen.jpg 400 | Export settings of phpMyAdmin}}? +  - Now you have to backup the Admidio database again, but this time **without** backing up the database structure. To do this, select **Custom - display all possible options** under **Export** in phpMyAdmin and then uncheck **Structure** in the tables header.\\ {{:en:2.0:update:database_repair.png?400|Export settings 1 from phpMyAdmin}} 
-  - Now all Admidio tables must be completely removed from the database. +  - In additionthe foreign keys must not be checked during the subsequent import. For this purpose, the setting **Disable foreign key checks** must be set. Afterwards the export can be started with **OK**.\\ {{:en:2.0:update:database_foreign_keys.png?400|Export settings 2 from phpMyAdmin}} 
-  - Nextwe are playing the database structure from the file ** db.sql ** which we have secured in the preparations. In addition one selects ** Import ** file ** ** db.sql from the hard drive, and confirms this with ** OK **. +  - Next, you should now delete all existing Admidio tables in the database with an appropriate program (in this documentation [[http://www.phpmyadmin.net|phpMyAdmin]]). For this you mark the appropriate tables and choose  entry **Delete**.\\ {{:en:2.0:documentation:backup:backup_delete_tables.png?400|Delete tables}} 
-  - In the next stepwe are now playing the backup point 1 again. This is also done with ** Import **. +  - In the next step you have to disable the setting **Enable foreign key checks**.\\ {{:en:2.0:documentation:backup:backup_foreign_keys.png?400|Disable foreign key checks}} 
-  - If both imports finishes without incidentso you can now place  the new Admidio version on your web server and start the update dialog ** adm_install / update.php call here ** to perform the update.+  - Next we import the database structure from the file **db.sql**which we have saved in the preparations. To do this, select the **db.sql** file from the hard disk under **Import** and confirm this with **OK**. 
 +  - In the next step we now import the backup from point 1 again. This is also done with **Import**. 
 +  - If both imports went through without errors, you can now place the new Admidio version on your web server and call the update dialog ''www.your-admidio-folder.org/adm_program/installation'' again here and perform the update.
  
-Now the update should run without errors. Are there still problems so please consult our [[http: //forum.admidio.org | Forum]].+Now the update should run without errors. Are there still problems so please consult our [[https://www.admidio.org/forum|Forum]].
  
 Much success! Much success!
  • en/2.0/probleme_beim_update.1444251192.txt.gz
  • Last modified: 2015/10/07 22:53
  • by thomas-rcv