hello, just playing around with the news box, (read that you haven't look at it for a decate) and found what actually caused the problem. it's the name of a table which has changed. so I corrected the table name to reflect the db
from this
PHP Code:
$last_date = $db->Execute("SELECT MAX(GREATEST(news_added_date, IFNULL(news_modified_date, '0001-01-01 00:00:00'), [COLOR="#FF0000"]news_published_date[/COLOR])) AS last_date
to this
PHP Code:
$last_date = $db->Execute("SELECT MAX(GREATEST(n.news_added_date, IFNULL(n.news_modified_date, '0001-01-01 00:00:00'), [COLOR="#FF0000"]n.news_start_date[/COLOR])) AS last_date
now it does not longer throw an error, but no data is written to the xml file
the result is
XML Parsing Error: no root element found
Location: https://xxxxxxxxxxxx/sitemap/sitemapboxnews.xml
Line Number 1, Column 1:
any idea where to look now?
thanks for reading.
Bookmarks