Table 'powerstore200.products' doesn't exist

I have gone through the getting started guide for PowerStore and seem to have had success through all the steps, including importing the .sql files through phpMyAdmin. I show 8 tables. I uploaded PS to my site and have accessed the admin login window. After logging in, I get the following error message:

Table 'powerstore200.products' doesn't exist

I know it's there. I can see it. I seem to be missing a communication somewhere, but, I don't know where. Anyone know what's going on?

According to the error, it is looking for the products table in the powerstore200 database, are you sure you are looking in the correct database?

Yes, it's there. Here's what I show at phpMyAdmin-

powerstore200 (8)

optiongroups
options
orderdetails
orders
productcategories
productoptions
products
users

Products opens up to show a list of 15 fields.

Double check the connection file, make sure the connection file is set to connect to the same MySQL Server as the one you are checking.


Are you testing locally? Or remotely?

If you are testing loccally, make sure the connection is set to connect to your local MySQL Server and that the database has been properly created in your local server.

If remotely, make sure it is connecting to the remote MySQL Server and that the database has been created there.

I'm testing remotely. I've tried everything I know how to do to get a connection. I'm new at this and a lot of the documentation is over my head. The database exists at phpMyAdmin. I've created a database with matching name on my domain. I just don't know what to do next to connect the two.

A typical connection file might look like this:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "uks12345cms";
$username_localhost = "uks12345neilo";
$password_localhost = "01234567;
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Maybe not all the time, but very often your database name has a prefix assigned to it when you create it in your control panel. So for me, if I create a new database called 'cms', a prefix (my control panel username) is prefixed to the beginning and it becomes: uks12345cms.

If you ever have to log in to phpMyAdmin via a phpMyAdmin login window, that would be your username. Check any documentation you have, and see if it specifies a prefix.

The best people to ask what your exact database access details are would be your hosting providers. You could have this cleared up in a couple of minutes.