1146 Table 'mynewdatabase.configuration' doesn't exist in:

[marymortis]

Hello, I'm moving one of my stores to another host (from godaddy to webfusion). I followed this tutorial to the letter https://www.zen-cart.com/tutorials/i...hp?article=100 many times over the last few days and have scoured the forum for a solution. The issue is after importing the old database into the new one and running fix_cach_key I get

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

I checked the configure.php files and the database is named correctly, I had no prefixes and I can't see anything else out of place. I've recreated the new database a few times and re-installed zen cart from scratch as many times again and still can't get it right. What am I missing? I have another move to do soon so if I can learn my mistakes here with your help, I'd be eternally grateful

[skipwater]

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

Your error states that the configuration table in not in your data base.

So is it there?

What utility are you using to work with the database?

Skip

[marymortis]

Your error states that the configuration table in not in your data base.

So is it there?

What utility are you using to work with the database?

Skip

Thanks for your reply, there appear to be no tables in the database.
Another thing I just looked at where the versions on Myphp admin (which is where I created my old .sql file in the old one and imported the .sql file on the new one) the old db is on v4.1 and the new is on v5 would this make a difference?

[skipwater]

How did you export you old data with what options checked in myphpadmin?

Export:
SQL

Structure:
[_] Add DROP TABLE / DROP VIEW
[x] Add IF NOT EXISTS
[x] Add AUTO_INCREMENT value
[_] Enclose table and field names with backquotes
[_] Add CREATE PROCEDURE / FUNCTION

Data:
[_] Complete inserts
[_] Extended inserts
[_] Maximal length of created query
[_] Use delayed inserts
[_] Use ignore inserts
[_] Use hexadecimal for BLOB
Export type INSERT

If your exported SQL file is missing the add if not exists command it will not build the tables for you.

Skip

[marymortis]

Gotcha, thank you!
I'm pretty new at this and this is the first move I've ever done, so I just followed the tutorial and didn't think to check anything else.
Many thanks for your help, it'll make my next move so much easier! <3 Skip X

~ Mary

[marymortis]

Actually, if you don't mind, I need to ask for help again. I took on someone else's Zen Cart not knowing that I was just getting their old cart and .sql file on disk (had assumed the shop was still live) and I'm getting the same error. Is there a way I can modify their .sql file to work. I've no idea what the last person did (they were friends of the client but aren't any longer!) during the creation of the file. Would you give it a look over for me and point me in the right direction? *flutters eyelashes*


~ Mary

[marymortis]

Sorry I was AFK earlier, I work in a store and had to deal with customers, also my pop-up blocker kicked in and I hadn't noticed the message. Set to allow pop ups from here now :)

[hedonist]

Hello,please help me.I am new in SQL and when I wanted to create newsletter in Fantasticodelux, i installed it right but when i configure attributes i got this mesage:
Database error 1146 while doing query Table 'hedonist_plst1.phplist_user_user' doesn't exist
What should i do?I have no idea.Thanks.

[Kibb]

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.