Just upgraded to the new 2.x dev from an older 2.x dev and receiving this--

User warning: 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 'type for db_type_placeholder AND id = unsupported type for db_type_placeholder' at line 1 query: SELECT * FROM xmlsitemap WHERE type = unsupported type for db_type_placeholder AND id = unsupported type for db_type_placeholder in _db_query() (line 141 of /var/www/............/includes/database.mysqli.inc).

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Did you run update.php?

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Postponed (maintainer needs more info)
WhenInRome’s picture

WhenInRome commented

update.php was run. yes.

bkonia’s picture

bkonia commented

Getting a similar error here. This is happening after a fresh install of the module and it's basically unusable. I believe this may be related to the fact that I'm running PHP 5.3.3. I did some debugging and the actual query being sent to MySQL on line 343 is:

SELECT * FROM {xmlsitemap_sitemap} WHERE smid IN (unsupported type for db_type_placeholder) - Array

Obviously, this is an invalid query.