Dobry den,
castokrat se setkavam pri updatech s nize uvedenymi hlaskami.
Vypada, ze tyto hlasky asi nezmenim. Je nejaky zpusob, jak je omezit nebo snizit cistenim databaze nebo podobnymi zpusobem?
Drupal database update
• user warning: Table 'web:adresar.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /web_adresar/www/sites/all/modules/date/date/date_api.module on line 1925.
• user warning: Unknown column 'xsm.changed' in 'where clause' query: SELECT COUNT(xsm.loc) FROM xmlsitemap xsm INNER JOIN system s ON s.name = xsm.module WHERE s.type = 'module' AND s.status = 1 AND xsm.changefreq <> 0 AND xsm.changed <> 0 AND (xsm.priority >= 0 AND xsm.priority <= 1) in /web_adresar/www/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap/xmlsitemap.module on line 620.
• user warning: Table 'skprovo61.date_format_types' doesn't exist query: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title in /web_adresar/www/sites/all/modules/date/date/date_api.module on line 1925.
• user warning: Unknown column 'xsm.changed' in 'where clause' query: SELECT COUNT(xsm.loc) FROM xmlsitemap xsm INNER JOIN system s ON s.name = xsm.module WHERE s.type = 'module' AND s.status = 1 AND xsm.changefreq <> 0 AND xsm.changed <> 0 AND (xsm.priority >= 0 AND xsm.priority <= 1) in /web_adresar/www/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap/xmlsitemap.module on line 620.
• Some updates are still pending. Please return to update.php and run the remaining updates.
• user warning: Unknown column 'xsm.changed' in 'where clause' query: SELECT COUNT(xsm.loc) FROM xmlsitemap xsm INNER JOIN system s ON s.name = xsm.module WHERE s.type = 'module' AND s.status = 1 AND xsm.changefreq <> 0 AND xsm.changed <> 0 AND (xsm.priority >= 0 AND xsm.priority <= 1) in /web_adresar/www/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap/xmlsitemap.module on line 620.
• warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ftpsite/skprovo.com/www/update.php on line 174.
• warning: Invalid argument supplied for foreach() in /web_adresar/www/update.php on line 339.
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.
• Main page
• Administration pages
The following queries were executed
xmlsitemap_menu module
Update #6105
• No queries
Update #6106
• UPDATE {system} SET weight = 10 WHERE name = 'xmlsitemap_menu'
Update #6107
• FORCE SITEMAP UPDATE
xmlsitemap_user module
Update #6110
• No queries
Update #6111
• No queries
Update #6112
• ALTER TABLE {xmlsitemap_user} DROP PRIMARY KEY
• ALTER TABLE {xmlsitemap_user} CHANGE uid `uid` INT unsigned NOT NULL DEFAULT 0, ADD PRIMARY KEY (uid)
• ALTER TABLE {xmlsitemap_user} CHANGE changed `changed` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {xmlsitemap_user} ADD `comments` INT unsigned NOT NULL DEFAULT 0
• UPDATE {xmlsitemap_user} SET priority_override = -2.0 WHERE priority_override IS NULL
• ALTER TABLE {xmlsitemap_user} CHANGE priority_override `priority_override` FLOAT NOT NULL DEFAULT -2
• ALTER TABLE {xmlsitemap_user_role} DROP PRIMARY KEY
• ALTER TABLE {xmlsitemap_user_role} CHANGE rid `rid` INT unsigned NOT NULL DEFAULT 0, ADD PRIMARY KEY (rid)
• UPDATE {xmlsitemap_user_role} SET priority = 0.5 WHERE priority IS NULL
• ALTER TABLE {xmlsitemap_user_role} CHANGE priority `priority` FLOAT NOT NULL DEFAULT 0.5
• ALTER TABLE {xmlsitemap_user_role} CHANGE priority `priority` FLOAT NOT NULL DEFAULT 0.5
• UPDATE {system} SET weight = 10 WHERE name = 'xmlsitemap_user'
• UPDATE {xmlsitemap_user} TABLE
• FORCE SITEMAP UPDATE
xmlsitemap_file module
Update #6111
• DROP TABLE {xmlsitemap_file}
• UPDATE {system} SET weight = 10 WHERE name = 'xmlsitemap_file'
Update #6112
• DELETE FROM {xmlsitemap} WHERE module = 'xmlsitemap_file'
date module
Update #6005
• Failed: Some updates are still pending.
Please re-run the update script.
date_api module
Update #6002
• CREATE TABLE {date_format_types} ( `type` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NOT NULL, `locked` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (type) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
• CREATE TABLE {date_format} ( `dfid` INT unsigned NOT NULL auto_increment, `format` VARCHAR(255) NOT NULL, `type` VARCHAR(255) NOT NULL, `locked` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (dfid), UNIQUE KEY format (format) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
• CREATE TABLE {date_format_locale} ( `format` VARCHAR(255) NOT NULL, `type` VARCHAR(255) NOT NULL, `language` VARCHAR(12) NOT NULL, PRIMARY KEY (type, language) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
xmlsitemap_node module
Update #6109
• No queries
Update #6110
• No queries
Update #6111
• No queries
Update #6112
• ALTER TABLE {xmlsitemap_node} DROP PRIMARY KEY
• ALTER TABLE {xmlsitemap_node} CHANGE nid `nid` INT unsigned NOT NULL DEFAULT 0, ADD PRIMARY KEY (nid)
• ALTER TABLE {xmlsitemap_node} CHANGE changed `changed` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {xmlsitemap_node} CHANGE comment_ratio `comment_ratio` FLOAT NOT NULL DEFAULT 0
• UPDATE {xmlsitemap_node} SET priority_override = -2.0 WHERE priority_override IS NULL
• ALTER TABLE {xmlsitemap_node} CHANGE priority_override `priority_override` FLOAT NOT NULL DEFAULT -2
Update #6113
• No queries
Update #6114
• No queries
Update #6115
• No queries
Update #6116
• UPDATE {xmlsitemap_node} TABLE
• FORCE SITEMAP UPDATE
xmlsitemap_term module
Update #6106
• UPDATE {system} SET weight = 10 WHERE name = 'xmlsitemap_term'
Update #6107
• ALTER TABLE {xmlsitemap_term} DROP PRIMARY KEY
• ALTER TABLE {xmlsitemap_term} CHANGE tid `tid` INT unsigned NOT NULL DEFAULT 0, ADD PRIMARY KEY (tid)
• ALTER TABLE {xmlsitemap_term} ADD `vid` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {xmlsitemap_term} CHANGE changed `changed` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {xmlsitemap_term} CHANGE previously_changed `previously_changed` INT unsigned NOT NULL DEFAULT 0
• UPDATE {xmlsitemap_term} SET priority_override = -2.0 WHERE priority_override IS NULL
• ALTER TABLE {xmlsitemap_term} CHANGE priority_override `priority_override` FLOAT NOT NULL DEFAULT -2
Update #6108
• No queries
Update #6109
• No queries
Update #6110
• UPDATE {xmlsitemap_term} TABLE
• FORCE SITEMAP UPDATE
xmlsitemap module
Update #6119
• No queries
Update #6120
• No queries
Update #6121
• No queries
Update #6122
• No queries
Update #6123
• No queries
Update #6124
• No queries
Update #6125
• No queries
Update #6126
• DELETE FROM {xmlsitemap}
Update #6127
• No queries
Update #6128
• No queries
Update #6129
• No queries
Update #6130
• No queries
Update #6131
• No queries
Update #6132
• ALTER TABLE {xmlsitemap} DROP PRIMARY KEY
• ALTER TABLE {xmlsitemap} DROP INDEX link_changed
• ALTER TABLE {xmlsitemap} DROP INDEX link_priority
• ALTER TABLE {xmlsitemap} ADD `lid` INT auto_increment DEFAULT NULL, ADD PRIMARY KEY (lid)
• ALTER TABLE {xmlsitemap} CHANGE lid `lid` INT NOT NULL auto_increment
• ALTER TABLE {xmlsitemap} CHANGE loc `loc` VARCHAR(255) NOT NULL DEFAULT ''
• ALTER TABLE {xmlsitemap} CHANGE module `module` VARCHAR(255) NOT NULL DEFAULT '', ADD INDEX link_module (module(25))
• ALTER TABLE {xmlsitemap} CHANGE type `type` VARCHAR(32) NOT NULL DEFAULT '', ADD INDEX link_type (type(10))
• ALTER TABLE {xmlsitemap} ADD `language` VARCHAR(12) NOT NULL DEFAULT '', ADD INDEX link_language (language)
• ALTER TABLE {xmlsitemap} CHANGE lastmod `changed` INT unsigned NOT NULL DEFAULT 0, ADD INDEX link_changed (changed)
• ALTER TABLE {xmlsitemap} CHANGE changefreq `changefreq` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {xmlsitemap} CHANGE priority `priority` FLOAT NOT NULL DEFAULT 0.5, ADD INDEX link_priority (priority)
• ENABLE 'xmlsitemap_helper' MODULE
• FORCE SITEMAP UPDATE
Vubec mne nenapadlo, ze by se to takto dalo. Parada, pomohlo to. Diky.
Tak podle všeho Vás tam zlobí modul XML Sitemap, který má problém s aktualizací své struktury. Výsledkem může být zabrždění ostatních aktualizací. Nevím, jakou používáte verzi, já bych zkusil modul vypnout, odinstalovat a nahodit znova nejnovější verzi.