+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / SQL syntax error using 3.7 and MySql

SQL syntax error using 3.7 and MySql

3 posts, 0 answered
  1. Jassen
    Jassen avatar
    3 posts
    Registered:
    23 Sep 2009
    15 Oct 2009
    Link to this post
    When using project manager to setup a new site with MySql, I get the following error using MySql version 5.1.

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-main.NN_NextValue' at line 1

    Source Error:

    Line 106:        <clear />
    Line 107:        <add connectionStringName="DefaultConnection" applicationName="/"
    Line 108: name="Sitefinity" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />Line 109:      </providers>
    Line 110:    </roleManager>

    Source File: C:\Program Files\telerik\Sitefinity3.7 Community\WebSites\mysql\web.config    Line: 108


    Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082

  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    15 Oct 2009
    Link to this post
    Hi Jassen R,

    I checked the installation of Sitefinity 3.7 SP1 under MySQL and could not find any problems. Most probably your database is not empty and the error is thrown from NN_NextValue store procedure. Try creating a new database and install the project.

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. Jassen
    Jassen avatar
    3 posts
    Registered:
    23 Sep 2009
    15 Oct 2009
    Link to this post
    Ok. I figured it out and got it working. I am a newbie to MySql, but am an old MSSQL /Oracle guy. It looks like in MySql you can't have hyphens in the DB name. Once I removed it, I was able to finish the install.

    As a note, trying to get MySql installed with this was actually quite painful compared to SQL or Oracle. You might want to create a MySql section in the installation guide to explain some of the setup issues that you can run into for MySql newbies because it took reading your forums all night to figure out the issue with having to also use the "root" user do to the grant SP permission problems with MySql.
Register for webinar
3 posts, 0 answered