I just installed Contemplate and even if all I do is check "affect body" and save it (no changes at all), I get this error:

user warning: Unknown column 'rss' in 'field list' query: INSERT INTO contemplate (type, teaser, body, rss, enclosure, flags) VALUES ('ad', '

\n

Strapline

\n

\n
print $field_strapline[0][\'view\']

\n

\n

\n\n

\n

Advertising Agency

\n

\n
print $field_advertising_agency[0][\'view\']

\n

\n

\n\n

\n

Client

\n

\n
print $field_client[0][\'view\']

\n

\n

\n\n

\n

Image

\n

\n
print $field_image[0][\'view\']

\n

\n

\n\n

\n

Art Director

\n

\n
print $field_art_director[0][\'view\']

\n

\n

\n\n

\n

Copywriter

\n

\n
print $field_copywriter[0][\'view\']

\n

\n

\n\n

\n

Photographer

\n

\n
print $field_photographer[0][\'view\']

\n

\n

\n', '

\r\n

Strapline

\r\n

\r\n
print check_plain($node->field_strapline[0][\'value\'])

\r\n

\r\n

\r\n\r\n

\r\n

Advertising Agency

\r\n

\r\n
print check_plain($node->field_advertising_agency[0][\'value\'])

\r\n

\r\n

\r\n\r\n

\r\n

Client

\r\n

\r\n
print $field_client[0][\'view\']

\r\n

\r\n

\r\n\r\n

\r\n

Image

\r\n

\r\n
print $field_image[0][\'view\']

\r\n

\r\n

\r\n\r\n

\r\n

Art Director

\r\n

\r\n
print $field_art_director[0][\'view\']

\r\n

\r\n

\r\n\r\n

\r\n

Copywriter

\r\n

\r\n
print $field_copywriter[0][\'view\']

\r\n

\r\n

\r\n\r\n

\r\n

Photographer

\r\n

\r\n
print $field_photographer[0][\'view\']

\r\n

\r\n

\r\n', '

\n

Strapline

\n

\n
print $field_strapline[0][\'view\']

\n

\n

\n\n

\n

Advertising Agency

\n

\n
print $field_advertising_agency[0][\'view\']

\n

\n

\n\n

\n

Client

\n

\n
print $field_client[0][\'view\']

\n

\n

\n\n

\n

Image

\n

\n
print $field_image[0][\'view\']

\n

\n

\n\n

\n

Art Director

\n

\n
print $field_art_director[0][\'view\']

\n

\n

\n\n

\n

Copywriter

\n

\n
print $field_copywriter[0][\'view\']

\n

\n

\n\n

\n

Photographer

\n

\n
print $field_photographer[0][\'view\']

\n

\n

\n', '', 2) in C:\www\drupal\includes\database.mysql.inc on line 172.

Comments

jjeff’s picture

jjeff commented

You've just installed version 1.2?

Were you updating from a previous version?

If so, did you run update.php?

If not, do you know if you happened to see any errors when you first enabled the module?

Thanks.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Priority: Normal » Critical

No, I did not update from a previous version - that's the problem. In update_1 you added fields, but you never went back and put them in the .install code. I forced update_1 to run and the problem is cleared up, but this needs to be fixed for anyone else installing for the first time.

jjeff’s picture

jjeff commented

Correct. Looks like installer file got out of sync. Should be fixed now. New release (Drupal 5 ver1.3) fixes this problem.

Thanks for the report!

Robardi56’s picture

Robardi56 commented

Hi,
I upgraded from 1.2 to 1.3 and ran the upgrade script, and still got the error after.
Is the only fix for this to uninstall / reinstall the module ?

Can't the upgrade script create the missing data ?

Thanks,
Brakkar

Robardi56’s picture

Robardi56 commented
Status: Active » Fixed

It's ok I forced it to run update 1.

DanielR’s picture

DanielR commented

I could really use the fix above. Anybody know how to run just one update function as suggested?

Robardi56’s picture

Robardi56 commented

On the upgrade script page, open the drop down menu with all the drop down menus of all your installed modules.
Go the the line about contemplate, open the drop down menu, and select the "1".

Then run the script, it will create the necessary tables.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)