The fields Enable Google AdWords on this node and Conversion Label are being shown on the specified content types, but the entered values are not being saved.
I can only produce the tracking code in a page by using the field Label | Pages on the General Conversion settings page.
(CSS and Javascript optimalisation are off. Cache-data are flushed.)

Same problem on my dev server:
user warning: Unknown column 'color' in 'field list' query: INSERT INTO google_adwords (nid, vid, enabled, label, format, color) VALUES (572, 575, 1, 'c_XXXXXXXXXXX', '2', 'FFFFFF') in F:\Data\inetpub\wwwroot\XXXXXXXX\sites\all\modules\google_adwords\google_adwords.module on line 167.

Comments

cburyta’s picture

cburyta commented

Just to bump this, I'm getting the same error. The below message was directly after saving a webform type nodes settings (the settings did save ok.) (e.g. node/234/webform/configure)

user warning: Unknown column 'color' in 'field list' query: INSERT INTO google_adwords (nid, vid, enabled, label, format, color) VALUES (234, 238, 0, '', '', '') in /var/www/projects/cho_site/sites/all/modules/google_adwords/google_adwords.module on line 167.

Update

To follow up, I notice that the .install has an odd discrepancy... the color field is in the 6001 update, but it's not in the actual _schema function. However, the format column is defined in both the _schema function as well as the 6001 update.

I fixed the issue by running the 6001 update via the update.php. I received an error stating the format column was already defined, but the update did create the color column in the google_adwords table... now I don't get the errors originally stated any longer.

Preston McMurry’s picture

Preston McMurry commented
Status: Active » Closed (duplicate)

This is a dupe of the "color field not included in install procedure" issue ( http://drupal.org/node/1271880 ), which has been solved with a patch. You will need to disable the module, then uninstall it, apply the patch, re-enable the module, step through the configs to your edit page, edit it, then save, noting the error no longer occurs.

stewart.adam’s picture

stewart.adam commented

(Note to those coming here through Google: link above should be to #1135348: color field not included in install procedure)

stewart.adam’s picture

stewart.adam commented
Issue summary: View changes

Same problem on my dev server: user warning added to message