jbinetworks Posted January 10, 2005 Report Share Posted January 10, 2005 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 More sharing options...
jbinetworks Posted January 10, 2005 Author Report Share Posted January 10, 2005 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 More sharing options...
Guest HHGAG Posted January 10, 2005 Report Share Posted January 10, 2005 You've to setup an empty mysql database, to install xt:C, and then you should run the installer Link to comment Share on other sites More sharing options...
jbinetworks Posted January 10, 2005 Author Report Share Posted January 10, 2005 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 More sharing options...
jbinetworks Posted January 10, 2005 Author Report Share Posted January 10, 2005 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 More sharing options...
Hubi Posted January 10, 2005 Report Share Posted January 10, 2005 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 More sharing options...
jbinetworks Posted January 10, 2005 Author Report Share Posted January 10, 2005 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 More sharing options...
messiah Posted April 16, 2008 Report Share Posted April 16, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.