After you create a custom publishing option, if you then delete it the site gets a bit angry. Although the column is correctly removed from the 'Node' table, it looks as though the module isn't cleaning up after itself properly when doing the removal.

Here's the full error (for reference, the machine name of the custom publishing option i created and then deleted was 'hide_social_media_links'):

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.hide_social_media_links' in 'field list': SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, base.hide_social_media_links AS hide_social_media_links, base.premium AS premium, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM {node} base INNER JOIN {node_revision} revision ON revision.vid = base.vid WHERE (base.nid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 91 ) in DrupalDefaultEntityController->load() (line 196 of C:\wamp\www\prepopulate-test\includes\entity.inc).
The website encountered an unexpected error. Please try again later. 

Fortunately, I had a database backup from just before installing the module and so I just rolled back to that version and started again, this time creating the publishing option exactly as I wanted. Serves me right for not thinking through what I wanted to do first! ;)

Comments

kevinquillen’s picture

Status: Active » Closed (cannot reproduce)

I created and then deleted a custom publishing option. The column was removed from the node table, and I did not receive a PDO exception.

I presume this was fixed along the way.