PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'machine_name' in 'field list': SELECT domain_id, subdomain, sitename, scheme, valid, weight, is_default, machine_name FROM {domain}; Array ( ) in domain_lookup() (line 1047 of /www/htdocs/wwwuser/hp/drupalsite/sites/all/modules/domain/domain.module)

Not sure if this is a particular domain acces issue allone, but in the moment it seems so and it causes firstly a WSOD and then it shows the error above without theme (white). That's why I wanted to post it soon. I will check any dependencies of the error and will report soon. Drush shows the same error and isn't possible to do anything in this root installation.

System info: Drupal 7.7 - latest domain access - latest i18n - latest variable - latest views,ctools,token,entity,ds and further depending modules

Comments

dqd’s picture

Title: After update 7.13 > 7.14 an SQLSTATE error occured - column machine_name in 'field list' not fount » Update 7.13 to 7.14 causes SQLSTATE error: WSOD with column machine_name in 'field list' not fount
Issue tags: +error, +WSOD, +update, +SQLSTATE
dqd’s picture

Title: Update 7.13 to 7.14 causes SQLSTATE error: WSOD with column machine_name in 'field list' not fount » Update 7.13 to 7.14 causes WSOD with SQLSTATE[42S22] error: column machine_name in 'field list' not found

I did a pm-update with Drush 5.x-dev and get the certain feeling that Drush has messed up the module updates. I will make a manual update of domain access and the other modules again and will report.

dqd’s picture

Now, after updating latest

ctools-7.x-1.x-dev.tar.gz
domain-7.x-2.14.tar.gz
ds-7.x-1.3.tar.gz
entity-7.x-1.x-dev.tar.gz
i18n-7.x-1.0.tar.gz
i18nviews-7.x-3.x-dev.tar.gz
token-7.x-1.x-dev.tar.gz
variable-7.x-1.1.tar.gz
views_bulk_operations-7.x-3.x-dev.tar.gz
views-7.x-3.x-dev.tar.gz

... manually again, to make shure that not Drush has messed up anything, the following error occures:

Fatal error: Cannot redeclare domain_theme_batch_lookup() (previously declared in /www/htdocs/wwwuser/hp/drupalsite/sites/all/modules/domain/domain_theme/domain_theme.module:286) in /www/htdocs/wwwuser/hp/drupalsite/sites/all/modules/domain/domain_theme/domain_theme.domain.inc on line 88

dqd’s picture

rolling back domain v2.13 doesn't help. same error, no chance to get in from any site or side ...

I have compared the database entries of this site with a fresh new test installation of Drupal with same modules and same preferences. No errors and the data entries are the same...

I have no idea where to search ...

agentrickard’s picture

Category: bug » support
Status: Active » Closed (cannot reproduce)

You have accidentally installed all or part of 7.x.3-dev, not 7.x.2.14. The 'machine_name' change does not exist _at all_ in the 7.x.2 branch.

Delete all the files in the /domain directory and re-download 7.x.2.14.

dqd’s picture

... maybe that happend by using drush pm-update to latest --dev or something accidently? Weird. I can confirm that it works now with 2.14 fresh install. I had to remove any folder and database entries manually because there was no chance to use drush uninstall or module lists in /admin.

For followers, remove the top level database rows 'domain' and all 'domain_*' following and the database entries with 'domain' and 'domain_*' in 'system'-datarow and then the folder 'domain' in 'sites/all/modules'

then clear all caches and reinstall domain 7.x-2.14 and rebuild node permissions.

Thanks for taking time, agentrickard.

dqd’s picture

Issue summary: View changes

appendix