Question

Photo of David Titkemeyer

0

That Wasn't Suppose To Happen An error occurred creating database.

2

I am receiving the following error upon installing RockRMS the first time

 

That Wasn't Suppose To Happen An error occurred creating database. Message: La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. Se terminó la instrucción. Se terminó la instrucción. Se terminó la instrucción. Current Script: INSERT [dbo].[Attribute] ([Id], [IsSystem], [FieldTypeId], [EntityTypeId], [EntityTypeQualifierColumn], [EntityTypeQualifierValue], [Key], [Name], [Description], [Order], [IsGridColumn], [DefaultValue], [IsMultiValue], [IsRequired], [Guid], [CreatedDateTime], [ModifiedDateTime], [CreatedByPersonAliasId], [ModifiedByPersonAliasId], [ForeignKey], [IconCssClass], [AllowSearch], [ForeignGuid], [ForeignId]) VALUES (1625, 1, 51, 9, N'BlockTypeId', N'361', N'DefaultReminderEmail', N'Default Reminder Email', N'The default Reminder Email Template value to use for a new template', 1, 0, N'{{ ''Global'' | Attribute:''EmailHeader'' }}

{{ Registration.Registrants | Map:''NickName'' | Join:'', '' | ReplaceLast:'','','' and'' }},

Just a reminder that you are registered for {{ RegistrationInstance.Name }}.

{{ RegistrationInstance.AdditionalReminderDetails }}

If you have any questions please contact {{ RegistrationInstance.ContactPersonAlias.Person.FullName }} at {{ RegistrationInstance.ContactEmail }}.

  • Photo of Jim Michael

    0

    I don't have a good answer for you, but based on the error you post I'm wondering if this is an unknown bug when running a server in Spanish? I don't suppose it's possible to try the same install against a Windows install set for English?

  • Photo of Nick Airdo

    0

    A couple of ideas come to mind on that issue:

    1. There could be something preventing your website from reaching the database server or…
    2. There could be a problem with the database permissions of the database user login you’ve provided to Rock or…
    3. Or some other problem prevented the tables from being created.

    You might also consider taking a look at this wiki page https://github.com/SparkDevNetwork/Rock/wiki/Create-Sql-Server-RockUser-Login and this one https://github.com/SparkDevNetwork/Rock/wiki/Install-SQL-Server (namely the part about Database Engine Configuration’s Mixed Mode).

    I know elsewhere you mentioned you were able to install Rock locally (and you restored your database locally) but when you tried to login you were not able to. That particular issue is probably due to not preserving the various keys (PasswordKey, DataEncryptionKey) from your hosted web.config to your local web.config.  Those keys are used during the login password process and therefore should move to the new host if you move your website.