Local Install copied to Live Server

Hi,

Is it possible to copy a local server install of powerstore 3 to a live sever. I am trying to get around the mysql user privilege problem with my hosting company. Its such a simple solution I am expecting a big NO, but no harm in asking!

Thanks

Jon

Yes, I have just managed it after four days and endless attempts of installs. It is so simple to achieve, but nowhere on the WebAssist website does it mention the ability to do so.

So, install it on your local testing server; look in the wa_settings table of the database and there you will see something like:

Root URL: sitename/

Local Root: /username/sitename/

Remote Root: /username/sitename/


On the basis the site is sitting at the top level of the live domain, you need to change the above to:

Root URL: www.sitename.com/

Local Root: /

Remote Root: /



You might also need to change the Google API Key

I have uploaded my local files to my remote server via DW, and literally within the last hour dumped my local testing server and uploaded it to the remote server, then changed the above settings... BINGO!

If it wasn't for Dani on here, I wouldn't have known to do that. I just had to ask the right question in order for that info to materialise which is a shame.

So, there you go WebAssist team... I appreciate that this was built with the novice in mind, but there are a good deal of people on here who want to be able test first, and then upload. But without the above info, it becomes almost impossible to figure out and do that. It would be great to have this as part of the documentation instructions as I would've understood that straight away rather than go round in circles for days on end.

Mat

Thanks so much for the quick reply. Thats super! My inital thought was how do I get around my hosting comanies reluctance to give the privilege required to the mysql user to run the install wizard. I didnt want to use another company as I'm otherwise very happy with them.

It took minutes to install locally here and now you have set the bar I will test and tweak here before uploading to remote.

I agree, the web assist documention is poor at times. However, this forum always seems to come up with the answers.

Thanks again.

Keep in mind that bypassing the installation program's check for create view privileges does not remove the need for them on the remote host.

The purpose of the check is to make sure you have everything on your host to insure that the store will run properly.

Office Guy, I assume you are referring to the cURL and GD library checks etc that the first page does?

I must admit, I hadn't considered that, but, I knew my host caters for that. However, if a host doesn't have things like that installed, then they surely are a poor hosting service. I guess one way of being sure beforehand is to do the phpinfo check.

I was just pointing out that if any of the checks fail while running the installation program, it means that the host doesn't have what is required to run PS3 properly.

The only thing the installation program needs is PHP so it isn't an issue with getting around the install process. It is checking the requirements for PS3.

There seems to be an impression that it is a problem with getting the install program to run and that's not the problem. The create view privilege is needed for the coupon system, not the install program.

Woah,
I have been strugling with this whole concept of how Web Assist markets all these products
eg, Power Store 3, And the ability to customize using the web extensions. and Dreamweaver. Yes its easy to setup either at your ISP or local testing server, with a few tweaks for the local setup. My problem was I setup first at my ISP, Great worked fine.
Now I want to customize using DreamweaverCS4 and CSSMenu Writer or Ecart, and all the extensions that are designed for this application.
typically, you FTP your site to your local machine after setting up testing server, I use xaamp, Then I exported the MySql database from my ISP and imported it to local data base.
All is well, tables are all there, and I can connect to database, changing the connection.php for the local site, Also modified the wa_settings to reflect the local root name user and password. The problem starts when you try to view live in DW, or through browser, Also had added treexml.xml to replace current in CSS Menu home.
add added the other fixes that were show in the forum. You get all these errors, MySql, connections and on and on. So I have given up on trying to customize a site that was already setup at your ISP. and after reading this post, I may try this instead.
What did you do about the database at your ISP? did you export from your local MySql server? to your ISP MySql, using phpadmin?

I wish Web Assist would draft a procedure that details how to customize Power Store 3 using Dreamweaver along with the extensions. on using a remote site what problems you may run into.

They leave to all of us to work out these details, like everyone has done here.
And post many questions just trying to get it to work right!

Thanks Office Guy & MRS. I was indeed just trying to bypass the install problem failing the privilege test. You make a good point.

Is it just the coupons that will fail to function without the correct mysql privilege?

Thanks again

Jon

yes, the view is only used for coupons.


Here is the work flow I would suggest for installing PowerStore on the remote host and your local computer to make edits:


1) Upload the files to the remote host and run the installer.

2) After the installer has finished, set the privileges on the Connections/PowerStoreConnection.php file to read only. This step will prevent dreamweaver from overwriting the connection settings.

3) Create a new Dreamweaver site for PowerStore. On the testing server tab, configure it to use your local testing server.

Set the Remote Info section to use FTP to connect to the remote host and upload to the same directory you installed PowerStore to.

4) Extract the PowerStore files to the root of your Dreamweaver site, the run the installation wizard on your local computer.


You can now make changes in Dreamweaver, test them locally, then upload them to the live site.

Thank you James. Can I confirm that Powerstore will function ok without the View privilege with the only exception been the coupons.

For future powerstore sites I will use 1 and 1.

Anyone know an Irish based hosting company that can fully support powerstore? I'm trying to keep things Irish, our great little nation is such a bad way I fear ever euro is needed at home!!! :)

Thanks again all for the time spent on the replies!

Jon