Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2005
    Posts
    33
    Plugin Contributions
    0

    Default 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?!

  2. #2
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default 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
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  3. #3
    Join Date
    Aug 2005
    Posts
    33
    Plugin Contributions
    0

    Default Re: 1054 Unknown column

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

  4. #4
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: 1054 Unknown column

    You can only check that in phpmyadmin (through Cpanel)
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  5. #5
    Join Date
    Aug 2005
    Posts
    33
    Plugin Contributions
    0

    Default Re: 1054 Unknown column

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

  6. #6
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: 1054 Unknown column

    You are looking for the configuration table and see if the column configuration_key is there!
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  7. #7
    Join Date
    Aug 2005
    Posts
    33
    Plugin Contributions
    0

    Default 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..

  8. #8
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default 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!
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  9. #9
    Join Date
    Aug 2005
    Posts
    33
    Plugin Contributions
    0

    Default 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.

  10. #10
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: 1054 Unknown column

    Thanks for the update!
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

 

 

Similar Threads

  1. Admin errors: 1054 Unknown column 'untries_id' , and 1052 column is ambiguous
    By kayamaya in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 9 Aug 2008, 04:40 AM
  2. 1054 Unknown column 'specials_date_available
    By Webskipper in forum General Questions
    Replies: 2
    Last Post: 27 Dec 2007, 02:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR