Troubleshooting - Midgard 1.8

1. Midgard is not working after update ( or fresh install ).
2. I have plenty of PHP warnings which include SQL queries. And some column is not known by SQL server. Unknown column 'guid' in 'field list'
3. I got plenty of warnings 'Illegal mix of collations'

Midgard is not working after update ( or fresh install ).

First, check the logs. Apache and PHP ones. Since 1.8 version of Midgard, every warning message is reported in logs without any need to switch log level to debug.

I have plenty of PHP warnings which include SQL queries. And some column is not known by SQL server. Unknown column 'guid' in 'field list'

Midgard database is not upgraded or upgrade failed. Note that database upgrade should be made with every Midgard update. Even if it's minor update. Run Datagard and select 'Update - Upgrade from previous Midgard release' option from menu. It will take a while till database is fully upgraded. During this step you will be informed about upgrade progress.

I got plenty of warnings 'Illegal mix of collations'

Probably you still run MySQL 4.0 version. Midgard 1.8 requires MySQL >= 4.1. If MySQL 4.1 or 5.0 is already installed , it means that database is not converted to fully support UTF-8. Run Datagard and select 'Convert - Convert database (UTF conversion)'.