Posted by rjjansen on September 4, 2009 at 6:43pm
Jump to:
| Project: | XML sitemap |
| Version: | 6.x-1.1 |
| Component: | xmlsitemap.module |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
user warning: Table 'site_dbname.xmlsitemap' doesn't exist 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/site/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 283.
Drupal 6.13
Clean install
enable modules
update.php
Error can be reproduced
Comments
#1
Did you upgrade from a previous version before 6.x-1.1? Did you follow the instructions in the release notes or INSTALL.txt?
#2
Fresh install (no upgrade)
install.txt instructions completed.
Problem occurs after enabling first module of group XML sitemap: "XML sitemap"
#3
Hmm... that's odd. If it was truly a clean install, the database tables should have been installed. Maybe you had a version of the module installed at some point but had it disabled/deleted but didn't do the uninstall via admin/build/modules/uninstall? I'd recommend doing an uninstall and another install. If the error comes back again, let us know.
#4
Did you enable more than one module together (i.e., xmlsitemap.module and xmlsitemap_node.module)?
#5
Did the uninstall (disable modules, delete files)
Re installed everything again
Result same error
Did it several times
Option a: Enable all modules at one go
Option b: Enable just the first module XML sitemap
Result is the same error
#6
Enabled with two different installs:
a. Alle modules (first time it went wrong)
b. Just the first module XML sitemap
Same result in errors
#7
To uninstall a module means to
Disabling a module, and then deleting the files doesn't invoke the uninstall function; that means Drupal will keep the data about the last update executed, and it will not invoke the install function when you copy back the files in the server (which means the database tables will not be created, if they weren't created before for any reasons).
#8
#9
Same result with the full uninstall procedure and the installing it again.
Seems to be a bug that is bugging us.
#10
Could you please list all the other modules you have enabled?
#11
Hi Dave,
A lot of modules are installed / enabled, can I e-mail you?
Also possible is a remote shared screen support session to speed up the process.
I'm using www.fastsupport.com
Let me know how you want to proceed.
/Ronald
#12
FYI we had this same problem in #509764: Trying to help for bug search... sitemap.xml not populating. You might be using Gallery2 or a custom module that improperly calls PHP's setlocale() function, which could wrongly convert floats like '0.5' to '0,5'. Since we use a default value of '0.5' for a field in the xmlsitemap schema, the table install fails becuase '0,5' is not a number.
#13
Yes I'm using Gallery2 and system is installed in English and Dutch.
Dutch notation uses "," for "." in normal text.
Problem stay's even if Gallery2 is de-installed and xmlsitemap is installed again.
#14
I have the same problem and made some experiments.
1.
- Drupal 6.13 clean installed
- hungarian language module installed
- XML Sitemap installed
- enabled XML sitemap module
- settings saved, NO ERROR
- enabled XML sitemap engines module
- settings saved, NO ERROR
2.
- Drupal 6.13 clean installed
- hungarian language module installed
- Gallery2 installed
- enabled Gallery2 modules
- XML Sitemap installed
- enabled XML sitemap module
- settings saved, SQL SYNTAX ERROR: unfortunately I couldn't catch it precisely but the essence was that there is and error in CREATE TABLE statement near line 5
- enabled other XML sitemap module
- settings saved, ERROR: xmlsitemap table doesn't exist, however, other three xmlsitemap.xxx tables are created.
3.
- Drupal 6.13 clean installed
- hungarian language module installed
- XML Sitemap installed
- enabled XML sitemap module
- settings saved, NO ERROR
- enabled XML sitemap engines module
- settings saved, NO ERROR
- Gallery2 installed
- enabled Gallery2 modules, NO ERROR
The environment:
openSUSE 11.1 x86_64
- Apache 2.2.10
- MySQL 5.0.67
- PHP 5.2.9
So it seems the order of the installation is important. XML Sitemap cannot be installed after Gallery2. Despite the fact it can be workarounded (or worked around, native English speakers, help!) it is still a bug, The only question is whether it is a bug of XML Sitemap or of Gallery2.
Rgrds: M. Gy.
#15
I don't have time to look at the moment but IIRC this is related to a comma in a numeric default value when changing locales that use commas instead of periods.
#16
Since this is an install issue only could we patch the install file to ensure the environment is correct?
#17
The problem is what exactly I said in #12. It's Gallery's fault and will cause this same exact problem with any other module that tries to install a table that has a default float value for a column. There is nothing the XML sitemap module can do.
Please read the past issues:
#512660: Problem with 0.5
#509764: Trying to help for bug search... sitemap.xml not populating
#290538: SQL error: operand should contain 1 column(s)
#193214: %f is locale dependent in db_query
http://www.google.com/search?hl=en&safe=off&q=+site:drupal.org+drupal+se...
Gallery.module issue: #389452: setlocale() calls in Gallery wrongly transform float numbers in SQL