ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

SQL error when publishing - looking for a column that doesn't exist

January 25, 2011 7:08am

Subscribe [2]
  • #1 / Jan 25, 2011 7:08am

    digitalformula

    176 posts

    Hi all,

    Why would this be happening when trying to publish an entry?

    A Database Error Occurred
    
    Error Number: 1054
    
    Unknown column 'field_ft_15' in 'field list'
    
    INSERT INTO exp_channel_data (`entry_id`, `channel_id`, `site_id`, `field_ft_1`, `field_ft_3`, `field_ft_2`, `field_ft_4`, `field_ft_15`, `field_id_1`, `field_id_3`, `field_id_2`, `field_id_4`, `field_id_15`, `field_id_5`, `field_id_10`) VALUES (63, '1', '1', 'none', 'none', 'none', 'none', 'none', '
    
    \nsome content\n
    ', 'This is only a test', 'tag', 'http://digitalformula.net/d/1a', 0, '', '')
    
    Filename: libraries/api/Api_channel_entries.php
    
    Line Number: 1789

    I’ve checked the database and field_ft_15 definitely doesn’t exist.

    The error is happening on my dev site only, not the production site.  Both are running EE 2.1.1 20101020.

    I can see it’s because of custom fields somehow but I can’t figure out why it’s happening.

    Can someone help?

    Thanks!

  • #2 / Jan 25, 2011 7:10am

    digitalformula

    176 posts

    Also, both sites are setup the same in terms of modules, categories, fields etc.

  • #3 / Jan 25, 2011 7:57am

    digitalformula

    176 posts

    Fixed it.  Found a row in one of the custom field tables that had a different primary key value on the development site.  Changed to match the production site, all working.

  • #4 / Jan 25, 2011 5:54pm

    Sue Crocker

    26054 posts

    Glad you were able to figure out what the problem was. Don’t hesitate to post again as needed.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases