Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5
PHP version: 5.2.17
MySQL version: 4.1.20
Host: (webreus.nl)
Admin Tools version: (2.2.a3)

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:

Hi, I tried a lot of possibilities and because a lot of stress I just want your opinion about this. If I use admintools update, AkeebaBu or export import database by phpmyadmin, two of my sites show up warnings. Other just went well, but these errors I can't explain. Sites seems to work OK, but I don't know if that's just a matter of time. Both sides show up errors, I can't fix with admintool nor Joomla build in fix.
local these errors don't show, but when I put the same site online it shows;
Warning: Database is not up to date!
Table 'brldknl_languages' does not have index 'ordering'. (From file 1.7.0-2011-06-06-2.sql.)
Table 'brldknl_languages' does not have index 'idx_ordering'. (From file 1.7.0-2011-06-06-2.sql.)
Table 'brldknl_categories' does not have column 'description' with type 'MEDIUMTEXT'. (From file 1.7.1-2011-09-15.sql.)
Table 'brldknl_session' does not have column 'data' with type 'MEDIUMTEXT'. (From file 1.7.1-2011-09-15.sql.)
Table 'brldknl_session' does not have column 'session_id' with type 'varchar(200)'. (From file 1.7.1-2011-09-15.sql.)
Table 'brldknl_modules' does not have column 'position' with type 'VARCHAR(50)'. (From file 1.7.1-2011-09-17.sql.)
Table 'brldknl_redirect_links' does not have column 'old_url' with type 'varchar(255)'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_redirect_links' does not have column 'new_url' with type 'varchar(255)'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_categories' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_contact_details' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_extensions' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_menu' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_modules' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_newsfeeds' does not have column 'access' with type 'int(10) unsigned'. (From file 1.7.1-2011-09-20.sql.)
Table 'brldknl_banners' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_categories' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_contact_details' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_content' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_content' does not have column 'title_alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_menu' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_newsfeeds' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_weblinks' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-10-15.sql.)
Table 'brldknl_languages' does not have index 'sitename'. (From file 1.7.3-2011-10-19.sql.)
Table 'brldknl_content' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.3-2011-11-10.sql.)
Table 'brldknl_languages' does not have index 'idx_image'. (From file 1.7.4-2011-11-19.sql.)
Table 'brldknl_languages' does not have index 'idx_langcode'. (From file 1.7.4-2011-11-19.sql.)
Table 'brldknl_newsfeeds' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'brldknl_content' does not have column 'alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'brldknl_content' does not have column 'title_alias' with type 'VARCHAR(255)'. (From file 1.7.4-2011-11-23.sql.)
Table 'brldknl_update_sites' does not have index 'last_check_timestamp'. (From file 2.5.0-2011-12-06.sql.)
Table 'brldknl_menu' does not have index 'idx_client_id_parent_id_alias_language'. (From file 2.5.0-2011-12-24.sql.)
Table 'brldknl_updates' does not have index 'infourl'. (From file 2.5.0-2012-01-10.sql.)
Table 'brldknl_languages' does not have column 'sitename' with type 'VARCHAR(1024)'. (From file 2.5.0-2012-01-14.sql.)

!? got stuck here...

trust me, if it was that easy I didn't even dare to ask your knowledge... I did that but doesn't work on two of my sites. On other where I had just a few warnings it worked indeed. But now nothing. When I backup the site and restore it local everything looks OK, no warnings at all. Maybe something with the HDD. But I tried to fix the site with an backup from the local site, and kickstart gave a warning about
Table 'brldknl_languages' does not have column 'sitename' with type 'VARCHAR(1024)'
I put it in the file and made 255 of it.
That went well, but these warnings stay...

I was never in doubt with your advice, so I ask my host (webreus.nl) to migrate me to a new server.... and what do you think?
Was PLESK 7* now I have PLESK 8*
Was MySQL 4* now I have 5.1.47
local host back-up time from a site from 39Mb takes 2.12 minutes
upload JPA, kickstart, unpack, install database, fine tune .htaccess and WAP -> less then 7 minutes!!!!
I think local develop in MySQL 5 and hosting life on MySQL 4 was the big P.
All the above failures where gone after migration to the new server.

Thank you again and hand up for Akeeba Backup!

Hope you have time to enjoy your 27" LED Cinema Display ;)