Copied to clipboard
  • stevo 90 karma points
    Nov 25, 2011 @ 00:28
    stevo
    0

    Problems with Umbraco 4.7.1

    Hey,

    first of all thanks for your package!
    I installed the "Sitereactor_Standard_Values_1.3.zip" package on Umbraco 4.7.1.

    First i had the same problem as here.
    No Standard Values folder was showing up after the installation.

    But then nothing happened if i click on any Document Types unter the Standard Values folder.

    Any suggestions?

    thx, stefan

  • Jan Skovgaard19239 karma points admin mvp c-trib
    Nov 25, 2011 @ 08:16
    Jan Skovgaard
    0

    Hi Stevo

    What database are you running your Umbraco instance on? If you're using SQL CE I know there are some problems with it.

    /Jan

  • stevo90 karma points
    Nov 25, 2011 @ 10:44
    stevo
    0

    Hey Jan,

    thanks for your answer!

    I've tried it on Microsoft SQL Server 2008 Express.

    On SQLCE4 you get an exception "System.Data.SqlServerCe.SqlCeException" during the installation.

    thx, stevo

  • stevo90 karma points
    Nov 28, 2011 @ 09:30
    stevo
    0

     

    Hey Guys,

    I’m the only one with this problem on Umbraco 4.7.1?

    Or is nobody using this package anymore?

    I would love to use this package.

    Has anyone an alternative package?

     Thanks a lot, Stefan

  • Morten Christensen2640 karma points admin hq
    Dec 14, 2011 @ 12:25
    Morten Christensen
    0

    Hi Stefan,

    Sorry, I seem to have missed your post :-S Version 1.4 is in the works, but currently awaiting some feedback.
    I'll try and get an update sorted this friday where I have time available.

    I will post back with an update on the progress.

    - Morten

  • Morten Christensen2640 karma points admin hq
    Dec 16, 2011 @ 15:02
    Morten Christensen
    0

    Hi Again,

    Just released version 1.4 of the standard values package, which works with Umbraco 4.7.1 and Sql CE.

    - Morten

  • Jeroen Breuer9854 karma points admin mvp c-trib
    Jan 16, 2012 @ 18:06
    Jeroen Breuer
    1

    Hello,

    I had 1.3 on 4.7.1.1 and removed it and than tried to install 1.4. It says the install was succesfull, but I can't see it in the tree. I looked at the database and it's there:

    FalseTrue7settingsstandardValuesStandard Valuesfolder_o.giffolder.gifSitereactor.StandardValuesTrees.LoadStandardValues

    Any idea what could be wrong or how to fix it? In the error log is this:

    Error undoing package action 'StandardValues_ExecuteNonQuery' for package Standard Values: System.NotImplementedException: The method or operation is not implemented.
       at Sitereactor.StandardValues.Installer.ExecuteNonQuery.Undo(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.UndoPackageAction(String packageName, String actionAlias, XmlNode actionXml)

    Jeroen

  • Jeroen Breuer9854 karma points admin mvp c-trib
    Jan 16, 2012 @ 18:12
    Jeroen Breuer
    0

    Here's another error I found in the log: 

    <p>Error in installing Application Tree for the Standard Values package:<br/><em>umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'.
    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters)
       at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
       --- End of inner exception stack trace ---
       at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
       at umbraco.BusinessLogic.ApplicationTree.MakeNew(Boolean silent, Boolean initialize, Byte sortOrder, String applicationAlias, String alias, String title, String iconClosed, String iconOpened, String assemblyName, String type, String action)
       at Sitereactor.StandardValues.Installer.InstallationHelper.InsertApplicationTree()</em> <br/></p>
    
    

    Jeroen

  • Jeroen Breuer9854 karma points admin mvp c-trib
    Jan 17, 2012 @ 10:45
    Jeroen Breuer
    0

    Hmm restarted pc and now the Standard Values node is back in the settings tree on my local dev. When I try to open a node for the first time I do get this error:

    At /umbraco/plugins/Sitereactor/StandardValues/EditStandardValue.aspx?id=1057 (Referred by: http://localhost/umbraco/): System.ArgumentException: No node exists with id '0'
       at umbraco.cms.businesslogic.CMSNode.setupNode()
       at umbraco.cms.businesslogic.CMSNode..ctor(Int32 Id)
       at Sitereactor.StandardValues.EditStandardValue.LoadPropertiesFromMaster(Int32 contentItemTypeId)
       at Sitereactor.StandardValues.EditStandardValue.OnInit(EventArgs e)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    This only happens the first time. After opening it again it works.

    Jeroen

  • Kalle Ekstrand255 karma points c-trib
    Feb 02, 2012 @ 14:18
    Kalle Ekstrand
    0

    The standard values folder does not show in 4.7.1.1 either. I use MS SQL 2008 R2.

    Any ideas?

  • Johan338 karma points
    Jun 12, 2012 @ 11:57
    Johan
    0

    And it doesn't show in 4.7.2 either.

  • MikeD92 karma points
    Jun 27, 2012 @ 18:24
    MikeD
    0

    Is anyone still paying attention to this thread?  Folks are reporting issues, and no dev responses in months...

    The folder is not showing up in the settings section... 

    I am running umbraco v 4.7.2 (Assembly version: 1.0.4500.21031) with a mySQL database.

    Please advise us what to do... this package appears to be exactly what I need, now if it would just work!  lol

  • stevo90 karma points
    Jun 28, 2012 @ 01:52
    stevo
    0

    maybe you should try this uLoremsy - Property Prevalue Setter

     

    for me it was a great alternative solution..

    cheers, stevo

     

  • Morten Christensen2640 karma points admin hq
    Jun 28, 2012 @ 18:07
    Morten Christensen
    0

    Hi All,

    Sorry for the late reply. I haven't had time to test the package against the latest releases of version 4, but I *think* the package just needs to be compiled against the latest release. Source is available here: https://bitbucket.org/sitereactor/standard-values-for-umbraco/src so please feel free to try it out.

    I have never tested the package against mySQL, so I have no idea if it actually works. The SQL within the package should work with both SQL Server, SQL CE and MySQL, but I'm afraid MySQL has never been a priority because so few use it.

    Best regards,
    Morten Christensen

  • Tom Maton642 karma points
    Jul 20, 2012 @ 15:39
    Tom Maton
    1

    Once installed, I've noticed that you need to touch the config for it then to appear in the Settings tree under Document Types

  • MikeD92 karma points
    Jul 20, 2012 @ 16:01
    MikeD
    0

    Morten,

    I think you would be surprized how many people use (or will use) mySQL because of the insane licensing costs of using MS SQL.  We are a development company and we develop Umbraco sites quite frequently.  mySQL is a great option because there is no extra cost involved.  I don't have to install MS SQL Server and I don't have to worry about licensing.

    In my humble opinion, saying it has never been tested because so few people use it is akin to saying I don't test my sites in Safari because so few people use a Mac.  It's unacceptable from a professional developer.

  • Morten Christensen2640 karma points admin hq
    Jul 20, 2012 @ 18:05
    Morten Christensen
    1

    Mike,

    I think you need to realize this is a free project that I develop in my spare time. If you do not accept the boundries I set for this project in order to actually release it, so others can benefit from it then I think you should either use something else or contribute with the features you would like to see added that I myself don't have time to include. The source is available on bitbucket: https://bitbucket.org/sitereactor/standard-values-for-umbraco - feel free to send me a pull request for the mysql features you would like to see added.

    Best regards,
    Morten Christensen

  • Eric Herlitz125 karma points
    Aug 23, 2012 @ 23:26
    Eric Herlitz
    0

    MikeD, compare MySQL vs SQL Server Express and you'll see that you are not allowed to use MySQL commercially for free as you seem to think. SQL Express on the other hand is free to use.

  • MikeD92 karma points
    Aug 23, 2012 @ 23:32
    MikeD
    0

    Eric,

    The problem with SQL express is you cannot use it for multiple databases... where did you get the idea/info that you cannot use mysql for free?  Just curious... I don't want to get my butt in a pickle... lol

  • Eric Herlitz125 karma points
    Aug 23, 2012 @ 23:44
    Eric Herlitz
    0

    The Enterprise version of MySQL is something like $900 a year. If you bundle MySQL with your application or project you cannot use the free edition (sorry).

    I used to work at a company that developed and shipped a telecommunications system with MySQL, when Sun bought the company we had to start to pay an annual fee of $700 / database server. If you ship Umbraco and install the MySQL database server in commercial usage you are in breach with their licensing terms unles you pay up.

  • MikeD92 karma points
    Aug 23, 2012 @ 23:49
    MikeD
    0

    oh no, we don't do that... we just use mysql for the umbraco database.  Install mysql on server, deploy websites... it's our server and it's not bundled in any way.  Same as if I had a bunch of php sites using mysql databases.

Please Sign in or register to post replies

Write your reply to:

Draft
Our.umbraco.org is the community mothership for Umbraco, the open source asp.net cms. With a friendly forum for all your questions, a comprehensive documentation and a ton of packages from the community.