Results 1 to 10 of 10
  1. #1
    Join Date
    Jul 2014
    Location
    Bathurst NSW Australia
    Posts
    4
    Plugin Contributions
    0

    Default Unknown column in configuration table

    Hi,

    Doing a first time install from a friend and after installing 4 times I keep getting the same error when I try to access most things in the Admin Configuration drop down. I get the "WARNING: An Error occurred, please refresh the page and try again." error message and in every case the log files contains "Unknown column 'configuration_tab' in 'field list'" when referring to the configuration table. I have searched everywhere I can think of to find out what the table is missing, even to the extent of looking in older versions. Can anyone help?

    Cheers,

    Warren

  2. #2
    Join Date
    Jul 2009
    Location
    picaflor-azul.com
    Posts
    6,930
    Plugin Contributions
    45

    Default Re: Unknown column in configuration table

    Quote Originally Posted by wazm View Post
    Hi,

    Doing a first time install from a friend and after installing 4 times I keep getting the same error when I try to access most things in the Admin Configuration drop down. I get the "WARNING: An Error occurred, please refresh the page and try again." error message and in every case the log files contains "Unknown column 'configuration_tab' in 'field list'" when referring to the configuration table. I have searched everywhere I can think of to find out what the table is missing, even to the extent of looking in older versions. Can anyone help?

    Cheers,

    Warren
    I believe that column is used in the fast and easy checkout module.

    Thanks,

    Anne

  3. #3
    Join Date
    Jul 2014
    Location
    Bathurst NSW Australia
    Posts
    4
    Plugin Contributions
    0

    Default Re: Unknown column in configuration table

    Quote Originally Posted by picaflor-azul View Post
    I believe that column is used in the fast and easy checkout module.

    Thanks,

    Anne
    So if I install the easy checkout module that should fix it? Seems weird that the software from scratch errors without installing other modules. I went through the SQL in the initial software load and couldn't find the column anywhere in the SQL statements. Just checked the easy checkout module and can't see it anywhere there either. If someone can tell me the type of field etc I could add it manually and possibly fix my probelm. (with luck)

    Cheers,

    Warren

  4. #4
    Join Date
    Jul 2012
    Posts
    16,732
    Plugin Contributions
    17

    Default Re: Unknown column in configuration table

    Quote Originally Posted by wazm View Post
    So if I install the easy checkout module that should fix it? Seems weird that the software from scratch errors without installing other modules. I went through the SQL in the initial software load and couldn't find the column anywhere in the SQL statements. Just checked the easy checkout module and can't see it anywhere there either. If someone can tell me the type of field etc I could add it manually and possibly fix my probelm. (with luck)

    Cheers,

    Warren
    Not sure what you mean by the fact that you just checked your fast and easy checkout. It seems that there is a partial install that has happened, and not sure what caused it, but if you look in the original package, possibly at: catalog/admin/configuration.php, you should see some information that includes the field configuration_tab.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Unknown column in configuration table

    Quote Originally Posted by picaflor-azul View Post
    I believe that column is used in the fast and easy checkout module.

    Thanks,

    Anne
    That column is added by a number of Numinix modules not just FEC..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  6. #6
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Unknown column in configuration table

    Quote Originally Posted by wazm View Post
    Hi,

    Doing a first time install from a friend and after installing 4 times I keep getting the same error when I try to access most things in the Admin Configuration drop down. I get the "WARNING: An Error occurred, please refresh the page and try again." error message and in every case the log files contains "Unknown column 'configuration_tab' in 'field list'" when referring to the configuration table. I have searched everywhere I can think of to find out what the table is missing, even to the extent of looking in older versions. Can anyone help?

    Cheers,

    Warren
    What are you trying to install??? It would help if you shared that....
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  7. #7
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Unknown column in configuration table

    Quote Originally Posted by wazm View Post
    Just checked the easy checkout module and can't see it anywhere there either. If someone can tell me the type of field etc I could add it manually and possibly fix my probelm. (with luck)
    I've just done a seach for configuration_tab and it appears that FEC isn't the only module that has/had a field by this name. Others include Ultimate SEO 2.200, Wishlist 2.0, "Track Package from Fedex, UPS, etc" and possibly others.

    If this is indeed a 'new install' and not an upgrade (or a reinstall of the same version) the error implies that you aren't starting out with a clean slate and that there is a file (or files) already sitting on the server that references this non existent field.

    You could try adding this field as you have suggested (use type VARCHAR) as this will *change* the error message even if it doesn't fix the problem. The 'new' error message (if you get one) may provide a clue as to the module/addon that is trying to use it.

    Cheers
    RodG

  8. #8
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Unknown column in configuration table

    Quote Originally Posted by DivaVocals View Post
    What are you trying to install??? It would help if you shared that....

    I was assuming a new ZenCart install, but you're right, he could be referring to a new module install.

    Cheers
    RodG

  9. #9
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Unknown column in configuration table

    Quote Originally Posted by RodG View Post
    I've just done a seach for configuration_tab and it appears that FEC isn't the only module that has/had a field by this name. Others include Ultimate SEO 2.200, Wishlist 2.0, "Track Package from Fedex, UPS, etc" and possibly others.

    If this is indeed a 'new install' and not an upgrade (or a reinstall of the same version) the error implies that you aren't starting out with a clean slate and that there is a file (or files) already sitting on the server that references this non existent field.

    You could try adding this field as you have suggested (use type VARCHAR) as this will *change* the error message even if it doesn't fix the problem. The 'new' error message (if you get one) may provide a clue as to the module/addon that is trying to use it.

    Cheers
    RodG
    Ty Package Tracker (Track Package from Fedex, UPS, etc) and Ultimate SEO 2.200 ABSOLUTELY DO NOT add this column to the configuration table.. the only modules which adds this column are ALL Numinix modules.. and FEC is only ONE module.. there are other Numinix modules..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  10. #10
    Join Date
    Jul 2014
    Location
    Bathurst NSW Australia
    Posts
    4
    Plugin Contributions
    0

    Default Re: Unknown column in configuration table

    Quote Originally Posted by RodG View Post
    I was assuming a new ZenCart install, but you're right, he could be referring to a new module install.

    Cheers
    RodG
    Hi,

    This is a completely new install. I started at the beginning of the instructions and went through them changing the permissions etc. I then attempted to install the responsive apparel boutique template and while following those instructions (including the complete backup) I received the error. After doing that complete cycle 3 times to make sure I hadn't missed anything, I then reinstalled and without attempting to install the template this time I went to Configuration > Product Listing and got the error, "WARNING: An Error occurred, please refresh the page and try again". This is with a completely new install straight out of the box (zip file) installation with nothing added. To me it looks like something missing in the install sql setup but again, it could be something I am missing.

    To add to the mystery, I have copied the installation package to a linux server (where I feel more at home) and have done a grep to try and locate anything to do with 'configuration_tab' and the search turned up blank! The error message in the log must be incorrect. I will go delve into the code and see if I can work out what is actually going wrong.

    Cheers,

    Warren

 

 

Similar Threads

  1. 1054 Unknown column 'value' in 'field list' ... "sessions" table
    By westonm in forum Installing on a Windows Server
    Replies: 5
    Last Post: 1 Jun 2012, 10:04 PM
  2. 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
  3. 1054 Unknown column
    By bugmenot in forum Installing on a Windows Server
    Replies: 9
    Last Post: 18 Feb 2008, 06:50 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