Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1046 - No Database Selected


edward

Recommended Posts

Posted

I have searched the database and found the same issue have happened to many people, but as a newbie I really can't understand those replied. Below is the error I have hit after clicking the "admin" button right after installation:

 

---

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

---

 

Can anyone let me know where and how I can solve it?

Posted

first can you access the catalog if not did you create a blank database prior to install

 

If you can access the catalog then

 

What to do is copy the part about the database info from the catalog/includes/configure.php to the admin/includes/configure.php

 

remember to only copy the part about the database info this bit

 

  
// define our database connection
define('DB_SERVER', '*******');
define('DB_SERVER_USERNAME', '*****');
define('DB_SERVER_PASSWORD', '*****');
define('DB_DATABASE', '*******');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'mysql');

 

in the example above the information has been *** out

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted
first can you access the catalog if not did you create a blank database prior to install

 

If you can access the catalog then

 

What to do is copy the part about the database info from the catalog/includes/configure.php to the admin/includes/configure.php

 

remember to only copy the part about the database info this bit

 

 ?
// define our database connection
define('DB_SERVER', '*******');
define('DB_SERVER_USERNAME', '*****');
define('DB_SERVER_PASSWORD', '*****');
define('DB_DATABASE', '*******');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'mysql');

 

in the example above the information has been *** out

Thank you, it seems working, but I just have a question why this happens? Is it an issue of osCommerce installation? Because I see other people hit this issue too?

Posted

I have done many installs and not one has had this issue, so go figure.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted
I have done many installs and not one has had this issue, so go figure.

Thank you, I tried re-installing it but could you kindly teach me how to remove the text as shown like below at the catagory frontpage?

 

Error Messages

 

If there are any error or warning messages shown above, please correct them first before proceeding.

 

Error messages are displayed at the very top of the page with a complete background color.

 

Several checks are performed to ensure a healthy setup of your online store - these checks can be disabled by editing the appropriate parameters at the bottom of the includes/application_top.php file.

Editing Page Texts

 

The text shown here can be modified in the following file, on each language basis:

 

[path to catalog]/includes/languages/english/index.php

 

That file can be edited manually, or via the Administration Tool with the Languages->English->Define or Tools->File Manager modules.

 

The text is set in the following manner:

 

define('TEXT_MAIN', 'This is a default setup of the osCommerce project...');

 

The text highlighted in green may be modified - it is important to keep the define() of the TEXT_MAIN keyword. To remove the text for TEXT_MAIN completely, the following example is used where only two single quote characters exist:

 

define('TEXT_MAIN', '');

 

More information concerning the PHP define() function can be read here.

Securing The Administration Tool

 

It is important to secure the Administration Tool as there is currently no security implementation available.

Online Documentation

 

Online documentation can be read at the osCommerce Wiki Documentation Effort site.

 

Community support is available at the osCommerce Community Support Forums site.

Posted
The text shown here can be modified in the following file, on each language basis:

 

[path to catalog]/includes/languages/english/index.php

this is from that text and as it says the text can be found in catalog/includes/languages/english/index.php

 

look for the code

 

The text is set in the following manner:

 

define('TEXT_MAIN', 'This is a default setup of the osCommerce project...');

 

The text highlighted in green may be modified - it is important to keep the define() of the TEXT_MAIN keyword. To remove the text for TEXT_MAIN completely, the following example is used where only two single quote characters exist:

 

define('TEXT_MAIN', '');

from the text again, as it says minimum to leave is
define('TEXT_MAIN', '');

so if you wish to replace the text then

define('TEXT_MAIN', 'this is where you would place your replacement text which can include html tags just be aware of any apostrophes they require special attention and should be replaced as \' in order to show properly so what\'s is the correct way to present the apostrophe');

the above gives an example of replacement text

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

  • 2 weeks later...
Posted

Thanks....this helped me. There must be a defect or bug that is causing all of these problems. It seems that many have had the same issue.

 

Thank you for helping me too!.

Archived

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

×
×
  • Create New...