BV Commerce Forum
»
BV Commerce Support
»
General Support
»
upgrading existing store on remote server.
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
Hi, I am upgrading my site from 5.3.2 to 5.5
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">D – Upgrade an Existing Store on a Remote Web Server<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">1) Unzip the BVCommerce55.zip file to a temporary location on your computer.<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">2) Go to the location on your computer where you unzipped the files and open the /src/www folder<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">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.<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">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.<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">5) open up your web store in a browser<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">6) You'll be prompted to run a SQL script that will create the store database. Click the button to create the store database<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">7) Your store should now be at the home page. Click the "Sign In" link to access the administrator side<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">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.<o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p>---------------------------------------------------------------------------------------------------</o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'"><o:p>
I have run steps 1-5 but when I open the store I am not prompted to run the SQL script in step [6]? Can I run this manually?
Thanks,
Derek
</o:p> |
|
|
|
|
|
|
Rank: Member
Joined: 3/15/2007(UTC)
Posts: 126
|
Hey Derek, Technically, All you really need to do is merge the files and the open your browser to your site. BV will install the correct DB updates that your site will need. All you need to do is push the button when prompt to update the DB. Oh also if you don't get the site to run the patch then type in your store domain name + /sqlpatch.aspx and that will trigger the SQL update, if needed. ex. www.iloveresposio.com/sqlpatch.aspxHope that helps if not shoot me an email. |
|
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
Excellent...thanks Brendon!
Much appreciated!
Derek |
|
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
I have tried to run the www.mysite.com/sqppatch.aspx directly on the existing site but I get the error....even though the files are confirmed to be there on the remote host. Thanks, Derek <H1>Server Error in '/' Application. <HR width="100%" color=silver SIZE=1> </H1> <H2> The resource cannot be found. </H2> <FONT face=Verdana>Descript<b>ion: </B>HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /sqlpatch.aspx </FONT> |
|
|
|
|
|
|
Rank: Member
Joined: 3/15/2007(UTC)
Posts: 126
|
I would check your host and make sure they have given you access to the files as long as you have determined the sqlpatch.aspx file exists on the server, in the root folder. |
|
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
Thanks Brendon, I have confirmed that the site does have acces to that file.
Is there not a SQL script that I could just manually run against the db using SQL Server Management Stusio Express....I am used to doing that.
Also, I would assume there should be 2 scripts, one for upgrade of existing store and one for new store.
Thanks,
Derek |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Derek,
There are SQL patches in /BVAdmin/BVSQL folder. If you have version 3.2 you would need to run the SP4 and SP5 patches in that order.
|
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
Thanks Marcus!
Question, when running 5.4 and then 5.5 scripts does it matter which script within each folder I run first...datascript and schemascript?
Also, if I wany to do a full install I imagine I run all scripts in the full folder only and again, does it matter which order?
Thanks,
Derek |
|
|
|
|
|
|
Rank: Member
Joined: 3/15/2007(UTC)
Posts: 126
|
-Start with folder above current version
-Run Scheme Script First
-Run Data Script Second
-Repeat for all folders until SP5 done
Obviously do not run the scripts your current version. So if you are at SP 2 start with the SP 3 folders. |
|
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
Awesome Brendon....that's exactly what I was after!
One more question: If I were to do a fresh install of full 5.5 only, what would be the order to run the scripts within the /full folder? There are 4 scripts in total; createfunction, creatreprocedures, createtables and populatedata.
Thanks,
d. |
|
|
|
|
|
|
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.