Numerous errors when trying to enable module [#473324]

After trying to enable this module i was hit with the following:



    * user warning: Table 'corydorning.xmlsitemap_additional' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_additional WHERE status = 1 in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.module on line 209.
    * user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
    * user warning: Table 'xmlsitemap_node' already exists query: CREATE TABLE xmlsitemap_node ( `mid` INT NOT NULL auto_increment, `pdata` INT unsigned NOT NULL DEFAULT 0, `sdata` INT unsigned NOT NULL DEFAULT 0, `language` VARCHAR(12) NOT NULL DEFAULT '', `status` INT NOT NULL DEFAULT 1, `previously_changed` INT unsigned NOT NULL DEFAULT 0, `changed` INT unsigned NOT NULL DEFAULT 0, `priority` FLOAT NOT NULL DEFAULT 0.5, `priority_override` FLOAT NOT NULL DEFAULT -2, PRIMARY KEY (mid), UNIQUE KEY link_pdata (pdata), INDEX link_language (language), INDEX link_status (status), INDEX link_changed (changed), INDEX link_priority (priority) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/coryroc/public_html/drupal6/includes/database.inc on line 515.
    * user warning: Table 'corydorning.xmlsitemap_additional' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_additional WHERE status = 1 in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.module on line 209.
    * user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
    * user warning: Table 'corydorning.xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
    * user warning: Table 'corydorning.xmlsitemap_additional' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_additional WHERE status = 1 in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.module on line 209.
    * user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
    * user warning: Table 'corydorning.xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.

Any help or ideas as to what is wrong?

Comment	File	Size	Author
#3	Sitemap_error.pdf	218.05 KB	usa2k

Comments

Comment #1

corydorning commented 26 May 2009 at 15:50

Also, when running update.php I get this:



    * user warning: Table 'corydorning.xmlsitemap_additional' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_additional WHERE status = 1 in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.module on line 209.
    * user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
    * user warning: Table 'corydorning.xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/coryroc/public_html/drupal6/update.php on line 174.
    * user warning: Table 'corydorning.xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/coryroc/public_html/drupal6/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
    * warning: Invalid argument supplied for foreach() in /home/coryroc/public_html/drupal6/update.php on line 338.

Comment #2

Stone_Golem130 commented 27 May 2009 at 23:29

I`m having the same issues when I have the XML sitemap taxonomy module enabled.

Status	File	Size
new	Sitemap_error.pdf	218.05 KB

Comment #4

Guide-1 commented 28 May 2009 at 12:06

I've tried each version which was created for drupal 6 and only xmlsitemap-6.x-0.x-dev did't show any error during installation and usage... can you release any stable version?

Comment #5

Anonymous (not verified) commented 29 May 2009 at 04:48

Assigned:

Unassigned

Once I can get back to looking at the code (a dire family emergency is preventing me from spending time here) I will look at what needs to be done to correct the recent bout of ills against version 6.x-1.0-betaX. Please try out 6.x-1.0-beta0 which is a tag that I set for a base of code prior to Kiam's changes beginning with BETA2.

Comment #6

miche

NH, USA

commented 29 May 2009 at 20:19

+1 I was having similar issues with tables not being created on install.

Comment #7

paku commented 31 May 2009 at 21:59

Same,

Multisite, multilanguage

After enabling

* user warning: Table 'l10n_4x4_org_pl_xmlsitemap_node' already exists query: CREATE TABLE l10n_4x4_org_pl_xmlsitemap_node ( `mid` INT NOT NULL auto_increment, `pdata` INT unsigned NOT NULL DEFAULT 0, `sdata` INT unsigned NOT NULL DEFAULT 0, `language` VARCHAR(12) NOT NULL DEFAULT '', `status` INT NOT NULL DEFAULT 1, `previously_changed` INT unsigned NOT NULL DEFAULT 0, `changed` INT unsigned NOT NULL DEFAULT 0, `priority` FLOAT NOT NULL DEFAULT 0.5, `priority_override` FLOAT NOT NULL DEFAULT -2, PRIMARY KEY (mid), UNIQUE KEY link_pdata (pdata), INDEX link_language (language), INDEX link_status (status), INDEX link_changed (changed), INDEX link_priority (priority) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /site/includes/database.inc on line 515.
* user warning: Table '4x5.l10n_4x4_org_pl_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM l10n_4x4_org_pl_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /site/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
* user warning: Table '4x5.l10n_4x4_org_pl_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM l10n_4x4_org_pl_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /site/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
* user warning: Table '4x5.l10n_4x4_org_pl_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM l10n_4x4_org_pl_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /site/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
* user warning: Table '4x5.l10n_4x4_org_pl_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM l10n_4x4_org_pl_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /site/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
* user warning: Table '4x5.l10n_4x4_org_pl_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM l10n_4x4_org_pl_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /site/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.

At the end of the update script:

user warning: Table '4x5.l10n_4x4_org_pl_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM l10n_4x4_org_pl_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /site/sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.

Comment #8

Anonymous (not verified) commented 9 June 2009 at 21:02

Status:

Active

» Fixed

We've reset the code via #483844: Restore code to beta0. There is not an intra development upgrade path available. You must follow the instructions per #379854-128: The site map is not being populated.

Comment #9

23 June 2009 at 21:10

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Numerous errors when trying to enable module

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

News items

Our community

Documentation

Drupal code base

Governance of community