Jump to:
| Project: | XML sitemap |
| Version: | 6.x-1.0-rc1 |
| Component: | xmlsitemap.module |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
Testing this module...
I installed the program and something went wrong. So I am trying again.
-Deactivated the modules XML sitemap, ML sitemap engines, XML sitemap node, and XML sitemap taxonomy.
-Uninstalled all the modules
-I look in phpmyadmin just to be sure... no xml* tables... but there is a gsitemap table. Let's delete that just to be sure.
-Install the modules XML sitemap, ML sitemap engines, XML sitemap node, and XML sitemap taxonomy.
-Go to the settings page, put the "Front page change frequency" daily, and add the ask.com search engine and the "Submit the sitemap when content changes" checkbox daily.
-I launch the cron.php
-The http://www.salsamontreal.com/sitemap.xml file seems to be empty.
-Looking in the logs I get this:
"Table 'aracine_smv6.xmlsitemap' doesn't exist query: SELECT xsm.loc, xsm.module, xsm.type, xsm.id, xsm.sid, xsm.changed, xsm.changefreq, xsm.priority 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) ORDER BY xsm.priority DESC, xsm.changed DESC, xsm.changefreq, xsm.loc LIMIT 0, 1000 dans /home/aracine/public_html/sites/all/modules/xmlsitemap/xmlsitemap.pages.inc à la ligne 178."
-I'll play around and see if I can find something...
-I even did this procedure again, but with the addition of deleting the xmlsitemap module folder after the uninstall and uploading the files again. Same result.
Here is another exemple of log error:
"Table 'aracine_smv6.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) dans /home/aracine/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module à la ligne 283."
Comments
#1
I guess that my current question should be : "When does the xmlsitemap table is suppose to be created?"
#2
Database tables are supposed to be created when the module is first enabled, as for the other modules.
I find a little strange that you see a table named gsitemap, because that was the name used a lot of versions ago (maybe it was used from the module XML sitemap comes from).
#3
I do agree for that, but it does not work. There are no table created just by activating the module.
Correct, it was for the 4.7 version named gsitemap for google site map. It's gone now :)
#4
If the database table is not created when you first enable the module, then something wrong happened.
Did you try the 6.x-2 branch, by any chances?
Actually, you opened two different reports, and reported two different errors that have in common the fact the database table is not created; it would be better to keep a single report.
#5
Do you perhaps happen to have more than one version of xmlsitemap in your sites directory somewhere?
Look at the system table WHERE `name` LIKE 'xmlsitemap%'. Does the path given match what you think?
If you do a fresh install then the table should be created. If not, you should check the watchdog table, the mysql server logs and the php server logs.
#6
@KiamLaLuno : I don't think I used the 6.x-2 branch yet. I have closed the other issue and I'll put efforts in here.
@earnie
After uninstalling the module, I get this.
SELECT *
FROM `system`
WHERE `name` LIKE 'xmlsitemap%'
LIMIT 0 , 30
sites/all/modules/xmlsitemap/xmlsitemap_engines/xmlsitemap_engines.module xmlsitemap_engines module 0 0 0 15 -1
sites/all/modules/xmlsitemap/xmlsitemap.module xmlsitemap module 0 0 0 5 -1
sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module xmlsitemap_node module 0 0 0 5 -1
sites/all/modules/xmlsitemap/xmlsitemap_user/xmlsitemap_user.module xmlsitemap_user module 0 0 0 0 -1
sites/all/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module xmlsitemap_taxonomy module 0 0 0 10 -1
Does this make any sence?
-1 means that the module is uncheck if I remember correctly.
#7
-1 is for the schema version, which (in the specific case) means Drupal is saying that it didn't execute any update function of those modules; as you uninstalled them, that is perfectly normal.
One of those zeroes means the modules are not enabled (differently, there would be a one).
#8
Well, at that point, it was just after uninstalling them, so it is okay to say that they are not enabled.
I could delete those five line, that would not affect anything I guess? After that, monitor that query and the xml* tables, while doing a normal installation of the single xmlsitemap.module module. Would that be a good test?
Thanks.
#9
Did you mean something went wrong in the install? I would suggest you uninstall, check to see that everything xmlsitemap is removed (remove them manually if not) and then install again. I suggest you remove the rows in the system table as well WHERE `name` LIKE 'xmlsitemap%'. Then enable each module independently so that we can capture at what point things are wrong.
#10
Follow up,
Steps and feedback...
-Uninstall module
-Remove files in sites\modules\etc...
=There are no xmlsitemap* tables...
=xmlsitemap is in the system table when doing " SELECT * FROM `system`WHERE `name` LIKE 'xmlsitemap%' LIMIT 0 , 30 "
-Delete the results of the query
-Copy the files back
-Go on the modules admin page...
-Looking back at the system table query, gives me the list of the 5 modules and there are no xmlsitemap* tables yet, so everything seems normal
-I enable the XML sitemap module only
-Looking at my tables, there is no xmlsitemap* tables... not normal.
-Looking at the system query this is the result for the XML sitemap module (all others are not enabled and at -1)
This is the full output...
sites/all/modules/xmlsitemap/xmlsitemap.module xmlsitemap module 1 0 0 5 6150 a:10:{s:4:"name";s:11:"XML sitemap";s:11:"description";s:63:"Create a XML sitemap conforming to sitemaps.org specifications.";s:7:"package";s:11:"XML sitemap";s:4:"core";s:3:"6.x";s:7:"version";s:11:"6.x-1.0-rc1";s:7:"project";s:10:"xmlsitemap";s:9:"datestamp";s:10:"1246545521";s:12:"dependencies";a:0:{}s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}
Looking at the drupal logs, I have this!
-- First interesting entry --
Emplacement http://www.salsamontreal.com/admin/build/modules/list/confirm
Référent http://www.salsamontreal.com/admin/build/modules
Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, PRIMARY KEY (lid), INDEX link_module (module(25)), INDEX link_language (la' at line 11 query: CREATE TABLE xmlsitemap ( `lid` INT NOT NULL auto_increment, `loc` VARCHAR(255) NOT NULL DEFAULT '', `module` VARCHAR(255) NOT NULL DEFAULT '', `type` VARCHAR(32) NOT NULL DEFAULT '', `id` INT unsigned NOT NULL DEFAULT 0, `sid` INT unsigned NOT NULL DEFAULT 0, `language` VARCHAR(12) NOT NULL DEFAULT '', `changed` INT unsigned NOT NULL DEFAULT 0, `changefreq` INT unsigned NOT NULL DEFAULT 0, `priority` FLOAT NOT NULL DEFAULT 0,5, PRIMARY KEY (lid), INDEX link_module (module(25)), INDEX link_language (language), INDEX link_changed (changed), INDEX link_priority (priority) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ dans /home/aracine/public_html/includes/database.inc à la ligne 515.
Importance erreur
-- FIN --
-- Second interesting entry --
Emplacement http://www.salsamontreal.com/admin/build/modules
Référent http://www.salsamontreal.com/admin/build/modules
Message Table 'aracine_smv6.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) dans /home/aracine/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module à la ligne 283.
-- FIN --
This is weird, I do have a correct MySQL version according do Drupal on the status report...
Base de données MySQL 5.0.77
Librairie GD bundled (2.0.34 compatible)
Librairie Unicode Extension PHP mbstring
MySQL database for event module 5.0.77
PHP 5.2.9
PHP 'register globals' Désactivé
This is a way better report, I hope this can help a bit more. I can do more tests if you want. Thanks.
#11
Thanks to the information provided in #10, this is a duplicate of #512660: Problem with 0.5