You are here:  » Problem with configuration


Problem with configuration

Submitted by ser_seven on Sun, 2013-10-20 13:38 in

Hi
i have install PT in folder /pt/, while joomla is installed in the root.
In the configuration Joomla SEF URLs is ON and the htaccess file in the root of the site properly.

I tried to display the folder of my /shopping/ site, such as default configuration of the component PT, but I get an error

The error is as follows
error 1146
Table 'yoopoint_jomd.pt_featured' does not exist SQL = SELECT * FROM `pt_featured` WHERE name NOT LIKE '% /%' ORDER BY sequence

I probably have some wrong configuration, for example do not know what should I enter in the component configuration to section External

thanks

Submitted by support on Mon, 2013-10-21 08:47

Hello ser,

That sounds like the 2 scripts (Joomla and Price Tapestry) are not sharing the same MySQL database, which is a requirement of running PriceTapestry.org. This should not normally cause a problem because Price Tapestry uses a default table prefix of "pt_" and Joomla uses either "jos_" or something random depending on version.

Step 1/3 of the Quick Start Guide for Joomla shows the corresponding Joomla settings that must match the $config_database... settings in /pt/config.php. To find the settings after installing Joomla, look in the file configuration.php in your Joomla installation folder, where you will find:

  public $host = 'localhost'; // $config_databaseServer
  public $user = 'username'; // $config_databaseUsername
  public $password = 'password'; // $config_databasePassword
  public $db = 'mydatabase'; // $config_databaseName

(i've added the comments to show the equivalent setting in /pt/config.php)

If you need to move your Price Tapestry installation in order to achieve this and have already made progress with feed registration / setup etc. you can use the Database Tool (/pt/admin/ menu) to export settings and then restore once re-installed in the new database.

Hope this helps!

Cheers,
David.
--
PriceTapestry.com