crcorey Posted April 22, 2008 Share Posted April 22, 2008 Here is the error I am receiving: 1054 - Unknown column 'configuration_key' in 'field list' select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] I am certain that I am doing something wrong in mySQL when attempting to create the table. Any advise? Link to comment Share on other sites More sharing options...
FIMBLE Posted April 24, 2008 Share Posted April 24, 2008 try installing once again, the database has not loaded all the tables. or if you are OK with phpmyadmin insert the following DROP TABLE IF EXISTS configuration; CREATE TABLE configuration ( configuration_id int NOT NULL auto_increment, configuration_title varchar(255) NOT NULL, configuration_key varchar(255) NOT NULL, configuration_value varchar(255) NOT NULL, configuration_description varchar(255) NOT NULL, configuration_group_id int NOT NULL, sort_order int(5) NULL, last_modified datetime NULL, date_added datetime NOT NULL, use_function varchar(255) NULL, set_function varchar(255) NULL, PRIMARY KEY (configuration_id) ); Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.