Urgent help needed

[kuroi]

Zen Cart has no problems running with MySQL5. Indeed it's getting increasingly rare to see a server running an older version.

The error message gives a clue as to the problem. It appears to be passing a path name rather than a table name to the mySQL engine.

Normally I would have said that this was a problem with your configuration files. I'd certainly have a look at includes/configure.php and in particular the DB_PREFIX setting towards the bottom. Normally this would be empty (i.e. two apostrophes) or something like 'zen_'.

However, it's interesting that you say that you could preview the site through Plesk until you changed the nameservers. That would point to something hinky in your server setup and you may need the help of the people hosting your server to get to where that directory path, "./dashequestrian/" is coming from.

[dashequestrian]

Kuroi

Thanks for replying, as suggested I looked into my includes/configure.php and the database bit looks like this;

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '******');
define('DB_SERVER_PASSWORD', '******');
define('DB_DATABASE', '******');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');

With the critical bits removed. The username, password and dbase name checkout as I have logged in via plesk with them.

In DB Web Admin after logging in using phpMyAdmin 2.8.2.4, the MySQL is;

# Protocol version: 10
# Server: Localhost via UNIX socket
# User: ******@localhost

Ignore the PLESK thing it previews the site perfectly as a fresh install now until clicking on any of the links on it where it presents the same error message.

Really stuck now

Thanks

Adam