Category Hierarchy Mapping (BETA)

Hi,

If you have only uploaded the latest admin tools over the top of a 14/06A installation it's most likely just that the database tables for the new features aren't in place.

The setup process doesn't DROP existing tables but just as a safeguard, if you first go to Tools > Backup and Restore and make a backup of all existing settings, and having saved the backup file to your local computer, browse to /pt/setup.php?installDB.php (make sure setup.sql from the beta distribution is in place) and that will create the database tables for the new features.

Cheers,
David.
--
PriceTapestry.com

Hi David,

I have followed the steps above. Still, I am not able to add any subcategories. Any other ideas on that front?

Strangely I have another issue with the WP Plugin, where a wrong featured product is shown with a broken link in WP, not in PT. I found another post regarding that, but I can exclude a cashing issue as removing the widget or changing it to anything else shows me a blank featured product listing.

It feels like to something got messed up in the database.

If you have any ideas, I d love to try anything.

Thanks

Hi,

Regarding Category Hierarchy Mapping, could you try adding a new category with database debug mode enabled by editing config.advanced.php and changing line 6 as follows:

That should reveal if it is a table related issue regarding the upgrade process.

Regarding mystery products in WordPress, I'm wondering if as a result of setting up / testing you have ended up with 2 Price Tapestry databases and the plugin is showing results from one database but then when it links through to jump.php in the standalone script it is pointing at another perhaps. If you could double check the equivalence of the settings as shown in step 3 on this page, and then further that $config_databaseTablePrefix from /pt/config.php matches the equivalent setting under the External section of the PriceTapestry.org Settings page (wp-admin > Settings > PriceTapestry.org).

That might be all it is, otherwise let me know and I'll check it out further with you of course;

Cheers,
David.
--
PriceTapestry.com

Hi

The error in the debug mode on the subcategory setup page is

[SELECT id,name FROM `pt_categories_hierarchy` WHERE parent='0' ORDER BY name][Table 'fotoserv_wp1.pt_categories_hierarchy' doesn't exist]

Running /pt/setup.php?installDB.php gives me a success message however.

I have just check MyPhpAdmin and there seems to be only one installation with the prefix pt_

The settings in config.php and configadvance.php seem to match

My apologies, the trigger to upgrade the database should be:

/pt/setup.php?installDB=1

(corrected above)

I have to go offline for a little while but just wanted to reply with that quickly so that you can get going with the Category Hierarchy, will follow up regarding the plugin issue shortly...

Cheers,
David.
--
PriceTapestry.com

OK. The setup went great and I can setup subcategories now. Cool. Thank you David.

Great!

Regarding the mystery products showing up in WordPress, could you possible try a test by first of all deleting all Featured Products (copy and paste into a .txt file to make a quick backup), and then using the Product Search tool on the Featured Products page to select a current product from the database to add to the list.

With that in place, if you could then try both the plugin home page (/shopping) and the standalone home page (/pt) and verify whether or not the new product selected displays in both cases?

Thanks!
David.
--
PriceTapestry.com

OK. I have deleted and selected new featured products in the admin section.

Result:

New selected featured products are showing fine on the /pt installation
The mystery product is still visible on WP when using the shortcode [pto featured=""]

Hi,

Apologies for the inconvenience. If possible, please could you email me a link to the WordPress installation so that I can try some test searches in both WordPress and standalone to see if I can spot what's going on for you..

Thanks!
David.
--
PriceTapestry.com

Email with all details just sent out. Thanks a lot.