Page 1 of 1
error while creating new article... Keine neuen Artikel mögl
Posted: Tue 17. Oct 2006, 22:51
by shorshe
Mist, irgendetwas läuft falsch...
While creating a new articel I get the following error:
Code: Select all
error while creating new article content
sql: SELECT DISTINCT *, date_format(article_tstamp, '%Y-%m-%d %H:%i:%s') AS article_date FROM cms__phpwcms_article LEFT JOIN cms__phpwcms_articlecat ON cms__phpwcms_article.article_cid=cms__phpwcms_articlecat.acat_id WHERE cms__phpwcms_article.article_id='54' LIMIT 1;
Must be database related.
I recently updated from 1.2.6-dev to 1.2.8 (including patch g)
The site seems to work just fine... I just can't create or change an article.
Any Clues?
Help!
Posted: Wed 18. Oct 2006, 22:48
by Oliver Georgi
check db update.
Oliver
Posted: Wed 18. Oct 2006, 23:01
by shorshe
I did upgrade the database to 1.2.8. Now I tried to do it again:
Code: Select all
-- ERROR --
#
#
CREATE TABLE `cms__phpwcms_formtracking` (
`formtracking_id` INT NOT NULL AUTO_INCREMENT,
`formtracking_hash` VARCHAR( 50 ) NOT NULL default '',
`formtracking_ip` VARCHAR( 20 ) NOT NULL default '',
`formtracking_created` TIMESTAMP(14) NOT NULL,
`formtracking_sentdate` VARCHAR( 20 ) NOT NULL default '',
`formtracking_sent` INT( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY (`formtracking_id`)
) TYPE=MyISAM;
-- ERROR --
ALTER TABLE `cms__phpwcms_articlecat` ADD `acat_maxlist` INT( 11 ) NOT NULL DEFAULT '0';
-- ERROR --
ALTER TABLE `cms__phpwcms_articlecat` ADD `acat_cntpart` VARCHAR( 255 ) NOT NULL;
Do you think it would be a goot idea to revert the database to 1.2.6 (from a backup) and do the 1.2.8 dbupdate again?
-----
Holy smokes, now it works.
What did I do?
tried the Database update again (got the above errors).
Deleted and restored complete database.... now it works
Posted: Thu 19. Oct 2006, 05:57
by DeXXus
BECAUSE the directive to CREATE TABLE ran successfully (adding table to your database) while the other two ALTER TABLE directives had previously been accomplished!
YAY!!!