Jump to content
xt:Commerce Community Forum

Database Config Error


Recommended Posts

I am dabling with an installation for a client of mine and I get this error in the configuration when trying to install this app.

A test connection made to the database was NOT successful.

The error message returned is:

Table 'jbinetwo_xtcomm.configuration' doesn't exist

Please click on the Back graphic to review your database server settings.

If you require help with your database server settings, please consult your hosting company.

I am installing this on a clean database and I still get this error, can someone please help me and thank you for any help I am given!

Link to comment
Share on other sites

Now I have a am receiving another error listed as:

A test connection made to the database was NOT successful.

The error message returned is:

Table 'jbinetwo_xtcommerce.configuration' doesn't exist

Please click on the Back graphic to review your database server settings.

If you require help with your database server settings, please consult your hosting company.

MY question is what are the settings that need to be in this first CONFIGURATION table for the install to work properly? Thanks again!

Link to comment
Share on other sites

I am running the installer but I am on step 5 and I get this error. Do I have to go create a table called configuration and put something into it so the installer doesn't keep giving me this error:

1054 - Unknown column 'configuration_key' in 'field list'

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[XT SQL Error]

Link to comment
Share on other sites

I tried installing on a fresh database with no tables in it and it gave me the second error I posted and then I went in and created a table called "configuration" with just a generic field name and the install gave me this error:

1054 - Unknown column 'configuration_key' in 'field list'

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[XT SQL Error]

So I don't know what I am doing wrong.

Link to comment
Share on other sites

The installer puts the Tables in the Database.

The only thing you have to do is to run the installer an give it the right datas to permit your database. Host, Name of database, user and password.

The error occurs if the installer could not connect to the database due to wrong datas.

Link to comment
Share on other sites

I tried using a blank database with no tables in it and it gave me an error that read this:

Webserver Configuration:

A test connection made to the database was NOT successful.

The error message returned is:

Table 'jbinetwo_xtcommerce.configuration' doesn't exist

Please click on the Back graphic to review your database server settings.

If you require help with your database server settings, please consult your hosting company.

Now if I put a table called Configuration the installer says it is complete and gives me this error on the next page:

1054 - Unknown column 'configuration_key' in 'field list'

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[XT SQL Error]

So I have no clue on what is happening.

Link to comment
Share on other sites

  • 3 years later...

Ich habe exakt das selbe Problem. Habe die gleichen Schritte durchgeführt.

Kann jemand bitte weiterhelfen?

Nachdem ich eine mysql5 Datenbank angelegt habe, die korrekten Daten in der xtcommerce installation eingegeben habe und in der datenbank eine tabelle namens configuration erstellt habe komme ich einen schritt weiter als ohne erstellung der tabelle configuration.

Nach Schritt 5 kommt folgende Fehlermeldung:

1054 - Unknown column 'configuration_key' in 'field list'

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[XT SQL Error]

Eine Seite davor:

"XT-Commerce Webserver Konfiguration war erfolgreich"

Link to comment
Share on other sites

Archived

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

×
  • Create New...