Page 1 of 1

database upgrade - error

Posted: Mon 28. Feb 2005, 16:37
by Schnoof
While updating from 1.1.9 I've got the following error:

-- ERROR --
ALTER TABLE `phpwcms_cache` ADD `cache_isprint` INT( 1 ) NOT NULL AFTER `cache_timeout`;ALTER TABLE `phpwcms_forum` ADD `forum_ctopic` INT NOT NULL AFTER `forum_uid`;ALTER TABLE `phpwcms_forum` ADD `forum_cpost` INT NOT NULL AFTER `forum_ctopic`;ALTER TABLE `phpwcms_forum` ADD `forum_lastpost` MEDIUMTEXT NOT NULL;

I looked at the table "phpwcms_cache" and I don't have the column "cache_timeout". Probably the update to 1.1.9 was already going wrong.

Could someone please give me the structures of the tables "phpwcms_cache" and "phpwcms_forum", for that I might change this in phpMyAdmin?

Thanks a lot
Schnoof

Posted: Mon 28. Feb 2005, 16:53
by pico
take a look to your phpwcms_init.sql in your setup-Folder
:lol:

Posted: Mon 28. Feb 2005, 18:34
by Schnoof
Thanks. Now I fixed it and everything works really fine. :D

Have fun
Schnoof