Sitemap has been working well for me for quite a while, but one feature that has never worked is the complete rebuild. The sitemap.xml gets built with each cron, but the standard drupal 7 error reports page requests that I do a complete rebuild. Each time I request a rebuild I get the progress bar, then within a second or two the following error...

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=165&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'lastmod' at row 1: INSERT INTO {xmlsitemap} (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12); Array ( [:db_insert_placeholder_0] => 182 [:db_insert_placeholder_1] => node [:db_insert_placeholder_2] => article [:db_insert_placeholder_3] => node/182 [:db_insert_placeholder_4] => und [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => -3600 [:db_insert_placeholder_9] => 0.5 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11]

Anyone else experiencing the same problem?

Comments

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Postponed (maintainer needs more info)

What version of PHP are you using?

Why is your lastmod timestamp equal to -3600?

sunnyara’s picture

sunnyara commented

I have got almost the same kind of error when I try to regenerate the files:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=1224&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYi8DWrH' (Errcode: 28): SELECT x.loc AS loc, x.lastmod AS lastmod, x.changefreq AS changefreq, x.changecount AS changecount, x.priority AS priority, x.language AS language, x.access AS access, x.status AS status FROM {xmlsitemap} x WHERE (x.access = :db_condition_placeholder_0) AND (x.status = :db_condition_placeholder_1) ORDER BY x.language DESC, x.loc ASC LIMIT 50000 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 ) in xmlsitemap_generate_chunk() (line 164 of /home/bporg/public_html/sites/all/modules/xmlsitemap/xmlsitemap.generate.inc).

I tried with drush too, it fails too with the same error:

WD xmlsitemap: PDOException: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYl7cksR' (Errcode: 28): SELECT x.loc AS loc, [error]
x.lastmod AS lastmod, x.changefreq AS changefreq, x.changecount AS changecount, x.priority AS priority, x.language AS language,
x.access AS access, x.status AS status
FROM
{xmlsitemap} x
WHERE (x.access = :db_condition_placeholder_0) AND (x.status = :db_condition_placeholder_1)
ORDER BY x.language DESC, x.loc ASC
LIMIT 50000 OFFSET 0; Array
(
[:db_condition_placeholder_0] => 1
[:db_condition_placeholder_1] => 1
)
in xmlsitemap_generate_chunk() (line 164 of /home/bporg/public_html/sites/all/modules/xmlsitemap/xmlsitemap.generate.inc).
WD php: PDOException: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYl7cksR' (Errcode: 28): SELECT x.loc AS loc, [error]
x.lastmod AS lastmod, x.changefreq AS changefreq, x.changecount AS changecount, x.priority AS priority, x.language AS language,
x.access AS access, x.status AS status
FROM
{xmlsitemap} x
WHERE (x.access = :db_condition_placeholder_0) AND (x.status = :db_condition_placeholder_1)
ORDER BY x.language DESC, x.loc ASC
LIMIT 50000 OFFSET 0; Array
(
[:db_condition_placeholder_0] => 1
[:db_condition_placeholder_1] => 1
)
in xmlsitemap_generate_chunk() (line 164 of /home/bporg/public_html/sites/all/modules/xmlsitemap/xmlsitemap.generate.inc).
PDOException: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYl7cksR' (Errcode: 28): SELECT x.loc AS loc, x.lastmod AS last mod, x.changefreq AS changefreq, x.changecount AS changecount, x.priority AS priority, x.language AS language, x.access AS access, x.status AS sta tus
FROM
{xmlsitemap} x
WHERE (x.access = :db_condition_placeholder_0) AND (x.status = :db_condition_placeholder_1)
ORDER BY x.language DESC, x.loc ASC
LIMIT 50000 OFFSET 0; Array
(
[:db_condition_placeholder_0] => 1
[:db_condition_placeholder_1] => 1
)
in xmlsitemap_generate_chunk() (line 164 of /home/bporg/public_html/sites/all/modules/xmlsitemap/xmlsitemap.generate.inc).
Drush command terminated abnormally due to an unrecoverable error.

Anonymous’s picture

Anonymous (not verified) commented

@sunnyara: Your error is not at all the same error. You'll need to determine why your DB engine cannot write to the file it is creating for the query.

sunnyara’s picture

sunnyara commented

You were right. I have less space in /tmp. After I cleaned the space in /tmp that worked. But you know, still the drupal tmp location setting is not taken by this module. I had some other location other than /tmp set in Drupal.

Anyway I got this fixed by cleaning up /tmp. Thanks

Anonymous’s picture

Anonymous (not verified) commented

Your database doesn't read the variable table data to know that. Your database engine is only related to Drupal in that you have told Drupal about the database. You have not told your database about Drupal, it is an entity unto itself. You have to configure your database engine to use a different directory if that is what you wish to do.