Hi,
Did anyone install it on Wordpress multisite?
Any issue's with that?
Hi David
I never used a database prefix when I setup my several PT installations, does that mean I will need to have separate installations of WP? or is there a way I could fix this so I can just have one wordpress.domain.com installation? my current database names at present are eg. comelec, comapp, etc would they have needed to be the same?
regards
Philip Stone
www.buy24-7.net
Hi Philip,
I know you've been using the core Price Tapestry script for some time now, before the installation used a default $config_databaseTablePrefix of "pt_".
Does the version you are running on the sites you would like to combine into a single WordPress site have the Database Tool menu option in your /admin/ home page?
I have helped many users with the database tool as a "back port" so if you don't have this that would be the first step in migrating your installations to a single database...
Thanks,
David.
Hi David
Yes I have the database tool and the most up to date version of the script installed on my site, when I try to backup the site, then restore to the new database which now has a prefix, it's not bringing the extra fields. I have added the following code under the feeds section of this database_tool.php file but it is only copying everything but this, are there other mods I would need to make to this file to make it work?
$fields["feeds"][] = "field_delivery";
$fields["feeds"][] = "field_promotion";
$fields["feeds"][] = "field_stock";
$fields["feeds"][] = "field_sku";
$fields["feeds"][] = "field_model";
$fields["feeds"][] = "field_mpc";thanks
Philip Stone
www.buy24-7.net
Hi Philip,
When creating the new installations; have you run the required dbmod.php scripts to create the new fields? The following would create all the above fields on one go for you;
dbmod.php
<?php
require("includes/common.php");
$sql = "ALTER TABLE `".$config_databaseTablePrefix."feeds`
ADD `field_delivery` VARCHAR(255) NOT NULL,
ADD `field_promotion` VARCHAR(255) NOT NULL,
ADD `field_stock` VARCHAR(255) NOT NULL,
ADD `field_sku` VARCHAR(255) NOT NULL,
ADD `field_model` VARCHAR(255) NOT NULL,
ADD `field_mpc` VARCHAR(255) NOT NULL
";
database_queryModify($sql,$result);
$sql = "ALTER TABLE `".$config_databaseTablePrefix."products`
ADD `delivery` VARCHAR(255) NOT NULL,
ADD `promotion` VARCHAR(255) NOT NULL,
ADD `stock` VARCHAR(255) NOT NULL,
ADD `sku` VARCHAR(255) NOT NULL,
ADD `model` VARCHAR(255) NOT NULL,
ADD `mpc` VARCHAR(255) NOT NULL
";
database_queryModify($sql,$result);
print "Done.";
?>
Hope this helps!
Cheers,
David.
hi David
got it working proper now, I was using old version of database_tools.php on the new installation. oops!!
thanks for the code above also, will come in very useful for future installations!
Philip Stone
www.buy24-7.net
Hi David
I have finished bringing everything into one database
so I am using
pt_electronics_
pt_appliances_
pt_gadgets_
pt_computers_
as my prefixes to the database, whole site is working great. Thanks for the help with that!!
when I use any of these prefixes in the wordpress plugin they work every time, but when I go to add it to a single page using [pto prefix="pt_electronics_"] or an alternative nothing shows up, what am I doing wrong, was hoping one wordpress installation could cope with all the site.
I made the changes to the pto.php file as discussed in http://www.pricetapestry.com/node/4231
installation at {link saved}
regards
phil
Philip Stone
www.buy24-7.net
Hi Philip,
Unfortunately it turned out to be not so straight forward (I think the thread on PriceTapestry.com may have been updated since you last checked) but I'm aware of the interest to be able to do this so I'll consider it over the next week as I finalise the beta; apologies for any inconvenience but the feedback for the requirement is valuable...
Cheers,
David.
Hey David,
I’ve installed WP multisite on my server with a couple of test sites. I have the PT plugin installed for the network, but the default PT installation doesn’t work for the additional sites unless I create separate PT directories for each site. Also, in the PT plugin, the fields are not automatically populated from the configuration file.
Is there a better option for multisite installations or have you gotten this far with the BETA yet?
Hi Brent,
I'm planning to look at multi-site next week as I finalise the beta to incorporate feedback. I've chosen to do that rather than drip-feed changes now as people have been making changes so it will be easier to port in one go rather than have to keep re-applying changes to beta updates.
Cheers,
David.
Thanks David!
I think the most unsettling issue with using multisite (depending on how you have it configured) is that there aren't any physical directories for the add-on sites. I modified the database prefix and the name of each PT directory so they would have unique configurations for each site in the multisite network admin. After tinkering to get the site running, I found this thread (www.pricetapestry.com/node/4231). I had been numbering the prefix and PT installation directories to match the site numbers assigned by WP...although I like the idea of naming them by product
type or category a lot better, I'm wondering how the increased number of characters will affect database size & performance over time.
Brent
Hi Brent,
Structure / length of any of the database config parameters shouldn't have any noticeable effect at all on performance.
Cheers,
David.
Hi Marco,
Would be good to hear if other users have successfully installed the beta on a multi-site installation but i'll also give it a go myself and report back!
Cheers,
David.