user warning: Table 'd6.node_field' doesn't exist query
NancyDru - September 16, 2009 - 16:07
| Project: | Import / Export API |
| Version: | 6.x-1.x-dev |
| Component: | importexportapi.module |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed |
| Issue tags: | other contrib modules |
Jump to:
Description
This happened after trying to export "content-fields".
#1
Thanks for the report Nancy. Was that the full error or did it give a module and line number?
#2
user warning: Table 'd6.node_field' doesn't exist query: SELECT nf.field_name, nf.type AS field_type, nf.global_settings, nf.required, nf.multiple, nf.db_storage FROM node_field nf in C:\www\webapps\drupal-6\sites\all\modules\importexportapi\engines\importexportapi_db_get.inc on line 144.
#3
And, BTW, trying to export "content types" (CSV):
# user warning: Table 'd6.node_type_content' doesn't exist query: SELECT nt.type_name, nt.label AS type_label, nt.description, nt.help AS help_text, nt.title_label FROM node_type_content nt in C:\www\webapps\drupal-6\sites\all\modules\importexportapi\engines\importexportapi_db_get.inc on line 144.
# user warning: Table 'd6.node_field_instance' doesn't exist query: SELECT nfi.field_name, nfi.type_name, nfi.weight, nfi.label, nfi.widget_type, nfi.widget_settings, nfi.description, nt.label AS type_label FROM node_field_instance nfi LEFT JOIN node_type_content nt ON nfi.type_name = nt.type_name in C:\www\webapps\drupal-6\sites\all\modules\importexportapi\engines\importexportapi_db_get.inc on line 144.
DRUPAL CORE Version: 6.13 Recommended version: 6.14 PHP VERSION: 5.2.5 DATABASE TYPE: mysqli; VERSION: 5.0.45 DRUPAL MODULES Package: Core - optional Module: Aggregator (6.13) Module: Blog (6.13) Module: Color (6.13) Module: Comment (6.13) Module: Contact (6.13) Module: Database logging (6.13) Module: Forum (6.13) Module: Help (6.13) Module: Locale (6.13) Module: Menu (6.13) Module: Path (6.13) Module: PHP filter (6.13) Module: Poll (6.13) Module: Profile (6.13) Module: Search (6.13) Module: Statistics (6.13) Module: Taxonomy (6.13) Module: Update status (6.13) Module: Upload (6.13) Package: Core - required Module: Block (6.13) Module: Filter (6.13) Module: Node (6.13) Module: System (6.13) Module: User (6.13) Package: Administration Module: Content management filter (6.x-2.x-dev) Package: CCK Module: Content (6.x-2.5) Module: Content Copy (6.x-2.5) Module: Content Permissions (6.x-2.5) Module: Fieldgroup (6.x-2.5) Module: FileField (6.x-3.1; Minimum PHP version required: 5.0) Module: ImageField (6.x-3.1) Module: Link (6.x-2.6) Module: Number (6.x-2.5) Module: Option Widgets (6.x-2.5) Module: Text (6.x-2.5) Module: User Reference (6.x-2.5) Package: CSS Module: CSS API (6.x-0.5-alpha) Package: CiviCRM Package: Content Profile Module: Content Profile (6.x-1.0-beta4) Package: Database Package: Date/Time Module: Date (6.x-2.3; Recommended version: 6.x-2.4) Module: Date API (6.x-2.3) Module: Date Timezone (6.x-2.3) Package: Developer Module: Beautifier (6.x-1.0-alpha1) Module: Beautifier PHP (6.x-1.0-alpha1) Package: Development Module: Coder (6.x-2.x-dev) Module: Configuration State (6.x-1.0; Recommended version: 6.x-1.1) Module: Devel (6.x-1.17) Module: Helpers (6.x-1.x-dev; Recommended version: 6.x-1.1) Module: Helpers_database (6.x-1.x-dev) Module: Helpers_form (6.x-1.x-dev) Module: Helpers_node (6.x-1.x-dev) Module: Helpers_taxonomy (6.x-1.x-dev) Module: Helpers_theme (6.x-1.x-dev) Module: SimpleTest (6.x-2.x-dev; Recommended version: 6.x-2.9; Minimum PHP version required: 5 ; Drupal 6) Package: Event Package: Flags Package: Form Elements Module: Hierarchical Select (6.x-3.x-dev) Module: Hierarchical Select Taxonomy (6.x-3.x-dev) Package: Image Module: Image (6.x-1.0-beta3) Module: Image Attach (6.x-1.0-beta3) Module: Image Gallery (6.x-1.0-beta3) Package: ImageCache Module: ImageAPI (6.x-1.6; Minimum PHP version required: 5.1) Module: ImageAPI GD2 (6.x-1.6) Module: ImageAPI ImageMagick (6.x-1.6) Module: ImageCache (6.x-2.0-beta10) Module: ImageCache UI (6.x-2.0-beta10) Package: Import Export API Module: Import Export API (6.x-1.x-dev) Module: Import Export UI (6.x-1.x-dev) Package: Location Package: Node Gallery Package: Optional Package: Other Module: Advanced help (6.x-1.2) Module: Announcements (6.x-1.x-dev; Recommended version: 6.x-1.3) Module: Cleaner (HEAD; Recommended version: 6.x-1.0; Minimum PHP version required: 5.1.0) Module: Code Filter (6.x-1.0) Module: CVS Deploy (6.x-1.1) Module: Frequently Asked Questions (6.x-1.x-dev; Recommended version: 6.x-1.8) Module: Faq_Ask (6.x-1.x-dev; Recommended version: 6.x-1.2) Module: Get Content Type (6.x-1.x-dev; Recommended version: 6.x-1.2) Module: Glossary (6.x-1.x-dev; Recommended version: 6.x-1.6) Module: Advanced help example (6.x-1.2) Module: Hovertip (6.x-1.x-dev) Module: IndexPage (6.x-1.x-dev; Recommended version: 6.x-1.1) Module: Lightbox2 (6.x-1.9) Module: MultiBlock (6.x-1.x-dev; Recommended version: 6.x-1.3) Module: Node Export (6.x-2.x-dev; Recommended version: 6.x-2.16) Module: Node_Type_Filter (6.x-1.x-dev; Recommended version: 6.x-1.2) Module: Pathauto (6.x-2.x-dev) Module: Poormanscron (6.x-1.x-dev; Recommended version: 6.x-1.0) Module: Translation template extractor (6.x-2.2) Module: Profile Privacy (6.x-1.2) Module: Quotes (6.x-1.x-dev; Recommended version: 6.x-1.30) Module: RealName (6.x-1.x-dev; Recommended version: 6.x-1.2) Module: Revision Deletion (6.x-1.x-dev; Recommended version: 6.x-1.0-rc1) Module: Site Documentation (6.x-1.x-dev; Recommended version: 6.x-1.2) Module: Sitenotes (6.x-1.x-dev; Recommended version: 6.x-1.2) Module: Submitted By (6.x-1.x-dev; Recommended version: 6.x-1.3) Module: Token (6.x-1.12) Module: Tracker 2 (6.x-1.1) Module: Update status advanced settings (6.x-1.0) Module: Weight (6.x-1.x-dev; Recommended version: 6.x-1.0) Package: Statistics Package: Taxonomy Module: Tagadelic (6.x-1.2) Module: Taxonomy Browser (6.x-1.x-dev; Recommended version: 6.x-1.4) Module: Taxonomy Delegate (6.x-1.x-dev; Recommended version: 6.x-1.3) Module: Taxonomy List (6.x-2.x-dev; Recommended version: 6.x-2.0-rc1) Module: Taxonomy Sifter (HEAD; Recommended version: 6.x-1.x-dev) Module: Taxonomy Import/Export via XML (6.x-1.3) Package: Taxonomy Filter Package: Taxonomy Image Module: Taxonomy Image (6.x-1.x-dev; Recommended version: 6.x-1.6) Module: Taxonomy Image Attach (6.x-1.x-dev) Module: Taxonomy Image Blocks (6.x-1.x-dev) Module: Taxonomy Image Link Alter (6.x-1.x-dev) Module: Taxonomy Image Node Display (6.x-1.x-dev) Package: Taxonomy Menu Package: User interface Package: Util Module: Log Clear (6.x-2.x-dev) Module: Module Weights (6.x-2.x-dev) Module: Access Permissions Fieldsets Manager (6.x-2.x-dev) Module: System Module (6.x-2.x-dev) Module: Type Defaults (6.x-2.x-dev) Module: Util (6.x-2.x-dev; Recommended version: 6.x-2.3) Package: Views Module: Views (6.x-2.6) Module: Views exporter (6.x-2.6) Module: Views UI (6.x-2.6) Package: Voting Module: Fivestar (6.x-1.18) Module: Fivestar Comments (6.x-1.18) Module: Voting API (6.x-2.3) Package: Weblinks Module: Google and Alexa Rank (6.x-2.x-dev) Module: Web Links (6.x-2.x-dev; Recommended version: 6.x-2.1) Module: Weblinks Blocks (6.x-2.x-dev) Module: Web Links Capture (Version: unknown) Module: Web Links Checker (6.x-2.x-dev) Module: Web Links Embed (6.x-2.x-dev) Module: Web Links Filter (6.x-2.x-dev) Module: Web Links OPML Export/Import (Version: unknown) Module: Who Likes Me (6.x-2.x-dev) Package: XML Sitemap WEB SERVER: Apache/2.2.6 (Win32) PHP/5.2.5 mod_ssl/2.2.6 OpenSSL/0.9.8g DRUPAL MINIMUM SUPPORTED PHP VERSION: 4.3.5 PHP EXTENSIONS bcmath calendar com_dotnet ctype session filter ftp hash iconv json odbc pcre Reflection date libxml standard tokenizer zlib SimpleXML dom SPL wddx xml xmlreader xmlwriter apache2handler curl gd mbstring mysql mysqli PDO pdo_mysql APACHE MODULES core mod_win32 mpm_winnt http_core mod_so mod_alias mod_authz_host mod_autoindex mod_dir mod_log_config mod_mime mod_rewrite mod_setenvif mod_ssl mod_status mod_info mod_logio mod_deflate mod_headers mod_php5 mod_auth_basic mod_authn_file mod_authz_user mod_cgi USER BROWSER: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729) CLEAN URLS: enabled CRON LAST RUN: 1 hour 25 min ago#4
This directly involves CCK. I will need to further delve into this at a later date of if someone else can supply the patch I'll commit it to CVS. See the files in definitions/contrib/cck/.
#5
#6
Here's the problem -- your module is not following CCK changes:
function content_update_6001() {
if ($abort = content_check_update()) {
return $abort;
}
$ret = array();
drupal_load('module', 'content');
if (db_table_exists('content_node_field')) {
return $ret;
}
db_rename_table($ret, 'node_field', 'content_node_field');
db_rename_table($ret, 'node_field_instance', 'content_node_field_instance');
variable_set('content_schema_version', 6001);
content_clear_type_cache(TRUE);
return $ret;
}
The tables were renamed.
#7
Thanks, NancyDru. Will consider this for a fix.