hello

i switch from 6.x-1.x-dev to 6.x-2.x-dev.. i deinstall the 6.x-1.x-dev and install 2.x-dev

now i become errors like this

* user warning: Table x.menu_links' doesn't exist query: SELECT COUNT(mlid) FROM menu_links WHERE menu_name = 'primary-links' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.menu_links' doesn't exist query: SELECT COUNT(mlid) FROM menu_links WHERE menu_name = 'navigation' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.menu_links' doesn't exist query: SELECT COUNT(mlid) FROM menu_links WHERE menu_name = 'secondary-links' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.node' doesn't exist query: 'story' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.node' doesn't exist query: SELECT COUNT(nid) FROM node WHERE type = 'blog' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.node' doesn't exist query: SELECT COUNT(nid) FROM node WHERE type = 'book' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.node' doesn't exist query: SELECT COUNT(nid) FROM node WHERE type = 'galerie_foto' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.node' doesn't exist query: SELECT COUNT(nid) FROM node WHERE type = 'geschichte' in /x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
* user warning: Table 'x.node' doesn't exist query: SELECT COUNT(nid) FROM node WHERE type = 'landing_pages' in x/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1105.
and more

i include mutch of my content types

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Postponed (maintainer needs more info)

I don't see what is going wrong here. The SQL that is printed out is obviously not trying to access the x.tablename tables otherwise it would have printed it. Does your database have the node and menu_links tables in it? Do you have prefixes enabled for some of these tables in your site's settings.php?

eule’s picture

eule commented

Hi David

yep i setup in the settings.php my db prefix

---settings.php

* Database URL format:
* $db_url = 'mysql://username:password@localhost/databasename';
* $db_url = 'mysqli://username:password@localhost/databasename';
* $db_url = 'pgsql://username:password@localhost/databasename';
*/
$db_url = 'mysql://user:pass@localhost/databasename';
$db_prefix = 'DBprefix_';

/**
* Access control for update.php script

------settings.php

i just wondering me now why the xmlsitemap module is going databasename but not DBprefix_

user warning: Table 'nameof_DB.node' doesn't exist query: SELECT COUNT(nid) FROM node WHERE type = 'news' in /srv/www/vhosts/vwspeed.eu/httpdocs/sites/all/modules/xmlsitemap/xmlsitemap.module on line 1113.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Are you copying the exact error messages? Because it doesn't make sense for it to be saying that "x.node' doesn't exist" but the queries does not even contain "x.node": SELECT COUNT(nid) FROM node WHERE type = 'blog'.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Aha! I see what's going on. I'll have it fixed shortly.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Postponed (maintainer needs more info) » Fixed

Fixed in CVS with:
http://drupal.org/cvs?commit=323938

eule’s picture

eule commented

hi david ..

i am drunk and dont know at the moment what u see ;)

Status: Fixed » Closed (fixed)

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