By uptwobucks on
When trying to enable Google xml sitemap module, I get this error.
user warning: Table 'uptwo2_drpl1.xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/uptwo2/public_html/bankseizedinvestments.com/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
Please advise.
Comments
=-=
this should be filed in the issue queue of the module in question. There are a few who are actively developing the module. You don't mention which version you are using.
Really?
NOT. You have to, or else they wouldn't know which version is it.
Table
please check it.
Question
Does that mean the user does not exist?
=-=
It means it can't find the table in the database for one reason or another.
The question is, is the table really there or did the table not get installed when you enabled the module.
An easier solution
Since I'm not a genius in this field, Would re-installing taxanomy be the easiest way to "maybe" correct this problem?
=-=
no. it has nothing to do with taxonomy tables or the core taxonomy.module, the error is because sitemap is trying to locate a table it thinks it installed when xmlsitemap_taxonomy.mdoule was installed. you can certainly disable it and uninstall it and reenable it though if you choose to.
Would you please tell us what version of xml_sitemap.module you are using? so we can install and check for you?
Sitemap Version
The version of sitemap is 6.x-1.0-beta5
Something you may need to know. When I installed drupal, I later deleted the user "uptwo2" and created a new user. When the error happened I re-created that same user, but it did not fix the error. This deleting of the user uptwo2 was done days before installing the xml sitemap module. Don't know if that had anything to do with creating this error.
=-=
I assume that is being joggled around in your mind because "'uptwo2_drpl1" you see uptwo2 in that error?
if so, I believe that is the name of your database? uptwo2_drpl1 . a user in drupal would be inserted into the user table, not inserted as a table name.
example:
'uptwo2_drpl1.xmlsitemap_taxonomy' xmlsitemap_taxonomy is the name of the table the module should be looking for.
where the uptwo2_ is coming from is really the question I think. That why you were asked to manually look in the database and see if there is actually a table in the database. are there any other tables in there with uptwo2_drpl1 in the title?
Database Name and XML Tables
You are correct. That is the database name: uptwo2_drpl1. There are no other tables in the database with that name.
The tables related to XML are as follows:
xmlsitemap_additional
xmlsitemap_node
xmlsitemap_user
xmlsitemap_user_role
=-=
and no xmlsitemap_taxonomy table. Thus the table the module is for isn't in the database, which is an install problem in some way.
if xmlsitemap_taxonomy is separate part of the xmlsitemap.module in administer -> modules and disable it (or you can disable the entire xmlsitemap module and all its parts.
go to the uninstall tab and see if there is anything left to uninstall from the database (there likey won't be unless you disabled the entire module and all it's parts.)
reenable the module/s you uninstalled.
error still present? if so, something is likely wrong with the .install file and you may want to use the -dev version of the module to see if the issue wasn't already fixed and awaiting a repacking.
Uninstalled
I disabled the four items in the XML sitemap module. Then went to uninstall, and all 4 were still present. I then uninstalled all 4 items. Once uninstalled I received this error:
user warning: Unknown table 'xmlsitemap_taxonomy' query: DROP TABLE xmlsitemap_taxonomy in /home/uptwo2/public_html/bankseizedinvestments.com/includes/database.mysql-common.inc on line 261.
=-=
thats not an error. It's a warning. What it is saying is it couldn't DROP (delete) the xmlsitemap_taxonomy table from the database. which makes total sense because that is the same table you knew was missing in the first place.
Re-install
After re-installing I get the same error:
user warning: Table 'uptwo2_drpl1.xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in /home/uptwo2/public_html/bankseizedinvestments.com/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187
I will un-install it till further notice.
How will I know the errors have been fixed before reinstalling again? Will there be a post of the fix?
=-=
you posted an issue, I'm sure someone will respond to it. When they do, you will know what to do next based on that response.
Thanks for your service.
I thank you so much for your help. You provide a far greater service than most paid support services.
This is a known issue for
This is a known issue for 6.x-1.0-beta5. See #472850: xmlsitemap_taxonomy table not created on install
What to use?
Since there is a bug. What can I use for xml sitemap creation in drupal 6.12. Please advise.
=-=
they released beta 6 today. try it. as i told you in a previous comment in this thread, you could have employed the -dev version of the module to see if it was a bug found that was already fixed.
Tried New Release
I just installed the new XML sitemap release 6.x-1.0-beta6 according to instructions. Uninstalling all previous versions, deleting all xml modules, and making sure no tables existed in the database. After install and ativating the module I received this warning:
user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 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 /home/uptwo2/public_html/bankseizedinvestments.com/modules/xmlsitemap/xmlsitemap.module on line 283.
Please advise if this is an issue or just an adjustment needed. If it is an adjustment, what do I need to change?
=-=
please report issues with specific modules in the issue queues of the modules in question and follow developer/s reccomendations where it concerns their modules.
I Am In Need OF An Alternative Method
I am using drupal, through Hostgator.com. Version 6.10.
I am in the middle of a website and cannot get a working xml sitemap. Is there a way to create a sitemap.xml without having to use the module?
=-=
6.10 is insecure and buggy and you should update your installation ASAP.
I wouldn't know if there are alternative methods, based on the fact that there is a module and that drupal's content isn't file based, I doubt it.
still no solution for this
me just disable this module at the moment