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

wazm:

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

picaflor-azul:

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

wazm:

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.

picaflor-azul:

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

wazm:

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

wazm:

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

DivaVocals:

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

RodG:

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

RodG:

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