...

1. First determine your database schema revision: the version is stored in the settings table

   1. On versions before 2.5 run

      Code Block
      sql
      SELECT `db_version` FROM `settings`;

   2. On versions after 2.5 run

      Code Block
      sql
      SELECT * FROM `settings` WHERE `key` = 'db_version';

2. Execute the appropriate upgrade*-*.sql scripts in phpMyAdmin or via the command line to bring your database up to date. 
   If you are at version 25, you need to execute SQL upgrade scripts: upgrade25-26.sql, upgrade26-27.sql, upgrade27-28.sql and so on up to the latest sql file in your /sql directory.
   Each schema revision is usually only a couple of small changes.

Manually running database upgrade scripts and fix error via phpMyadmin

1. if you log into your Ushahidi as an admin and encounter Ushahidi database  upgrade page, it mostly like means you need to upgrade your database version to newer version.
   
   Image Added
   
   
   
2. If you click on upgrade button, database error page would appear.
   
   Image Added 
   
   
   
   
3. You just need to upgrade your database, to find out which  Database version your currently running and  which version you need to update to, look at the first page. In my case i am  running v2,7.1 with database version 108 and i need to upgrade to version 113. 
   
   Image Added
   
   
   
   
4. To fix this problem we have to manually import the databases from Ushahidi_Web-2.7.2/sql starting from the current database version incrementally to version 113 in phpmyadmin’s database
   
   Image Added