Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Anton 135 posts 186 karma points
    Jan 19, 2012 @ 22:19
    Anton
    0

    Error running Reader: SQL Statement:

    My local web-site don't working. What it is?

     

    Error running Reader:
    SQL Statement:
    Select userNoConsole, userDisabled, userType,startStructureID, startMediaId, userName,userLogin,userEmail,userDefaultPermissions, userLanguage, defaultToLiveEditing from umbracoUser where id = @id

    Exception:
    System.Data.SqlServerCe.SqlCeException: . [ File name = F:\_\Sharkof( )\SharkOf\App_Data\Umbraco.sdf ]
       System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr)
       System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
       System.Data.SqlServerCe.SqlCeConnection.Open()
       SQLCE4Umbraco.SqlCeContextGuardian.ensureOpenBackgroundConnection(String connectionString)
       SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
       SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 19, 2012 @ 23:53
    Jan Skovgaard
    0

    Hi Anton

    Have you checked that the permissions for iusr and network service are correct? If so...what version of Umbraco are you using and is it installed on a mssql server or sql ce database?

    EDIT: Nevermind the DB question...

    /Jan

  • Anton 135 posts 186 karma points
    Jan 20, 2012 @ 01:05
    Anton
    0

    It happends after I add my site to Team Foundation Server. I have click button Check In, and then I cannot started my project on local machine. All project that I add to source control become projects with this error. But why Visual Studio change permissions on my local machine ?

  • Anton 135 posts 186 karma points
    Jan 20, 2012 @ 05:06
    Anton
    0

    Oh) I understand, I must do Check Out in Visual Studio.

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 20, 2012 @ 17:55
    Jan Skovgaard
    0

    Ah, that's something I did not even think about could be the issue. (Primarily using mercurial myself)

    Happy to see you got it figured out :)

    /Jan

  • ANSHIT 10 posts 30 karma points
    Feb 01, 2012 @ 13:06
    ANSHIT
    0

    i created an application using umbraco. everything is working fine on my localhost but when i am uploading it on the server, it is returning a error saying:

    Error running Reader:
    SQL Statement:
    select id, domainName from umbracoDomains.

    what could be the problem , all worked well on my local host but not running on server.

    plz help if anyone knows this...


  • Md Johirul Islam 37 posts 57 karma points
    Feb 06, 2012 @ 10:41
    Md Johirul Islam
    0

    I have the same problem but reverse. My CMS work in to server but when i download from server to local to change same problem arise. Please help ...... 

    Exception:
    System.Data.SqlServerCe.SqlCeException: The database file may be corrupted. Run the repair utility to check the database file. [ Database name = \\?\C:\Users\johirul.islam\Documents\My Web Sites\ICLP\App_Data\Umbraco.sdf ]
      at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr)
      at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
      at System.Data.SqlServerCe.SqlCeConnection.Open()
      at SQLCE4Umbraco.SqlCeContextGuardian.ensureOpenBackgroundConnection(String connectionString)
      at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

  • Greg Mattison 40 posts 60 karma points
    Oct 25, 2012 @ 16:40
    Greg Mattison
    0

    We're getting this error now. The site was working fine, we installed NWS Twitter Goodies then uninstalled the package and now the site is down. Can anyone assist?

Please Sign in or register to post replies

Write your reply to:

Draft