PHP Error with Channel Field Group

Question

I am getting a PHP Error, when I go to publish > Channel(name). I have this assigned to what I call the 'master' field group (master) it has 15 fields. I set up a test field group and assigned it to the channel and NO ERROR message. Can I fix this without rebuilding the master field group? I can not find out if there is a limited to the Number of field group I can have.

Here are the 3 PHP Error I get:

A PHP Error was encountered

Severity: Notice
Message: Undefined offset: 0
Filename: models/grid_model.php
Line Number: 496

A PHP Error was encountered

Severity: Warning
 Message: Cannot modify header information - headers already sent by (output    started at /home/jbreen/dev-sbco/sbco/codeigniter/system/core/Exceptions.php:170)
 Filename: core/Common.php
 Line Number: 475

A Database Error Occurred

Error Number: 1054
Unknown column 'col_id_' in 'order clause'
SELECT * FROM (`exp_channel_grid_field_15`) WHERE `entry_id` IN (0) ORDER BY `col_id_` asc
Filename: models/grid_model.php
Line Number: 413

Answer 1

From your question, it looks like the issue is in the channel field with the ID 15, and this field is in fact a grid type.

I've posed a few questions for you above, however as a "first answer" could you try going to your Channel fields, removing just field with ID of 15 (grid) and recreating please?

That's what the error is saying, field 15 has got issues in the DB. Another question, have you recently tried updating a server with your local copy? it could be (cant be sure, lack of info) that you created a grid field on your local/dev (which created the table and columns) and then migrated the data to a different server, and lost some of your field setups...