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.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | registration-instance-errors-5568144-3.patch | 2.03 KB | dpi |
Comments
Comment #1
pixelsweatshop commentedI can confirm the same thing on both alpha and dev on a clean install.
Comment #2
dpiI'll see what I can do.
Comment #3
dpi46520e1e and a1bfbc2c may have been the issue.
Give this patch a shot.
Note: Adds new general purpose helper.
Comment #4
levelos commentedThanks @dpi, pushed with a few minor tweaks in ee7cb48.
Comment #5
yktdan commentedhaven'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
Comment #6
dpiCannot reproduce on existing install, or fresh installs.
Comment #7
yktdan commentedThe 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.
Comment #8
bforchhammer commentedI 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.
Comment #9
spgd01 commentedI can confirm that alpha 3 breaks the site with an error and 1.x dev works.