1054 Unknown column

18 Feb 2008, 3:50 AM

#1

New Zenner

Join Date:: Aug 2005
Posts:: 31
Plugin Contributions:: 0

1054 Unknown column

I uploaded zen cart to my website and editef the configuration files but when I go in and accepts the agreements and press continue I get this:

1054 Unknown column 'configuration_key' in 'where clause'
in:
[SELECT count(*) as count FROM configuration WHERE configuration_key = 'CATEGORIES_COUNT_ZERO']

Im probably doing something wrong but i dont know what. Any help please?!

18 Feb 2008, 5:03 AM

#2

superprg

Totally Zenned

Join Date:: Feb 2006
Location:: Chicago
Posts:: 1,349
Plugin Contributions:: 0

Re: 1054 Unknown column

That probably means that you have messed up with the configuration table. Please check in phpmyadmin if you have all the columns there

18 Feb 2008, 5:15 AM

#3

bugmenot

New Zenner

Join Date:: Aug 2005
Posts:: 31
Plugin Contributions:: 0

Re: 1054 Unknown column

How do I do that? how do i know how to check tables from Zen Cart?

18 Feb 2008, 5:21 AM

#4

superprg

Totally Zenned

Join Date:: Feb 2006
Location:: Chicago
Posts:: 1,349
Plugin Contributions:: 0

Re: 1054 Unknown column

You can only check that in phpmyadmin (through Cpanel)

18 Feb 2008, 5:24 AM

#5

bugmenot

New Zenner

Join Date:: Aug 2005
Posts:: 31
Plugin Contributions:: 0

Re: 1054 Unknown column

Im in phpmyadmin right now but I dont know exactly what Im looking for...

18 Feb 2008, 5:25 AM

#6

superprg

Totally Zenned

Join Date:: Feb 2006
Location:: Chicago
Posts:: 1,349
Plugin Contributions:: 0

Re: 1054 Unknown column

You are looking for the configuration table and see if the column configuration_key is there!

18 Feb 2008, 5:29 AM

#7

bugmenot

New Zenner

Join Date:: Aug 2005
Posts:: 31
Plugin Contributions:: 0

Re: 1054 Unknown column

well im in the database in phpmyadmin and I cant find a configuration table. Sorry, I dont really know much about this..

18 Feb 2008, 5:32 AM

#8

superprg

Totally Zenned

Join Date:: Feb 2006
Location:: Chicago
Posts:: 1,349
Plugin Contributions:: 0

Re: 1054 Unknown column

Did you click on the database used by zen cart and then saw the list of tables? I cant believe that the table configuration is not there at all. IF that is the case, you should have got tabel doesnt exist error!

18 Feb 2008, 5:47 AM

#9

bugmenot

New Zenner

Join Date:: Aug 2005
Posts:: 31
Plugin Contributions:: 0

Re: 1054 Unknown column

OK I fixed it. I think the problem was that I used that same database for another script. So I made a new database and it worked. Thanks for the help.

18 Feb 2008, 5:50 AM

#10

superprg

Totally Zenned

Join Date:: Feb 2006
Location:: Chicago
Posts:: 1,349
Plugin Contributions:: 0

Re: 1054 Unknown column

Thanks for the update!