The views part of table wizard is broken after update from 1.2 to 1.3
The fields no longer can be found, resulting in huge numbers of errors.

Comments

moonray’s picture

moonray CreditAttribution: moonray commented

Looks like this got fixed by deleting the view in question and flushing caches... but not a clean update, it seems.

luthien’s picture

luthien CreditAttribution: luthien commented

I experienced the same problem when I tried to update from 6.x-1.1 to 6.x-1.2, all the views were broken. If updating from 1.1 to 1.3, the views are still visible but views with custom php (http://drupal.org/project/views_customfield) fields are broken, I get the missing/broken link message for those fields. Any idea how to update without breaking the site? my site uses tw to link to external dbs then we generate the views, having this module working is critical for the correct functioning of the web site.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Murphysboro, IL, USA
CreditAttribution: mikeryan commented
Status: Active » Postponed (maintainer needs more info)

Did you run update.php when upgrading? Does clearing the Drupal cache help?

One thing that may be a problem is the change in how date fields are represented to Views - default views from Table Wizard should be fixed by clearing the cache, but I'm not sure how views you've built on top of Table Wizard tables will fare - and I also don't see what Table Wizard can do about it...

luthien’s picture

luthien CreditAttribution: luthien commented

Yes, I used drush to update tw and I cleared the cache. I still don't know why the dynamic field is emptied every time I update tw.

freelock’s picture

freelock
Location Seattle
CreditAttribution: freelock commented

Not sure if this is the same issue as you're getting, but we had a major breakage happen with upgrade to 1.3 because we were trying to add a relationship to the main {users} table. TW now automatically creates views handlers for each table you add -- which duplicate the core views users module support, and cause those views handlers to break entirely (along with ugly error messages all over the site).

Errors go away when you remove {users} from the table list -- but then you lose the relationship to that table.

luthien’s picture

luthien CreditAttribution: luthien commented

My problem is different, not related with the {users} table. I have not been able to update from 1.1 yet, tw is the most important module for our web site and only 1.1 works fine. Recently, I exported my views to a module, I can try to update again to see if that works considering that now the code for the dynamic field was saved as code in a module.

Test: I moved my views to a module, I tried to update tw again (using drush) but I got a blank screen, I'm not able to access any page. Still unable to update tw to the latest version.

Executing tw_update_6006                                                                                 [success]
ALTER TABLE {tw_tables} ADD `provide_view` TINYINT unsigned NOT NULL DEFAULT 1                           [success]
ALTER TABLE {tw_tables} ADD `view_name` VARCHAR(255) NOT NULL DEFAULT ''                       [success]
ALTER TABLE {tw_tables} DROP existing_view_data                                                          [success]
Finished performing updates.                                                                             [ok]
The following updates are pending:

 tw module                        
 6006 - description not available