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

Forums / Set-up & Installation / Can't create/write to file 'C:\Windows\TEMP\#sql

Can't create/write to file 'C:\Windows\TEMP\#sql

8 posts, 0 answered
  1. Charles Richardson
    Charles Richardson avatar
    7 posts
    Registered:
    23 Oct 2012
    29 Oct 2009
    Link to this post
    I got Sitefinity 3.7 installed on a Windows 7 64-bit system. Now I am having trouble creating a project.

    The project will be created by the wizard, and I will go through the step that asks me what database to use. I am using a MySQL 5.0 database for this project. It successfull creates the database (56 tables). It adds the amin account (I know it does that because when I go back in it finds it.)

    But when I try to do the last step--import the data--I get this error:

    Can't create/write to file 'C:\Windows\TEMP\#sql_a8c_0.MYD' (Errcode: 17)

    I can see the file in the temp directory, it has been created.

    The same thing happens whether I ask the wizard to import the sample data or not. When I close the wizard and restart, the project is there, but when I try to browse, it takes me through the database selection step again, then on to the import step, and the same error occurs.

    I have tried deleting everything and starting over, and get the same error.
  2. Charles Richardson
    Charles Richardson avatar
    7 posts
    Registered:
    23 Oct 2012
    29 Oct 2009
    Link to this post
    I'm using the Community Edition.

    I have tried to run the application from Visual Studio. It compiles fine, but then I get the yellow error screen with the same error:

    Parser Error Message: Can't create/write to file'C:\Windows\TEMP\#sql_a8c_0.MYD' (Errcode: 17)


  3. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    30 Oct 2009
    Link to this post
    Hi Charles Richardson,

    As I see it from the error message, ASP.NET account does not have read and write permissions to the TEMP folder. Could you check whether the ASP.NET account has required permissions. This is a server side setting that is not controlled by Sitefinity.

    Greetings,
    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.
  4. Charles Richardson
    Charles Richardson avatar
    7 posts
    Registered:
    23 Oct 2012
    30 Oct 2009
    Link to this post
    There is no ASP.Net user in Windows 7 (or VIsta).

    I added the Network Service user to the folder.

    Now I am getting another error:

    Importing template data failed: The type initializer for 'Telerik.Cms.Engine.ContentUrlRewriterService' threw an exception.. Check the error log for more details.
  5. Charles Richardson
    Charles Richardson avatar
    7 posts
    Registered:
    23 Oct 2012
    30 Oct 2009
    Link to this post
    And if I try to go back, I get the same error as in the first instance:

    Can't create/write to file 'C:\Windows\TEMP\#sql_a8c_0.MYD' (Errcode: 17)


    However, that file IS there, and was created by Sitefinity. (See image attached.)

    (Thanks for the reply!)
  6. Charles Richardson
    Charles Richardson avatar
    7 posts
    Registered:
    23 Oct 2012
    30 Oct 2009
    Link to this post
    It appears to be a problem with MySQL.

    I just had it connect to a SQL Server database, and it worked fine.

    So it's some issue with persmissions with a local MySQL server.
  7. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    30 Oct 2009
    Link to this post
    Hello Charles Richardson,

    There is no way to know which OS you use, since it was not mentioned or marked in your account details. There error says that you should check the error log. It is located under App_Data folder. Error 17 means that MySQL is trying to create a temporary file that already exists. Try stopping the MySQL service. Remove the files from c:\windows\temp, run the service again. You could try creating a new temporarily directory for MySQL and pointing to it in my.ini if the problem persists. Check the following article. It is better to use SQL because it is faster.

    Kind regards,
    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.
  8. Charles Richardson
    Charles Richardson avatar
    7 posts
    Registered:
    23 Oct 2012
    30 Oct 2009
    Link to this post
    Thanks, Ivan.

    You are right; I did not specify my OS in the original post. My apologies. I should know better!

    I agree that SQL Server is faster. But in this project, I'm limited to MySQL due to client requirements.

    I see from the MySQL forums that other people have this problem, and it doesn't appear to be easy to solve.

    But at least we've determined that it isn't a Sitefinity issue, which is good.
Register for webinar
8 posts, 0 answered