Guest Posted March 5, 2003 Posted March 5, 2003 This has probably been asked before but I have searched but cannot find the answer. I need 2 carts on the same webspace. My provider only gives me 1 mySQL database and if I do a new install in a new directory to create my second shop my existing database is overwritten. What I need is a mod that changes the database field names and the cart itself so it looks for the new names. Does a mod/contribution it exist? Apols if this is naive question but I hadn't heard of php 10 days ago!
DnJ Posted March 5, 2003 Posted March 5, 2003 Look in the contributions in the other category - virtual mall contribution. I couldn't get it to work with MS1 but maybe you will have better luck. You could also create a second install with the new install pointing to your existing database. "One Of Life's Greatest Pleasures Is Doing What Others Say You Can't"
Guest Posted March 5, 2003 Posted March 5, 2003 I will have a look at the Mall contrib thanks As for your second point, if I make a new install it will overwrite my existing database won't it? :?:
toolcrazy Posted March 5, 2003 Posted March 5, 2003 If you are doing a second install you don't have to upload the database, just turn that option off. But the main problem will be is that the products for one store will show in both stores. The only way it will work is create a mirror database and rename all the refrences in OSC, a big job. Example: Table Products Create another identical table under it called maybe Products_two. With all the same field and atributes. Then you would have to rename all the refrences to Products in OSC to Products_two. I hope I'm not too confusing for ya. Steve -------------------------
Guest Posted March 5, 2003 Posted March 5, 2003 I am lucky in that to use the same database would be an advantage providing I can pull different prices into each cart. Shop1 is B2B selling our products to retailers. Shop 2 is selling to public (at higher price as I want to keep our retailers!) I don't want to sound thick but how can you turn the database off during the install?
toolcrazy Posted March 5, 2003 Posted March 5, 2003 I don't want to sound thick but how can you turn the database off during the install? The second page of the install script has a check box at the top, just uncheck the option. It says something like. Import Database? Steve -------------------------
Guest Posted March 5, 2003 Posted March 5, 2003 With ref to the above. If I have two carts using the same database will there be any problems if users on each cart are accessing and modifying the database simultaneously?
toolcrazy Posted March 6, 2003 Posted March 6, 2003 I hope you realize that if you use the same database you will have no control for each individule store. What you do in one will happen in the other. Steve -------------------------
Guest Posted March 6, 2003 Posted March 6, 2003 I eunderstand that the one database will govern both stores. To distill my queries 1. can 2 carts post safely to one database at the same time 2. Is there any way I can call separate prices into each cart Paul
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.