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

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

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

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

Hi Again,

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

- Morten

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

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

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

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

Any ideas?

And it doesn't show in 4.7.2 either.

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

maybe you should try this uLoremsy - Property Prevalue Setter

for me it was a great alternative solution..

cheers, stevo

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

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

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.

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

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.

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

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.

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.

is working on a reply...