Nia Through Movement We Find HealthNia Through Movement We Find Health 1. Overview 2. Select updates 3. Run updates 4. Review log Drupal database update * user warning: Table 'cache_form' already exists query: CREATE TABLE cache_form ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, serialized int(1) NOT NULL default '0', PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 1415. * user warning: Unknown column 'serialized' in 'cache' query: ALTER TABLE cache CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 520. * user warning: Unknown column 'serialized' in 'cache_filter' query: ALTER TABLE cache_filter CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 520. * user warning: Unknown column 'serialized' in 'cache_page' query: ALTER TABLE cache_page CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 520. * user warning: Table 'menu_router' already exists query: CREATE TABLE menu_router ( `path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` VARCHAR(255) NOT NULL DEFAULT '', `to_arg_functions` VARCHAR(255) NOT NULL DEFAULT '', `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX fit (fit), INDEX tab_parent (tab_parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/includes/database.inc on line 529. * user warning: Table 'menu_links' already exists query: CREATE TABLE menu_links ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8` INT unsigned NOT NULL DEFAULT 0, `p9` INT unsigned NOT NULL DEFAULT 0, `updated` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (mlid), INDEX path_menu (link_path(128), menu_name), INDEX menu_plid_expand_child (menu_name, plid, expanded, has_children), INDEX menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9), INDEX router_path (router_path(128)) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/includes/database.inc on line 529. * user warning: Table 'menu_custom' already exists query: CREATE TABLE menu_custom ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL, PRIMARY KEY (menu_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/includes/database.inc on line 529. * user warning: Duplicate entry 'navigation' for key 'PRIMARY' query: INSERT INTO menu_custom (menu_name, title, description) VALUES ('navigation', 'Navigation', 'The navigation menu is provided by Drupal and is the main interactive menu for any site. It is usually the only menu that contains personalized links for authenticated users, and is often not even visible to anonymous users.') in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 1751. * user warning: Duplicate entry 'primary-links' for key 'PRIMARY' query: UPDATE menu_custom SET menu_name = 'primary-links', description = 'Primary links are often used at the theme layer to show the major sections of a site. A typical representation for primary links would be tabs along the top.' WHERE menu_name = 'menu-primary-links' in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 1868. * user warning: Duplicate entry 'secondary-links' for key 'PRIMARY' query: INSERT INTO menu_custom (menu_name, title, description) VALUES ('secondary-links', 'Secondary links', 'Secondary links are often used for pages like legal notices, contact details, and other secondary navigation items that play a lesser role than primary links.') in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 1886. * user warning: Table 'upload' already exists query: ALTER TABLE file_revisions RENAME TO upload in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 249. * user warning: Duplicate column name 'nid' query: ALTER TABLE upload ADD `nid` INT unsigned NOT NULL DEFAULT 0 in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 298. * user warning: Duplicate key name 'nid' query: ALTER TABLE upload ADD INDEX nid (nid) in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 434. * user warning: Multiple primary key defined query: ALTER TABLE upload ADD PRIMARY KEY (vid, fid) in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 374. * user warning: Duplicate key name 'fid' query: ALTER TABLE upload ADD INDEX fid (fid) in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 434. * user warning: Table 'actions_old_contrib' already exists query: ALTER TABLE actions RENAME TO actions_old_contrib in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 249. * user warning: Table 'actions' already exists query: CREATE TABLE actions ( `aid` VARCHAR(255) NOT NULL DEFAULT '0', `type` VARCHAR(32) NOT NULL DEFAULT '', `callback` VARCHAR(255) NOT NULL DEFAULT '', `parameters` LONGTEXT NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '0', PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/includes/database.inc on line 529. * user warning: Table 'actions_aid' already exists query: CREATE TABLE actions_aid ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/includes/database.inc on line 529. * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lists of watched posts, administer watcher, use watcher, administer workflow, sc' at line 1 query: UPDATE permission SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create polls, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, edit own blog, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit custom_page content, edit download content, edit featured_event content, edit group content, edit news_media content, edit newsletter content, edit newsletter_article content, edit ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit producer_call content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer permissions, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions' WHERE rid = 11 in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 2175. * user warning: Table 'search_node_links' already exists query: CREATE TABLE search_node_links ( `sid` INT unsigned NOT NULL DEFAULT 0, `type` VARCHAR(16) NOT NULL DEFAULT '', `nid` INT unsigned NOT NULL DEFAULT 0, `caption` LONGTEXT DEFAULT NULL, PRIMARY KEY (sid, type, nid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/six.nianow.com/htdocs/includes/database.inc on line 529. * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lists of watched posts, administer watcher, use watcher, administer workflow, sc' at line 1 query: UPDATE permission SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create poll content, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, edit own blog, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit any bio content, edit any class content, edit any custom_page content, edit any download content, edit any featured_event content, edit any group content, edit any news_media content, edit any newsletter content, edit any newsletter_article content, edit any ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit any page content, edit any producer_call content, edit any product content, edit any story content, edit any teacher_telecourse content, edit any telecourse content, edit any testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer access control, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions' WHERE rid = 11 in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 2298. * user warning: Duplicate column name 'weight' query: ALTER TABLE upload ADD `weight` TINYINT NOT NULL DEFAULT 0 in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 298. * user warning: Duplicate entry '20585-0-NA' for key 'PRIMARY' query: ALTER TABLE poll_votes ADD PRIMARY KEY (nid, uid, hostname) in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 374. * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lists of watched posts, administer watcher, use watcher, administer workflow, sc' at line 1 query: UPDATE permission SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create polls, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, create blog entries, edit own blog entries, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit custom_page content, edit download content, edit featured_event content, edit group content, edit news_media content, edit newsletter content, edit newsletter_article content, edit ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit producer_call content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer access control, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions' WHERE rid = 11 in /var/www/six.nianow.com/htdocs/modules/system/system.install on line 2496. * user warning: Duplicate key name 'tab_root_weight_title' query: ALTER TABLE menu_router ADD INDEX tab_root_weight_title (tab_root(64), weight, title) in /var/www/six.nianow.com/htdocs/includes/database.mysql-common.inc on line 434. * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lists of watched posts, administer watcher, use watcher, administer workflow, sc' at line 1 query: UPDATE permission SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create polls, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, edit own blog, create book content, create new books, edit any book content, edit own book content, administer book outlines, access printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit custom_page content, edit download content, edit featured_event content, edit group content, edit news_media content, edit newsletter content, edit newsletter_article content, edit ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit producer_call content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer access control, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions, add content to books' WHERE rid = 11 in /var/www/six.nianow.com/htdocs/modules/book/book.install on line 105. * Saving an old value of the welcome message body for users that are pending administrator approval. However, you should consider modifying this text, since Drupal can now be configured to automatically notify users and send them their login information when their accounts are approved. See the User settings page for details. * Drupal can check periodically for important bug fixes and security releases using the new update status module. This module can be turned on from the modules administration page. For more information please read the Update status handbook page. * Drupal now has separate edit and delete permissions. Previously, users who were able to edit content were automatically allowed to delete it. For added security, delete permissions for individual core content types have been removed from all roles on your site (only roles with the "administer nodes" permission can now delete these types of content). If you would like to reenable any individual delete permissions, you can do this at the permissions page. * User signatures no longer inherit comment input formats. Each user's signature now has its own associated format that can be selected on the user's account page. Existing signatures have been set to your site's default input format. * Blog API module does not depend on blog module's permissions anymore, but provides its own 'administer content with blog api' permission instead. Until this permission is assigned to at least one user role, only the site administrator will be able to use Blog API features. Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged. Reminder: don't forget to set the $update_free_access value in your settings.php file back to FALSE. * Main page * Administration pages The following queries were executed system module Update #6000 * ALTER TABLE {boxes} CHANGE COLUMN bid bid int NOT NULL * REPLACE INTO {sequences} VALUES ('{boxes}_bid', 75) Update #6001 * ALTER TABLE {term_node} ADD `vid` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {term_node} DROP PRIMARY KEY * ALTER TABLE {term_node} ADD PRIMARY KEY (vid, tid, nid) * ALTER TABLE {term_node} ADD INDEX vid (vid) Update #6002 * ALTER TABLE {variable} DROP PRIMARY KEY * ALTER TABLE {variable} CHANGE `name` `name` VARCHAR(128) NOT NULL DEFAULT '' * ALTER TABLE {variable} ADD PRIMARY KEY (name) Update #6003 * ALTER TABLE {comments} ADD INDEX status (status) Update #6004 * No queries Update #6005 * ALTER TABLE {url_alias} ADD language varchar(12) NOT NULL default '' * ALTER TABLE {url_alias} DROP INDEX dst * ALTER TABLE {url_alias} ADD UNIQUE dst_language (dst, language) Update #6006 * ALTER TABLE {node_counter} DROP INDEX daycount * ALTER TABLE {node_counter} DROP INDEX totalcount * ALTER TABLE {node_counter} DROP INDEX timestamp Update #6007 * UPDATE {watchdog} SET severity = 5 WHERE severity = 0 * UPDATE {watchdog} SET severity = 4 WHERE severity = 1 * UPDATE {watchdog} SET severity = 3 WHERE severity = 2 Update #6008 * UPDATE {system} SET owner = description * ALTER TABLE {system} DROP description Update #6009 * UPDATE {system} SET status = 1 WHERE name = 'php' AND type = 'module' * UPDATE {filters} SET delta = 0, module = 'php' WHERE module = 'filter' AND delta = 1 * UPDATE {filters} SET delta = 1 WHERE module = 'filter' AND delta = 2 * UPDATE {filters} SET delta = 2 WHERE module = 'filter' AND delta = 3 Update #6010 * ALTER TABLE {watchdog} ADD `variables` LONGTEXT DEFAULT NULL * UPDATE {watchdog} SET variables = '%s' (N;) * ALTER TABLE {watchdog} CHANGE `variables` `variables` LONGTEXT NOT NULL Update #6011 * ALTER TABLE {node} ADD language varchar(12) NOT NULL default '' Update #6012 * No queries Update #6013 * Cache rebuilt. Update #6014 * variable_set('install_task') Update #6015 * Failed: CREATE TABLE {cache_form} ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, serialized int(1) NOT NULL default '0', PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ Update #6016 * ALTER TABLE {node} ADD UNIQUE KEY nid_vid (nid, vid) * ALTER TABLE {blocks} ADD bid int NOT NULL AUTO_INCREMENT PRIMARY KEY * ALTER TABLE {filters} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY * ALTER TABLE {flood} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY * ALTER TABLE {permission} ADD pid int NOT NULL AUTO_INCREMENT PRIMARY KEY * ALTER TABLE {term_relation} ADD trid int NOT NULL AUTO_INCREMENT PRIMARY KEY * ALTER TABLE {term_synonym} ADD tsid int NOT NULL AUTO_INCREMENT PRIMARY KEY Update #6017 * variable_set(user_mail_register_admin_created_subject) * variable_del(user_mail_admin_subject) * variable_set(user_mail_register_admin_created_body) * variable_del(user_mail_admin_body) * variable_set(user_mail_register_pending_approval_subject) * variable_del(user_mail_approval_subject) * variable_set(user_mail_register_pending_approval_body) * variable_del(user_mail_approval_body) * variable_set(user_mail_register_no_approval_required_subject) * variable_del(user_mail_welcome_subject) * variable_set(user_mail_register_no_approval_required_body) * variable_del(user_mail_welcome_body) * variable_set(user_mail_password_reset_subject) * variable_del(user_mail_pass_subject) * variable_set(user_mail_password_reset_body) * variable_del(user_mail_pass_body) Update #6018 * HTML corrector filter added to the 'Filtered HTML' input format. * HTML corrector filter added to the 'Full HTML' input format. Update #6019 * ALTER TABLE {aggregator_feed} DROP KEY link * ALTER TABLE {aggregator_feed} ADD UNIQUE KEY url (url) * ALTER TABLE {boxes} CHANGE `format` `format` SMALLINT NOT NULL DEFAULT 0 * ALTER TABLE {comments} CHANGE `format` `format` SMALLINT NOT NULL DEFAULT 0 * ALTER TABLE {comments} DROP INDEX lid * ALTER TABLE {comments} ADD INDEX nid (nid) * Failed: ALTER TABLE {cache} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 * Failed: ALTER TABLE {cache_filter} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 * Failed: ALTER TABLE {cache_page} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 * ALTER TABLE {cache_form} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0 * UPDATE {users} SET uid = 3365 WHERE uid = 0 * ALTER TABLE {users} DROP PRIMARY KEY * ALTER TABLE {users} CHANGE `uid` `uid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (uid) * UPDATE {users} SET uid = 0 WHERE uid = 3365 * ALTER TABLE {boxes} DROP PRIMARY KEY * ALTER TABLE {boxes} CHANGE `bid` `bid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (bid) * ALTER TABLE {files} DROP PRIMARY KEY * ALTER TABLE {files} CHANGE `fid` `fid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (fid) * ALTER TABLE {node} DROP PRIMARY KEY * ALTER TABLE {node} CHANGE `nid` `nid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (nid) * ALTER TABLE {node_revisions} DROP PRIMARY KEY * ALTER TABLE {node_revisions} CHANGE `vid` `vid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (vid) Update #6020 * Failed: CREATE TABLE {menu_router} ( `path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` VARCHAR(255) NOT NULL DEFAULT '', `to_arg_functions` VARCHAR(255) NOT NULL DEFAULT '', `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX fit (fit), INDEX tab_parent (tab_parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ * Failed: CREATE TABLE {menu_links} ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8` INT unsigned NOT NULL DEFAULT 0, `p9` INT unsigned NOT NULL DEFAULT 0, `updated` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (mlid), INDEX path_menu (link_path(128), menu_name), INDEX menu_plid_expand_child (menu_name, plid, expanded, has_children), INDEX menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9), INDEX router_path (router_path(128)) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ Update #6021 * ALTER TABLE {menu} ADD `converted` TINYINT unsigned NOT NULL DEFAULT 0 * Failed: CREATE TABLE {menu_custom} ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL, PRIMARY KEY (menu_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ * Failed: UPDATE {menu_custom} SET menu_name = 'primary-links', description = 'Primary links are often used at the theme layer to show the major sections of a site. A typical representation for primary links would be tabs along the top.' WHERE menu_name = 'menu-primary-links' * UPDATE {menu_links} SET menu_name = 'primary-links' WHERE menu_name = 'menu-primary-links' * UPDATE {blocks} SET delta = 'primary-links' WHERE module = 'menu' AND delta = '2' * UPDATE {blocks_roles} SET delta = 'primary-links' WHERE module = 'menu' AND delta = '2' * UPDATE {blocks} SET delta = 'menu-main-menu0' WHERE module = 'menu' AND delta = '256' * UPDATE {blocks_roles} SET delta = 'menu-main-menu0' WHERE module = 'menu' AND delta = '256' * UPDATE {blocks} SET delta = 'menu-resources0' WHERE module = 'menu' AND delta = '342' * UPDATE {blocks_roles} SET delta = 'menu-resources0' WHERE module = 'menu' AND delta = '342' * Relocated 423 existing items to the new menu system. * DROP TABLE {menu} Update #6022 * ALTER TABLE {files} DROP INDEX nid * ALTER TABLE {files} CHANGE `nid` `uid` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {files} ADD `status` INT NOT NULL DEFAULT 0 * ALTER TABLE {files} ADD `timestamp` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {files} ADD INDEX uid (uid) * ALTER TABLE {files} ADD INDEX status (status) * ALTER TABLE {files} ADD INDEX timestamp (timestamp) * ALTER TABLE {file_revisions} DROP PRIMARY KEY * ALTER TABLE {file_revisions} DROP INDEX vid * Failed: ALTER TABLE {file_revisions} RENAME TO {upload} * Failed: ALTER TABLE {upload} ADD `nid` INT unsigned NOT NULL DEFAULT 0 * Failed: ALTER TABLE {upload} ADD INDEX nid (nid) * Failed: ALTER TABLE {upload} ADD PRIMARY KEY (vid, fid) * Failed: ALTER TABLE {upload} ADD INDEX fid (fid) * UPDATE {files} SET status = 1 Update #6023 * ALTER TABLE {node_revisions} DROP INDEX nid * ALTER TABLE {node_revisions} CHANGE `nid` `nid` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {node_revisions} ADD INDEX nid (nid) Update #6024 * ALTER TABLE {node} ADD `tnid` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {node} ADD `translate` INT NOT NULL DEFAULT 0 * ALTER TABLE {node} ADD INDEX tnid (tnid) * ALTER TABLE {node} ADD INDEX translate (translate) Update #6025 * ALTER TABLE {node} DROP INDEX node_title_type * ALTER TABLE {node} CHANGE `title` `title` VARCHAR(255) NOT NULL DEFAULT '' * ALTER TABLE {node} ADD INDEX node_title_type (title, type(4)) * ALTER TABLE {node_revisions} CHANGE `title` `title` VARCHAR(255) NOT NULL DEFAULT '' Update #6026 * No queries Update #6027 * ALTER TABLE {blocks} ADD `cache` TINYINT NOT NULL DEFAULT 1 Update #6028 * No queries Update #6029 * 'dblog' module enabled. Update #6030 * Failed: ALTER TABLE {actions} RENAME TO {actions_old_contrib} * Failed: CREATE TABLE {actions} ( `aid` VARCHAR(255) NOT NULL DEFAULT '0', `type` VARCHAR(32) NOT NULL DEFAULT '', `callback` VARCHAR(255) NOT NULL DEFAULT '', `parameters` LONGTEXT NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '0', PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ * Failed: CREATE TABLE {actions_aid} ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ Update #6031 * No queries Update #6032 * ALTER TABLE {profile_fields} DROP KEY name * ALTER TABLE {profile_fields} CHANGE `name` `name` VARCHAR(128) NOT NULL DEFAULT '' * ALTER TABLE {profile_fields} ADD UNIQUE KEY name (name) Update #6033 * ALTER TABLE {node_comment_statistics} CHANGE `nid` `nid` INT unsigned NOT NULL DEFAULT 0 Update #6034 * UPDATE {permission} SET perm = 'create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit own Event field_feature_0, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_green_belt, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, view Event field_feature_0, view Event field_training, view NiaFinder Profile field_belt_level, view NiaFinder Profile field_green_belt, view NiaFinder Profile field_trainer, post comments, post comments without approval, create repeat events, access fckeditor, create forum topics, edit own forum topics, masquerade as user, producer, receive teacher discount, trainer, access content, create bio content, create download content, create group content, create page content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit download content, edit group content, edit own bio content, edit own class content, edit own download content, edit own group content, edit own newsletter content, edit own newsletter_article content, edit own page content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, access private messages, search content, use advanced search, administer site configuration, access user profiles, administer permissions, administer users, use watcher' WHERE rid = 6 * Failed: UPDATE {permission} SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create polls, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, edit own blog, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit custom_page content, edit download content, edit featured_event content, edit group content, edit news_media content, edit newsletter content, edit newsletter_article content, edit ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit producer_call content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer permissions, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions' WHERE rid = 11 Update #6035 * ALTER TABLE {system} DROP INDEX weight * ALTER TABLE {system} ADD INDEX modules (type(12), status, weight, filename) * ALTER TABLE {system} ADD INDEX bootstrap (type(12), status, bootstrap, weight, filename) Update #6036 * ALTER TABLE {search_dataset} ADD `reindex` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {search_index} DROP INDEX from_sid_type * ALTER TABLE {search_index} DROP fromsid * ALTER TABLE {search_index} DROP fromtype * ALTER TABLE {search_dataset} DROP INDEX sid_type * Failed: CREATE TABLE {search_node_links} ( `sid` INT unsigned NOT NULL DEFAULT 0, `type` VARCHAR(16) NOT NULL DEFAULT '', `nid` INT unsigned NOT NULL DEFAULT 0, `caption` LONGTEXT DEFAULT NULL, PRIMARY KEY (sid, type, nid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ * ALTER IGNORE TABLE {search_index} ADD UNIQUE KEY word_sid_type (word, sid, type) * ALTER IGNORE TABLE {search_dataset} ADD UNIQUE KEY sid_type (sid, type) * UPDATE {search_dataset} SET reindex = 1 Update #6037 * ALTER TABLE {blocks} CHANGE `region` `region` VARCHAR(64) NOT NULL DEFAULT '' * UPDATE {blocks} SET region = '' WHERE status = 0 Update #6038 * UPDATE {profile_fields} SET category = 'Account settings' WHERE LOWER(category) = 'account' Update #6039 * UPDATE {permission} SET perm = 'create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit own Event field_feature_0, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_green_belt, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, view Event field_feature_0, view Event field_training, view NiaFinder Profile field_belt_level, view NiaFinder Profile field_green_belt, view NiaFinder Profile field_trainer, post comments, post comments without approval, create repeat events, access fckeditor, create forum topics, edit own forum topics, masquerade as user, producer, receive teacher discount, trainer, access content, create bio content, create download content, create group content, create page content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit any bio content, edit any class content, edit any download content, edit any group content, edit own bio content, edit own class content, edit own download content, edit own group content, edit own newsletter content, edit own newsletter_article content, edit own page content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit any page content, edit any product content, edit any story content, edit any teacher_telecourse content, edit any telecourse content, edit any testimonial content, revert revisions, view revisions, access private messages, search content, use advanced search, administer site configuration, access user profiles, administer permissions, administer users, use watcher' WHERE rid = 6 * UPDATE {permission} SET perm = 'create events, edit own events, create Event field_feature_0, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, edit Event field_feature_0, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit own Event field_feature_0, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_green_belt, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, view Event field_feature_0, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, clone node, access comments, administer comments, post comments, post comments without approval, create repeat events, access fckeditor, create flash nodes, edit own flash nodes, administer forums, create forum topics, edit own forum topics, flush imagecache, view imagefield uploads, access imce, administer menu, add testimonials for others, trainer, access content, administer content types, administer nodes, create bio content, create class content, create group content, create newsletter content, create newsletter_article content, create page content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit any bio content, edit any class content, edit any group content, edit any newsletter content, edit any newsletter_article content, edit own bio content, edit own class content, edit own group content, edit own newsletter content, edit own newsletter_article content, edit own page content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit any page content, edit any product content, edit any story content, edit any teacher_telecourse content, edit any telecourse content, edit any testimonial content, revert revisions, view revisions, create url aliases, access private messages, search content, administer taxonomy, access user profiles, administer users, use watcher, schedule workflow transitions' WHERE rid = 10 * Failed: UPDATE {permission} SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create poll content, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, edit own blog, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit any bio content, edit any class content, edit any custom_page content, edit any download content, edit any featured_event content, edit any group content, edit any news_media content, edit any newsletter content, edit any newsletter_article content, edit any ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit any page content, edit any producer_call content, edit any product content, edit any story content, edit any teacher_telecourse content, edit any telecourse content, edit any testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer access control, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions' WHERE rid = 11 * UPDATE {permission} SET perm = 'create events, edit own events, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, access fckeditor, create forum topics, edit own forum topics, create images, edit images, edit own images, view original images, access imce, add testimonials for others, create featured_event content, create ntn content, create page content, create product content, create story content, create teacher_telecourse content, create telecourse content, edit any featured_event content, edit any newsletter_article content, edit any ntn content, edit own bio content, edit own featured_event content, edit own group content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, access private messages, search content, use watcher' WHERE rid = 17 Update #6040 * Failed: ALTER TABLE {upload} ADD `weight` TINYINT NOT NULL DEFAULT 0 Update #6041 * UPDATE {vocabulary} SET required = 0 WHERE vid = 7 * UPDATE {system} SET weight = 1 WHERE name = 'forum' Update #6042 * No queries Update #6043 * ALTER TABLE {flood} ADD INDEX allow (event, hostname, timestamp) * ALTER TABLE {history} ADD INDEX nid (nid) * ALTER TABLE {blocks} CHANGE `theme` `theme` VARCHAR(64) NOT NULL DEFAULT '', ADD UNIQUE KEY tmd (theme, module, delta), ADD INDEX list (theme, status, region, weight, module) * ALTER TABLE {blocks_roles} ADD INDEX rid (rid) * ALTER TABLE {filters} DROP INDEX weight * ALTER TABLE {filters} ADD UNIQUE KEY fmd (format, module, delta) * ALTER TABLE {filters} ADD INDEX list (format, weight, module, delta) * ALTER TABLE {node} DROP INDEX status * ALTER TABLE {node} DROP KEY nid_vid * ALTER TABLE {users} ADD INDEX mail (mail) * ALTER TABLE {users_roles} ADD INDEX rid (rid) * ALTER TABLE {aggregator_category_feed} DROP PRIMARY KEY * ALTER TABLE {aggregator_category_feed} ADD PRIMARY KEY (cid, fid) * ALTER TABLE {aggregator_category_feed} ADD INDEX fid (fid) * ALTER TABLE {aggregator_category_item} DROP PRIMARY KEY * ALTER TABLE {aggregator_category_item} ADD PRIMARY KEY (cid, iid) * ALTER TABLE {aggregator_category_item} ADD INDEX iid (iid) * ALTER TABLE {contact} ADD INDEX list (weight, category) * ALTER TABLE {poll_votes} DROP INDEX nid * Failed: ALTER TABLE {poll_votes} ADD PRIMARY KEY (nid, uid, hostname) * ALTER TABLE {profile_values} DROP INDEX uid * ALTER TABLE {profile_values} DROP INDEX fid * ALTER TABLE {profile_values} CHANGE `fid` `fid` INT unsigned NOT NULL DEFAULT 0, ADD INDEX fid (fid) * ALTER TABLE {profile_values} CHANGE `uid` `uid` INT unsigned NOT NULL DEFAULT 0 * ALTER TABLE {profile_values} ADD PRIMARY KEY (uid, fid) * ALTER TABLE {term_data} DROP INDEX vid * ALTER TABLE {term_data} ADD INDEX vid_name (vid, name) * ALTER TABLE {term_data} ADD INDEX taxonomy_tree (vid, weight, name) * ALTER TABLE {term_node} DROP PRIMARY KEY * ALTER TABLE {term_node} DROP INDEX tid * ALTER TABLE {term_node} ADD PRIMARY KEY (tid, vid) * ALTER TABLE {term_relation} DROP INDEX tid1 * ALTER TABLE {term_relation} ADD UNIQUE KEY tid1_tid2 (tid1, tid2) * ALTER TABLE {term_synonym} DROP INDEX name * ALTER TABLE {term_synonym} ADD INDEX name_tid (name, tid) * ALTER TABLE {vocabulary} ADD INDEX list (weight, name) * ALTER TABLE {vocabulary_node_types} DROP PRIMARY KEY * ALTER TABLE {vocabulary_node_types} ADD PRIMARY KEY (type, vid) * ALTER TABLE {vocabulary_node_types} ADD INDEX vid (vid) Update #6044 * DELETE FROM {term_node} WHERE vid = 0 Update #6045 * Failed: UPDATE {permission} SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create polls, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, create blog entries, edit own blog entries, create book pages, create new books, edit book pages, edit own book pages, outline posts in books, see printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit custom_page content, edit download content, edit featured_event content, edit group content, edit news_media content, edit newsletter content, edit newsletter_article content, edit ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit producer_call content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer access control, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions' WHERE rid = 11 Update #6046 * No queries Update #6047 * UPDATE {blocks} SET cache = -1 WHERE module = 'user' AND delta IN ('0', '1') * UPDATE {blocks} SET cache = -1 WHERE module = 'system' AND delta = '0' Update #6048 * ALTER TABLE {menu_router} CHANGE `load_functions` `load_functions` TEXT NOT NULL * ALTER TABLE {menu_router} CHANGE `to_arg_functions` `to_arg_functions` TEXT NOT NULL Update #6049 * ALTER TABLE {url_alias} DROP INDEX src * ALTER TABLE {url_alias} ADD INDEX src_language (src, language) Update #6050 * No queries Update #6051 * ALTER TABLE {users} ADD `signature_format` SMALLINT NOT NULL DEFAULT 0 * UPDATE {users} SET signature_format = 1 Update #6052 * Failed: ALTER TABLE {menu_router} ADD INDEX tab_root_weight_title (tab_root(64), weight, title) Update #6053 * ALTER TABLE {system} ADD INDEX type_name (type(12), name) blogapi module Update #6000 * No queries Update #6001 * No queries book module Update #6000 * Failed: UPDATE {permission} SET perm = 'administer actions, access administration menu, display drupal links, access electoral list, add write-ins, administer polls, cancel own vote, create polls, edit own polls, edit polls, inspect all votes, vote on polls, access news feeds, administer news feeds, use PHP for title patterns, administer autologout, create events, edit own events, administer blocks, use PHP for block visibility, edit own blog, create book content, create new books, edit any book content, edit own book content, administer book outlines, access printer-friendly version, administer databases, administer cck field permissions, create Event field_feature_0, create Event field_mindbody, create Event field_training, create NiaFinder Profile field_belt_level, create NiaFinder Profile field_green_belt, create NiaFinder Profile field_trainer, create NiaFinder Profile field_training_levels, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, create Testimonial field_feature, edit Event field_feature_0, edit Event field_mindbody, edit Event field_training, edit NiaFinder Profile field_belt_level, edit NiaFinder Profile field_green_belt, edit NiaFinder Profile field_trainer, edit NiaFinder Profile field_training_levels, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit Testimonial field_feature, edit own Event field_mindbody, edit own Event field_training, edit own NiaFinder Profile field_belt_level, edit own NiaFinder Profile field_trainer, edit own NiaFinder Profile field_training_levels, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, edit own Testimonial field_feature, view Event field_feature_0, view Event field_mindbody, view Event field_training, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, view Testimonial field_feature, clone node, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer templates, create repeat events, access fckeditor, administer fckeditor, allow fckeditor file uploads, view filefield uploads, administer filters, administer flash node, create flash nodes, edit own flash nodes, import flash, administer forums, create forum topics, edit own forum topics, administer google analytics, opt-in or out of tracking, use PHP for tracking visibility, create images, edit images, edit own images, view original images, administer imagecache, flush imagecache, view imagefield uploads, access imce, administer imce, masquerade as user, administer menu, add testimonials for others, edit own training, producer, receive teacher discount, trainer, access content, administer content types, administer nodes, create bio content, create class content, create custom_page content, create download content, create featured_event content, create group content, create news_media content, create newsletter content, create newsletter_article content, create ntn content, create page content, create producer_call content, create product content, create story content, create teacher_telecourse content, create telecourse content, create testimonial content, edit bio content, edit class content, edit custom_page content, edit download content, edit featured_event content, edit group content, edit news_media content, edit newsletter content, edit newsletter_article content, edit ntn content, edit own bio content, edit own class content, edit own custom_page content, edit own download content, edit own featured_event content, edit own group content, edit own news_media content, edit own newsletter content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own producer_call content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, edit own testimonial content, edit page content, edit producer_call content, edit product content, edit story content, edit teacher_telecourse content, edit telecourse content, edit testimonial content, revert revisions, view revisions, administer url aliases, create url aliases, administer pathauto, notify of path changes, access private messages, schedule (un)publishing of nodes, administer search, search content, use advanced search, restrict searches, administer string overrides, access administration pages, administer site configuration, select different theme, administer_tac_lite, administer taxonomy, upload files, view uploaded files, access user profiles, administer access control, administer users, change own username, access all views, administer views, administer voting api, access others' lists of watched posts, administer watcher, use watcher, administer workflow, schedule workflow transitions, add content to books' WHERE rid = 11 * UPDATE {permission} SET perm = 'create events, edit own events, create book content, create new books, edit any book content, edit own book content, administer book outlines, create Teacher TeleCourse field_audio, create Teacher TeleCourse field_code, create Teacher TeleCourse field_phone, edit Teacher TeleCourse field_audio, edit Teacher TeleCourse field_code, edit Teacher TeleCourse field_phone, edit own Teacher TeleCourse field_audio, edit own Teacher TeleCourse field_code, edit own Teacher TeleCourse field_phone, view Teacher TeleCourse field_audio, view Teacher TeleCourse field_code, view Teacher TeleCourse field_phone, access fckeditor, create forum topics, edit own forum topics, create images, edit images, edit own images, view original images, access imce, add testimonials for others, create featured_event content, create ntn content, create page content, create product content, create story content, create teacher_telecourse content, create telecourse content, edit any featured_event content, edit any newsletter_article content, edit any ntn content, edit own bio content, edit own featured_event content, edit own group content, edit own newsletter_article content, edit own ntn content, edit own page content, edit own product content, edit own story content, edit own teacher_telecourse content, edit own telecourse content, access private messages, search content, use watcher, add content to books' WHERE rid = 17 * CREATE TABLE {book_temp} ( `nid` INT unsigned NOT NULL DEFAULT 0, `parent` INT NOT NULL DEFAULT 0, `weight` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (nid), INDEX parent (parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ * INSERT INTO {book_temp} (nid, parent, weight) SELECT b.nid, b.parent, b.weight FROM {book} b INNER JOIN {node} n on b.vid = n.vid * DROP TABLE {book} * CREATE TABLE {book} ( `mlid` INT unsigned NOT NULL DEFAULT 0, `nid` INT unsigned NOT NULL DEFAULT 0, `bid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (mlid), UNIQUE KEY nid (nid), INDEX bid (bid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ * Relocated existing book pages. * DROP TABLE {book_temp} comment module Update #6001 * ALTER TABLE {comments} DROP score * ALTER TABLE {comments} DROP users Update #6002 * Global comment settings copied to all node types. Update #6003 * ALTER TABLE {comments} ADD INDEX pid (pid) forum module Update #6000 * No queries