Database Error.. ??

[nvmber9]

I haven't upgraded it or transferred it from a different host. I was able to access the store yesterday (not sure about the admin). Then today I came up with this.

for the store:

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

and this for the admin:

1146 Table 'db1068695_onlinestore.project_version' doesn't exist
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any suggestions would be a great help. I have searched numerous articles and forums and still haven't come across anything. My 'DB_PREFIX' is ' '. I don't think I specified a prefix when creating the database..

I'm not a coder, and this is all very new to me, but I think the problem is there are no tables set up in that specific database. I've been trying to find a Zen Cart database table in SQL format to upload manually since I can't access my admin section and haven't been able to find anything. Is it in my own store files? I couldn't find it.

Thanks in advance :)

[kobra]

Check your /includes/configure.php file and towards the bottom what the DB name is...

From the error it shoulkd be db1068695_onlinestore

[DrByte]

I'm not a coder, and this is all very new to me, but I think the problem is there are no tables set up in that specific database.

Yes, that's what the messages are telling you.

I've been trying to find a Zen Cart database table in SQL format to upload manually since I can't access my admin section and haven't been able to find anything.

It's a lot more complicated than that.

The more important thing is to find out why your database data existed yesterday but not today. Time for a call to your hosting company.
And also a visit to the FAQs on how to do backups ... Here's one for doing database backups: https://www.zen-cart.com/tutorials/i...hp?article=103
You can do PHP file backups by downloading with your FTP program.

[maineiac13]

I just started getting the following error when trying to go to my admin:

"0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

As I have done nothing in the last hour to modify my database, I have contacted my host (doteasy.com) and am waiting to hear back. Hoping that it is some kind of a problem with my host...I do have a recent database backup...but at the moment I can not even log in to my admin panel at my host site...which even makes me more convinced that the problem is with my host.

[maineiac13]

Just started working again fine for me...so the problem was with my host...hopefully that was/is your problem as well.

[nvmber9]

I just checked with the hosting service and they said they had nothing to do with it and that they don't usually help with scripting.

Is there a way to manually upload those database tables in the database_tables.php page?

Thanks again for all your help

[kobra]

I just checked with the hosting service and they said they had nothing to do with it
I was able to access the store yesterday (not sure about the admin). Then today I came up with this.

Well if this is not from something that you inadvertantly did then it should be explained by your host

[nvmber9]

Thanks kobra-

Maybe it was something I did and had no idea.. that's my bad. But I think the problem here is there aren't any tables in this database. I am able to access the database through phpMyAdmin and can see that there aren't any tables. I'm assuming that includes/configure.php, admin/includes/configure.php, and includes/database_tables.php will make these tables for me automatically. I believe I have everything set up correctly.. just not sure why it isn't working. Is there another page that I need to edit??

Thanks

[CJPinder]

Maybe it was something I did and had no idea.. that's my bad. But I think the problem here is there aren't any tables in this database. I am able to access the database through phpMyAdmin and can see that there aren't any tables.

If the site was working but now the database is empty then something has happened to your database. As DrByte said previously you should ask your website host to check the database server.

Do you have a backup of your database? If so you can use phpMyAdmin to restore it. If not you could try talking to your host to see if they will restore the database for you. They probably won't though.

If you cannot get the database restored you will need to start again with a new one. To do this you will need to upload the zc_install files from the Zen Cart distribution and go through the installation process.

Regards,
Christian.