Drupal 7 multi-site install is half working–What's the next thing to check with a View SQL error?-Collection of common programming errors
Multi-site Drupal 7 and Draggableviews module is giving me heck. I’ve uninstalled every module and re-enabled the absolute minimum in a sub-site (call this site “wiskey”) of my multi-site installation. A search for similar “unknown column” errors frequently pointed to References module. I updated with drush upc.
Since this is a multi-site, I created a Draggableviews test View in the default site (call this site “alpha”) and this works, and drags my table like a champ. Which tells me its a problem with the ‘w-site’ and there’s nothing wrong with the Drupal, Views, or Draggableviews modules.
I ran a diff on drush pml of both sub-sites until they were identical. Enabled Seven theme. I re-made the original view. Cleared the Views cache. But, I’m still getting this error,
SQLSTATE [42S22]: Column not found: 1054 Unknown column 'draggableviews_structure.weight' in 'field list'.
What next?
This= Drupal 7 (recently updated). MySQL. Only one admin user (I checked all the admin/owner permissions to be sure).
Originally posted 2013-11-09 21:09:33.