database upgrade - error

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
Schnoof
Posts: 12
Joined: Tue 1. Feb 2005, 19:08
Contact:

database upgrade - error

Post 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
User avatar
pico
Posts: 2595
Joined: Wed 28. Jul 2004, 18:04
Location: Frankfurt/M Germany
Contact:

Post by pico »

take a look to your phpwcms_init.sql in your setup-Folder
:lol:
Lieber Gott gib mir Geduld - ABER BEEIL DICH
Horst - find me at Musiker-Board
Schnoof
Posts: 12
Joined: Tue 1. Feb 2005, 19:08
Contact:

Post by Schnoof »

Thanks. Now I fixed it and everything works really fine. :D

Have fun
Schnoof
Post Reply