ah ah !
repaired!
maybe it was not working with 2.7... there was 3 bugs... here they are :
1- the query was misconstructed
it added a "wb_" on a record when it shouldn't : "visibility = "public" AND '. TABLE_PREFIX.'mod_news_posts.
'.TABLE_PREFIX.'page_id='.TABLE_PREFIX.'pages.page_id"
2- as soon as i removed that, a second bug come to view...
line 84 "$properties['dc:date']=date("Y-M-d, H:i",$item["modified_when"]);"
was telling no index "modified_when"...
found out that on my version, "modified_when" is indeed "posted_when" so i'bve changed it
3- but the code still called for a non-existant index on that line, so i've found that this was not called in the query, so i've added ", '.TABLE_PREFIX.'mod_news_posts.post
ed_when" at the end of the select... TADA ... working.
here the query needed :
$query = 'SELECT '.TABLE_PREFIX.'mod_news_posts.link, '.TABLE_PREFIX.'mod_news_posts.title, '.TABLE_PREFIX.'mod_news_posts.content_short, '.TABLE_PREFIX.'mod_news_posts.posted_when FROM '.TABLE_PREFIX.'mod_news_posts, '.TABLE_PREFIX.'pages WHERE active=1 AND visibility = "public" AND '. TABLE_PREFIX.'mod_news_posts.page_id='.TABLE_PREFIX.'pages.page_id AND '.TABLE_PREFIX.'pages.page_id='."$newsPage".' ORDER BY '.TABLE_PREFIX.'mod_news_posts.post_id DESC LIMIT 0 , 10';
and the line 84 "$properties['dc:date']=date("Y-M-d, H:i",$item["modified_when"]);" need to be changed to :
$properties['dc:date']=date("Y-M-d, H:i",$item["posted_when"]);
thank you for your help, i've wouldn't have checked the code without your help
WebsiteBaker Community Forum
