Whenever I try to edit or delete a view, I get the following error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'composers' 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] => composers [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => default [:db_insert_placeholder_3] => node [:db_insert_placeholder_4] => composers [:db_insert_placeholder_5] => 7 ) in views_db_object->save_row() (line 2092 of /home/mysite/public_html/modules/views/includes/view.inc).

When this error occurs, when trying to edit/modify an existing a view, the view is not modified/updated.

Notice: Undefined property: view::$export_type in ctools_export_ui->access() (line 128 of /home/mysite/public_html/modules/ctools/plugins/export_ui/ctools_export_ui.class.php).

When this error occurs, when trying to delete a view, the view is not deleted.

Comments

sprite’s picture

sprite commented
Priority: Normal » Major

After changing the version of ctools I am running to ctools - 7.x-1.0 - I now get the following error, apparently in the menu subsystem when I try to delete an existing view.

In addition, when I try to access a view via its path, I get a "page not found" error. However, When I try to edit that same view, the - preview - of the view displays the expected contents (list of articles) in the preview section of the view editing page.

To summarize, running Drupal 7.12 with the recommended recent versions of all necessary modules, the Views feature isn't working for me, and producing the various PHP error notices displayed below.

    Notice: Undefined variable: tab_root_map in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Notice: Undefined variable: tab_parent_map in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).
    Notice: Undefined variable: tab_root_map in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Notice: Undefined variable: tab_parent_map in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).
    Notice: Undefined variable: tab_root_map in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Notice: Undefined variable: tab_parent_map in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).



    Notice: Undefined variable: tab_root_map in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 786 of /home/mysite/public_html/includes/menu.inc).
    Notice: Undefined variable: tab_parent_map in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).
    Warning: implode() [function.implode]: Invalid arguments passed in _menu_translate() (line 787 of /home/mysite/public_html/includes/menu.inc).

----------------------------
(below is a list of all the modules I am running with their versions, so that it will possible to determine if there is some sort of module version incompatibility problem)

Name Version Description Operations
Aggregator 7.12 Aggregates syndicated content (RSS, RDF, and Atom feeds). Help Permissions Configure
Block 7.12 Controls the visual building blocks a page is constructed with. Blocks are boxes of content rendered into an area, or region, of a web page.
Required by: Dashboard (enabled)
Help Permissions Configure
Blog 7.12 Enables multi-user blogs. Help
Book 7.12 Allows users to create and organize related content in an outline. Help Permissions Configure
Color 7.12 Allows administrators to change the color scheme of compatible themes.
Required by: Stylizer (enabled)
Help
Comment 7.12 Allows users to comment on and discuss published content.
Requires: Text (enabled), Field (enabled), Field SQL storage (enabled)
Required by: Forum (enabled), Tracker (enabled)
Help Permissions Configure
Contact 7.12 Enables the use of both personal and site-wide contact forms. Help Permissions Configure
Content translation 7.12 Allows content to be translated into different languages.
Requires: Locale (disabled)

Contextual links 7.12 Provides contextual links to perform actions related to elements on a page.
Required by: Apply skins UI (enabled)
Help Permissions
Dashboard 7.12 Provides a dashboard page in the administrative interface for organizing administrative tasks and tracking information within your site.
Requires: Block (enabled)
Help Permissions Configure
Database logging 7.12 Logs and records system events to the database. Help
Field 7.12 Field API to add fields to entities like nodes and users.
Requires: Field SQL storage (enabled), Field (enabled)
Required by: Drupal, Field SQL storage (enabled), Field (enabled), File (enabled), AudioField (enabled), Field UI (enabled), CCK (enabled), Text (enabled), Comment (enabled), File entity (enabled), Options (enabled), Taxonomy (enabled), Forum (enabled), Image (enabled), List (enabled), Media (enabled), Media Internet Sources (enabled), Number (enabled), Tracker (enabled)
Help
Field SQL storage 7.12 Stores field data in an SQL database.
Requires: Field (enabled), Field SQL storage (enabled)
Required by: Drupal, Field SQL storage (enabled), Field (enabled), File (enabled), AudioField (enabled), Field UI (enabled), CCK (enabled), Text (enabled), Comment (enabled), File entity (enabled), Options (enabled), Taxonomy (enabled), Forum (enabled), Image (enabled), List (enabled), Media (enabled), Media Internet Sources (enabled), Number (enabled), Tracker (enabled)
Help
Field UI 7.12 User interface for the Field API.
Requires: Field (enabled), Field SQL storage (enabled)
Required by: CCK (enabled)
Help
File 7.12 Defines a file field type.
Requires: Field (enabled), Field SQL storage (enabled)
Required by: AudioField (enabled), Image (enabled), Media (enabled), Media Internet Sources (enabled)
Help
Filter 7.12 Filters content in preparation for display.
Required by: Drupal
Help Permissions Configure
Forum 7.12 Provides discussion forums.
Requires: Taxonomy (enabled), Options (enabled), Field (enabled), Field SQL storage (enabled), Comment (enabled), Text (enabled)
Help Permissions Configure
Help 7.12 Manages the display of online help. Help
Image 7.12 Provides image manipulation tools.
Requires: File (enabled), Field (enabled), Field SQL storage (enabled)
Required by: Drupal (Field type(s) in use - see Field list), Media (enabled), Media Internet Sources (enabled)
Help Permissions Configure
List 7.12 Defines list field types. Use with Options to create selection lists.
Requires: Field (enabled), Field SQL storage (enabled), Options (enabled)
Help
Locale 7.12 Adds language handling functionality and enables the translation of the user interface to languages other than English.
Required by: Content translation (disabled)

Menu 7.12 Allows administrators to customize the site navigation menu. Help Permissions Configure
Node 7.12 Allows content to be submitted to the site and displayed on pages.
Required by: Drupal
Help Permissions Configure
Number 7.12 Defines numeric field types.
Requires: Field (enabled), Field SQL storage (enabled)
Help
OpenID 7.12 Allows users to log into your site using OpenID.
Options 7.12 Defines selection, check box and radio button widgets for text and numeric fields.
Requires: Field (enabled), Field SQL storage (enabled)
Required by: Taxonomy (enabled), Forum (enabled), List (enabled)
Help
Overlay 7.12 Displays the Drupal administration interface in an overlay. Help Permissions
Path 7.12 Allows users to rename URLs.
Required by: Pathauto (disabled)
Help Permissions Configure
PHP filter 7.12 Allows embedded PHP code/snippets to be evaluated. Help Permissions
Poll 7.12 Allows your site to capture votes on different topics in the form of multiple choice questions. Help Permissions
RDF 7.12 Enriches your content with metadata to let other applications (e.g. search engines, aggregators) better understand its relationships and attributes. Help
Search 7.12 Enables site-wide keyword searching. Help Permissions Configure
Shortcut 7.12 Allows users to manage customizable lists of shortcut links. Help Permissions Configure
Statistics 7.12 Logs access statistics for your site. Help Permissions Configure
Syslog 7.12 Logs and records system events to syslog. Help
System 7.12 Handles general site configuration for administrators.
Required by: Drupal
Help Permissions Configure
Taxonomy 7.12 Enables the categorization of content.
Requires: Options (enabled), Field (enabled), Field SQL storage (enabled)
Required by: Drupal (Field type(s) in use - see Field list), Forum (enabled)
Help Permissions Configure
Testing 7.12 Provides a framework for unit and functional testing.
Text 7.12 Defines simple text field types.
Requires: Field (enabled), Field SQL storage (enabled)
Required by: Drupal (Field type(s) in use - see Field list), Comment (enabled), Forum (enabled), Tracker (enabled)
Help
Toolbar 7.12 Provides a toolbar that shows the top-level administration menu items and links from other modules.
Tracker 7.12 Enables tracking of recent content for users.
Requires: Comment (enabled), Text (enabled), Field (enabled), Field SQL storage (enabled)
Help
Trigger 7.12 Enables actions to be fired on certain system events, such as when new content is created. Help Configure
Update manager 7.12 Checks for available updates, and can securely install or update modules and themes via a web interface. Help Configure
User 7.12 Manages the user registration and login system.
Required by: Drupal
Help Permissions Configure
Hide Administration

Enabled Name Version Description Operations
Actions permissions 7.x-3.0-rc1 Integrates actions with the permission system. Help Permissions
Administration Development tools 7.x-3.0-rc1 Administration and debugging functionality for developers and site builders.
Administration menu 7.x-3.0-rc1 Provides a dropdown menu to most administrative tasks and other common destinations (to users with the proper permissions).
Required by: Administration menu Toolbar style (enabled)
Help Permissions Configure
Administration menu Toolbar style 7.x-3.0-rc1 A better Toolbar.
Requires: Administration menu (enabled)

Administration views 7.x-3.0-rc1 Replaces all system object management pages in Drupal core with real views.
Requires: Views (enabled), Chaos tools (enabled), Views Bulk Operations (enabled), Entity API (enabled)

Hide CCK

Enabled Name Version Description Operations
CCK 7.x-2.x-dev Miscellaneous field functions not handled by core.
Requires: Field UI (enabled), Field (enabled), Field SQL storage (enabled)
Permissions
Content Migrate 7.x-2.x-dev Migrate fields and field data from CCK D6 format to the D7 field format. Required to migrate data, can be disabled once all fields have been migrated.
Hide Chaos tool suite

Enabled Name Version Description Operations
Bulk Export 7.x-1.0 Performs bulk exporting of data objects known about by Chaos tools.
Requires: Chaos tools (enabled)
Permissions
Chaos tools 7.x-1.0 A library of helpful tools by Merlin of Chaos.
Required by: Views (enabled), Views Bulk Operations (enabled), Administration views (enabled), Bulk Export (enabled), Custom rulesets (enabled), Chaos Tools (CTools) AJAX Example (enabled), Custom content panes (enabled), Panels (enabled), Page manager (enabled), Chaos Tools (CTools) Plugin Example (enabled), File entity (enabled), Media (enabled), Media Internet Sources (enabled), Panels In-Place Editor (enabled), Mini panels (enabled), Panel nodes (enabled), Skinr Panels (enabled), Stylizer (enabled), Views content panes (enabled), Views UI (enabled)
Help
Chaos Tools (CTools) AJAX Example 7.x-1.0 Shows how to use the power of Chaos AJAX.
Requires: Chaos tools (enabled)

Chaos Tools (CTools) Plugin Example 7.x-1.0 Shows how an external module can provide ctools plugins (for Panels, etc.).
Requires: Chaos tools (enabled), Panels (enabled), Page manager (enabled), Advanced help (enabled)
Help
Custom content panes 7.x-1.0 Create custom, exportable, reusable content panes for applications like Panels.
Requires: Chaos tools (enabled)
Permissions
Custom rulesets 7.x-1.0 Create custom, exportable, reusable access rulesets for applications like Panels.
Requires: Chaos tools (enabled)
Permissions
Page manager 7.x-1.0 Provides a UI and API to manage pages within the site.
Requires: Chaos tools (enabled)
Required by: Chaos Tools (CTools) Plugin Example (enabled)
Help Permissions
Stylizer 7.x-1.0 Create custom styles for applications such as Panels.
Requires: Chaos tools (enabled), Color (enabled)
Permissions
Views content panes 7.x-1.0 Allows Views content to be used in Panels, Dashboard and other modules which use the CTools Content API.
Requires: Chaos tools (enabled), Views (enabled)

Hide Fields

Enabled Name Version Description Operations
AudioField 7.x-1.0-beta4 Handle audio upload using fields.
Requires: File (enabled), Field (enabled), Field SQL storage (enabled)
Help Permissions
Hide Fusion Accelerator

Enabled Name Version Description Operations
Apply skins 7.x-2.0-beta1 Provides a way to define and skin Drupal UI components, such as blocks and menus.
Required by: Apply skins for pages and regions (enabled), Apply skins UI (enabled)
Help
Apply skins for pages and regions 7.x-2.0-beta1 Adds a new tab to the administrative interface to edit skins for pages and regions.
Requires: Apply skins (enabled)
Help
Apply skins UI 7.x-2.0-beta1 Administrative interface to edit skins for Drupal UI components. Without this module, you cannot edit your skins or rules.
Requires: Apply skins (enabled), Contextual links (enabled)
Help Permissions Configure
Fusion grid tools 7.x-2.0-beta1 Provides dynamic grid generation for responsive layouts. Help
Fusion labels 7.x-2.0-beta1 Toggle buttons are added for administrators to visualize regions and grids in a theme. Permissions
Responsive layouts for IE 6-8 7.x-2.0-beta1 Provides simulated support for CSS media queries in Internet Explorer versions 6-8.
Requires: Libraries (missing)

Hide Media

Enabled Name Version Description Operations
File entity 7.x-1.0 Extends Drupal file entities to be fieldable and viewable.
Requires: Field (enabled), Field SQL storage (enabled), Chaos tools (enabled)
Required by: Media (enabled), Media Internet Sources (enabled)

IMCE 7.x-1.5 An image/file uploader and browser supporting personal directories and user quota. Help Permissions Configure
Media 7.x-1.0 Provides the core Media API
Requires: File entity (enabled), Field (enabled), Field SQL storage (enabled), Chaos tools (enabled), Image (enabled), File (enabled)
Required by: Media Internet Sources (enabled)
Help Permissions
Media Internet Sources 7.x-1.0 Provides an API for accessing media on various internet services
Requires: Media (enabled), File entity (enabled), Field (enabled), Field SQL storage (enabled), Chaos tools (enabled), Image (enabled), File (enabled)
Permissions
Hide Other

Enabled Name Version Description Operations
Advanced help 7.x-1.0 Allow advanced help and documentation.
Required by: Chaos Tools (CTools) Plugin Example (enabled), Advanced help example (enabled)
Help Permissions
Advanced help example 7.x-1.0 A example help module to demonstrate the advanced help module.
Requires: Advanced help (enabled)
Help
Entity API 7.x-1.0-rc1 Enables modules to work with any entity type and to provide entities.
Required by: Views Bulk Operations (enabled), Administration views (enabled), Entity tokens (enabled)
Help
Entity tokens 7.x-1.0-rc1 Provides token replacements for all properties that have no tokens and are known to the entity API.
Requires: Entity API (enabled)
Help
Pathauto 7.x-1.0 Provides a mechanism for modules to automatically generate aliases for the content they manage.
Requires: Path (enabled), Token (enabled)

Token 7.x-1.0 Provides a user interface for the Token API and some missing core tokens.
Required by: Pathauto (disabled)
Help
Hide Panels

Enabled Name Version Description Operations
Mini panels 7.x-3.2 Create mini panels that can be used as blocks by Drupal and panes by other panel modules.
Requires: Panels (enabled), Chaos tools (enabled)
Permissions
Panel nodes 7.x-3.2 Create nodes that are divided into areas with selectable content.
Requires: Panels (enabled), Chaos tools (enabled)
Permissions Configure
Panels 7.x-3.2 Core Panels display functions; provides no external UI, at least one other Panels module should be enabled.
Requires: Chaos tools (enabled)
Required by: Chaos Tools (CTools) Plugin Example (enabled), Panels In-Place Editor (enabled), Mini panels (enabled), Panel nodes (enabled), Skinr Panels (enabled)
Help Permissions Configure
Panels In-Place Editor 7.x-3.2 Provide a UI for managing some Panels directly on the frontend, instead of having to use the backend.
Requires: Panels (enabled), Chaos tools (enabled)
Configure
Hide Skinr

Enabled Name Version Description Operations
Skinr 7.x-2.0-alpha1 Provides a way to define and/or skin bits of Drupal output from the UI.
Required by: Skinr UI (enabled)
Help
Skinr Panels 7.x-2.0-alpha1 Provides Skinr integration with Panels.
Requires: Panels (enabled), Chaos tools (enabled)

Skinr UI 7.x-2.0-alpha1 Administrative interface to skinr. Without this module, you cannot edit your skins.
Requires: Skinr (enabled)
Permissions Configure
Hide User interface

Enabled Name Version Description Operations
CKEditor 7.x-1.8 Enables CKEditor (WYSIWYG HTML editor) for use instead of plain text fields. Help Permissions Configure
Wysiwyg 7.x-2.1 Allows to edit content with client-side editors. Help Configure
Hide Views

Enabled Name Version Description Operations
Views 7.x-3.3 Create customized lists and queries from your database.
Requires: Chaos tools (enabled)
Required by: Views Bulk Operations (enabled), Administration views (enabled), Views content panes (enabled), Views UI (enabled)
Help Permissions
Views Bulk Operations 7.x-3.0-rc1 Provides a way of selecting multiple rows and applying operations to them.
Requires: Entity API (enabled), Views (enabled), Chaos tools (enabled)
Required by: Administration views (enabled)
Help
Views UI 7.x-3.3 Administrative interface to views. Without this module, you cannot create or edit your views.
Requires: Views (enabled), Chaos tools (enabled)
Configure

dawehner’s picture

dawehner
Primary language German
commented

Deleting a view works fine for me, so maybe something else has a problem.

Take sure that you clear the cache, twice, and all this basic stuff, run update.php etc.
Things like this are especially be hard, because if it would be really broken thousands of people would report it, so it seems to be some custom problem on your site.

Maybe #1527778: View::save needs to check for machine name before saving. Not reliant on vid only. would automatically solve this problem, but i'm not sure, as especially the notice shows a pretty broken view.

selinav’s picture

selinav commented

I have this problem when the name contain underscore instead of an accented character.

Title : Compétitions
View name : comp_titions

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Postponed (maintainer needs more info)

Also deleting a view with an underscore works fine for me, mhhh it is hard to fix an issue which doesn't exist for you...

esmerel’s picture

esmerel commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)