Cannot add

[cth3]

I have upgraded to the 1.2.7 and cannot add anything more to my site. I get error:

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='3' LIMIT 1;

Is there anyway I can fix this or go back to a working version?

[DeXXus]

Go back to the /setup folder and run the upgrade.php through ALL of the .SQL files to solve this.

[Guru]

I have the same problem too..
and I tried what you said but all the sql files are full of errors when I upgrade....so I think it's not working.
Any new ideeas .... I'm stuck here.

[DeXXus]

The errors are only about "already created" tables and fields and cause no harm.

Maybe check this thread:
http://www.phpwcms.de/forum/viewtopic.php?t=11433

Or do the "wiser" thing and goto Forum Search and enter select+distinct+left+join with radio button named <Search for all terms> chosen!

EDIT:
Apparently you DO NOT experience the above error... but, instead, one that has this clue:
error while connecting to database