Cannot find or add Product Catalog after installing demo store
Hello,
I've installed a fresh copy of umbraco 4.5.1 on the ASP.NET 4 platform, and subsequently uCommerce 1.0.4.1 & uCommerce Store 1.0.1.2 without problems.
I can set the hostname on the 'uCommerce' node in the Content section, as detailed in the 2nd video (FAQ section).
However, when I go to the "Commerce" Section , and try to expand the "Product Catalog" tree , it returns no sub-nodes !? In the video it shows a "uCommerce.dk" subnode, but I cannot see it. It's in the Database however, I've checked the table "uCommerce_ProductCatalogGroup" and there is 1 record present. I can even add a second catalog, but they never display in the tree navigation ...
I've tried on 2 completely different servers (both IIS 6 , Win 2K3) with the same result ...
A bug was discovered in version 1.0.4.1 when running uCommerce with Umbraco 4.5 and access the back office from a remote machine causing the issue you describe. If you make sure to access the admin module from localhost you should see all the nodes popping up properly. A fix is in the works.
Asp.Net 3.5, Ms Sql server 2005 , windows Vista. The first time I installed Ucommerce 1.0.4.2 , I followed all the steps in the video and it all went well except for when I opened the link to the actual store. I could see the links " login" and "order history" and the text " your basket is empty", but the "ucommerce" link isn't there. But in umbraco I could see the nodes under " Product catalog".
I uninstalled everything and installed it again, and now I can't see the nodes under "Product catalog". I am accessing the admin module from localhost.
Once uCommerce and the uCommerce Store is installed you need to configure the store to be used with a content site. The following screencast shows you how to do so Watch Installing and Configuring uCommerce Store.
As for no nodes showing up under the Product Catalog after the second install could you please check the table umbracoLog and see if uCommerce has logged any errors during install and post them back to me?
I watched the video for installing ucommerce, then the one for installing and configuring uCommerce Store, did it for each installation.
errors:
Package install error: System.IO.FileNotFoundException: Could not find file 'C:\inetpub\wwwroot\data\561efaf5-a576-457f-8cbf-7ad7db597583\UCommerce.gif'. File name: 'C:\inetpub\wwwroot\data\561efaf5-a576-457f-8cbf-7ad7db597583\UCommerce.gif' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.Move(String sourceFileName, String destFileName) at umbraco.cms.businesslogic.packager.Installer.InstallFiles(Int32 packageId, String tempDir) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\cms\businesslogic\Packager\Installer.cs:line 213
Error in uCommerce.DbInstaller.InstallDatabase() script:C:\inetpub\wwwroot\umbraco\ucommerce\install\uCommerceDB.001.sql, error: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'uCommerce_PK_PaymentStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_PaymentStatus'. Violation of PRIMARY KEY constraint 'uCommerce_PK_ProductDefinition'. Cannot insert duplicate key in object 'dbo.uCommerce_ProductDefinition'. Violation of PRIMARY KEY constraint 'uCommerce_PK_ProductDefinition'. Cannot insert duplicate key in object 'dbo.uCommerce_ProductDefinition'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Customer'. Cannot insert duplicate key in object 'dbo.uCommerce_Customer'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Customer'. Cannot insert duplicate key in object 'dbo.uCommerce_Customer'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Customer'. Cannot insert duplicate key in object 'dbo.uCommerce_Customer'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'. Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'. Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'. Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'. Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'. Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert dup...
It looks like there may be a permission issue with the user running your Umbraco install. It needs access to the Umbraco install for writing files and moving them around. Interestingly when you reinstall uCommerce it will pick up which database version you're running and not reinstall that so I'm a bit puzzled that it appears to be trying to do just that.
At this point I think a clean install is the easier option rather than debugging your install.
Cannot find or add Product Catalog after installing demo store
Hello,
I've installed a fresh copy of umbraco 4.5.1 on the ASP.NET 4 platform, and subsequently uCommerce 1.0.4.1 & uCommerce Store 1.0.1.2 without problems.
I can set the hostname on the 'uCommerce' node in the Content section, as detailed in the 2nd video (FAQ section).
However, when I go to the "Commerce" Section , and try to expand the "Product Catalog" tree , it returns no sub-nodes !? In the video it shows a "uCommerce.dk" subnode, but I cannot see it. It's in the Database however, I've checked the table "uCommerce_ProductCatalogGroup" and there is 1 record present. I can even add a second catalog, but they never display in the tree navigation ...
I've tried on 2 completely different servers (both IIS 6 , Win 2K3) with the same result ...
I'm kinda at a loss here, please advise,
Thanks !
Mike
Hi Mike,
A bug was discovered in version 1.0.4.1 when running uCommerce with Umbraco 4.5 and access the back office from a remote machine causing the issue you describe. If you make sure to access the admin module from localhost you should see all the nodes popping up properly. A fix is in the works.
The fix is implemented and being tested by partners at the moment.
Upgrading to 1.0.4.2 indeed fixed the issue for me ...
Thanks.
Wonderful! Could you please mark this thread as solved? Thanks.
Hi,
I have umbraco v 4.0.4.2
Asp.Net 3.5, Ms Sql server 2005 , windows Vista. The first time I installed Ucommerce 1.0.4.2 , I followed all the steps in the video and it all went well except for when I opened the link to the actual store. I could see the links " login" and "order history" and the text " your basket is empty", but the "ucommerce" link isn't there. But in umbraco I could see the nodes under " Product catalog".
I uninstalled everything and installed it again, and now I can't see the nodes under "Product catalog". I am accessing the admin module from localhost.
Once uCommerce and the uCommerce Store is installed you need to configure the store to be used with a content site. The following screencast shows you how to do so Watch Installing and Configuring uCommerce Store.
As for no nodes showing up under the Product Catalog after the second install could you please check the table umbracoLog and see if uCommerce has logged any errors during install and post them back to me?
Hi Søren,
I watched the video for installing ucommerce, then the one for installing and configuring uCommerce Store, did it for each installation.
errors:
Package install error: System.IO.FileNotFoundException: Could not find file 'C:\inetpub\wwwroot\data\561efaf5-a576-457f-8cbf-7ad7db597583\UCommerce.gif'.
File name: 'C:\inetpub\wwwroot\data\561efaf5-a576-457f-8cbf-7ad7db597583\UCommerce.gif'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.Move(String sourceFileName, String destFileName)
at umbraco.cms.businesslogic.packager.Installer.InstallFiles(Int32 packageId, String tempDir) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\cms\businesslogic\Packager\Installer.cs:line 213
Error in uCommerce.DbInstaller.InstallDatabase() script:C:\inetpub\wwwroot\umbraco\ucommerce\install\uCommerceDB.001.sql, error: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'uCommerce_PK_PaymentStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_PaymentStatus'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_ProductDefinition'. Cannot insert duplicate key in object 'dbo.uCommerce_ProductDefinition'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_ProductDefinition'. Cannot insert duplicate key in object 'dbo.uCommerce_ProductDefinition'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_DataType'. Cannot insert duplicate key in object 'dbo.uCommerce_DataType'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Customer'. Cannot insert duplicate key in object 'dbo.uCommerce_Customer'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Customer'. Cannot insert duplicate key in object 'dbo.uCommerce_Customer'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Customer'. Cannot insert duplicate key in object 'dbo.uCommerce_Customer'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Currency'. Cannot insert duplicate key in object 'dbo.uCommerce_Currency'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_Country'. Cannot insert duplicate key in object 'dbo.uCommerce_Country'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert duplicate key in object 'dbo.uCommerce_OrderStatus'.
Violation of PRIMARY KEY constraint 'uCommerce_PK_OrderStatus'. Cannot insert dup...
Thanks for the reply.
It looks like there may be a permission issue with the user running your Umbraco install. It needs access to the Umbraco install for writing files and moving them around. Interestingly when you reinstall uCommerce it will pick up which database version you're running and not reinstall that so I'm a bit puzzled that it appears to be trying to do just that.
At this point I think a clean install is the easier option rather than debugging your install.
is working on a reply...