Upgrading to version 11-1-2004 problem

[Moozie]

I installed the patch for the version of 10-1-2004. But when I ran upgrade.php I got the error:

Code: Select all

ERROR: 
CREATE TABLE `phpwcms_pagelayout` (
  `pagelayout_id` int(11) NOT NULL auto_increment,
  `pagelayout_name` varchar(255) NOT NULL default '',
  `pagelayout_default` int(1) NOT NULL default '0',
  `pagelayout_var` mediumblob NOT NULL,
  `pagelayout_trash` int(1) NOT NULL default '0',
  PRIMARY KEY  (`pagelayout_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

ERROR: 
ALTER TABLE `phpwcms_articlecat` ADD `acat_ssl` INT( 1 ) NOT NULL;

ERROR: 
ALTER TABLE `phpwcms_articlecat` ADD `acat_regonly` INT( 1 ) NOT NULL;

Any idea what's wrong?

[cguenther]

Same error also here, but i check the db manualy after that error & here it updated the db-structure correct.

[Oliver Georgi]

Maybe - some errors are normal if you have current version.

Check if the "added" fields are available.

The 2004-01-11 patch needs last line only.

Maybe you have not copied setup to same structure as needed.

Oliver

[Moozie]

Now I have upgraded with the new total version. Everything seems to work, except I can not create menu-items in site structure. It returns a white screen with only the word "error" on the top left. I see that the script tries to access http://www.mydomain/phpwcms/include/inc ... ucture.php

Strange is that I can create articles (in the root off course).

But no site structure. In phpMyAdmin I count 23 tables just created.

Any ideas what 's wrong?

[Oliver Georgi]

Check that you fill in the last line of the db code to you phpwcms database.

Attention: add the db table prefix before the table name there.

Code: Select all

ALTER TABLE MYPREFIX_phpwcms_articlecat ADD acat_regonly INT( 1 ) NOT NULL;

Oliver

[Moozie]

Ahaaa that's it!!

But I downloaded the latest version of today. I thought the extra field was in it already? Isn't it???


Thanks anyway

[Oliver Georgi]

The field is in and functional - but not ready in frontend.

[Moozie]

In fact I do not quite understand what this field is all about. I read your poll this afternoon but you lost me. But nevertheless why is that table field not added automatically? Or do I misunderstand you?

Maybe you can also explain again the use of that field...

[Oliver Georgi]

This new field would be used in frontend to decide if the structure level is visible to all or only to logged on frontend users.

[Moozie]

OK so some kind of inlog will be created for the frontend in time...

But that leaves my question why that line isn't added automatically. I had to do it manually and I downloaded the latest TOTAL version.

Code: Select all

ALTER TABLE MYPREFIX_phpwcms_articlecat ADD acat_regonly INT( 1 ) NOT NULL; 

[Oliver Georgi]

I don't really know.