BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Problem upgrading to 5.4 - No Payment Gateways!!!
Rank: Member
Joined: 7/3/2007(UTC)
Posts: 79
|
Hi there,
I know there've been a few posts about this but I haven't seen anyway to fix this yet. I'm trying to upgrade on a test site from 5.3.2 to 5.4 but am not getting anywhere!
When I run the upgrade script from the folder www\BVAdmin\BVSql\SP4 it always fails and I get the following errors:
Adding foreign keys to [dbo].[bvc_KitPart]
[red]Msg 1757, Level 16, State 0, Line 1
Column 'dbo.bvc_Product.bvin' is not of same collation as referencing column 'bvc_KitPart.ProductBvin' in foreign key 'FK_bvc_KitPart_bvc_Product'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
[/red]
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_KitComponent]
[red]Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.bvc_KitComponent" because it does not exist or you do not have permissions.
[/red]
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_KitGroup]
[red]Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.bvc_KitGroup" because it does not exist or you do not have permissions.
[/red]
(1 row(s) affected)
The database update failed
Any help would be greatly appreciated....
Kind Regards,
Jason
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
The SQL scripts specify the collation. For example, Code:ALTER TABLE [dbo].[bvc_KitPart] ALTER COLUMN [ProductBvin] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL You will need to change the collation to match what is in your database. You can discover the existing collation using a tool like SQL Server Management Studio Express. For example, here are the properties for the products ID field in my database, http://screencast.com/t/XpnAAhlKFhNotice that the collation matches the value in the script. In your case, it will be different. Just copy and paste the value that you are using into the SQL script. |
|
|
|
|
|
|
Rank: Member
Joined: 7/3/2007(UTC)
Posts: 79
|
Thanks for your help Andy, I've now managed to upgrade to 5.4.
However... I now have a new problem... all the payment methods have disappeared since upgrading! All I can see under Options > Payment is "Sign up for Paypal & Google Checkout"!!
Does anyone know how to resolve this please?
Kind Regards,
Jason
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
All of the payment gateways are loaded during startup by a file called TaskLoader.vb in the App_Code directory. If you are missing the file, upload another copy. Inside the file, you should be able to find a method called LoadCreditCardGateways. The beginning looks like this: Code: Public Shared Function LoadCreditCardGateways() As Collection(Of Payment.CreditCardGateway)
Dim result As New Collection(Of Payment.CreditCardGateway)
LoadCustomCreditCardGateways(result)
'result.Add(New BVSoftware.Bvc5.Payment.AuthorizeNet.AuthorizeNetProvider)
result.Add(New BVSoftware.Bvc5.Payment.ACHDirect.ACHDirectProvider)
result.Add(New Payment.Gateways.BVTestGateway)
result.Add(New Payment.Gateways.ManualGateway) If your copy is missing the "result.Add(..." lines, then upload a new copy. |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.