error while creating new article... Keine neuen Artikel mögl

[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!

[Oliver Georgi]

check db update.

Oliver

[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

[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!!!