i receive this error when i access the configuration page of cer

Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).

i have 7.26 core -

and after i create the field for corresponding entity reference i get

Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
Warning: Invalid argument supplied for foreach() in cer_settings_form() (line 15 of /home/......./sites/all/modules/cer/cer.admin.inc).
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_types_content_fields' in 'where clause': SELECT t__0.* FROM {cer} t__0 WHERE (entity_types_content_fields IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => node*clienti*field_produse*node*produse*field_client ) in ctools_export_load_object() (line 462 of /home/webstral/public_html/service/sites/all/modules/ctools/includes/export.inc).

CommentFileSizeAuthor
#4 cer-2179689-field-no-bundles-4.patch653 bytesphenaproxima

Comments

phenaproxima’s picture

phenaproxima
he/him
Primary language English
Location Massachusetts
commented

A cursory glance suggests that there is database corruption here (I base that on the PDOException you're getting). If you look at your DB, the cer table should have two fields, 'enabled', and 'entity_types_content_fields'. If it doesn't have both of those, you may need to completely uninstall, then re-install CER.

phenaproxima’s picture

phenaproxima
he/him
Primary language English
Location Massachusetts
commented
Category: Bug report » Support request

Changing issue category.

danbarron’s picture

danbarron commented

I am also getting this warning. I am not getting the PDOException. So I wonder if they might not be related.

I had set up two relationships, person to incident, and incident to document, all nodes. So there are four checkboxes on the config form.

I did try uninstalling and reinstalling CER. Same problem, before I checked any boxes.

When I check all the boxes, I get two instances. If I then use the "Update Existing Entities" for Node and go back to the References tab there is only one instance of the warning. But it never goes away.

I looked at the database table cer and it looks to be correct to me.

I understand this is in development, and I am only going to link nodes for now, so I am going to try CNR, but wanted to let you know my experience, in case it helps run down the problem.

But this is a great project. I will follow it and move to CER once it's officially released.

phenaproxima’s picture

phenaproxima
he/him
Primary language English
Location Massachusetts
commented
Status: Active » Needs review
StatusFileSize
new cer-2179689-field-no-bundles-4.patch653 bytes

It seems that if you have a field which hasn't yet been instantiated on any entity types (there are a number of reasons why this could happen), this error will be triggered, and could lead to other problems. I've attached a small patch that adds a sanity check. Let me know if this helps.

phenaproxima’s picture

phenaproxima
he/him
Primary language English
Location Massachusetts
commented
Status: Needs review » Closed (fixed)

Patch committed to 7.x-2.x.

  • Commit 66bc15b on 7.x-2.x by phenaproxima: 
    Issue #2179689: Invalid argument supplied for foreach() in...