Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Moozie
Posts: 164 Joined: Sat 8. Nov 2003, 00:21
Location: Netherlands
Post
by Moozie » Sun 11. Jan 2004, 22:49
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
Posts: 111 Joined: Sun 11. Jan 2004, 12:41
Location: Halle, Germany
Contact:
Post
by cguenther » Sun 11. Jan 2004, 23:05
Same error also here, but i check the db manualy after that error & here it updated the db-structure correct.
Oliver Georgi
Site Admin
Posts: 9900 Joined: Fri 3. Oct 2003, 22:22
Contact:
Post
by Oliver Georgi » Sun 11. Jan 2004, 23:16
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
Posts: 164 Joined: Sat 8. Nov 2003, 00:21
Location: Netherlands
Post
by Moozie » Sun 11. Jan 2004, 23:24
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
Site Admin
Posts: 9900 Joined: Fri 3. Oct 2003, 22:22
Contact:
Post
by Oliver Georgi » Sun 11. Jan 2004, 23:51
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
Posts: 164 Joined: Sat 8. Nov 2003, 00:21
Location: Netherlands
Post
by Moozie » Mon 12. Jan 2004, 00:08
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
Site Admin
Posts: 9900 Joined: Fri 3. Oct 2003, 22:22
Contact:
Post
by Oliver Georgi » Mon 12. Jan 2004, 00:13
The field is in and functional - but not ready in frontend.
Moozie
Posts: 164 Joined: Sat 8. Nov 2003, 00:21
Location: Netherlands
Post
by Moozie » Mon 12. Jan 2004, 00:16
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
Site Admin
Posts: 9900 Joined: Fri 3. Oct 2003, 22:22
Contact:
Post
by Oliver Georgi » Mon 12. Jan 2004, 00:17
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
Posts: 164 Joined: Sat 8. Nov 2003, 00:21
Location: Netherlands
Post
by Moozie » Mon 12. Jan 2004, 00:21
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;