Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Problem/Motivation
Each time I try to export the MySQL tables using the Database Administration module, I receive the following error message, one for each table I select to export:
Notice: Undefined index: create table in dba_mysql_show_create_table() (line 14 of C:\inetpub\wwwroot\stadtlabor\sites\all\modules\contrib\dba\database\mysql.inc).
This error has appeared first after upgrading the Drupal Core to 7.32. The error still occurs after upgrading the Drupal Core to 7.33. This error message did not appear when using Drupal Core 7.31.
Steps to reproduce error:
1. Navigate to the Structure page.
2. Click the Database Administration link.
3. Select all tables and then click the Export button.
4. For the format, select mysqldump.
5. Click the Export button.
6. When asked if you want to open or save the .sql file, click Save.
7. Click the X to close the Database Administration screen.
At this point is when the error message appears.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | 20150111-1800 Errors Database Administration Export.png | 273.14 KB | halfjapanese |
Comments
Comment #1
halfjapanese CreditAttribution: halfjapanese commentedUpgraded to Drupal Core 7.34. Tested today (January 11, 2015) and confirmed the error messages still appear. Attaching a screenshot.
Information about current system:
Operating System Windows Server 2008 R2
Web server Microsoft-IIS/7.5
PHP 5.3.24
PHP extensions Enabled
PHP memory limit 128M
PHP register globals Disabled
Drupal 7.34
Install profile Standard (standard-7.34)
Drupal core update status Up to date
Database system MySQL Windows 5.1
Database system version 5.1.72-community
Database updates Up to date
Module and theme update status Up to date
Drupal root C:\inetpub\wwwroot\stadtlabor
Site path sites/default
File directory path sites/default/files
Private file directory path sites/default/files/private
Temporary file directory path sites/default/files/tmp
Modules Installed:
Package Name Version
Acquia Connector Acquia agent (acquia_agent) 7.x-2.15
Acquia Connector Acquia Site Profile Information (acquia_spi) 7.x-2.15
Chaos tool suite Chaos tools (ctools) 7.x-1.5
Core Block (block) 7.34
Core Color (color) 7.34
Core Comment (comment) 7.34
Core Contextual links (contextual) 7.34
Core Dashboard (dashboard) 7.34
Core Database logging (dblog) 7.34
Core Field (field) 7.34
Core Field SQL storage (field_sql_storage) 7.34
Core Field UI (field_ui) 7.34
Core File (file) 7.34
Core Filter (filter) 7.34
Core Help (help) 7.34
Core Image (image) 7.34
Core List (list) 7.34
Core Menu (menu) 7.34
Core Node (node) 7.34
Core Number (number) 7.34
Core Options (options) 7.34
Core Overlay (overlay) 7.34
Core Path (path) 7.34
Core RDF (rdf) 7.34
Core Search (search) 7.34
Core Shortcut (shortcut) 7.34
Core System (system) 7.34
Core Taxonomy (taxonomy) 7.34
Core Text (text) 7.34
Core Toolbar (toolbar) 7.34
Core Update manager (update) 7.34
Core User (user) 7.34
Date/Time Date (date) 7.x-2.8
Date/Time Date API (date_api) 7.x-2.8
Date/Time Partial Date (partial_date) 7.x-1.0-beta1
Development Database Administration (dba) 7.x-1.0-alpha2
Fields Address Field (addressfield) 7.x-1.0-rc1
Fields File (Field) Paths (filefield_paths) 7.x-1.0-beta4
Fields Geofield (geofield) 7.x-2.3
OpenLayers OpenLayers (openlayers) 7.x-2.0-beta11
OpenLayers OpenLayers UI (openlayers_ui) 7.x-2.0-beta11
OpenLayers OpenLayers Views (openlayers_views) 7.x-2.0-beta11
Other Automatic Nodetitles (auto_nodetitle) 7.x-1.0
Other Backup and Migrate (backup_migrate) 7.x-3.0
Other Geocoder (geocoder) 7.x-1.2
Other geoPHP (geophp) 7.x-1.7
Other Libraries (libraries) 7.x-2.2
Other Node Convert (node_convert) 7.x-1.2
Other Plupload widget (plup) 7.x-1.0-alpha1
Other Proj4JS (proj4js) 7.x-1.2
Other Token (token) 7.x-1.5
Other Transliteration (transliteration) 7.x-3.2
Security Security Kit (seckit) 7.x-1.9
Views Views (views) 7.x-3.8
Views Views UI (views_ui) 7.x-3.8
Comment #3
Jeremy CreditAttribution: Jeremy at Tag1 Consulting commentedFix committed:
http://cgit.drupalcode.org/dba/commit/?id=fe9c8ae