Setup Config

Submitted by konpapdo on Thu, 2011-06-02 09:38 in Price Tapestry

In the manual at installation step 4:
4 Browse to setup.php. The following should be displayed:
Checking database connection...PASS
Checking database selection...PASS
Checking database tables...FAIL [click here to install tables]

When I click to "click here to install tables", it does nothing..
I run it localhost, and I have created a database for pricetapestry and the config:

<?php
  $config_title = "PT Test";
  $config_charset = "utf-8";
  $config_baseHREF = "/donald/pricetapestry";
  $config_useRewrite = FALSE;
  $config_useRelated = FALSE;
  $config_useTracking = FALSE;
  $config_useJavaScript = FALSE;
  $config_useInteraction = FALSE;
  $config_currencyHTML = "&euro;";
  $config_resultsPerPage = 10;
  $config_databaseServer = "localhost";
  $config_databaseUsername = "pricetapestry";
  $config_databasePassword = "*****";
  $config_databaseName = "pricetapestry";
  $config_databaseTablePrefix = "pt_";
?>

When I am trying to register a feed it pops a warning:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\includes\database.php on line 27
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\includes\database.php on line 32

and it doesn't register it, what I am doing wrong?

Hi Konpapdo, That sounds to

Submitted by support on Thu, 2011-06-02 09:42

Hi Konpapdo,

That sounds to me like the username that you have created does not have CREATE TABLE permissions in the database - I think that should be all it is.

In your MySQL administration tool, double check the permissions for the "pricetapestry" user, and make sure that they have all DATA and STRUCTURE privileges...

Hope this helps,

Cheers,
David.
--
PriceTapestry.com

It didn't worked :( I gave

Submitted by konpapdo on Thu, 2011-06-02 10:10

It didn't worked :(
I gave the database user "pricetapestry" all privileges (both Global and the database "pricetapestry")
After the setup.php I had 2 Pass and 1 Fail and the database "pricetapestry" is totally empty.

Hi konpapdo, In the

Submitted by support on Thu, 2011-06-02 10:55

Hi konpapdo,

In the privileges settings in your MySQL administration area are the privileges listed against % as the host (which is the wildcard).

As the next test, please could you enable database debug mode by changing line 6 of config.advanced.php to:

$config_databaseDebugMode = TRUE;

...then run the "Click here to install tables" again and let me know what is displayed as this should give more information about the problem..

Cheers,
David.
--
PriceTapestry.com