Hi,

With the last version, when i clic on the Save button, i get this error message :

PDOException : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'annuaire_f_d_ral' for key 2: INSERT INTO {views_view} (name, description, tag, base_table, human_name, core) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => annuaire_f_d_ral [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => default [:db_insert_placeholder_3] => node [:db_insert_placeholder_4] => Annuaire Fédéral [:db_insert_placeholder_5] => 7 ) dans views_db_object->save_row() (ligne 1830 dans /homepages/36/d260999590/htdocs/Intranet/sites/all/modules/views/includes/view.inc).

When i come back back to edit the view, i have this message before the edit page :
All changes are stored temporarily. Click Save to make your changes permanent. Click Cancel to discard the view.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Letharion’s picture

Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

We need steps to reproduce.

cyrakuse’s picture

i clic on "create a new view"
i put my view name "my test view"
i clic on "continue and edit"
i set the parameters of my view :

Filter criteria :
node type = my_node
taxonomy vocabulary = my_taxonomy_vocabulary
taxonomy term = exposed

Page settings :
Menu : normal menu entry
Access : Rôle : Multiple roles

I always have this error.

dagomar’s picture

I can confirm this. This occurred after I upgraded to beta3 from alpha1.

The 'all changes are stored temporarily' message occurs also without the PDO wsod.

ashedryden’s picture

I can also confirm. Happens on every view after the second save.

Peasoup’s picture

With different parameters it also happens here.
Filtercriteria:
content:published (yes) AND
content: Type(= this_type)
AND
content: has taxonomy term (= first_term) OR
content: has taxonomy term (=second_term)

menu: normal
access: permissions: show published content

Edit: but apparently it DID save the changes, but still shows the yellow box "All changes are stored temporarily...." and so on

dagomar’s picture

After I upped php memory, this problem stopped for me...

Dave Reid’s picture

I can also confirm this. I keep getting 'Integrity constraint violation' when saving a comment RSS view with two Feed displays.

Dave Reid’s picture

Version: 7.x-3.0-beta3 » 7.x-3.x-dev
Status: Postponed (maintainer needs more info) » Active

I also am doubtful this is related to memory limit. I already have my since to 256M but am still getting the SQL error when saving views.

neoglez’s picture

Status: Active » Postponed (maintainer needs more info)

I can not reproduce this one, i used #2 and #5 test cases.
Please see this issue for reference & let me know:
http://drupal.org/node/1136196

merlinofchaos’s picture

Ok, so what we've got here:

The error we're seeing indicates that Views is trying to write a new view, but the view already exists in the database, and thus there is a constraint violation -- you can't re-use the key.

The question then becomes, why does it think the view is new when it is already in the database? Obviously several people are seeing this, so we can't just dismiss it, but we can't seem to intentionally get things into this state. The missing piece of information is ... how does this happen? Once it's happening I can see what's going on -- most likely there is a 'new' view in the cache while there is the existing view saved.

But how?

Can anyone who's seeing this identify anything unusual going on? Multiple people trying to work on the same view? Or the same person on multiple browsers, perhaps?

Peasoup’s picture

I received this message quite a few times, not just once, I wouldn't have checked for an open issue if it would have been a one time error, but since a few days I can't reproduce it either. So I'm sorry that I can't give any further hints, where this error comes from. But it does not occur due to multiple people working on the same view, that I can tell for sure as my co-worker didn't interfere with the site that day and it happened on a test installation, so no one from outside could have used the site in that moments. I did have the site open in different browsers that day, but I didn't work with views in the other browser. And it also doesn't happen these days, regardless of browsers using the site.
Sorry that I can't be of much help right now. I'll let you know if I manage to reproduce it!
Thanks for your time and work!

cutmedia’s picture

Have the same error after cloning a calendar view and trying to save all latest devs Views, Ctools, Date, Calendar:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'regular_exercise_regime' for key 'name': INSERT INTO {views_view} (name, description, tag, base_table, human_name, core) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => regular_exercise_regime [:db_insert_placeholder_1] => A multi-dimensional calendar view with back/next navigation. [:db_insert_placeholder_2] => Calendar [:db_insert_placeholder_3] => node [:db_insert_placeholder_4] => Regular Exercise Regime [:db_insert_placeholder_5] => 0 ) in views_db_object->save_row() (line 1929 of C:\xampp\htdocs\test\modules\views\includes\view.inc).

aqua_linksunten’s picture

I can confirm this error. I duplicated a view, changed a view things, hit the save button and everything seemed ok. I than noticed a misspelled title changed that, hit the save button and got the error.

A possible workaround is to go to PHPMyAdmin, find the questionalble view in the views_view table and delete it. Than the view can be saved and the vid is incremented by one.

benschaaf’s picture

I just received this error on Site B, but only after an unsuccessful import a view with the same name from a different site (Site A). (If that makes any sense)

aqua_linksunten’s picture

Hours later it worked with no trouble, after unlocking the changes i didn't save before. So I would assume it's an issue fixed by a cron-run (as nothing else change through the time). Maybe some cache? Also I did clear the cache before.

davidneedham’s picture

Anyone here recently create some Views Content Panes, then decide not to use panels and disable the module?

I was having this problem and noticed that I had some content pane displays - despite the module being disabled. After enabling the Views Content Panes module and removing my content pane displays, my view has returned to its normal behavior.

afdave14’s picture

I have the same error as the original author of this issue. Every time I try to save the view, I get the PDOException. The reason I had this error and thereby found this issue is because I was getting the following error:

Strict warning: Declaration of views_handler_filter_user_name::value_submit() should be compatible with that of views_handler_filter_in_operator::value_submit() in require_once() (line 6 of C:\xampp\htdocs\mywebsite\sites\all\modules\views\modules\user\views_handler_filter_user_name.inc).

I looked at some posts and others who had the same error were suggested to uninstall the current version of views (the beta version) and install the latest dev version. I went ahead and tried to uninstall the current version of views via the interface provided by Drupal on the modules page. I went to install the dev version and it said that I already had views installed. So I looked at the list of modules I had installed and low and behold, there was views, comfortably still sitting there. I then manually deleted the views folder in the sites/all/modules directory, refreshed the module page and it was gone. Now, whether or not I was supposed to do that, I don't know, but that was the only way I could install the dev version.

When I finally installed the dev version, I had some layout issues when going to edit some views and so I reverted to the beta version of views. Before I did that though, I received the same PDOException. Like I said, I'm using the beta version right now and I'm still getting the error. If anyone can figure out what's going on, that'd be great.

(I've flushed the cache several times with no luck)

davidneedham’s picture

@afdave14 - to fix the layout problem in the dev release, see: #1153708: Views Interface garbled. Basically, update ctools to dev release and flush cache.

aqua_linksunten’s picture

in reply to # 16: No, i've never installed panels.

neoglez’s picture

I then manually deleted the views folder in the sites/all/modules directory, refreshed the module page and it was gone. Now, whether or not I was supposed to do that, I don't know, but that was the only way I could install the dev version.

You erased the folder but didn't erase the views tables?? (see views.install hook_schema). Views module is files + db.

afdave14’s picture

I'm sorry, what is views.install hook_schema

afdave14’s picture

I uninstalled ctools and views, including deleting the actual directory's in the modules folder and installed the dev versions for both of the modules. I didn't actually remove any db items partially for curiosity sake to see if I would have any issues after installing both modules, but also because I honestly didn't know how to. Not with phpmyadmin. I'm used to using putty but I don't know how to log into the database on my local machine. Stupid? Probably, but that's why.

After installing dev releases for both modules everything works fine, including the layout. Not sure why though. I guess it's because I'm using a different version of ctools.

neoglez’s picture

Stupid? Probably, but that's why

No, at all.
In hook schema is described the DB structure of a module. To work with phpmyadmin is very easy (it has a web interface), just need to read the docu.
On the other hand, the layout issue has to do with ctools & cache situation (see for example the picture in #12 and the recommendation in #15 ), but you fixed that already right? ;-)
I see two things here:

  • The PDO exception-> You erased the Views files but not the DB, the info is already there, thereby the Integrity constraint violation by tring to create a new record intead of updating the one already in db?
  • The imposibilty of deactivating-deinstalling Views-> Would this be the right title of this issue and what we are seeing is just a consequence of it?

With this info, i'm gonna try to reproduce this issue (it's very shy, it appears by it's own will ;-)

benschaaf’s picture

@#15.

After running cron, I was able to save my view as well. An awful "bug".

benschaaf’s picture

Update: I am still getting error still and running cron is not resolving the issue. Hmm.

drcho’s picture

@snowfox - I had the same problem. After running cron, all new created views worked (even with the same settings), but not the old view with the error message.

drcho’s picture

FileSize
29.68 KB

Update: After trying to delete the erroneous view, I got this error message:
Access denied - Notice: Undefined property: view::$export_type in ctools_export_ui->access() (line 128 of /www/drupaldev/sites/all/modules/ctools/plugins/export_ui/ctools_export_ui.class.php)

Perhaps an issue of views in combination with ctools?

shawsolution’s picture

+1 Subscribing

sectornitad’s picture

+1 Subscribing

ConradFlashback’s picture

sub

nyoz’s picture

I coming with fresh infos here, as I'm experiencing the same PDOexception error since a few days. Here is it's consequences and how I got there.

=> WHAT I DID BEFORE THE ERROR OCCURED :

- I updated Views to 3.0 - rc1 and CTools to 1.0 - beta1 via the administration panel. I then updated the database as it asked me to. But it crashed (PHP Memory limit error).

- So, I used the trick of merlinofchaos detailled there : http://drupal.org/node/1170312#comment-4547662
Is seems to have worked as no db update were asked. But it soon became the total chaos !!! I had php memory limit for any page loaded, even those without any views related content... (btw most of those errors were related to views/theme/theme.inc).

- Thus I uninstall manually views rc1 and reinstall manually the beta 3. I then did the http://drupal.org/node/1170312#comment-4547662 again so as to possibly undo the db modification done by Views rc1 / rebuild the registry (BUT DID THAT WORK? I have no idea).

=> SINCE THEN :

- Everything seems back to more or less normal (I have less php memory limit error, but those are due to ViewsUI which is pretty heavy...).
- BUT I can't save anymore any change of any kind to any type of view. When I edit a view, the "* All changes are stored temporarily. Click Save to make your changes permanent. Click Cancel to discard the view." appears all the time. And when I click on the "save" button, I get (the name of the view is derniers_coms) :

PDOException : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'derniers_coms' for key 2: INSERT INTO {views_view} (name, description, tag, base_table, human_name, core) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => derniers_coms [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => default [:db_insert_placeholder_3] => comment [:db_insert_placeholder_4] => Derniers_coms [:db_insert_placeholder_5] => 7 ) dans views_db_object->save_row() (line 1830 in **DRUPAL_ROOT_FOLDER**/sites/all/modules/views/includes/view.inc).

And when I refresh the page (F5), I get back to the edit page, and the changes are still not saved... So I'm totally blocked right now.

And this can't be a multiple access to the same db entry as I've read above : I'm the only one editing the site, and I access on only one browser in an individual window.

=> Do you want me to test something particulary (like trying to update once again views to rc1) ?
(It seems like my major problem is a problem of badly built registry, how to fix it?).

Thks for reading !

nyoz’s picture

Is anyone still following this issue ??

nyoz’s picture

Status: Postponed (maintainer needs more info) » Active
neoglez’s picture

Thus I uninstall manually views rc1

What does that supossed to mean? (deleted the module, update the system table in DB, deleted the views_view table...??)

nyoz’s picture

Well, I managed to uncheck Views in the modules pages despite the php errors. Then I erased the views folder by FTP, and copy the old one (beta3) by FTP. Then check views again in the module page.

Then I tried to rebuild the registry with merlinofchaos script, but I think I failed! ^^

chiappa’s picture

I also cannot delete views. It says:

Access denied

Notice: Undefined property: view::$export_type in ctools_export_ui->access() (line 128 of /Library/WebServer/Documents/toritori/sites/all/modules/ctools/plugins/export_ui/ctools_export_ui.class.php).

You are not authorized to access this page.

eric-ie’s picture

Yes still running into this issue. As far as I can tell the steps to reproduce the problem are still as described above.
1) Install CTools 7.x-1.0-beta1
2) Install Views 7.x-3.0-rc1
3) Make a new View save it (seems to work fine)
4) Modify that View then save it results in the following error

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'adptd_front' for key 'name': INSERT INTO {views_view} (name, description, tag, base_table, human_name, core) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => adptd_front [:db_insert_placeholder_1] => Shows Work Highlights and company summary [:db_insert_placeholder_2] => default [:db_insert_placeholder_3] => node [:db_insert_placeholder_4] => Adptd Front [:db_insert_placeholder_5] => 7 ) in views_db_object->save_row() (line 1977 of /Users/eric/TestSiteD7/sites/all/modules/views/includes/view.inc).

After that error I'm unable to delete the view or do anything to it.
Have tried clearing cache, and waiting a few hours, and run Cron as described above but the error keeps returning.

Was there some resolution to this problem? A PHPMyAdmin work around or anything?

eric-ie’s picture

For what it's worth I uninstalled Views, removed the files, then upgraded to 7.x-3.x-dev instead of rc1. Seems to have cleared up the saving issues I had.

skhot’s picture

Might be helpful to someone. I was having a similar second save DB error after updating to the latest dev release, specifically:

PDOException: SQLSTATE[23000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.views_view' with unique index 'name_unique'. in views_db_object->save_row() (line 1977 of root\sites\all\modules\views\includes\view.inc).

I cleared my cache and ran cron - problem solved.

pwaak’s picture

I had this problem with a freshly installed ctools-7.x-1.0-beta1 and views-7.x-3.0-rc1. Flushing the caches for both the server and browser and running cron did not help. I then went to the view and used cancel instead of trying to save. The alert about a pending change went away and the view then saved correctly when I reapplied the change. Maybe this will provide a clue to what is happening.

Loikkk’s picture

The only one solution was to delete the view directly via the phpmyadmin interface in the table view_view as mentionned before.
I don't know where that issue comes from "Not authorized to access this page" and this notice but by now everything seem to work.

Isb1009’s picture

This seems to be the same issue as #1167958: PDOException: SQLSTATE[23000]: Integrity constraint violation: .

I have fixed this error disabling and uninstalling Views and CTools and all modules which depend on them, re-enabling them, logging out and back in as two different users and increasing PHP memory_limit to 128M (I am on a local test install and had it at 64M).

Using the latest dev versions of CTools, Views and the modules which depend on them.
Just a note: this install is an upgrade from Drupal 6.

jessicakoh’s picture

#41 Thank you. It works.

Not just delete the offending view in views_view. Delete the corresponding vid in views_display.

narinping’s picture

I had same this issue, but i have already finally improved it

Walt Haas’s picture

Version: 7.x-3.x-dev » 7.x-3.0-rc1

I'm currently seeing this issue with CTools 7.x-1.0-rc1 and Views 7.x-3.0-rc1

dawehner’s picture

So did you tryed out the latest dev version so see whether it still does not work?

Walt Haas’s picture

Not yet.

The immediate cause of the error is that the view is cached in ctools_object_cache with vid == 'new' so it is returned that way from views_ui_cache_load(). I haven't quite figured out why it was cached that way.

Walt Haas’s picture

Well it seems that if I create a new view then click Continue & Edit a row is inserted into ctools_object_cache with vid == 'new'. If I navigate away from the edit page and then load Structure>Views the newly created view doesn't appear in the list. If I then edit the browser location bar to take me back to the edit page of the new view, then click Save, this row is removed from the cache correctly and there is no error. So how to reproduce the chain of events that leaves the row with vid == 'new' in the cache table?

Walt Haas’s picture

Ha! Got it!

If you get your database into the state where there is a row for a certain view in views_view with a certain vid, and also a row in ctools_object_cache with a row for the same view and vid == 'new', you are doomed. Attempting to edit the view and save it will produce the PDOException error. So how do you get the database into that state?

1. Go to Structure>Views and click Add New View

2. Give the new view some name, say Test

3. Click Continue & edit. This inserts a row with name == 'test' and vid == 'new' into ctools_object_cache.

4. Now go back to Structure>Views again. Notice that view Test is not listed. Click Add New View.

5. Give the new view name Test, same as before.

6. Click Save & exit. This inserts a row into views_view with name == 'test' and some numeric vid. The row with vid == 'new' remains in ctools_object_cache.

7. Go to Structure>Views. Notice that Test is now listed. Click edit.

8. On the edit page click Save.

9. Bingo! PDOException.

I just installed the latest dev version, with no change. The same sequence produces the same PDOException for the same reason, and the problem in the database remains.

You owe me a beer :-)

-- Walt

neoglez’s picture

Version: 7.x-3.0-rc1 » 7.x-3.x-dev

I just installed the latest dev version, with no change. The same sequence produces the same PDOException for the same reason, and the problem in the database remains.

Updating version
...About the beer we'll see ;-)

Chi’s picture

Confirm #49.
I just delete corresponding view object from ctools_object_cache table.

mostoneskin’s picture

After reading all this having experienced the same error, I'm still not sure what the "fix" is, if there is one? Or has this now been fixed in the latest dev version? I don't to upgrade from rc1 to the dev one if it won't fix this but might introduce other issues!

dawehner’s picture

 I don't to upgrade from rc1 to the dev one if it won't fix this but might introduce other issues!

As you see the issue is still open, so it's not fixed yet. Sure all we do is to introduce new bugs, every day.
Personally i don't use the RC1 because there are so many more bugs in it :)

mostoneskin’s picture

Thanks dereine. I'm not for one minute suggesting that you guys are filling the dev one with bugs every day. To be honest I think the Drupal coders are immense. I'll try the dev one anyway and keeping watching watching this issue.

dawehner’s picture

Status: Active » Needs review
FileSize
616 bytes

I really like this issue because it's shows who uses "save and exit" and who doesn't even think to use it :)

WaltHaas ... I can't express in words how i liked your comment
http://drupal.org/node/1123198#comment-4994034

It is actually so helpful to be able to reprodce bugs without too much effort. THANKS!!
The additional informations about ctools object cache are nice as well.

4. Now go back to Structure>Views again. Notice that view Test is not listed. Click Add New View.

But this is okay, you don't actually stored the view. I think this is clear for you as well, just wanted to summarize.

Okay here is a patch.

mostoneskin’s picture

Works a treat thanks.

dawehner’s picture

If WaltHaas would give a okay for this patch, it could probably be commited.

Walt Haas’s picture

I'm sorry I didn't notice that you had generated this patch. For some reason I didn't get an email about your new comment, and didn't visit this page and notice it until two weeks after you posted the patch.

The patch works fine at preventing the problem. If there is already the situation of a view in ctools_object_cache and also a view with the same name in views_view, the patch doesn't remove the excess row - you still need to do that by hand with phpMyAdmin. The problem is that the edit form is generated from the row in ctools_object_cache with vid=='new' so the same PDOexception occurs. In my opinion, it isn't worth the complexity of trying to fix this situation in code since the patch prevents it, and any old conflicted views can be easily fixed by hand.

-- Walt

dawehner’s picture

Status: Needs review » Fixed
 If there is already the situation of a view in ctools_object_cache and also a view with the same name in views_view, the patch doesn't remove the excess row - you still need to do that by hand with phpMyAdmin.

Yeah i think you are totally right here, so commited to 7.x-3.x
Thanks for testing the patch!!

cpelham’s picture

Status: Fixed » Active

I updated to today's Oct 19 Views but am still unable to save a view and just continue to get the message:

All changes are stored temporarily. Click Save to make your changes permanent. Click Cancel to discard the view.

I am using Drupal 7.8 and latest CTools (and latest Workbench dev):

Here is the view:


$view = new view;
$view->name = 'workbench_moderation';
$view->description = '';
$view->tag = 'Workbench';
$view->base_table = 'node_revision';
$view->human_name = 'workbench_moderation';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['title'] = 'Content I\'ve Edited';
$handler->display->display_options['use_more_always'] = TRUE;
$handler->display->display_options['use_more_text'] = 'view all';
$handler->display->display_options['group_by'] = TRUE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'use workbench_moderation my drafts tab';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '25';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['expose']['items_per_page'] = TRUE;
$handler->display->display_options['pager']['options']['expose']['items_per_page_options'] = '10, 25, 50, 100, 200';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'nid' => 'nid',
  'nid_1' => 'nid_1',
  'log' => 'log',
  'nothing' => 'nothing',
  'state' => 'state',
  'moderation_actions' => 'moderation_actions',
  'title' => 'title',
  'type' => 'type',
  'name' => 'name',
  'changed' => 'changed',
);
$handler->display->display_options['style_options']['default'] = 'changed';
$handler->display->display_options['style_options']['info'] = array(
  'nid' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
  'nid_1' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
  'log' => array(
    'align' => '',
    'separator' => '',
  ),
  'nothing' => array(
    'align' => '',
    'separator' => '',
  ),
  'state' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
  'moderation_actions' => array(
    'align' => '',
    'separator' => '',
  ),
  'title' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
  'type' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
  'name' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
  'changed' => array(
    'sortable' => 1,
    'default_sort_order' => 'desc',
    'align' => '',
    'separator' => '',
  ),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['order'] = 'desc';
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['empty'] = FALSE;
$handler->display->display_options['empty']['area']['content'] = 'You haven\'t created or edited any content.';
$handler->display->display_options['empty']['area']['format'] = '1';
/* Relationship: Content revision: User */
$handler->display->display_options['relationships']['uid']['id'] = 'uid';
$handler->display->display_options['relationships']['uid']['table'] = 'node_revision';
$handler->display->display_options['relationships']['uid']['field'] = 'uid';
/* Field: Content: Nid */
$handler->display->display_options['fields']['nid_1']['id'] = 'nid_1';
$handler->display->display_options['fields']['nid_1']['table'] = 'node';
$handler->display->display_options['fields']['nid_1']['field'] = 'nid';
$handler->display->display_options['fields']['nid_1']['exclude'] = TRUE;
$handler->display->display_options['fields']['nid_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['nid_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['nid_1']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['nid_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['nid_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['nid_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['nid_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['nid_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['nid_1']['element_label_colon'] = 1;
$handler->display->display_options['fields']['nid_1']['element_default_classes'] = 1;
$handler->display->display_options['fields']['nid_1']['hide_empty'] = 0;
$handler->display->display_options['fields']['nid_1']['empty_zero'] = 0;
$handler->display->display_options['fields']['nid_1']['link_to_node'] = 1;
/* Field: Content revision: Log message */
$handler->display->display_options['fields']['log']['id'] = 'log';
$handler->display->display_options['fields']['log']['table'] = 'node_revision';
$handler->display->display_options['fields']['log']['field'] = 'log';
$handler->display->display_options['fields']['log']['exclude'] = TRUE;
$handler->display->display_options['fields']['log']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['log']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['log']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['log']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['log']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['log']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['log']['alter']['trim'] = 0;
$handler->display->display_options['fields']['log']['alter']['html'] = 0;
$handler->display->display_options['fields']['log']['element_label_colon'] = 1;
$handler->display->display_options['fields']['log']['element_default_classes'] = 1;
$handler->display->display_options['fields']['log']['hide_empty'] = 0;
$handler->display->display_options['fields']['log']['empty_zero'] = 0;
/* Field: Global: Custom text */
$handler->display->display_options['fields']['nothing']['id'] = 'nothing';
$handler->display->display_options['fields']['nothing']['table'] = 'views';
$handler->display->display_options['fields']['nothing']['field'] = 'nothing';
$handler->display->display_options['fields']['nothing']['exclude'] = TRUE;
$handler->display->display_options['fields']['nothing']['alter']['text'] = 'View moderation history';
$handler->display->display_options['fields']['nothing']['alter']['make_link'] = 1;
$handler->display->display_options['fields']['nothing']['alter']['path'] = 'node/[nid_1]/moderation';
$handler->display->display_options['fields']['nothing']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['nothing']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['nothing']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['nothing']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['nothing']['alter']['trim'] = 0;
$handler->display->display_options['fields']['nothing']['alter']['html'] = 0;
$handler->display->display_options['fields']['nothing']['element_label_colon'] = 1;
$handler->display->display_options['fields']['nothing']['element_default_classes'] = 1;
$handler->display->display_options['fields']['nothing']['hide_empty'] = 0;
$handler->display->display_options['fields']['nothing']['empty_zero'] = 0;
/* Field: Moderation State */
$handler->display->display_options['fields']['state']['id'] = 'state';
$handler->display->display_options['fields']['state']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['fields']['state']['field'] = 'state';
$handler->display->display_options['fields']['state']['ui_name'] = 'Moderation State';
$handler->display->display_options['fields']['state']['label'] = 'Moderation State';
$handler->display->display_options['fields']['state']['alter']['alter_text'] = 1;
$handler->display->display_options['fields']['state']['alter']['text'] = '<div>[state]</div><div>[nothing]</div>';
$handler->display->display_options['fields']['state']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['state']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['state']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['state']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['state']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['state']['alter']['trim'] = 0;
$handler->display->display_options['fields']['state']['alter']['html'] = 0;
$handler->display->display_options['fields']['state']['element_label_colon'] = 1;
$handler->display->display_options['fields']['state']['element_default_classes'] = 1;
$handler->display->display_options['fields']['state']['hide_empty'] = 0;
$handler->display->display_options['fields']['state']['empty_zero'] = 0;
/* Field: Workbench Moderation: Moderation Links */
$handler->display->display_options['fields']['moderation_actions']['id'] = 'moderation_actions';
$handler->display->display_options['fields']['moderation_actions']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['fields']['moderation_actions']['field'] = 'moderation_actions';
$handler->display->display_options['fields']['moderation_actions']['label'] = 'Moderate';
$handler->display->display_options['fields']['moderation_actions']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['moderation_actions']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['moderation_actions']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['moderation_actions']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['moderation_actions']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['moderation_actions']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['moderation_actions']['alter']['trim'] = 0;
$handler->display->display_options['fields']['moderation_actions']['alter']['html'] = 0;
$handler->display->display_options['fields']['moderation_actions']['element_label_colon'] = 1;
$handler->display->display_options['fields']['moderation_actions']['element_default_classes'] = 1;
$handler->display->display_options['fields']['moderation_actions']['hide_empty'] = 0;
$handler->display->display_options['fields']['moderation_actions']['empty_zero'] = 0;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Type */
$handler->display->display_options['fields']['type']['id'] = 'type';
$handler->display->display_options['fields']['type']['table'] = 'node';
$handler->display->display_options['fields']['type']['field'] = 'type';
$handler->display->display_options['fields']['type']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['type']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['type']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['type']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['type']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['type']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['type']['alter']['trim'] = 0;
$handler->display->display_options['fields']['type']['alter']['html'] = 0;
$handler->display->display_options['fields']['type']['hide_empty'] = 0;
$handler->display->display_options['fields']['type']['empty_zero'] = 0;
$handler->display->display_options['fields']['type']['link_to_node'] = 0;
$handler->display->display_options['fields']['type']['machine_name'] = 0;
/* Field: User: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'users';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['relationship'] = 'uid';
$handler->display->display_options['fields']['name']['label'] = 'Revised by';
$handler->display->display_options['fields']['name']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['name']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['name']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['name']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['name']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['name']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['name']['alter']['trim'] = 0;
$handler->display->display_options['fields']['name']['alter']['html'] = 0;
$handler->display->display_options['fields']['name']['element_label_colon'] = 1;
$handler->display->display_options['fields']['name']['element_default_classes'] = 1;
$handler->display->display_options['fields']['name']['hide_empty'] = 0;
$handler->display->display_options['fields']['name']['empty_zero'] = 0;
$handler->display->display_options['fields']['name']['link_to_user'] = 1;
$handler->display->display_options['fields']['name']['overwrite_anonymous'] = 0;
/* Field: Content: Updated date */
$handler->display->display_options['fields']['changed']['id'] = 'changed';
$handler->display->display_options['fields']['changed']['table'] = 'node';
$handler->display->display_options['fields']['changed']['field'] = 'changed';
$handler->display->display_options['fields']['changed']['label'] = 'Last updated';
$handler->display->display_options['fields']['changed']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['changed']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['changed']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['changed']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['changed']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['changed']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['changed']['alter']['trim'] = 0;
$handler->display->display_options['fields']['changed']['alter']['html'] = 0;
$handler->display->display_options['fields']['changed']['element_label_colon'] = 1;
$handler->display->display_options['fields']['changed']['element_default_classes'] = 1;
$handler->display->display_options['fields']['changed']['hide_empty'] = 0;
$handler->display->display_options['fields']['changed']['empty_zero'] = 0;
$handler->display->display_options['fields']['changed']['date_format'] = 'time ago';
/* Field: Content translation: Language */
$handler->display->display_options['fields']['language']['id'] = 'language';
$handler->display->display_options['fields']['language']['table'] = 'node';
$handler->display->display_options['fields']['language']['field'] = 'language';
$handler->display->display_options['fields']['language']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['language']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['language']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['language']['alter']['external'] = 0;
$handler->display->display_options['fields']['language']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['language']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['language']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['language']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['language']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['language']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['language']['alter']['trim'] = 0;
$handler->display->display_options['fields']['language']['alter']['html'] = 0;
$handler->display->display_options['fields']['language']['element_label_colon'] = 1;
$handler->display->display_options['fields']['language']['element_default_classes'] = 1;
$handler->display->display_options['fields']['language']['hide_empty'] = 0;
$handler->display->display_options['fields']['language']['empty_zero'] = 0;
$handler->display->display_options['fields']['language']['link_to_node'] = 0;
$handler->display->display_options['fields']['language']['native_language'] = 0;
/* Sort criterion: Content: Updated date */
$handler->display->display_options['sorts']['changed']['id'] = 'changed';
$handler->display->display_options['sorts']['changed']['table'] = 'node';
$handler->display->display_options['sorts']['changed']['field'] = 'changed';
$handler->display->display_options['sorts']['changed']['order'] = 'DESC';
/* Filter criterion: User: Current */
$handler->display->display_options['filters']['uid_current']['id'] = 'uid_current';
$handler->display->display_options['filters']['uid_current']['table'] = 'users';
$handler->display->display_options['filters']['uid_current']['field'] = 'uid_current';
$handler->display->display_options['filters']['uid_current']['relationship'] = 'uid';
$handler->display->display_options['filters']['uid_current']['value'] = '1';
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['operator'] = 'contains';
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Title';
$handler->display->display_options['filters']['title']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['remember'] = 1;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['exposed'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['operator_id'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['label'] = 'Type';
$handler->display->display_options['filters']['type']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['type']['expose']['operator'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['identifier'] = 'type';
$handler->display->display_options['filters']['type']['expose']['remember'] = 1;
$handler->display->display_options['filters']['type']['expose']['reduce'] = 0;
/* Filter criterion: Workbench Moderation: State */
$handler->display->display_options['filters']['state']['id'] = 'state';
$handler->display->display_options['filters']['state']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['state']['field'] = 'state';
$handler->display->display_options['filters']['state']['value'] = array(
  'Draft' => 'Draft',
  'Needs Review' => 'Needs Review',
);
$handler->display->display_options['filters']['state']['exposed'] = TRUE;
$handler->display->display_options['filters']['state']['expose']['operator_id'] = 'state_op';
$handler->display->display_options['filters']['state']['expose']['label'] = 'State';
$handler->display->display_options['filters']['state']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op';
$handler->display->display_options['filters']['state']['expose']['identifier'] = 'state';
$handler->display->display_options['filters']['state']['expose']['remember'] = 1;
$handler->display->display_options['filters']['state']['expose']['reduce'] = 1;
/* Filter criterion: Workbench Moderation: Current */
$handler->display->display_options['filters']['current']['id'] = 'current';
$handler->display->display_options['filters']['current']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['current']['field'] = 'current';

/* Display: Needs Review Page */
$handler = $view->new_display('page', 'Needs Review Page', 'needs_review_page');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'Needs Review';
$handler->display->display_options['defaults']['access'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'use workbench_moderation needs review tab';
$handler->display->display_options['defaults']['empty'] = FALSE;
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['empty'] = FALSE;
$handler->display->display_options['empty']['area']['content'] = 'This list displays content in the "Needs Review" state that you can moderate. Currently there is no such content.';
$handler->display->display_options['empty']['area']['format'] = 'plain_text';
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter criterion: Workbench Moderation: Current */
$handler->display->display_options['filters']['current']['id'] = 'current';
$handler->display->display_options['filters']['current']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['current']['field'] = 'current';
$handler->display->display_options['filters']['current']['value'] = '1';
/* Filter criterion: Workbench Moderation: State */
$handler->display->display_options['filters']['state']['id'] = 'state';
$handler->display->display_options['filters']['state']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['state']['field'] = 'state';
$handler->display->display_options['filters']['state']['value'] = array(
  'needs_review' => 'needs_review',
);
$handler->display->display_options['filters']['state']['expose']['label'] = 'Workbench Moderation: State';
$handler->display->display_options['filters']['state']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op';
$handler->display->display_options['filters']['state']['expose']['identifier'] = 'state';
$handler->display->display_options['filters']['state']['expose']['remember'] = FALSE;
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['operator'] = 'contains';
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Title';
$handler->display->display_options['filters']['title']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['remember'] = 1;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['exposed'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['operator_id'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['label'] = 'Type';
$handler->display->display_options['filters']['type']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['type']['expose']['operator'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['identifier'] = 'type';
$handler->display->display_options['filters']['type']['expose']['remember'] = 1;
$handler->display->display_options['filters']['type']['expose']['reduce'] = 0;
$handler->display->display_options['path'] = 'admin/workbench/needs-review';
$handler->display->display_options['menu']['type'] = 'tab';
$handler->display->display_options['menu']['title'] = 'Needs Review';
$handler->display->display_options['menu']['weight'] = '99';

/* Display: Drafts Page */
$handler = $view->new_display('page', 'Drafts Page', 'drafts_page');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'My Drafts';
$handler->display->display_options['defaults']['empty'] = FALSE;
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['empty'] = FALSE;
$handler->display->display_options['empty']['area']['content'] = 'This list displays content you have created that is not published. Currently there is no such content.';
$handler->display->display_options['empty']['area']['format'] = 'plain_text';
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter criterion: User: Current */
$handler->display->display_options['filters']['uid_current']['id'] = 'uid_current';
$handler->display->display_options['filters']['uid_current']['table'] = 'users';
$handler->display->display_options['filters']['uid_current']['field'] = 'uid_current';
$handler->display->display_options['filters']['uid_current']['relationship'] = 'uid';
$handler->display->display_options['filters']['uid_current']['value'] = '1';
/* Filter criterion: Workbench Moderation: Current */
$handler->display->display_options['filters']['current']['id'] = 'current';
$handler->display->display_options['filters']['current']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['current']['field'] = 'current';
$handler->display->display_options['filters']['current']['value'] = '1';
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['operator'] = 'contains';
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Title';
$handler->display->display_options['filters']['title']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['remember'] = 1;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['exposed'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['operator_id'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['label'] = 'Type';
$handler->display->display_options['filters']['type']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['type']['expose']['operator'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['identifier'] = 'type';
$handler->display->display_options['filters']['type']['expose']['remember'] = 1;
$handler->display->display_options['filters']['type']['expose']['reduce'] = 0;
/* Filter criterion: Workbench Moderation: State */
$handler->display->display_options['filters']['state']['id'] = 'state';
$handler->display->display_options['filters']['state']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['state']['field'] = 'state';
$handler->display->display_options['filters']['state']['value'] = array(
  'Draft' => 'Draft',
  'Needs Review' => 'Needs Review',
);
$handler->display->display_options['filters']['state']['exposed'] = TRUE;
$handler->display->display_options['filters']['state']['expose']['operator_id'] = 'state_op';
$handler->display->display_options['filters']['state']['expose']['label'] = 'State';
$handler->display->display_options['filters']['state']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op';
$handler->display->display_options['filters']['state']['expose']['identifier'] = 'state';
$handler->display->display_options['filters']['state']['expose']['remember'] = 1;
$handler->display->display_options['filters']['state']['expose']['reduce'] = 1;
$handler->display->display_options['path'] = 'admin/workbench/drafts';
$handler->display->display_options['menu']['type'] = 'tab';
$handler->display->display_options['menu']['title'] = 'My Drafts';
$handler->display->display_options['menu']['weight'] = '98';

/* Display: Needs Review by Yasuko Page */
$handler = $view->new_display('page', 'Needs Review by Yasuko Page', 'page_1');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'Needs Review by Yasuko';
$handler->display->display_options['defaults']['access'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'moderate content from Needs Review by Yasuko to Published';
$handler->display->display_options['defaults']['empty'] = FALSE;
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['empty'] = FALSE;
$handler->display->display_options['empty']['area']['content'] = 'This list displays content in the "Needs Review" state that you can moderate. Currently there is no such content.';
$handler->display->display_options['empty']['area']['format'] = 'plain_text';
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter criterion: Workbench Moderation: Current */
$handler->display->display_options['filters']['current']['id'] = 'current';
$handler->display->display_options['filters']['current']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['current']['field'] = 'current';
$handler->display->display_options['filters']['current']['value'] = '1';
/* Filter criterion: Workbench Moderation: State */
$handler->display->display_options['filters']['state']['id'] = 'state';
$handler->display->display_options['filters']['state']['table'] = 'workbench_moderation_node_history';
$handler->display->display_options['filters']['state']['field'] = 'state';
$handler->display->display_options['filters']['state']['value'] = array(
  'needs_review_by_yasuko' => 'needs_review_by_yasuko',
);
$handler->display->display_options['filters']['state']['expose']['label'] = 'Workbench Moderation: State';
$handler->display->display_options['filters']['state']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['state']['expose']['operator'] = 'state_op';
$handler->display->display_options['filters']['state']['expose']['identifier'] = 'state';
$handler->display->display_options['filters']['state']['expose']['remember'] = FALSE;
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['operator'] = 'contains';
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Title';
$handler->display->display_options['filters']['title']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['remember'] = 1;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['exposed'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['operator_id'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['label'] = 'Type';
$handler->display->display_options['filters']['type']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['type']['expose']['operator'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['identifier'] = 'type';
$handler->display->display_options['filters']['type']['expose']['remember'] = 1;
$handler->display->display_options['filters']['type']['expose']['reduce'] = 0;
$handler->display->display_options['path'] = 'admin/workbench/needs-review-by-yasuko';
$handler->display->display_options['menu']['type'] = 'tab';
$handler->display->display_options['menu']['title'] = 'Needs Review';
$handler->display->display_options['menu']['weight'] = '99';
cpelham’s picture

I have cross-posted this in the Workbench Moderation issue queue in the event that this is a Workbench problem:

http://drupal.org/node/1316146

Also, I am using the 7.x-1.0 release of the Workbench suite (not the dev as I previously stated).

cpelham’s picture

Status: Active » Fixed

Reverting the Workbench Moderation view and re-creating it fixed the problem....

Status: Fixed » Closed (fixed)

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

snoopy77’s picture

I confirm that. Had the same problem, and tried out every possible thing. Eventually went straight into the '`views_view` table and removed the record. That did the trick.

Dexter0015’s picture

Version: 7.x-3.x-dev » 7.x-3.0-rc3
Status: Closed (fixed) » Active

I have the same issue too.

I work localy (MAMP server) with a fresh Drupal 7.10 installation :

  • Views 7.X-3.0-rc3
  • cTools 7.x-1.0-rc1

I create a new view (my only view for the moment) with 2 displays :

  • page (with menu link)
  • block

Both displays are unformatted list of nodes (restricted to one define content type, order by publish date DESC, with several fields), the only difference between the different displays is in the pagination method.

When I try to edit the view, I have the same PHP error message about duplicate entry.

I don't really know if the view is correctly saved because I can't the link in my menu and have a 404 error if I try to see the page.

I can see the view in list, I can enter in edit mode, and still have notice of changes not saved.

I tried several things :

  • deleted entry in views_view from phpMyAdmin
  • delete and reinstall Views module
  • flush all caches (Drupal and browser) with or without run the cron task

but the only thing that really help me was to follow the same procedure as indicate in #40 (by the way, thanks pwaak) :
click edit (from views list), when click "cancel" to "clear" the view without saving changes, and finally return in edit mode to apply new changes. An then, it works.

Hope it could be helpful for anyone.

davidneedham’s picture

Version: 7.x-3.0-rc3 » 7.x-3.x-dev
Status: Active » Closed (fixed)

Rule of thumb: if you can't get the "recommended release" to work, try to development release.

Most issues in the queues are based on the dev version of the module because that's where the most active work is done. If it works in dev, the maintainers will eventually roll it into the recommended version.

Please try the dev versions of both Views and ctools and see if you still get the error. As a best practice, first uncheck the modules and save to disable them, go the uninstall tab and uninstall them to clean up the database, delete all of the files for Views and ctools in your modules folder, then copy over the files and enable the dev versions.

If after all that (and flushing your cache to be doubly sure) you still get the errors you see here, feel free to re-open this issue.

Dexter0015’s picture

Version: 7.x-3.x-dev » 7.x-3.0-rc3

Sorry, I forgot to add an update to this issue.

In my case, it was due to a conflict with the Elements module or HTML 5 Tools (I think), which add support for HTML 5 new elements to Drupal 7 and views 3, and after desactivate it, I don't have problem anymore.

Hope it can help.

heatherann’s picture

I just wanted to note my process in case anyone else ran into my situation.

I ran cron and deleted the entry in views_view from phpMyAdmin, but this error did not go away. I also had to go into the views_display table in phpMyAdmin and delete any entries with the vid of the view that I had deleted in views_view.

Now that both the views_view and views_display tables are clean, I can make the view again and it saves fine.

KingMoore’s picture

Broken for me. I have latest dev release of ctools and views. I can create a view, but then when I go to edit it it gives above error. Trying to delete it also gives me this error:

Notice: Undefined property: view::$export_type in ctools_export_ui->access() (line 128 of /Applications/MAMP/htdocs/DFS/sites/default/modules/ctools/plugins/export_ui/ctools_export_ui.class.php).

NOTE: I originally was using the RCs, but tried the dev version to see if that fixed the problem. It did not.

KingMoore’s picture

ahah, manually deleting the record from drupal_ctools_object_cache solved the problem... not sure why it happened in the first place.

hedel’s picture

I get the same error. I was creating a view and by mistake don't save the changes in this one and start to create other one, in the moment of save come the error. I can see one view with the name of the first (the same where I don't save the changes) but with the changes of the second view. However, I was unable to delete the view.
In the database. from the the table ' views_view ' I deleted the last row and now everything is ok. I can create and delete others views without problems.

bobvan’s picture

I'm trying drupal7 views and am getting these year and a half old errors...

Undefined property: view::$export_type in ctools_export_ui

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

When I modify/save or delete Views, I have to do things like:

Hard browser reload/resubmit on white screen of death
Press browser back then clear Views Cache
Clear all caches
SQL: delete from ctools_object_cache

Seems funny that a major Views bug like this, which users have reported over a year, has no definitive fix or patch. Well I might have a beta module or two, so that might be a problem.

I wonder what a proper fix would be for this?

sandrea’s picture

I'm totally new to Drupal but I got this error when I first tried to edit a view and then later tried to delete it. I was using Firefox. I desided to open my Drupal testsite in Internet explorer and I was able to delete the view there. I switched back to Firefox, refreshed the page and the bugged view was gone :)

coolhandlukek2’s picture

#Subscribe

coolhandlukek2’s picture

Was having this error when saving views

I resolved this by increasing my sites php memory limit

/sites/default/settings.php

Set the files permissions to 0777 (so you can edit and save) - then locate the PHP settings section and add the following line

ini_set('memory_limit', '128M');

Save and reset the files permission back to 0444

This method will affect only the site using this file.

Hope this helps

:-)

mettam’s picture

Just like KingMoore, I tried with the latest versions of Views (3.3) and cTools. Then I tried with the dev versions of both. I still get the same error that I can't save a view. I can create a new view and save, but when I open the view then immediately save (i.e., no actual edits) I get the same error everyone else is. What is the solution to this? Not being to edit a view is a serious bug.

TelFiRE’s picture

Priority: Normal » Critical
Status: Closed (fixed) » Needs work

This should not be closed. As others have stated, the issue is still present in dev.

This is obviously a massively critical bug, views literally doesn't work at all.

Having read the thread, there is no clear solution and neither the dev or recommended release work.

TelFiRE’s picture

I spent all day on this. I finally was able to resolve it in my instance, by uninstalling Hierarchical Select. I didn't see that module mentioned anywhere in any of the many error messages I was seeing, but uninstalling it put the site back to normal for me. I can flush my cache, save my views, and do as I please. Perhaps this will help someone else. But I doubt it is the root cause.

nicksanta’s picture

I had luck with KingMoore's solution in #70, although he has table prefixing enabled - the table is called ctools_object_cache by default.

damiankloip’s picture

adevane’s picture

Version: 7.x-3.0-rc3 » 7.x-3.3

I'm also having this problem. I'm a bit confused in terms of deleting the table entry. If I do this won't I lose my data? Or is it an unnecessary bit that should be deleted? I've done a ton of work in views and I'd hate to lose everything but uninstalling and deleting. It seems a bit extreme I guess.
I'm having the same error, have increased the memory per instructions, have tried going in and canceling (per #78 comment) then returning to edit. Same error.
I tried to delete the offending view and it throws an error that states I do not have permission to do so.

The only thing that's worked for me is to clone a view that isn't throwing errors and altering it to suit my needs. This does seem like a pretty big bug so I'll definitely stay tuned to this discussion. Thanks for everyone's troubleshooting, saves us all so much time!

using 7.x-3.3 and Drupal 7.12 (not the most recent)

DylanDog73’s picture

I'm pretty new to Drupal and got the same message. Can't really figure out WHY it happens. What I understand is that the View is created, and a second view with the same name attempts to be created too. Well... What worked for me was to manually empty all tables related to Views caches. For some reason, "drush cc all" doesn't affect these tables. Important : one shall NOT delete the View itself in Views_view. I think the cache_views table is where the evil really lies ! ctools_object_cache sould be emptied too. After I id that, I was able to save changes in my view. And I could edit it later without a problem. But what a burden !

CSch’s picture

I spent several hours on this too. I first ran into this error by trying to clone the taxonomy term view and to change the default settings there. After running into the 'PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry'-error once, everything got weird with views from then on (Drupal 7.4, Views 7.x-3.3, Chaos tools 7.x.1.0).

I tried to create a new view to find out, if this error was correlated with the cloned taxonomy term view only. But after I successfully saved the new view, I wasn't able to update this either while running into the same duplicate entry error again:

PDOException: SQLSTATE[23000]: 
Integrity constraint violation: 1062 Duplicate entry 'my_test_view' for key 'name': INSERT INTO {views_view} (name, description, tag, base_table, human_name, core) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( 
[:db_insert_placeholder_0] => my_test_view 
[:db_insert_placeholder_1] => 
[:db_insert_placeholder_2] => default 
[:db_insert_placeholder_3] => node 
[:db_insert_placeholder_4] => my test view
[:db_insert_placeholder_5] => 7 ) 
in views_db_object->save_row() (line 2092 of /.../includes/view.inc).

The message implicates that there is an attempt to save an existing database entry as a new one instead of updating it, which matches to the cited responsible function in views.inc:

function save_row($update = NULL) {
    $fields = $defs = $values = $serials = array();
    $schema = drupal_get_schema($this->db_table);

    // Go through our schema and build correlations.
    foreach ($schema['fields'] as $field => $info) {
      // special case -- skip serial types if we are updating.
      if ($info['type'] == 'serial') {
        $serials[] = $field;
        continue;
      }
      elseif ($info['type'] == 'int') {
        $this->$field = (int) $this->$field;
      }
      $fields[$field] = empty($info['serialize']) ? $this->$field : serialize($this->$field);
    }
    if (!$update) {
      $query = db_insert($this->db_table);
    }
    else {
      $query = db_update($this->db_table)
        ->condition($update, $this->$update);
    }
    $return = $query
      ->fields($fields)
      ->execute();

I don't know much about PHP or MySQL but it seemed obvious to me, that there might be a problem with $update here because according to the error message INSERT is executed instead of UPDATE.

For the new test view I could fix the problem in this way:

  • disable view
  • enable view
  • edit view
  • analyze view
  • save view.

I tried this "solution" for another existing view but than wasn't able to disable the view while running into an 'AJAX HTTP Internal Server Error (500)'. The edit view of the view than losts its 'Save' and its 'Cancel'-button and I wasn't even able to delete a view or create a new one.

This nearly caused me a heart attack, because I invested a lot of time in building views for my site, which -without views- would become worthless.

I think this is really a frustrating bug, because views is such an essential tool for D7. I really lost some of my confidence in using Drupal 7 for my projects and would be very glad if this issue could be solved soon. It seems to be unresolved for more than a year now.

Running cron, flush cashes and empty cache_views table in the database didn't work for me.

Empty ctools_object_cache table helps, but only until running into the double entry error again.

Brian Groenenstein’s picture

can confirm coolhandlukek2
Increase the memoy limit as in post 75

solves a lot of problems i had with views.

This problem appeared on a site with a huge amount of views with arguments of mine. Also solved a lot of other problems as well.

Thanks coolhandlukek2

DylanDog73’s picture

All the problems I had with Views (then other freshly installed modules) vanished when I increased PHP's memory_limit. I believe this is simply a PHP memory thing.

couturier’s picture

I had exactly the same issues with Views breaking under insufficient PHP memory limits.

my-family’s picture

The problem is also with memory limit of 256 M. Most hosting providers do not give even this. But I believe that Dupal with views should run under average webhosting...

couturier’s picture

@my-family Drupal is a workhorse and requires substantial server resources. You will need more than average hosting. Check the marketplace section to find hosts that specialize in Drupal (like Acquia). If average hosting is more important to you than the functionality Drupal offers, choose a different CMS.

fraxinus’s picture

I have encountered this problem on D7.15, with 128MB memory limit. Clearing the cache twice seems to have sorted it and allowed me to delete my unwanted view.

busla’s picture

Version: 7.x-3.3 » 7.x-3.x-dev
Component: Views Data » User interface
Status: Needs work » Active

I´m getting this error when trying to delete a view after playing with the views_php module.

Undefined property: view::$export_type in ctools_export_ui->access() (line 128 ...

I did a dsm($data) call first and then started working my way down the array and suddenly my computer froze. When I create a new view and add a PHP field the page halts completely. It seems to work if I don´t add the PHP field. Note that it halts as soon I have added the field, no data has been entered in to the output textarea.

I upgraded to views-7.x-3.5-dev but still having the same problem.

couturier’s picture

@busla are you having the same problem with the production, non-dev version? Try it and let us know.

busla’s picture

The issue came up in the supported version and I updated to dev because of the issue. Then dev produced the same problem. Let me know if there is anything else I can do.

couturier’s picture

@busla definitely switch back to the non-dev for now. Views is a huge module and you never know what can be encountered in dev. It's different from other dev modules in that respect, that so much is going on in Views dev.

As for adding a PHP field in Views, can't you do that without another module? I am able to add a text area and select PHP format for the input in Views. Make sure you have PHP activated in your modules list before trying this. Let us know how it goes.

busla’s picture

@couturier thanks for the tip. I did indeed forget to enable the php module in core. But ... it didn´t help :-) System HALT again!

Here is the log from MAMP

http://localhost:8888/kennaratal_01|1354641738|php|127.0.0.1|http://localhost:8888/kennaratal_01/admin/structure/views/view/children_before_teaching_started/preview/page/ajax|http://localhost:8888/kennaratal_01/admin/structure/views/view/children_before_teaching_started?render=overlay|1||Notice: Undefined property: stdClass::$views_php_3 in render() (line 223 of /Applications/MAMP/htdocs/kennaratal_01/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc).

dawehner’s picture

@busla
This is the views_php contrib module, not views itself, so feel free to post an issue on their issue queue.

RKS’s picture

Wow I've started getting this error after updating to the newest release. Then I went to dev, continued. Going to have to roll back ( but that release has a security warning on it...)

In my instance, here are my symptoms:

1) It always occurs if I try to "Continue & Edit" instead of "Save & Quit." Once I try to save it after selecting "Continue & Edit," I get the server error.
2) It always occurs if I try to add a new block view to an existing view.
3) Eventually occurs after editing and saving a good view an indeterminate number of times. I.e. a good, working view, once I edit it say 10 times, will go bad. Not necessarily ten times, but there's something that triggers it.
4) The views themselves still work at the paths you just can no longer edit the view.

I can offer a list of modules I'm using, but I don't think I'm doing anything special. I using relationships, and CCK created content types. I have seen these errors via the overlay and on the non-overlay pages. I've cleared caches, ran update, run cron.

RKS’s picture

I've rolled back every version and the only working release is 7.x-3.0. I know this doesn't help but at least it might help narrow down what might be causing the problem. Something changed in 3.1 that didn't exist before and all the releases after were affected.

olisongs’s picture

i had the same problem while saving view doing NO changes !! Just opened and saved.

changing memory limit brings no result

cleaning view cache no results

deleting row in ctools_object_cache (entry with the views which ist not wirking) solved this problem

but where it comes? a bug while checking cache? count 0 or 1?

RKS’s picture

Thanks, olisongs, for finding that out. While not ideal, it does offer a way to update to the newer version without a security risk. It will be a pain to have to work in the dB when the problem occurs but at least there's a way to get it working again. Thanks again for the news.

olisongs’s picture

Ok, i've got the same error again, when editing a view special a picture field with change to colorbox

ok did it again, no error. may be its an initial thing when it happens, depends on the wether, today its sunny ;-).

ok the db thing is not a real good solution but it helps me to come to the next step.
hope the error will be found.

raphar’s picture

I have the same problem: no possibility to save the view or to delete it when importing the following view ("view") from "config one" to "config two": (and also when recreating the view directly without import):

config one:
ctools 7.x-1.3
drupal core 7.21
gmap 7.x-2.7
location 7.x-3.0-rc1
views 7.x-3.7

config two:
Chaos tool suite (ctools) 7.x-1.3
Drupal core 7.22
GMap Module 7.x-2.7
Location 7.x-3.0-rc2
Views 7.x-3.7

view :
$view = new view();
$view->name = 'france';
$view->description = 'this is awesome ';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'France';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'France';
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'none';
$handler->display->display_options['style_plugin'] = 'gmap';
$handler->display->display_options['style_options']['markers'] = 'nodetype';
$handler->display->display_options['style_options']['latfield'] = 'title';
$handler->display->display_options['style_options']['lonfield'] = 'title';
$handler->display->display_options['style_options']['markerfield'] = 'title';
$handler->display->display_options['style_options']['enablermt'] = 0;
$handler->display->display_options['style_options']['rmtfield'] = 'title';
$handler->display->display_options['style_options']['tooltipenabled'] = 1;
$handler->display->display_options['style_options']['tooltipfield'] = 'title';
$handler->display->display_options['style_options']['bubbletextenabled'] = 1;
$handler->display->display_options['style_options']['bubbletextfield'] = 'title';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['inline'] = array(
'title' => 'title',
);
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'cities' => 'cities',
);
/* Filter criterion: Content: Has taxonomy term */
$handler->display->display_options['filters']['tid']['id'] = 'tid';
$handler->display->display_options['filters']['tid']['table'] = 'taxonomy_index';
$handler->display->display_options['filters']['tid']['field'] = 'tid';
$handler->display->display_options['filters']['tid']['value'] = array(
0 => '11',
);
$handler->display->display_options['filters']['tid']['vocabulary'] = 'tag';

/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block');
$handler->display->display_options['block_description'] = 'France view';
$translatables['france'] = array(
t('Master'),
t('France'),
t('more'),
t('Apply'),
t('Reset'),
t('Sort by'),
t('Asc'),
t('Desc'),
t('Block'),
t('France view'),
);

deleting row in the ctools_object_cache table allowed me to delete the view but still i cannot save the view when trying to recreate it...
nor did clearing caches or running cron solved it..

Is there a solution to this problem? related to the new drupal core and/or location module ? thx in advance...

raphar’s picture

my error message is
Notice: Undefined property: view::$export_type in ctools_export_ui->access() (line 128 of C:\wamp\www\drupal\sites\all\modules\ctools\plugins\export_ui\ctools_export_ui.class.php).)

raphar’s picture

Title: Error message on save view » Error message when modifying filter criteria/saving view
Component: User interface » block displays
Category: bug » support
Priority: Critical » Major

was working on creating a completely different view and when modifying the filter criteria the following error occured:

http://localhost/drupal/admin/structure/views/ajax/config-item/nivo_slid...

[{"command":"settings","settings":{"basePath":"\/drupal\/","pathPrefix":"","ajaxPageState":{"theme":"adaptivetheme_admin","theme_token":"rvmxU_KnxOt547kex0EN9c97ffH5ks2nxMXCXSW-0yQ"},"heartbeat_language":"en","heartbeat_poll_url":"http:\/\/localhost\/drupal\/heartbeat\/js\/poll","statuses":{"autofocus":false,"noautoclear":false,"maxlength":140,"hideLength":0,"refreshLink":false},"custom_search":{"form_target":"_self","solr":0}},"merge":true},{"command":"viewsSetForm","output":"\u003Cform action=\u0022\/drupal\/admin\/structure\/views\/ajax\/config-item\/nivo_slider_view\/block\/filter\/status\u0022 method=\u0022post\u0022 id=\u0022views-ui-config-item-form\u0022 accept-charset=\u0022UTF-8\u0022\u003E\u003Cdiv\u003E\u003Cdiv class=\u0022views-override clearfix container-inline\u0022\u003E\u003Cdiv class=\u0022form-item form-type-select form-item-override-dropdown\u0022\u003E\n \u003Clabel for=\u0022edit-override-dropdown\u0022\u003EFor \u003C\/label\u003E\n \u003Cselect id=\u0022edit-override-dropdown\u0022 name=\u0022override[dropdown]\u0022 class=\u0022form-select\u0022\u003E\u003Coption value=\u0022default\u0022\u003EAll displays\u003C\/option\u003E\u003Coption value=\u0022block\u0022\u003EThis block (override)\u003C\/option\u003E\u003C\/select\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\u003Cdiv class=\u0022scroll form-wrapper\u0022 id=\u0022edit-options\u0022\u003E\u003Cdiv class=\u0022form-item description form-wrapper\u0022 id=\u0022edit-options-form-description\u0022\u003EWhether or not the content is published.\u003C\/div\u003E\u003Cdiv class=\u0022views-expose clearfix\u0022\u003E\u003Cdiv class=\u0022js-only form-wrapper\u0022 id=\u0022edit-options-expose-button-checkbox\u0022\u003E\u003Cdiv class=\u0022form-item form-type-checkbox form-item-options-expose-button-checkbox-checkbox\u0022\u003E\n \u003Cinput type=\u0022checkbox\u0022 id=\u0022edit-options-expose-button-checkbox-checkbox\u0022 name=\u0022options[expose_button][checkbox][checkbox]\u0022 value=\u00221\u0022 class=\u0022form-checkbox\u0022 \/\u003E \u003Clabel class=\u0022option\u0022 for=\u0022edit-options-expose-button-checkbox-checkbox\u0022\u003EExpose this filter to visitors, to allow them to change it \u003C\/label\u003E\n\n\u003C\/div\u003E\n\u003C\/div\u003E\u003Cdiv class=\u0022description exposed-description\u0022\u003EThis filter is not exposed. Expose it to allow the users to change it.\u003C\/div\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-options-expose-button-button\u0022 name=\u0022op\u0022 value=\u0022Expose filter\u0022 class=\u0022form-submit\u0022 \/\u003E\u003C\/div\u003E\u003Cdiv class=\u0022clearfix\u0022\u003E\u003Cdiv class=\u0022views-group-box views-left-30\u0022\u003E\u003C\/div\u003E\u003Cdiv class=\u0022form-item form-type-radios form-item-options-value\u0022\u003E\n \u003Clabel for=\u0022edit-options-value\u0022\u003EPublished \u003C\/label\u003E\n \u003Cdiv id=\u0022edit-options-value\u0022 class=\u0022form-radios\u0022\u003E\u003Cdiv class=\u0022form-item form-type-radio form-item-options-value\u0022\u003E\n \u003Cinput type=\u0022radio\u0022 id=\u0022edit-options-value-1\u0022 name=\u0022options[value]\u0022 value=\u00221\u0022 class=\u0022form-radio\u0022 \/\u003E \u003Clabel class=\u0022option\u0022 for=\u0022edit-options-value-1\u0022\u003EYes \u003C\/label\u003E\n\n\u003C\/div\u003E\n\u003Cdiv class=\u0022form-item form-type-radio form-item-options-value\u0022\u003E\n \u003Cinput type=\u0022radio\u0022 id=\u0022edit-options-value-0\u0022 name=\u0022options[value]\u0022 value=\u00220\u0022 checked=\u0022checked\u0022 class=\u0022form-radio\u0022 \/\u003E \u003Clabel class=\u0022option\u0022 for=\u0022edit-options-value-0\u0022\u003ENo \u003C\/label\u003E\n\n\u003C\/div\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\u003Cfieldset class=\u0022collapsible collapsed form-wrapper\u0022 id=\u0022edit-options-more\u0022\u003E\u003Clegend\u003E\u003Cspan class=\u0022fieldset-legend\u0022\u003EMore\u003C\/span\u003E\u003C\/legend\u003E\u003Cdiv class=\u0022fieldset-wrapper\u0022\u003E\u003Cdiv class=\u0022form-item form-type-textfield form-item-options-ui-name\u0022\u003E\n \u003Clabel for=\u0022edit-options-ui-name\u0022\u003EAdministrative title \u003C\/label\u003E\n \u003Cinput type=\u0022text\u0022 id=\u0022edit-options-ui-name\u0022 name=\u0022options[ui_name]\u0022 value=\u0022\u0022 size=\u002260\u0022 maxlength=\u0022128\u0022 class=\u0022form-text\u0022 \/\u003E\n\u003Cdiv class=\u0022description\u0022\u003EThis title will be displayed on the views edit page instead of the default one. This might be useful if you have the same item twice.\u003C\/div\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\u003C\/fieldset\u003E\n\u003C\/div\u003E\u003Cdiv class=\u0022clearfix\u0022\u003E\u003Cdiv class=\u0022form-buttons\u0022\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-submit\u0022 name=\u0022op\u0022 value=\u0022Apply\u0022 class=\u0022form-submit\u0022 \/\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-cancel\u0022 name=\u0022op\u0022 value=\u0022Cancel\u0022 class=\u0022form-submit\u0022 \/\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-remove\u0022 name=\u0022op\u0022 value=\u0022Remove\u0022 class=\u0022form-submit\u0022 \/\u003E\u003C\/div\u003E\u003C\/div\u003E\u003Cinput type=\u0022hidden\u0022 name=\u0022form_build_id\u0022 value=\u0022form-heSjKwjwL24dK2FcawzjBQCbJM2O4iQ9Vco23wCSrko\u0022 \/\u003E\n\u003Cinput type=\u0022hidden\u0022 name=\u0022form_token\u0022 value=\u0022JK67oBeLGfEv6-Ourl0EZx00OM28IGbHjeXbfaafHHg\u0022 \/\u003E\n\u003Cinput type=\u0022hidden\u0022 name=\u0022form_id\u0022 value=\u0022views_ui_config_item_form\u0022 \/\u003E\n\u003C\/div\u003E\u003C\/form\u003E","title":"Configure filter criterion: Content: Published","url":"http:\/\/localhost\/drupal\/admin\/structure\/views\/ajax\/config-item\/nivo_slider_view\/block\/filter\/status"},{"command":"viewsHilite","selector":".block-filter-status"}]

What is the solution to this?

raphar’s picture

Title: Error message when modifying filter criteria/saving view » Error message when modifying filter criteria/saving View
Version: 7.x-3.x-dev » 7.x-3.7

After the issue when saving a gmap view (#101), I attempted to create a slider view and had the same error message (#103). Now I’ve tried to create a view with a blank install and the following modules and same erro as #103 again.. Not being able to use views in Drupal, how can you move forward?

Drupal core

Up to dateok
Drupal core 7.22
Includes: Bartik, Block, Color, Comment, Contextual links, Dashboard, Database logging, Field, Field SQL storage, Field UI, File, Filter, Help, Image, List, Menu, Node, Number, Options, Overlay, Path, RDF, Search, Seven, Shortcut, System, Taxonomy, Text, Toolbar, Update manager, User
Modules

Up to dateok
Administration menu 7.x-3.0-rc4
Includes: Administration menu
Up to dateok
Chaos tool suite (ctools) 7.x-1.3
Includes: Chaos tools
Up to dateok
jQuery Update 7.x-2.3
Includes: jQuery Update
Up to dateok
Libraries API 7.x-2.1
Also available: 7.x-3.x-dev (2012-Sep-06)
Download
Release notes
Includes: Libraries
Up to dateok
Module Filter 7.x-1.7
Also available: 7.x-2.x-dev (2013-Jan-05)
Download
Release notes
Includes: Module filter
Up to dateok
Nivo Slider 7.x-1.10
Includes: Nivo Slider
Up to dateok
Views 7.x-3.7
Includes: Views, Views UI
Up to dateok
Views Nivo Slider 7.x-3.x-dev (2012-Jun-14)
Includes: Views Nivo Slider

Same error when trying to modify the filter in a view, hence impossible to work with the view module in drupal !

http://localhost/blankdrupal7/admin/structure/views/ajax/config-item/niv...

[{"command":"settings","settings":{"basePath":"\/blankdrupal7\/","pathPrefix":"","ajaxPageState":{"theme":"seven","theme_token":"bDJ45MpLwWJCgjbCNXiqCa8RhAu_bger7om1BPXUrbY"}},"merge":true},{"command":"viewsSetForm","output":"\u003Cform action=\u0022\/blankdrupal7\/admin\/structure\/views\/ajax\/config-item\/nivo_slider_view\/block\/filter\/status\u0022 method=\u0022post\u0022 id=\u0022views-ui-config-item-form\u0022 accept-charset=\u0022UTF-8\u0022\u003E\u003Cdiv\u003E\u003Cdiv class=\u0022views-override clearfix container-inline\u0022\u003E\u003Cdiv class=\u0022form-item form-type-select form-item-override-dropdown\u0022\u003E\n \u003Clabel for=\u0022edit-override-dropdown\u0022\u003EFor \u003C\/label\u003E\n \u003Cselect id=\u0022edit-override-dropdown\u0022 name=\u0022override[dropdown]\u0022 class=\u0022form-select\u0022\u003E\u003Coption value=\u0022default\u0022\u003EAll displays\u003C\/option\u003E\u003Coption value=\u0022block\u0022\u003EThis block (override)\u003C\/option\u003E\u003C\/select\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\u003Cdiv class=\u0022scroll form-wrapper\u0022 id=\u0022edit-options\u0022\u003E\u003Cdiv class=\u0022form-item description form-wrapper\u0022 id=\u0022edit-options-form-description\u0022\u003EWhether or not the content is published.\u003C\/div\u003E\u003Cdiv class=\u0022views-expose clearfix\u0022\u003E\u003Cdiv class=\u0022js-only form-wrapper\u0022 id=\u0022edit-options-expose-button-checkbox\u0022\u003E\u003Cdiv class=\u0022form-item form-type-checkbox form-item-options-expose-button-checkbox-checkbox\u0022\u003E\n \u003Cinput type=\u0022checkbox\u0022 id=\u0022edit-options-expose-button-checkbox-checkbox\u0022 name=\u0022options[expose_button][checkbox][checkbox]\u0022 value=\u00221\u0022 class=\u0022form-checkbox\u0022 \/\u003E \u003Clabel class=\u0022option\u0022 for=\u0022edit-options-expose-button-checkbox-checkbox\u0022\u003EExpose this filter to visitors, to allow them to change it \u003C\/label\u003E\n\n\u003C\/div\u003E\n\u003C\/div\u003E\u003Cdiv class=\u0022description exposed-description\u0022\u003EThis filter is not exposed. Expose it to allow the users to change it.\u003C\/div\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-options-expose-button-button\u0022 name=\u0022op\u0022 value=\u0022Expose filter\u0022 class=\u0022form-submit\u0022 \/\u003E\u003C\/div\u003E\u003Cdiv class=\u0022clearfix\u0022\u003E\u003Cdiv class=\u0022views-group-box views-left-30\u0022\u003E\u003C\/div\u003E\u003Cdiv class=\u0022form-item form-type-radios form-item-options-value\u0022\u003E\n \u003Clabel for=\u0022edit-options-value\u0022\u003EPublished \u003C\/label\u003E\n \u003Cdiv id=\u0022edit-options-value\u0022 class=\u0022form-radios\u0022\u003E\u003Cdiv class=\u0022form-item form-type-radio form-item-options-value\u0022\u003E\n \u003Cinput type=\u0022radio\u0022 id=\u0022edit-options-value-1\u0022 name=\u0022options[value]\u0022 value=\u00221\u0022 class=\u0022form-radio\u0022 \/\u003E \u003Clabel class=\u0022option\u0022 for=\u0022edit-options-value-1\u0022\u003EYes \u003C\/label\u003E\n\n\u003C\/div\u003E\n\u003Cdiv class=\u0022form-item form-type-radio form-item-options-value\u0022\u003E\n \u003Cinput type=\u0022radio\u0022 id=\u0022edit-options-value-0\u0022 name=\u0022options[value]\u0022 value=\u00220\u0022 checked=\u0022checked\u0022 class=\u0022form-radio\u0022 \/\u003E \u003Clabel class=\u0022option\u0022 for=\u0022edit-options-value-0\u0022\u003ENo \u003C\/label\u003E\n\n\u003C\/div\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\u003Cfieldset class=\u0022collapsible collapsed form-wrapper\u0022 id=\u0022edit-options-more\u0022\u003E\u003Clegend\u003E\u003Cspan class=\u0022fieldset-legend\u0022\u003EMore\u003C\/span\u003E\u003C\/legend\u003E\u003Cdiv class=\u0022fieldset-wrapper\u0022\u003E\u003Cdiv class=\u0022form-item form-type-textfield form-item-options-ui-name\u0022\u003E\n \u003Clabel for=\u0022edit-options-ui-name\u0022\u003EAdministrative title \u003C\/label\u003E\n \u003Cinput type=\u0022text\u0022 id=\u0022edit-options-ui-name\u0022 name=\u0022options[ui_name]\u0022 value=\u0022\u0022 size=\u002260\u0022 maxlength=\u0022128\u0022 class=\u0022form-text\u0022 \/\u003E\n\u003Cdiv class=\u0022description\u0022\u003EThis title will be displayed on the views edit page instead of the default one. This might be useful if you have the same item twice.\u003C\/div\u003E\n\u003C\/div\u003E\n\u003C\/div\u003E\u003C\/fieldset\u003E\n\u003C\/div\u003E\u003Cdiv class=\u0022clearfix\u0022\u003E\u003Cdiv class=\u0022form-buttons\u0022\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-submit\u0022 name=\u0022op\u0022 value=\u0022Apply\u0022 class=\u0022form-submit\u0022 \/\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-cancel\u0022 name=\u0022op\u0022 value=\u0022Cancel\u0022 class=\u0022form-submit\u0022 \/\u003E\u003Cinput type=\u0022submit\u0022 id=\u0022edit-remove\u0022 name=\u0022op\u0022 value=\u0022Remove\u0022 class=\u0022form-submit\u0022 \/\u003E\u003C\/div\u003E\u003C\/div\u003E\u003Cinput type=\u0022hidden\u0022 name=\u0022form_build_id\u0022 value=\u0022form-l79Nz6NHyuBFv5Os2cMOU3KY7s_RRtFmQ_Y-I1rPB1I\u0022 \/\u003E\n\u003Cinput type=\u0022hidden\u0022 name=\u0022form_token\u0022 value=\u0022hj01GbeLJ7Nay96fNcdS80s_DQWUiPkjFNKiupCLSzk\u0022 \/\u003E\n\u003Cinput type=\u0022hidden\u0022 name=\u0022form_id\u0022 value=\u0022views_ui_config_item_form\u0022 \/\u003E\n\u003C\/div\u003E\u003C\/form\u003E","title":"Configure filter criterion: Content: Published","url":"http:\/\/localhost\/blankdrupal7\/admin\/structure\/views\/ajax\/config-item\/nivo_slider_view\/block\/filter\/status"},{"command":"viewsHilite","selector":".block-filter-status"}]

Kind support welcome..

raphar’s picture

I also tried with the latest dev version of views, still the same error message..

raphar’s picture

Category: support » bug
Priority: Major » Normal

works fine !
had to go back to core 7.21, views 7.x-3.7, jquery 1.7 and jquery ui 1.8.11

still exploring and actually it might be related to jquery that i had updated when updating core..:

https://drupal.org/node/1965674

Paul B’s picture

Yeah i think you are totally right here, so commited to 7.x-3.x

I can't find that commit and the code is not in views_ui_add_form_save_submit() now.

Paul B’s picture

Component: block displays » Code
Status: Active » Needs review
FileSize
552 bytes

Re-roll of patch from #55

johnv’s picture

Issue summary: View changes

Coming from #2153221 : the following error appears when saving a view to code, and override it afterwards: PDOException: in views_db_object->save_row() (line 2224 of \views\includes\view.inc)
#2153221 saves the view via 'views_ui_edit_view_form_submit' (which already clears the cache), not 'views_ui_add_form_save_submit' as in the patch.

This patch seems a remedy, when used upfront. (However, there are more issues about clearing views 'default' cache )
[EDIT] This patch seems a remedy, if the code is moved INTO method view::save(), and added to view::delete(), too.

Further more:
1. Is there any reason why you would clear the cache after saving the view, and not before?
2. the call to ctools_include('object-cache'); shouldn't be necessary anymore.

markus_petrux’s picture

Version: 7.x-3.7 » 7.x-3.x-dev
Priority: Normal » Major
Status: Needs review » Needs work

Patch does not help here.

It is actually impossible to edit and save a view that is defined in code (views_default).

Being able to override a view is higher priority than normal.

markus_petrux’s picture

Tried again on the same site, and today it was possible to save that default view with no PHP Exceptions. It just works. hmm... puzzled...

johnv’s picture

A review of the Views-php-code when saving my of my erroneous view-in-code View, shows that the php-code is OK.
After that, I applied attached patch to my dev-system, and it reveiled the following message:
Error: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF6ller"...' for column 'display_options' at row 1

I recalled my display settings contain the word "Möller", and it still did:
$handler->display->display_options['fields']['title']['alter']['text'] = 'möller';
I removed this line from the code-file (since I could not refind it in my display using Views UI) , and now I can save my view.
This explains why the problem is not in every View.

I don't know why the error appears, since my tables look like this, and utf8_unicode_ci-tables shouolde be able to accept that.

views_display	MyISAM	utf8_unicode_ci	630.9 KiB	23.9 KiB
views_view		MyISAM	utf8_unicode_ci	7.5 KiB	100 B
watchdog    	MyISAM	utf8_unicode_ci	189.5 KiB	-
136 tables		InnoDB	latin1_swedish_ci	78.4 MiB	16.6 MiB

But my problem has gone now, provided I do not use German letters.

Oh, and I do have #108 applied, but I don't think it is necessary.

johnv’s picture

As an addition to #108, it seems it is sufficient to re-save the coding file as UTF8 instead of ANSI.
I used Windows Notepad for it. Choose File | Save As... , set the Encoding field and save the file.