Problems during Updating

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 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 MyISAM on 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.

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.
• Next, you should download Admidio again in your currently used version of our 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
• 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.

Now we will update the database structure of your Admidio installation. The next steps, we will describe with reference to the Software phpMyAdmin. They can also be made with a different database software.

The following things have to be carried out in sequence:

1. It now must to be started a backup of Admidio database, but at this time to secure without the database structure. For this purpose, choose 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:
   - Now all Admidio tables must be completely removed from the database. - Next, we 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 . - In the next step, we are now playing the backup point 1 again. This is also done with Import . - If both imports finishes without incident, so 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.

Now the update should run without errors. Are there still problems so please consult our Forum.

Much success!