Page 1 of 1

[solved]Sitemap SQL error

Posted: Sun 19. Feb 2006, 08:01
by davide
Hi all, friends!

I'm a beginner with phpwcms and I'm trying to set up a sitemap page.

I have created the article and I know that I must add a contentpart called sitemap to the article.

There is a problem: when I try to save the article, it appears this error message:
error while creating new article content
sql: SELECT DISTINCT *, date_format(article_tstamp, '%Y-%m-%d %H:%i:%s') AS article_date FROM phpwcms_article LEFT JOIN phpwcms_articlecat ON phpwcms_article.article_cid=phpwcms_articlecat.acat_id WHERE phpwcms_article.article_id='2' LIMIT 1;
Could someone help me?
Thanks in advance.

Ciao,
Davide.

Posted: Sun 19. Feb 2006, 17:11
by DeXXus

Posted: Sun 19. Feb 2006, 19:15
by davide
Thanks!
Davide.