Page 1 of 1
Upgrading to version 11-1-2004 problem
Posted: Sun 11. Jan 2004, 22:49
by 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?
Posted: Sun 11. Jan 2004, 23:05
by cguenther
Same error also here, but i check the db manualy after that error & here it updated the db-structure correct.
Posted: Sun 11. Jan 2004, 23:16
by 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
Posted: Sun 11. Jan 2004, 23:24
by 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?
Posted: Sun 11. Jan 2004, 23:51
by 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
Posted: Mon 12. Jan 2004, 00:08
by 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
Posted: Mon 12. Jan 2004, 00:13
by Oliver Georgi
The field is in and functional - but not ready in frontend.
Posted: Mon 12. Jan 2004, 00:16
by 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...
Posted: Mon 12. Jan 2004, 00:17
by 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.
Posted: Mon 12. Jan 2004, 00:21
by 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;
Posted: Mon 12. Jan 2004, 06:29
by Oliver Georgi
![Wink ;-)](./images/smilies/icon_wink.gif)
I don't really know.