MySQL error on update

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

[jscholtysik]

Hi Cyrus,


Karla seems to have a solution:

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


Joachim

[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