The problem is that

SELECT TOP 1 

isn't standard SQL it is a keyword for MS SQL Server. MySql has to use

SELECT... Limit 1

I will report it to blogpackage core and will do a patch for it. Stay tuned...

Thomas

Seems taht you are the first one using the package on mysql *g*

Ok, fast solution: Download the code from codeplex (http://codeplex.com/blog4umbraco) and change in the codebehind of the dashboard/CreatePost.ascx the following method:

private void SetBlogRoot()
{
    if (_parentId == -1)
    {
        string sql = "select id, path from umbracoNode " +
                     "inner join cmsContent on cmsContent.nodeId = umbracoNode.id " +
                     "inner join cmsContentType on cmsContentType.nodeId = cmsContent.contentType " +
                     "where cmsContentType.alias = '{0}' and path not like '%-20%' and path like '%{1}%' " +
                     "order by path";
        string userStartNode = (umbraco.BasePages.UmbracoEnsuredPage.CurrentUser.StartNodeId != -1)
                                   ? "," + umbraco.BasePages.UmbracoEnsuredPage.CurrentUser.StartNodeId + ","
                                   : umbraco.BasePages.UmbracoEnsuredPage.CurrentUser.StartNodeId + ",";
        sql = String.Format(sql, GetBlogDocumentType().Alias,
                            userStartNode);
        IRecordsReader reader = umbraco.BusinessLogic.Application.SqlHelper.ExecuteReader(sql);
        reader.Read();
        _parentId = reader.GetInt("id");
    }
}

As I said I will submit this to codeplex as a patch...

hth, Thomas

@Thomas, what's your codeplex username ? will just add you as a developer that way you can commit your path.

My Codeplex name is hoehler

Thanks Tim

Done, thanks for the solution Thomas!

Thank you so far.

I need some help on how to get the change implemented in Umbraco.

Do I need to compile the file after the changes or where are the ascx.cs file placed?

/Martin

@Martin, just compile the project and place the updated assembly (Umlaut.Umb.Blog) in the bin directory.

Or as a temp solution you could also just remove the usercontrol from the dashboard by editing /config/dashboard.config

I search through all my cd's with programs and I can't find my Visual Studio 2005 (I got it while I was studying, through download from Microsoft).

Could anyone build this dll file for me?

I haven't been able to find another program which could have done the job.

Take a look at the nightly builds. the changes from yesterday shuold have been included: http://nightly.umbraco.org/Blog4Umbraco/2.0.24/

Thomas

is working on a reply...