U4-2153 - MySQL Error for Backend Homepage in 6.0.4

Created by Brian Powell 25 Apr 2013, 15:38:55 Updated by Sebastiaan Janssen 28 May 2013, 17:26:44

Duplicates: U4-2176

After I upgraded from 6.0.3 to 6.0.4, I now see a MySQL error on the backend homepage when I first sign in. It looks like there is a problem with a SQL statement referencing the UmbracoLog table. I've attached the exception generated by IIS.

1 Attachments

Download error.htm


Sebastiaan Janssen 25 Apr 2013, 15:45:27

I suspect this is a problem with the latestedits usercontrol. Try to disable it in the dashboard. I guess mysql doesn't support "select top 30 from.." queries.

Brian Powell 25 Apr 2013, 15:50:31

Disabling latestedits worked.

Richard Hull 28 Apr 2013, 16:13:50

Hi Sebastiaan - I've got the same error - is this due to be fixed in an update soon?

Sebastiaan Janssen 29 Apr 2013, 15:39:09

Sorry, this is low priority at the moment, we'd be happy to accept a fix if someone can provide one. Should be pretty easy to make the query compatible with MySQL.

Workaround: remove lastedits from dashboards.config.

Priority: Normal

Type: Bug

State: Duplicate


Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions: 6.0.4

Due in version:


Story Points: