Page 1 of 1
Cannot add
Posted: Tue 25. Jul 2006, 16:37
by 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?
Posted: Tue 25. Jul 2006, 19:39
by DeXXus
Go back to the /setup folder and run the upgrade.php through ALL of the .SQL files to solve this.
DeXXus
Posted: Mon 31. Jul 2006, 02:21
by 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.
Posted: Mon 31. Jul 2006, 04:05
by 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