Hiya,

I have been testing out doing the migration which has involved going back to a base state of my site (pre-registration). So I downloaded the latest version of registration and when I tried to install the module, I get the following error:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (fc.active = '1') AND (fc.storage_active = '1') AND (fc.deleted = '0') AN' at line 3: SELECT fci.* FROM {field_config_instance} fci INNER JOIN {field_config} fc ON fc.id = fci.field_id WHERE (fci.field_name IN ()) AND (fc.active = :db_condition_placeholder_0) AND (fc.storage_active = :db_condition_placeholder_1) AND (fc.deleted = :db_condition_placeholder_2) AND (fci.deleted = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => 0 ) in field_read_instances() (line 704 of /Users/amodi/Sites/d7.redcat.org/modules/field/field.crud.inc).

And there is no way to recover and try to uninstall the module (drush or otherwise - I had made backups and its on my dev site so I went back to an older version of my db)
I see that there are a *lot* of commits over the weekend but the one that I get the issues starting from are commit hash a1bfbc2cdac8a375a744f0d2f474f369ee94cfcd (#1428976: Add Views Relationships to Author and Parent Entity). If I go to the commits prior to that, the codebase seems to work just fine.

Comments

pixelsweatshop’s picture

I can confirm the same thing on both alpha and dev on a clean install.

dpi’s picture

Assigned: Unassigned » dpi

I'll see what I can do.

dpi’s picture

Status: Active » Needs review
StatusFileSize
new2.03 KB

46520e1e and a1bfbc2c may have been the issue.

Give this patch a shot.

Note: Adds new general purpose helper.

levelos’s picture

Status: Needs review » Fixed

Thanks @dpi, pushed with a few minor tweaks in ee7cb48.

yktdan’s picture

Version: 7.x-1.x-dev » 7.x-1.0-alpha3
Status: Fixed » Needs work

haven't tested -dev but alpha3 gets bad arg errors on array_keys($registration_fields)
fatal - had to delete module to get system working again.
waiting for alpha4 to test again

dpi’s picture

Status: Needs work » Postponed (maintainer needs more info)

Cannot reproduce on existing install, or fresh installs.

yktdan’s picture

The dev version supposedly fixes the problem in alpha3 which has a date earlier than the dev version. I am waiting for a new alpha version or better yet a full release. I don't like running dev on live sites.

bforchhammer’s picture

Version: 7.x-1.0-alpha3 » 7.x-1.x-dev
Status: Postponed (maintainer needs more info) » Fixed

I can confirm that the issue is indeed solved in the dev version. It doesn't look like this needs work or more info... correct me if I'm wrong.

spgd01’s picture

I can confirm that alpha 3 breaks the site with an error and 1.x dev works.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

  • levelos committed ee7cb48 on 7.x-1.x, panels, any-entity, slots, integrations, hold_state authored by dpi
    #1430574 by dpi: Resolve fatal field instace errors when a field did not...