2013-03-20 21:21:02,718 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 18 (took 174ms)
2013-03-20 21:21:02,773 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 8ms)
2013-03-20 21:21:02,785 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 7ms)
2013-03-20 21:21:02,794 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 7ms)
2013-03-20 21:21:02,810 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 7ms)
2013-03-20 21:21:02,818 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 7ms)
2013-03-20 21:21:03,436 [24] INFO umbraco.BusinessLogic.Log - [Thread 29] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3
2013-03-20 21:21:03,437 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of umbraco.interfaces.IApplication, found 7 (took 17ms)
2013-03-20 21:21:03,586 [24] INFO Umbraco.Core.PluginManager - [Thread 16] Completed resolution of types of umbraco.interfaces.ITree, found 27 (took 17ms)
2013-03-20 21:21:08,031 [24] INFO Umbraco.Core.PluginManager - [Thread 5] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 13ms)
2013-03-20 21:21:08,081 [24] INFO Umbraco.Core.PluginManager - [Thread 5] Completed resolution of types of umbraco.interfaces.ITree, found 36 (took 12ms)
2013-03-20 21:21:38,002 [24] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 5] Error executing query SELECT id FROM cmsPropertyTypeGroup WHERE contenttypeNodeId = @contentTypeId
System.Threading.ThreadAbortException: Thread was being aborted.
at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 )
at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
Is there a way of manually installing Blogsy so that I can work past this particular error? Or, at least, figure out why it is happening?
Note: running SQL Server 2008 on Win2K8R2. All patches, all updates installed. Configured IIS correctly, with separate .NET 4.0 application pool just for this site, and named the same as this site.
With that said, I come from the security end of I.T., so I'm also having kittens that mixed-mode authentication is needed for Umbraco (specifically, that it *only* uses SQL authentication). With even Microsoft saying “don't use SQL authentication unless you have no other choice”, I find it very curious that Umbraco does not permit a properly-configured and secured database to be used. I already use Windows Authentication mode for several other apps on this server, and was rather put out when I had to take a big leap backward just to install Umbraco.
Did you get a yellow screen whilst installing? If so, do you have the error it gave?
Event logs. Do you have the event logs from both the web server and the sql server? (are they on separate boxes? if so whats the distance/ping between them, as it looks like something is trying to abort the SQL connection thread. and I'm wondering if its a timeout kinda thing, whats the timeout set to in your web.config? and how long were you waiting before the installation bombs out? )
The error looks like something hasn't been created in the database that the installation expects. So that @contentTypeId doesn't have a contentTypeId in the cmsPropertyGroup table for whatever reason and is going tits up.
What priviliges did you give the sql account that has access to umbraco. Does the account have db_owner priviliges to the umbraco database in the securable tab under the login properties?
Also i'm presuming that Umbraco is working as normal - you can get into the back office and create content, templates, scripts etc. ??
I am running everything on one box. IIS & SQL Server. So it's not a timeout thing.
I created a special SQL authentication account just for Umbraco. It has all the needed rights, including db_owner. I can get into the back office to do those kinds of things -- that's where I am trying to install uBlogsy from - the Developer/Packages/Repository section. However, even downloading and installing uBlogsy from the Install Local Package tool creates the same error.
The only thing I can suggest is that you compare what is in your cmsPropertyTypeGroup table with someone who has a working copy of uBlogsy - i'm sure Anthony can help you out here. You can then maybe get more of a pointer as to what part of the installation is failing or why.
I was just thinking: Why don't you provide me with an SQL statement which does the populating of the database, and I simply set everything up under SQL Server before actually doing the install of Umbraco and uBlogsy? That way, the data is in there (to avoid that SQL error), and the installation of uBlogsy can fill in the gaps.
I finally managed to open up that sdf file, and confirmed that the table in question is missing one-fifth of its entries. Specifically, the sdf file has 15 entries for cmsPropertyTypeGroups, whereas the table created by the uBlogsy installer creates only twelve entries. The entries for Subscriptions, Subscriber Info and Tags are missing.
Tentative conclusion: The uBlogsy installer has an error. It consistently fails to populate the database properly and/or completely.
Since I am using an SQL Server 2008 database with custom settings (location of files, etc.), how do I overcome this? Or how do I short-circuit the error process? I am completely unfamiliar with sdf files, and do not know how to apply the content of the sdf file I have to the SQL Server 2008 database that I have created.
I would prefer to use Umbraco to uninstall uBlogsy, apply the sdf file in some way to the already-existing database (to populate the tables, etc.), and then re-install uBlogsy. I am hoping that the already-configured database will allow uBlogsy to install successfully. Is anyone able to walk me through the steps to do this?
Opened up the sdf file using CompactView. Copied the SQL Schema over to SQL Server 2008, and tried to run as an SQL statement directly against the Umbraco database that I set up. Came across these errors:
Msg 102, Level 15, State 1, Line 505 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 505 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 508 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 508 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 511 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 511 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 514 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 514 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 520 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 520 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 523 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 523 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 526 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 526 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 532 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 532 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 535 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 535 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 541 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 541 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 550 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 550 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 562 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 562 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 568 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 568 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 571 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 571 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 580 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 580 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 583 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 583 Incorrect syntax near 'ACTION'. Msg 102, Level 15, State 1, Line 589 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Line 589 Incorrect syntax near 'ACTION'.
As an example, here are lines 501 through 505:
ALTER TABLE [cmsContentType2ContentType] ADD CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_parent] FOREIGN KEY ([parentContentTypeId]) REFERENCES [umbracoNode] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE [cmsContentTypeAllowedContentType] ADD CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType] FOREIGN KEY ([Id]) REFERENCES [cmsContentType] () ON DELETE NO ACTION ON UPDATE NO ACTION;
The only difference between the lines that failed and the lines that didn’t involve the contents of the brackets on the second line. They do not have any reference to any table columns. With what I know about SQL, this is bound to throw an error, as you need to reference *something*.
So… is this a problem in the uBlogsy setup, or is this a problem in the Umbraco setup?
Has everyone gone home for the weekend? Sure looks like it. All I’m hearing are crickets. Unfortunately, I cannot wait, so I am plowing ahead with what I can.
Deleted the old site, started fresh. New site, new database. But before I even tried to install uBlogsy, and after the Umbraco site was up and running, I extracted the data (data only export) from the sdf file (using CompactView) and tried to import the data into the database prior to uBlogsy being installed. No dice. Each and every insert statement produced an error, similar to the one below:
Msg 547, Level 16, State 0, Line 6746 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_cmsPreviewXml_cmsContent_nodeId". The conflict occurred in database "redacted", table "dbo.cmsContent", column 'nodeId'. The statement has been terminated.
I’m at a bit of a loss here. Why does the uBlogsy sdf file not contain content that populates the required database tables? (In the case above, cmsContent) Why the errors when trying to insert pure content from the sdf file? Isn’t this the sole source of data for when uBlogsy installs, and therefore, should produce an identical success/failure pattern no matter the method of installation?
I am at an absolute loss as to how to properly install uBlogsy. I have already tried about a dozen times to install it, with varying degrees of failure.
I am willing to allow someone connected with uBlogsy to connect via Teamviewer directly to my server, so that they can confirm that my server is set up correctly and see the installation failure occur in real-time. I believe that I have done everything correctly, and that this error is from elsewhere, either within Umbraco v6 or uBlogsy v3.
Since I connect to my server via RDP, any audio will have to be by phone.
There is definitely something wrong with your computer/db/setup.
I'm not a db expert, but I would personally start with security... Kill ALL security on your computer, then connecting to the db using the sa user account, NOT windows auth.
Get it working, then figure out why it doesnt work.
If you do figure out what is wrong, it would be good if you could write an article about it, or at least report back here as I've never seen that issue before.
When you are starting over to do a clean install of Umbraco and Ublogsy, are you deleting your database schema completely and recreating it? If not, you may want to try that. Or at least create another, new database for your clean install.
I am deleting the entire database, and creating a new one from scratch (and I also reset the whole web app by deleting the whole Umbraco install and starting that from scratch as well).
And while I don’t agree with it (and will be looking for a way to go back to Windows Auth once everything is running correctly), I have enabled SQL authentication for the short term. So there *is* a SQL account available for the install -- the Umbraco install is flawless (no problems with the DB config at all), it’s only the uBlogsy install where there is a problem. So I am having ZERO DB issues with Umbraco as a whole. It is only when I work with uBlogsy where I am running into problems.
Do other packages install correctly as well? Might be worth grabbing a few and making sure they all install correctly.
I'm presuming you are looking in the install log files to make sure that you have 'ZERO DB issues with Umbraco?
Regarding you using sql authentication then there is no benefit over using windows auth. It's really dependent on making sure you have decent complex passwords and keep your passwords safe etc . It really makes no difference using NTLM or the sql authentication.
Mods, please lock and close this particular thread -- I have moved on to WordPress. Granted, it meant installing PHP and MySQL on my system (it also doesn’t like Windows Auth for SQL Server, so I installed MySQL just for the PHP side of things), but it. Just. Works.
I will no longer be following and/or monitoring this particular thread.
Hopefully in the future, for a less critical blog, I will be able to try uBlogsy again. Unfortunately, my need for a fully functional blog *right now* was too great - I just couldn’t afford to waste time farking around to find where the problem is. I have a number of sites running on this server (ASP.NET 4.0 & SQL Server 2008), and *ALL* of them have ZERO db issues and no issues whatsoever with an SQL Server that has only Windows Auth enabled (no SQL Auth).
I just had one last thought. Rene, are you running asp.net in full trust? I'm not sure if not being in full trust could even cause this kind of error, was just a thought.
I've just ran into this problem, and it was caused by trying to install uBlogsy version 2.1.1.2 onto Umbraco 4.7.1. Once I upgraded the site to the latest version 4.11.8 then uBlogsy installed just fine.
Installation timed out.
Ran into a bit of a problem installing uBlogsy. Below is the TraceLog output:
Looks to be an issue with that last SQL statement. Suggestions?
Looks like a database issue.
Which version of ublogsy and umbraco?
Latest for each. This is a fresh and clean installation.
Well, looks like an sql error.
Try it on another clean install Perhaps another db/db server.
Tried another clean install, new db, same issue. Same crapout point.
Is there a way of manually installing Blogsy so that I can work past this particular error? Or, at least, figure out why it is happening?
Note: running SQL Server 2008 on Win2K8R2. All patches, all updates installed. Configured IIS correctly, with separate .NET 4.0 application pool just for this site, and named the same as this site.
With that said, I come from the security end of I.T., so I'm also having kittens that mixed-mode authentication is needed for Umbraco (specifically, that it *only* uses SQL authentication). With even Microsoft saying “don't use SQL authentication unless you have no other choice”, I find it very curious that Umbraco does not permit a properly-configured and secured database to be used. I already use Windows Authentication mode for several other apps on this server, and was rather put out when I had to take a big leap backward just to install Umbraco.
Installing package involves many many doctypes and content nodes etc... i wouldnt want to create those by hand.
I've tweeted.. hopefully an sqlserver guru will come along.
Couple of qq.
Did you get a yellow screen whilst installing? If so, do you have the error it gave?
Event logs. Do you have the event logs from both the web server and the sql server? (are they on separate boxes? if so whats the distance/ping between them, as it looks like something is trying to abort the SQL connection thread. and I'm wondering if its a timeout kinda thing, whats the timeout set to in your web.config? and how long were you waiting before the installation bombs out? )
<system.web>
<httpRuntime maxRequestLength="8092" executionTimeout="100000"/>
The error looks like something hasn't been created in the database that the installation expects. So that @contentTypeId doesn't have a contentTypeId in the cmsPropertyGroup table for whatever reason and is going tits up.
What priviliges did you give the sql account that has access to umbraco. Does the account have db_owner priviliges to the umbraco database in the securable tab under the login properties?
Also i'm presuming that Umbraco is working as normal - you can get into the back office and create content, templates, scripts etc. ??
I am running everything on one box. IIS & SQL Server. So it's not a timeout thing.
I created a special SQL authentication account just for Umbraco. It has all the needed rights, including db_owner. I can get into the back office to do those kinds of things -- that's where I am trying to install uBlogsy from - the Developer/Packages/Repository section. However, even downloading and installing uBlogsy from the Install Local Package tool creates the same error.
The only thing I can suggest is that you compare what is in your cmsPropertyTypeGroup table with someone who has a working copy of uBlogsy - i'm sure Anthony can help you out here. You can then maybe get more of a pointer as to what part of the installation is failing or why.
Thanks stephen and mark.
Rene, a sqlce db is in the source:
https://bitbucket.org/anthonydotnet/ublogsy/commits/branch/mvc
Sorry, Anthony. I am not familiar with bitbucket or uBlogsy, I am not sure what I am looking for or where to find it.
And here is the content of the table against which the SQL statement fails:
id parentGroupId contenttypeNodeId text sortorder
https://bitbucket.org/anthonydotnet/ublogsy/src/45794a0ec32bb6d8db9916d3da35b16a8a05f15d/Source/uBlogsy.Web/App_Data/Umbraco.sdf?at=mvc#
click Umbraco.sdf to download
I am unable to open that sdf file in either Visual Studio 2008 or SQL Server Management Studio 2008. How do I use it?
I was just thinking: Why don't you provide me with an SQL statement which does the populating of the database, and I simply set everything up under SQL Server before actually doing the install of Umbraco and uBlogsy? That way, the data is in there (to avoid that SQL error), and the installation of uBlogsy can fill in the gaps.
I finally managed to open up that sdf file, and confirmed that the table in question is missing one-fifth of its entries. Specifically, the sdf file has 15 entries for cmsPropertyTypeGroups, whereas the table created by the uBlogsy installer creates only twelve entries. The entries for Subscriptions, Subscriber Info and Tags are missing.
Tentative conclusion: The uBlogsy installer has an error. It consistently fails to populate the database properly and/or completely.
Since I am using an SQL Server 2008 database with custom settings (location of files, etc.), how do I overcome this? Or how do I short-circuit the error process? I am completely unfamiliar with sdf files, and do not know how to apply the content of the sdf file I have to the SQL Server 2008 database that I have created.
I would prefer to use Umbraco to uninstall uBlogsy, apply the sdf file in some way to the already-existing database (to populate the tables, etc.), and then re-install uBlogsy. I am hoping that the already-configured database will allow uBlogsy to install successfully. Is anyone able to walk me through the steps to do this?
Opened up the sdf file using CompactView. Copied the SQL Schema over to SQL Server 2008, and tried to run as an SQL statement directly against the Umbraco database that I set up. Came across these errors:
As an example, here are lines 501 through 505:
The only difference between the lines that failed and the lines that didn’t involve the contents of the brackets on the second line. They do not have any reference to any table columns. With what I know about SQL, this is bound to throw an error, as you need to reference *something*.
So… is this a problem in the uBlogsy setup, or is this a problem in the Umbraco setup?
Has everyone gone home for the weekend? Sure looks like it. All I’m hearing are crickets. Unfortunately, I cannot wait, so I am plowing ahead with what I can.
Deleted the old site, started fresh. New site, new database. But before I even tried to install uBlogsy, and after the Umbraco site was up and running, I extracted the data (data only export) from the sdf file (using CompactView) and tried to import the data into the database prior to uBlogsy being installed. No dice. Each and every insert statement produced an error, similar to the one below:
I’m at a bit of a loss here. Why does the uBlogsy sdf file not contain content that populates the required database tables? (In the case above, cmsContent) Why the errors when trying to insert pure content from the sdf file? Isn’t this the sole source of data for when uBlogsy installs, and therefore, should produce an identical success/failure pattern no matter the method of installation?
I am at an absolute loss as to how to properly install uBlogsy. I have already tried about a dozen times to install it, with varying degrees of failure.
I am willing to allow someone connected with uBlogsy to connect via Teamviewer directly to my server, so that they can confirm that my server is set up correctly and see the installation failure occur in real-time. I believe that I have done everything correctly, and that this error is from elsewhere, either within Umbraco v6 or uBlogsy v3.
Since I connect to my server via RDP, any audio will have to be by phone.
There is definitely something wrong with your computer/db/setup.
I'm not a db expert, but I would personally start with security... Kill ALL security on your computer, then connecting to the db using the sa user account, NOT windows auth.
Get it working, then figure out why it doesnt work.
In the mean time, here are 2 dbs:
https://docs.google.com/file/d/0Bxy95GRb59DMejhVZmp6TFpudHM/edit?usp=sharing
One is a clean umbraco 6.0.2 install, the other is the previous db with uBlogsy 3.0 installed.
btw the admin pw is admin
When you are starting over to do a clean install of Umbraco and Ublogsy, are you deleting your database schema completely and recreating it? If not, you may want to try that. Or at least create another, new database for your clean install.
I am deleting the entire database, and creating a new one from scratch (and I also reset the whole web app by deleting the whole Umbraco install and starting that from scratch as well).
And while I don’t agree with it (and will be looking for a way to go back to Windows Auth once everything is running correctly), I have enabled SQL authentication for the short term. So there *is* a SQL account available for the install -- the Umbraco install is flawless (no problems with the DB config at all), it’s only the uBlogsy install where there is a problem. So I am having ZERO DB issues with Umbraco as a whole. It is only when I work with uBlogsy where I am running into problems.
Do other packages install correctly as well? Might be worth grabbing a few and making sure they all install correctly.
I'm presuming you are looking in the install log files to make sure that you have 'ZERO DB issues with Umbraco?
Regarding you using sql authentication then there is no benefit over using windows auth. It's really dependent on making sure you have decent complex passwords and keep your passwords safe etc . It really makes no difference using NTLM or the sql authentication.
So far I have installed about four packages aside from uBlogsy, and I have had no issues with any of them.
The are,:
None of these threw any db errors.
Mods, please lock and close this particular thread -- I have moved on to WordPress. Granted, it meant installing PHP and MySQL on my system (it also doesn’t like Windows Auth for SQL Server, so I installed MySQL just for the PHP side of things), but it. Just. Works.
I will no longer be following and/or monitoring this particular thread.
Hopefully in the future, for a less critical blog, I will be able to try uBlogsy again. Unfortunately, my need for a fully functional blog *right now* was too great - I just couldn’t afford to waste time farking around to find where the problem is. I have a number of sites running on this server (ASP.NET 4.0 & SQL Server 2008), and *ALL* of them have ZERO db issues and no issues whatsoever with an SQL Server that has only Windows Auth enabled (no SQL Auth).
uBlogsy definitely does NOT do anything with sql.
It's a standard package like the umbraco blog and business package. It's just doctypes and content nodes.
One more thought... increase request timeout.
Rene. if you are still following this and want a blog in Umbraco, you may try Umbraco 4.11.5, with uBlogsy 2.1.x
I just had one last thought. Rene, are you running asp.net in full trust? I'm not sure if not being in full trust could even cause this kind of error, was just a thought.
Steve that's a good call. Not being in full trust can cause all types of crazy errors.
I've just ran into this problem, and it was caused by trying to install uBlogsy version 2.1.1.2 onto Umbraco 4.7.1. Once I upgraded the site to the latest version 4.11.8 then uBlogsy installed just fine.
is working on a reply...