Setting up test site

[mamasylvia]

I copied my working store files into a new directory, zentest. I also set up a new database, zentest. What do I need to change in what file so the test store only acts on the test database, not my real database?

[ronlee67]

That is all done in /includes/configure.php and /admin/includes/configure.php.

I know you already loaded the files on your test server, but you might find it easier to scratch that and reinstall using the guide here: http://www.zen-cart.com/wiki/index.p...Switch_Servers

[mamasylvia]

> you might find it easier to scratch that and reinstall

Installing was such a nightmare that I'm really trying to avoid that. But after I edited the test configure.php files, not only replacing the database name but the directory name, I tried to go to www.SteigerFamily.com/ZenCartTest/ and got this error message:

1146 Table 'steigerf_zentest.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

Any clue what I can do to fix this? If I have to install from scratch, I will, but oh jeepers I'd rather not ...

[swguy]

In your two configure.php files, you need

define(DB_DATABASE, 'steigerf_zentest');

[mamasylvia]

Already there -- line 77 in the admin/includes file and line 55 in the regular /includes file.

[swguy]

OK. Go into phpMyAdmin and look at that database. Do the tables have a prefix?
(i.e. are the names zen_configuration instead of configuration?) If so you'll need to modify DB_PREFIX in the config files.

[mamasylvia]

Wow, you are so far beyond what I know how to do ...

I opened MyPHPAdmin and there is no option for "look at database." Info is:

MySQL client version: 4.1.21
Used PHP extensions: mysql
Language: English
Theme 7 Style: Arctic Ocean
Font size: 82%
Server version: 5.0.45-community-log
Protocol version: 10
Server: Localhost via UNIX socket
User: steigerf@localhost
MySQL charset: UTF-8 Unicode (utf8)
Create new database:

Options are:
[Change Log] [Subverson] [Lists]
Show MySQL runtime information
Show MySQL system variables
Processes
Character Sets and Collations
Storage Engines
Databases
Export
Import
Log out

There are also links to PHPMyAdmin documentation, wiki, and official homepage. I did click on "databases" but there didn't seem to be a way to look at one.

[swguy]

Isn't there a dropdown on the left hand side that allows you to pick a database? You need to pick yours and look at the tables in it to see if they have a prefix.

[stevesh]

On the 'home' page of phpMyAdmin, there should be a list of your databases on the left. Click on the one for Zencart, and it'll open to a list of your tables.

address_book
address_format
etc.

If you have a prefix, it'll show there

If you want to see what's in that table, click the first little icon to the right of the name (Browse).

Edit:swguy beat me to it.

[mamasylvia]

Not a dropdown, but a series of 3 links, one for each database. The test database shows up there as plain ol' zentest. I clicked on it and it said "no tables found in database" and asked if I wanted to create a table. Just for comparison, I looked at my real database and it has a bunch of tables in it -- think that is the problem? Am I going to have to reinstall to let Zen Cart create the tables?