"1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

I have just used the tutorial "I want to move my Zen cart installation to another host or different server" the idea being to use it on my localhost, using Xampp.
I need to correct numerous errors made sometime ago before I 'Upgrade'.
I believe I followed the instructions to the letter, but obviously got it wrong somewhere as I get an error on loading in the browser.

The error is
"1146 Table 'beeworks_zc1.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]"

I would appreciate an explanation and a fix if possible! If not I start again, and again, and again ad nauseam. By which you'll gather I've had my share of problems.
The 'beeworks_zc1' is my database.

Literally, it means "the table named 'configuration' inside the database named 'beeworks_zc1' can't be found", and thus the program can't find the data it needs, and thus cannot continue running.

In the tutorial you mentioned, it tells you to pay attention to database names and also table-prefixes ("DB_PREFIX"). Usually the error message you quoted is a result of not properly indicating the correct database name and table-prefix in the configure.php files of the server that's showing the error message. The FAQ article does cover all the steps ... and still many people miss some of the things mentioned there for one reason or another.

DrByte:

Literally, it means "the table named 'configuration' inside the database named 'beeworks_zc1' can't be found", and thus the program can't find the data it needs, . The FAQ article does cover all the steps ... and still many people miss some of the things mentioned there for one reason or another.
Thank you, you're right, sorry for wasting your time.
I just checked my setup again. I had selected the wrong database file.
Back to the drawing board.:oops:

DrByte:

In the tutorial you mentioned, it tells you to pay attention to database names and also table-prefixes ("DB_PREFIX"). Usually the error message you quoted is a result of not properly indicating the correct database name and table-prefix in the configure.php files of the server that's showing the error message.

I hate to be a pain, but after loading and unloading so many times I could do it with my eyes shut, I have to say 'It's not working'.
To date. Using ZC 1.3.7 and Xampp two versions 1.4 and 1.7 and being super/super careful with every entry, every comma and period correct, I continue to get the same error.
Is there any other way to download and run a 'live' site on localhost? Any other suggestions? Please.

If you "continue to get the same error", and that error is "1146 Table 'beeworks_zc1.configuration' doesn't exist", then the problem is that your local install either doesn't have a database entitled "beeworks_zc1", or if it does, then that database doesn't have a table named "configuration" inside it.

DrByte:

If you "continue to get the same error", and that error is "1146 Table 'beeworks_zc1.configuration' doesn't exist", then the problem is that your local install either doesn't have a database entitled "beeworks_zc1", or if it does, then that database doesn't have a table named "configuration" inside it.
Ummm! There is the problem, the database is beeworks_zc1 and there is a table called 'configuration. These are the items I checked so diligently before I posted this thread!
Any other way to achieve what I need, as this is getting boring for all concerned. Please!
I have to correct errors as I didn't use the overides when I first built the site, so now I cannot upgrade.

Please disregard the previous post, I've fixed it, with reservations.
I assumed in my ignorance that not selecting SSL in the install wouldn't make any difference. Seems I was wrong.
My apologies for any inconvenience.
Now I've got "Session start and Header errors". Never stops does it?

Using SSL or not for a local test install should have no bearing whatsoever on whether the database can be connected.

DrByte:

Using SSL or not for a local test install should have no bearing whatsoever on whether the database can be connected.
OK. I'm not in a position to argue, but it was the only thing I changed from the previous 6 installs!:smile:
Subject closed?

No worries. Just adding comments for those who might read this discussion later and go trying something on supposition.

Glad you got it working for your needs.

DrByte:

Glad you got it working for your needs.

To be honest, no, it's not working correctly, in fact I've got a major headache, but that's another thread!!:no:

newbeeman:

Now I've got "Session start and Header errors". Never stops does it?Possible related FAQ: https://www.zen-cart.com/tutorials/index.php?article=87

newbeeman:

... but that's another thread!!:no:Yes, that's best, esp if the FAQ article above doesn't help. Be sure to state such in the new thread if that's the case.

This may help someone, it worked for me when receiving the "1146" error, and I had checked all configure.php settings and all were correct.

The "mysql_zencart.sql" file that exists in the Zen Cart install directory "zc_install/sql/" is the key. I user PHPMyAdmin to connect to the database, then click the "Import" tab, and import that mentioned sql file. This builds the initial database structure.

Once that step was complete, then running "http://mywebsite.org/zc_install" proceeded without that blasted 1146 error.