Search Forum Home   DotNetNuke  CATALooK.netStore  Order number: 0...  Order number: 0    3/20/2009 11:03:02 PM tkussner 2 posts Order number: 0 I just upgraded catalook and DNN to the latest versions.  4.9.2 on DNN.  When I test the ordering system everything works fine except the Order Number is 0 and it doesn't record the order.  Any ideas?  3/23/2009 4:49:20 AM Dirty Dog Web Design 171 posts DirtyDogWebDesign.com Re: Order number: 0 you should probably just try to re-install the catalook module packages before you go crazy hunting down the issue. Sometimes it has a malformed install that will cause rogue problems. If that doesn't do the trick, you could always run a script to change the order number and test to see if the '0' is causing the issues....although it shouldn't care. script is below and will change the next order number to be 186741 -- script start ALTER TABLE {databaseOwner}CAT_Orders DROP CONSTRAINT FK_CAT_Orders_Users GO ALTER TABLE {databaseOwner}CAT_Orders DROP CONSTRAINT DF_CAT_Orders_OrderDate GO if exists (select * from sysobjects where id = object_id(N'{databaseOwner}[DF_CAT_Orders_PurchaseOrderNumber]') and OBJECTPROPERTY(id, N'IsForeignKey') = 0) ALTER TABLE {databaseOwner}[CAT_Orders] DROP CONSTRAINT DF_CAT_Orders_PurchaseOrderNumber GO CREATE TABLE {databaseOwner}Tmp_CAT_Orders ( OrderID int NOT NULL IDENTITY (186740, 1), CustomerID int NOT NULL, OrderDate datetime NOT NULL, ShipDate datetime NULL, ShipToID int NULL, PaymentType nvarchar(50) NULL, PaymentState nvarchar(200) NULL, ShipCosts money NULL, ShipTax decimal(5, 2) NULL, PurchaseOrderNumber nvarchar(255) NOT NULL, ShipTax2 decimal(7, 4) NOT NULL Default (0) ) ON [PRIMARY] GO ALTER TABLE {databaseOwner}Tmp_CAT_Orders ADD CONSTRAINT DF_CAT_Orders_OrderDate DEFAULT (getdate()) FOR OrderDate GO ALTER TABLE {databaseOwner}Tmp_CAT_Orders ADD CONSTRAINT DF_CAT_Orders_PurchaseOrderNumber DEFAULT ('') FOR PurchaseOrderNumber GO SET IDENTITY_INSERT {databaseOwner}Tmp_CAT_Orders ON IF EXISTS(SELECT * FROM {databaseOwner}CAT_Orders) EXEC('INSERT INTO {databaseOwner}Tmp_CAT_Orders (OrderID, CustomerID, OrderDate, ShipDate, ShipToID, PaymentType, PaymentState, ShipCosts, ShipTax, PurchaseOrderNumber, ShipTax2) SELECT OrderID, CustomerID, OrderDate, ShipDate, ShipToID, PaymentType, PaymentState, ShipCosts, ShipTax, PurchaseOrderNumber, ShipTax2 FROM {databaseOwner}CAT_Orders') SET IDENTITY_INSERT {databaseOwner}Tmp_CAT_Orders OFF GO ALTER TABLE {databaseOwner}CAT_OrderDetails DROP CONSTRAINT FK_CAT_OrderDetails_Orders GO DROP TABLE {databaseOwner}CAT_Orders GO EXECUTE sp_rename N'{databaseOwner}Tmp_CAT_Orders', N'CAT_Orders', 'OBJECT' GO ALTER TABLE {databaseOwner}CAT_Orders ADD CONSTRAINT PK_CAT_Orders PRIMARY KEY CLUSTERED ( OrderID ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX IX_CAT_Orders ON {databaseOwner}CAT_Orders ( CustomerID, OrderDate ) ON [PRIMARY] GO ALTER TABLE {databaseOwner}CAT_Orders WITH NOCHECK ADD CONSTRAINT FK_CAT_Orders_Users FOREIGN KEY ( CustomerID ) REFERENCES {databaseOwner}{objectQualifier}Users ( UserID) ON DELETE CASCADE NOT FOR REPLICATION GO ALTER TABLE {databaseOwner}CAT_OrderDetails WITH NOCHECK ADD CONSTRAINT FK_CAT_OrderDetails_Orders FOREIGN KEY ( OrderID ) REFERENCES {databaseOwner}CAT_Orders ( OrderID ) ON DELETE CASCADE NOT FOR REPLICATION GO -- script end Kind Regards, Aric Roy Dirty Dog Web Design  3/23/2009 4:51:38 AM Dirty Dog Web Design 171 posts DirtyDogWebDesign.com Re: Order number: 0 that came out like crap!! don't use as is unless you know SQL. Use this one..hopefully it posts correctly. -- script start ALTER TABLE {databaseOwner}CAT_Orders DROP CONSTRAINT FK_CAT_Orders_Users GO ALTER TABLE {databaseOwner}CAT_Orders DROP CONSTRAINT DF_CAT_Orders_OrderDate GO if exists (select * from sysobjects where id = object_id(N'{databaseOwner}[DF_CAT_Orders_PurchaseOrderNumber]') and OBJECTPROPERTY(id, N'IsForeignKey') = 0) ALTER TABLE {databaseOwner}[CAT_Orders] DROP CONSTRAINT DF_CAT_Orders_PurchaseOrderNumber GO CREATE TABLE {databaseOwner}Tmp_CAT_Orders ( OrderID int NOT NULL IDENTITY (186740, 1), CustomerID int NOT NULL, OrderDate datetime NOT NULL, ShipDate datetime NULL, ShipToID int NULL, PaymentType nvarchar(50) NULL, PaymentState nvarchar(200) NULL, ShipCosts money NULL, ShipTax decimal(5, 2) NULL, PurchaseOrderNumber nvarchar(255) NOT NULL, ShipTax2 decimal(7, 4) NOT NULL Default (0) ) ON [PRIMARY] GO ALTER TABLE {databaseOwner}Tmp_CAT_Orders ADD CONSTRAINT DF_CAT_Orders_OrderDate DEFAULT (getdate()) FOR OrderDate GO ALTER TABLE {databaseOwner}Tmp_CAT_Orders ADD CONSTRAINT DF_CAT_Orders_PurchaseOrderNumber DEFAULT ('') FOR PurchaseOrderNumber GO SET IDENTITY_INSERT {databaseOwner}Tmp_CAT_Orders ON IF EXISTS(SELECT * FROM {databaseOwner}CAT_Orders) EXEC('INSERT INTO {databaseOwner}Tmp_CAT_Orders (OrderID, CustomerID, OrderDate, ShipDate, ShipToID, PaymentType, PaymentState, ShipCosts, ShipTax, PurchaseOrderNumber, ShipTax2) SELECT OrderID, CustomerID, OrderDate, ShipDate, ShipToID, PaymentType, PaymentState, ShipCosts, ShipTax, PurchaseOrderNumber, ShipTax2 FROM {databaseOwner}CAT_Orders') SET IDENTITY_INSERT {databaseOwner}Tmp_CAT_Orders OFF GO ALTER TABLE {databaseOwner}CAT_OrderDetails DROP CONSTRAINT FK_CAT_OrderDetails_Orders GO DROP TABLE {databaseOwner}CAT_Orders GO EXECUTE sp_rename N'{databaseOwner}Tmp_CAT_Orders', N'CAT_Orders', 'OBJECT' GO ALTER TABLE {databaseOwner}CAT_Orders ADD CONSTRAINT PK_CAT_Orders PRIMARY KEY CLUSTERED ( OrderID ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX IX_CAT_Orders ON {databaseOwner}CAT_Orders ( CustomerID, OrderDate ) ON [PRIMARY] GO ALTER TABLE {databaseOwner}CAT_Orders WITH NOCHECK ADD CONSTRAINT FK_CAT_Orders_Users FOREIGN KEY ( CustomerID ) REFERENCES {databaseOwner}{objectQualifier}Users ( UserID) ON DELETE CASCADE NOT FOR REPLICATION GO ALTER TABLE {databaseOwner}CAT_OrderDetails WITH NOCHECK ADD CONSTRAINT FK_CAT_OrderDetails_Orders FOREIGN KEY ( OrderID ) REFERENCES {databaseOwner}CAT_Orders ( OrderID ) ON DELETE CASCADE NOT FOR REPLICATION GO -- script end Kind Regards, Aric Roy Dirty Dog Web Design  4/8/2009 3:35:11 PM jdudley 4 posts Re: Order number: 0 I am having the same issue. What did you do to fix it the script doesnt work for me.  4/8/2009 4:10:05 PM tkussner 2 posts Re: Order number: 0 I reverted to my back up copy of the older version.  Everytime I upgraded I ran into a new error so I just gave up. Sorry :(  4/8/2009 7:46:16 PM jdudley 4 posts Re: Order number: 0 I sent an email to support and they sent me back some new versions of the modules. I installed that and everything seems to be fine.  Page 1 of 1   DotNetNuke  CATALooK.netStore  Order number: 0... Flat View Tree View Oldest To Newest Newest To Oldest