• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Marcus
#1 Posted : Monday, April 13, 2009 10:16:22 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

BV Commerce 5.5 - Readme

Please read these instructions carefully because the installation routine for 5.4 and later is different from version 5.3 and earlier of BV Commerce. Skipping an installation step can prevent your store from working correctly so please read carefully.


What's New in 5.5

Mail To Link – Customer email addresses are now MailTo: links for faster communication with customers

Version Checking – Dashboad page now includes a version checker to help notify you when a patch is available for your store

Avalara AvaTax Service – A new optional subscription service that delivers up to date tax rates and report for your store.

Bug Fixes - All bug fixes and hot fixes after version 5.4 are included, See list of fixes at the bottom of this document for more information

.NET 3.5 SP1 Requirement - Make sure your web server has the .net framework version 3.5 sp1 or later installed first.


Install Instructions

The installation process for BV Commerce Service Pack 5 involves 2 main steps. 1) Copying the new files into your store and 2) Updating your database to the latest version.

You can run these 2 steps manually or let the installer program do them for you.

Instructions for these scenarios are listed below:

A) Create a new store on the local computer (if you want a demo store or are installing directly from a server login) PC ONLY
B) Create a new store on a remote web server (if you want to install the software are your hosting company) MAC and PC
C) Upgrade an existing store on the local computer PC ONLY
D) Upgrade an existing store on a remote web server MAC and PC
E) Upgrading from BVC 2004 to BV Commerce 5


A – Create a New Store on the Local Computer

1) Make sure your web site has the prerequisites for BV Commerce - (IIS6 or IIS7, .NET 3.5 sp1 or later, and SQL 2005 or SQL 2008)

2) Unzip the BVCommerce55.zip file to a temporary location on your computer.

3) Create a folder on your computer where you will keep a copy of your store and the source code required to build the store. Don't worry if you don't want the source code we can copy just the web site later if needed.

4) Gather your SQL Server login information. Either create a new blank database yourself or get the SQL Server, SQL Database name, SQL Username and SQL Password information from your web hosting company.

5) Run CreateNewStore.exe and click “Create New Store”

6) Fill in the information about your local folder and SQL database as requested by the program

7) If you are running on IIS7 open the "www" folder inside your install location and rename "web.config" to "web.iis6.config", then rename "web.iis7.config" to "web.config"

8) After the program completes you'll need to configure IIS.

9) Run the IIS manager program and create a new web site or application folder that points the "www" folder inside the install location you selected.

10) Open up your web store in a browser.

11) You'll be prompted to run a SQL Script that will create the store database. Click the button to create the store database

12) Your store should now be at the home page. Click the "Sign In" link to access the administrator side

12a) - The default username is "admin" and the default password is "password"


B – Create a New Store on a Remote Web Server

1) Unzip the BVCommerce55.zip file to a temporary location on your computer.

2) Go to the location on your computer where you unzipped the files and open the /src/www folder

3) If your web hosting in on Windows 2008, rename "web.config" to "web.iis6.config", then rename "web.iis7.config" to "web.config"

4) Gather your SQL Server login information. Either create a new blank database yourself or get the SQL Server, SQL Database name, SQL Username and SQL Password information from your web hosting company.

5) Using a text editor like Notepad or TextEdit open the web.config file. Look for the section that starts with <connectionStrings> and look for the tag that starts with <add name=”Bvc5Database”. This is the SQL connection string setting and you’ll need to update it manually with your information.

SQL Server: MyServer
SQL Database: MyDatabaseBV5
Username: SampleUser
Password: Password

Using the above sample information the tag in your web.config should look like this after you update it:

<add name="Bvc5Database" connectionString=”server=MyServer;database=MyDatabaseBV5;uid=SampleUser;pwd=Password;"/>

If you need assistance with your connection string visit http://www.connectionstrings.com for examples.


6) Using FTP or whatever method your hosting company provides, copy all of the files in the "/src/www" folder to the root of your hosting company web site.

7) Open up your web store in a browser

8) You'll be prompted to run a SQL Script that will create the store database. Click the button to create the store database

9) Your store should now be at the home page. Click the "Sign In" link to access the administrator side

10) - The default username is "admin" and the default password is "password"


C – Upgrade an Existing Store on the Local Computer

1) Make sure your web site has the prerequisites for BV Commerce - (IIS6 or IIS7, .NET 3.5 sp1 or later, and SQL 2005 or SQL 2008)

2) Unzip the BVCommerce55.zip file to a temporary location on your computer.

3) Create a folder on your computer where you will keep a copy of the source code required to build the store.

4) Run CreateNewStore.exe and click “Update 5.x Store”

5) Fill in the information about where your current store is located, where you want to install the source code and where you want to backup your current files that may be overwritten.

6) Click “Start Upgrade”

7) Open up your web store in a browser.

8) You'll be prompted to run a SQL Script that will create the store database. Click the button to create the store database

9) Your store should now be at the home page. Click the "Sign In" link to access the administrator side

10) Login with your existing username and password and your store should show the message “Your store is up to date.” In the left column on the admin dashboard.


D – Upgrade an Existing Store on a Remote Web Server

1) Unzip the BVCommerce55.zip file to a temporary location on your computer.

2) Go to the location on your computer where you unzipped the files and open the /src/www folder

3) Delete the web.config and web.ii7.config files so that they won’t be accidentally uploaded to your web server. Doing this may overwrite your existing database connection information.

4) Using FTP or whatever method your hosting company provides, copy all of the files in the "/src/www" folder to the root of your hosting company web site.

5) Open up your web store in a browser

6) You'll be prompted to run a SQL Script that will create the store database. Click the button to create the store database

7) Your store should now be at the home page. Click the "Sign In" link to access the administrator side

8) Login with your existing username and password and your store should show the message “Your store is up to date.” In the left column on the admin dashboard.


E – Upgrading from BVC2004

BV Commerce 5 and BV Commerce 2004 are built on different versions of the .net framework. When you upgrade from BVC 2004 you install a separate, new BV Commerce 5 store and then migrate your data to the new store. This process also requires changes to your store theme/design and is usually best handled by a design and developer who are familiar with the software.

Free data migration tools are available in the forums at http://forums.bvcommerce.com but we recommend that merchants who are not comfortable with programming and SQL databases use a developer partner at http://www.bvsoftware.com/partners to assist with the upgrade process.

If you’re comfortable working with code and SQL databases this is a high level overview of the upgrade process:

1) Install a new BV Commerce 5 store
2) Use the data migration tools from http://forums.bvcommerce.com to move over data
3) Manually port over the old BVC 2004 theme or use a new BV Commerce 5 theme
4) Test the new store
5) Close the BVC 2004 store and BV5 store
6) Run the data migration tool AGAIN while the bvc 2004 store is closed to make sure you port over any orders created while you were testing the BV5 store.
7) Open the BV5 store
8) If the BV5 store fails for any reason you should close the BV5 store and re-open the BVC2004 store. Repeat steps 2 through 7 if needed.



List of Bugs/Issues Corrected Version 5.5

Resolved - Fixed
Hot Fix B: Products with Inventory Variants not displaying correctly under some circumstances
Hot Fix C: Inventory Levels not saving correctly for products with inventory tracking variants
Hot Fix D: Gift Certificate Expiration Date not checked during checkout
Hot Fix E: Password regex on MyAccount_ChangeEmail.aspx / MyAccount_ChangePassword.aspx has hard coded min password length of 6
Hot Fix F: Reset Password is sending new encrypted password instead of plain text version
Hot Fix G: View Order Page in Admin can break when products are no longer in the store database
Hot Fix H: PayPal sending incorrect money format for Express Checkout non-US locales
FIXED: SQL Patcher adds event log entry even when not running updates
FIXED: Changes to custom properties on LineItem do not set dirty flag
FIXED: BVAdmin/Configuration/GiftCertificates.aspx defaults back to '30' days when you re-visit the page, even if you have changed it to '0' and saved.
FIXED: Multi Cart when cart is empty isn't displaying contents on http://www.domain.com/ca...ti=product2:2;product1:1
FIXED: Can't deactivate gift certificate by changing expiration date to long in the past
FIXED: EventValidation with Coupon Code Removal on Cart Page (Gridview enableviewstate="false" id=CouponGrid)
FIXED: ImageRadioButton List not setting value correctly, radioButton.Value = choiceOption.Bvin
FIXED: Kitting and Merge Identical Items broken
FIXED: When buying 1 shipping and 1 non-shipping items the per-item ship rate is calculating 2 instead of one. Individually, they work fine.
FIXED: Google Checkout is charging shipping costs on non-shipping items
FIXED: Anthem needs IE8 meta tag: <meta content=”IE=EmulateIE7” http-equiv=”X-UA-Compatible” />
FIXED: BOGO offer is reported to not correctly calculate when going from (1 paid, 1 free) to (4 with 2 paid, 2 free)
NEW: Avalara Tax Service Included
NEW: Mailto: links added on admin order screens_
HPros
#2 Posted : Tuesday, April 14, 2009 7:39:27 PM(UTC)
HPros

Rank: Member

Joined: 1/30/2008(UTC)
Posts: 215

Please also include a list of changed files for those of us with customizations.
Andy Miller
#3 Posted : Wednesday, April 15, 2009 1:33:53 AM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
Skip the list. Use Beyond Compare.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
Marcus
#4 Posted : Wednesday, April 15, 2009 6:33:01 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Andy's right. What you really what to know is "what's different between my store and BV 5.5"

Beyond Compare from http://www.scootersoftware.com is a really cheap way to generate this information. It lets you browse to folders side by side and compare the contents. Even better, it lets you view the files that are different line by line to see what's changed in a specific file.

There are a lot of other utilities that do this but I happen to like Beyond Compare and think it's really easy to use.
MitchA
#5 Posted : Wednesday, April 15, 2009 7:26:17 AM(UTC)
MitchA

Rank: Member

Joined: 3/3/2006(UTC)
Posts: 1,737

Will Beyond Compare find the files that are different, or do you need to manually select suspect files for examination? If the later, a list of files would be a useful thing to have.
Optimists invent airplanes,
Pessimists buy parachutes.
PeterP
#6 Posted : Wednesday, April 15, 2009 7:42:25 AM(UTC)
PeterP

Rank: Member

Joined: 9/17/2008(UTC)
Posts: 22

Sorry for stupid question.... but I do not see it when I check my order history, I still see only 5.4... I am sorry in advance if I just missed it,


Let me know and Thank you
Marcus
#7 Posted : Wednesday, April 15, 2009 7:57:35 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Mitch,

Beyond compare will show which files are different, which files are new, which files are missing between folders and also which files are the same or similar (white space only). I really recommend it for applying service packs if you have customized anything. I think it's only $30.

Peter,
Service Pack 5.5 will be available tomorrow. 5.4 is the only thing you'll see in your account until tomorrow.
PeterP
#8 Posted : Wednesday, April 15, 2009 8:18:34 AM(UTC)
PeterP

Rank: Member

Joined: 9/17/2008(UTC)
Posts: 22

Thanks a lot guys....

Is Beyond Compare much different then Windiff which is free from microsoft?

Just a quick thought.
Marcus
#9 Posted : Wednesday, April 15, 2009 10:53:47 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Windiff is a free alternative. I prefer to support people like Scooter Software who are providing a great value for the money. It encourages ongoing development and helps everyone. I use free software at times but find long term that vendor supported software wins out.
Matt@9BallDesign
#10 Posted : Wednesday, April 15, 2009 11:13:04 AM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

I've found it extremely useful over the years to keep a change log for each site I've developed.

1. File Name &gt; Quick Summary
2. File Name &gt; Quick Summary
3. File Name &gt; Quick Summary
....
....

Upgrade = Archive existing site files, create new directory, install upgrade version

Archive Directory Structure looks like this:

BVSITE.5.4/
BVSITE.3.4/
BVSITE.3.2/

Change log points me to my changes, 2 cups of coffee and the phone turned off.

I've used Araxis Merge from time to time, but beyondcompare beats the price!
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative &amp; Builder's Hardware

------------------------------------------------
Chris Dittmeier
#11 Posted : Wednesday, April 15, 2009 11:23:08 PM(UTC)
Chris Dittmeier

Rank: Member

Joined: 1/3/2004(UTC)
Posts: 1,497

I use FolderMatch.
Chris
Sirius Programming

www.siriusprogramming.com
BMFResposio
#12 Posted : Thursday, April 16, 2009 4:40:22 AM(UTC)
BMFResposio

Rank: Member

Joined: 3/15/2007(UTC)
Posts: 126

Heh I use a 24 inch monitor and a 24 oz cup of coffee. The ole 24/24 Helps me find what I am looking for :)
ttillman
#13 Posted : Thursday, April 16, 2009 1:58:33 PM(UTC)
ttillman

Rank: Member

Joined: 4/10/2009(UTC)
Posts: 120
Location: Mechanicsville, VA

Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
6:30am.... what is Brendon doing? Checking the forums... oh yeah.... :)

Then again, Chris was on at 1:30am.... so.... I'm not sure which is worse.


Tim
DidiahProd
#14 Posted : Thursday, April 16, 2009 4:50:05 PM(UTC)
DidiahProd

Rank: Member

Joined: 7/18/2004(UTC)
Posts: 13

Beyond Compare is awesome. it's my primary FTP tool, local file compare app, backup system, and remote compare tool. price of the software is a steal.
Chris Dittmeier
#15 Posted : Friday, April 17, 2009 9:26:17 AM(UTC)
Chris Dittmeier

Rank: Member

Joined: 1/3/2004(UTC)
Posts: 1,497

It was only 11:30 pm for me.
Chris
Sirius Programming

www.siriusprogramming.com
Surfscience
#16 Posted : Wednesday, April 29, 2009 4:01:19 AM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66

I tried upgrading a brand new install of 3.2 I already had set up on our dev machine (nothing changed after a default install) and the 5.5 store upgrader throws a collation error when it gets to the automated DB updates:

Code:

Column 'dbo.bvc_Product.bvin' is not of same collation as referencing column 'bvc_KitPart.ProductBvin' in foreign key 'FK_bvc_KitPart_bvc_Product'.
Could not create constraint. See previous errors.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Column 'dbo.bvc_Product.bvin' is not of same collation as referencing column 'bvc_KitPart.ProductBvin' in foreign key 'FK_bvc_KitPart_bvc_Product'.
Could not create constraint. See previous errors.

Stack Trace:

[SqlException (0x80131904): Column 'dbo.bvc_Product.bvin' is not of same collation as referencing column 'bvc_KitPart.ProductBvin' in foreign key 'FK_bvc_KitPart_bvc_Product'.
Could not create constraint. See previous errors.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.RunSingleStatement(String statement, SqlConnection& c) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:545
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:533
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile, String& ErrorMessage) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:510
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:524
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:35
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in C:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:42
SqlPatch.StartButton_Click(Object sender, EventArgs e) +20
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
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.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012