I am getting the below error on the latest update... any ideas how to fix?

The following updates returned messages

simpleads module

Update #7005
Failed: FieldException: Attempt to create field name field_ad_status which already exists and is active. in field_create_field() (line 85 of /home/site/public_html/modules/field/field.crud.inc).

Comments

minnur’s picture

minnur commented

It says that you already have field_ad_status in the system. Please make sure that field_ad_status doesn't exists before running update.

Thanks.

virtuali1151’s picture

virtuali1151 commented

Where do I go to remove that..??? In the DB..??

I tried to rename this field_data_field_ad_status to field_data_field_ad_status_old and it still gave me the same error...

Cheers.

minnur’s picture

minnur commented

Open this page http://yoursite/admin/reports/fields and confirm that the "field_ad_status" exists/doesn't exists.

virtuali1151’s picture

virtuali1151 commented

Ah... got it... thanks for your help mate..

Cheers.

minnur’s picture

minnur commented
Status: Active » Closed (fixed)

no problem

virtuali1151’s picture

virtuali1151 commented

UGGG... Spoke to soon... now I am getting this..??

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'tid' cannot be null: INSERT INTO {simplenews_newsletter} (nid, tid, status) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 81 [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 0 ) in simplenews_newsletter_save() (line 2012 of /home/site/public_html/sites/all/modules/simplenews/simplenews.module).

minnur’s picture

minnur commented

PHP error comes from SimpleNews not from SimpleAds.

virtuali1151’s picture

virtuali1151 commented

Ahh.. yup.. just noticed that one.. Cheers.

Sk1Zy’s picture

Sk1Zy commented

I got the same error, i checked the field report and it isn't there. I also checked the views field report and it was there, i removed the field from the view so it doesn't show up in the report anymore but i still get the same error.

xlyz’s picture

xlyz commented
Priority: Critical » Major
Status: Closed (fixed) » Active

definetely something is broken with #7005 update.

in my case the field field_data_field_ad_status is present in the db, but it does not shows up neither in the fields list (/admin/reports/fields) nor in the manage fields page of the simple ad content (/admin/structure/types/manage/simpleads/fields).

drush updb ends with an ok, but if I try it again the 7005 update shows up again:

$ drush updb
The following updates are pending:

simpleads module : 
  7005 -   Create a new field for Ad status. Disalbe comments on SimpleAds content type. 

Do you wish to run all pending updates? (y/n): y
Finished performing updates.                                         [ok]
$ drush updb
The following updates are pending:

simpleads module : 
  7005 -   Create a new field for Ad status. Disalbe comments on SimpleAds content type. 

Do you wish to run all pending updates? (y/n):
minnur’s picture

minnur commented

Which version of SimpleAds you were trying to upgrade? ( for instance 1.5 => 1.8)

xlyz’s picture

xlyz commented

1.7 => 1.8

minnur’s picture

minnur commented
Status: Active » Closed (duplicate)

See #1594798: Reinstalling the module does not create the content type fields