Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help, SQL changed, Now site is Down


Guest

Recommended Posts

Help, was trying to set up a second shop on my website using a new mysql database. It didn't work so I uninstalled it. But now, my original site is down with this error appearing when trying to access the admin or webpage

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Any help would be greatly appreciated as I need to get my site back up ASAP;

 

Thanks in advance

Link to comment
Share on other sites

Sounds your database had been dropped or renamed.

If not, check your configure file, make sure the database name is original one.

hi, checked all that, and everything is still as it was, the only thing I notice that is different is when you log into the phpMyAdmin for the SQL in the left column it appears to be displaying database table names like

CPG_albums

CPG_banned

CPG_categories

CPG_comments

CPG_config

CPG_ecards

CPG_exif

CPG_filetypes

CPG_pictures

CPG_temp_data

CPG_usergroups

CPG_users

CPG_votes

address_book

address_format

banners

banners_history

categories

instead of the database name, but if you go to the main column and click on databases it shows the correct database as still existing and if you click on it, all the info is there. I'm stumped and unfortunately not a wiz at php or mysql.
Link to comment
Share on other sites

hi, checked all that, and everything is still as it was, the only thing I notice that is different is when you log into the phpMyAdmin for the SQL in the left column it appears to be displaying database table names like instead of the database name, but if you go to the main column and click on databases it shows the correct database as still existing and if you click on it, all the info is there. I'm stumped and unfortunately not a wiz at php or mysql.

 

If you are sure the database is there and you have the correct database info in your configure.php file make sure the user is assigned to the database as you can get that error if it is not assigned.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...