#2783 [6931] PDOException creating a sitemap (Gedcom name vs. id)

v4.3.0
open
nobody
None
5
2010-02-14
2010-02-14
Frank Warius
No

Hi,

actctual a created sitemap.xml looks like this

<?xml version='1.0' encoding='UTF-8'?>
<?xml-stylesheet type="text/xsl" href="http://pgv.warius.info/modules/sitemap/gss.xsl"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">
<url>
<loc>http://pgv.warius.info/index.php?command=gedcom&amp;ged=Musyal.ged</loc>
<changefreq>monthly</changefreq>
<priority>0.7</priority>
</url>

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'Musyal.ged' for column 'gedcom_id' at row 1' in D:\#Web\pgv\includes\classes\class_pgv_db.php:835
Stack trace:
#0 [internal function]: PDOStatement->execute(Array)
#1 D:\#Web\pgv\includes\classes\class_pgv_db.php(835): call_user_func_array(Array, Array)
#2 [internal function]: PGV_DBStatement->__call('execute', Array)
#3 D:\#Web\pgv\includes\functions\functions_db.php(2794): PGV_DBStatement->execute(Array)
#4 D:\#Web\pgv\includes\functions\functions_export.php(184): set_user_gedcom_setting('38', 'Musyal.ged', 'canedit', 'none')
#5 D:\#Web\pgv\modules\sitemap\index.php(89): createTempUser('#SiteMap#', 'visitor', 'Musyal.ged')
#6 D:\#Web\pgv\module.php(73): require_once('D:\#Web\pgv\mod...')
#7 {main}
thrown in D:\#Web\pgv\includes\classes\class_pgv_db.php on line 835

regards
Frank

Discussion