Unable to Publish using the Control Panel (only one channel) - Database Error 1054
Development and Programming
9 years ago
Happens when I try to publish to a specific channel. Other channels working fine.
A Database Error Occurred Error Number: 1054
Unknown column ‘field_id_0’ in ‘field list’
SELECT field_id_0 FROM (exp_channel_data) WHERE channel_id = ‘0’
Filename: fieldtypes/select/ft.select.php
Line Number: 162
Haven’t seen this one before. Any ideas where to start?
-Tony
9 years ago
Looks like line 162 in that file is this:
$pop_query = ee()->db->get(‘channel_data’);
I don’t speak PHP tho… 😊
-Tony
9 years ago
Never mind. Found this answer from our forums:
Problem solved! Here’s the deal. I had several ‘Select Dropdown’ fields and on one of those fields a radio button was not selected:
- Populate the menu manually
- Populate the menu from another channel field
If one of them is not selected it throws this error.