You are here:  » Price Tapestry Installation


Price Tapestry Installation

Submitted by pkumar125 on Tue, 2006-10-03 01:50 in

Hello
I am a php programmer and need to do modification on http://www.pricedonkey.co.uk/
The modifications are : need to add Merchant and user login.

I downloaded complete script from http://www.pricedonkey.co.uk/ to my local server(XAMPP). I try to do modification but not able to install the software.

I am Getting this error :

Server error!
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Error 500
localhost
10/03/06 07:00:34
Apache/2.2.2 (Win32) DAV/2 mod_ssl/2.2.2 OpenSSL/0.9.8b mod_autoindex_color PHP/5.1.4

Please help me in installation

Thanks
Mandakini

Submitted by support on Tue, 2006-10-03 06:49

Hi Mandakini,

That sounds like PHP is not configured properly on your local server. Before trying Price Tapestry, first just try a test PHP script, for example:

test.php:

<?php
  
print "PHP is working...";
?>

Do you get the same error with that?

Cheers,
David.

Submitted by pkumar125 on Tue, 2006-10-03 11:07

Hello
David I am running four project on same server and its working fine. There are no problem in php configuration.
In this script If I delete .htaccess file and $config_useRewrite = false; then getting this error

Checking database connection...FAIL check $config_databaseUsername and $config_databasePassword values

Checking database selection...FAIL

Checking database tables...FAIL

But I am using correct username and password ($config_databaseUsername ,$config_databasePassword) that I tested by directly browse config.php and config.php gives correct result.

Please help me to find error.

Regards
Mandakini

Submitted by support on Tue, 2006-10-03 11:24

Hi Mandakini,

The first part indicates that you downloaded the code with the .htaccess file from the main server, which doesn't seem to be compatible with your local installation. An internal server error (500) is a common sign that something is wrong with .htaccess.

Otherwise, what are you using as your $config_databaseServer? It if "localhost"; however you confirmed that MySQL is up and running on "localhost"? Do you have other scripts that are using MySQL?

I would recommended testing this outside of Price Tapestry, using the example scripts from the PHP website:

http://uk2.php.net/mysql_connect

<?php
$link 
mysql_connect('localhost''mysql_user''mysql_password');
if (!
$link) {
   die(
'Could not connect: ' mysql_error());
}
echo 
'Connected successfully';
mysql_close($link);
?>

Run that script after changing mysql_user and mysql_password and see if you can connect....

Cheers,
David.

Submitted by pkumar125 on Sat, 2006-10-07 04:50

Thanks for your reply Now I am able to connect with mysql but still If I keep $config_useRewrite = true; getting this error

Server error!
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Error 500
localhost
10/07/06 10:10:10
Apache/2.2.2 (Win32) DAV/2 mod_ssl/2.2.2 OpenSSL/0.9.8b mod_autoindex_color PHP/5.1.4

With $config_useRewrite = false; script working fine Please tell me how to modify .htaccess or how to test wether this script is right or wrong. I am sure some minor changes need to do because home link is working fine with $config_useRewrite = true; only merchants and category link not able to execute

Thanks for your co-operation
Mandakini

Submitted by pkumar125 on Sat, 2006-10-07 07:55

Code for .htaccess file is:

Options -MultiViews

RewriteEngine On

RewriteBase /

RewriteRule ^product/(.*).html$ products.php?q=$1&rewrite=1&%{QUERY_STRING} [L]

RewriteRule ^review/(.*).html$ reviews.php?q=$1&rewrite=1&%{QUERY_STRING} [L]

RewriteRule ^merchant/$ merchants.php
RewriteRule ^merchant/(.*)/$ search.php?q=merchant:$1:&rewrite=1%{QUERY_STRING} [L]
RewriteRule ^merchant/(.*)/(.*).html$ search.php?q=merchant:$1:&page=$2&rewrite=1%{QUERY_STRING} [L]

RewriteRule ^category/$ categories.php
RewriteRule ^category/(.*)/$ search.php?q=category:$1:&rewrite=1%{QUERY_STRING} [L]
RewriteRule ^category/(.*)/(.*).html$ search.php?q=category:$1:&page=$2&rewrite=1%{QUERY_STRING} [L]

RewriteRule ^brand/$ brands.php
RewriteRule ^brand/(.*)/$ search.php?q=brand:$1:&rewrite=1%{QUERY_STRING} [L]
RewriteRule ^brand/(.*)/(.*).html$ search.php?q=brand:$1:&page=$2&rewrite=1%{QUERY_STRING} [L]

Regards
Mandakini

Submitted by support on Sat, 2006-10-07 08:23

Hello Mandakini,

Have you installed Price Tapestry in the root directory of your web server? If not, you need to edit the following line in .htaccess - for example if the script is in a directory called "shopping" you would use:

RewriteBase /shopping/

The other thing to check is if you get a 500 Internal Server error there should be a message in the web servers error log file that should help...

Cheers,
David.