Page 1 of 1

MySQL error on update

Posted: Thu 17. Feb 2005, 15:34
by Cyrus
Updating from 1.1.9-DEV to 1.2-DEV I get the following error :

SQL-query:

Code: Select all

ALTER TABLE `phpwcms_forum` ADD `forum_cpost` INT NOT NULL AFTER `forum_counttopic`

MySQL said:

Code: Select all

#1054 - Unknown column 'forum_counttopic' in 'phpwcms_forum'
Something wrong somewhere with my tables?

Posted: Thu 17. Feb 2005, 15:42
by jscholtysik
Hi Cyrus,


Karla seems to have a solution:

http://www.phpwcms.de/forum/viewtopic.php?t=5648


Joachim

Posted: Thu 17. Feb 2005, 15:53
by Cyrus
Thanks for that...sorry.... should have caught the earlier post.

Code: Select all

ALTER TABLE `phpwcms_forum` ADD `forum_cpost` INT NOT NULL AFTER `forum_ctopic` ;
worked successfully