Page 5 of 9
Posted: Thu 17. Nov 2005, 04:50
by Pappnase
hello
an new cvs release is published the following files are updatet.
-login.php
-phpwcms.php
-rss.php (2nd update for this file)
-img/random_image.php
-include/inc_act/act_newsletter.php
-include/inc_front/front.func.inc.php
-include/inc_lang/backend/de/lang.inc.php
-include/inc_lang/backend/en/lang.inc.php
-include/inc_lib/default.inc.php
-include/inc_tmpl/admin.keyword.tmpl.php
-setup/phpwcms_init.sql
-setup/update_sql/07__27-08-2004_to_1.2.6-DEV.sql
-setup/update_sql/13__1.2.5-DEV_to_1.2.6-DEV.sql
hallo
ein neue cvs version wurde veröffentlicht. folgende datein wurden verändert!
-login.php
-phpwcms.php
-rss.php (2tes update dieser datei)
-img/random_image.php
-include/inc_act/act_newsletter.php
-include/inc_front/front.func.inc.php
-include/inc_lang/backend/de/lang.inc.php
-include/inc_lang/backend/en/lang.inc.php
-include/inc_lib/default.inc.php
-include/inc_tmpl/admin.keyword.tmpl.php
-setup/phpwcms_init.sql
-setup/update_sql/07__27-08-2004_to_1.2.6-DEV.sql
-setup/update_sql/13__1.2.5-DEV_to_1.2.6-DEV.sql
Posted: Thu 17. Nov 2005, 08:59
by sustia
Hi pappnase, I've updated without problems.
I see a new feature named "Keywords" in the admin section, but seems that it's not complete, ut's true?
Posted: Thu 17. Nov 2005, 11:18
by Kosse
Pappnase wrote:hello
an new cvs release is published the following files are updatet.
-login.php
-phpwcms.php
-rss.php (2nd update for this file)
-img/random_image.php
-include/inc_act/act_newsletter.php
-include/inc_front/front.func.inc.php
-include/inc_lang/backend/de/lang.inc.php
-include/inc_lang/backend/en/lang.inc.php
-include/inc_lib/default.inc.php
-include/inc_tmpl/admin.keyword.tmpl.php
-setup/phpwcms_init.sql
-setup/update_sql/07__27-08-2004_to_1.2.6-DEV.sql
-setup/update_sql/13__1.2.5-DEV_to_1.2.6-DEV.sql
Hi Pap',
if I downloaded dev 1.2.6 do I have to upgrade Mysql also??
The three files?
-setup/phpwcms_init.sql
-setup/update_sql/07__27-08-2004_to_1.2.6-DEV.sql
-setup/update_sql/13__1.2.5-DEV_to_1.2.6-DEV.sql
Thx
Cheers
Posted: Thu 17. Nov 2005, 12:05
by jscholtysik
Hi Kosse,
it depends whether you already downloaded the CVS version from 06.11.2005. The new CVS-Release contains a slightly different SQL upgrade than the last version:
CVS-Version from 16.11.2005:
Code: Select all
#####################################################
#
# PHPWCMS SQL Update
#
# Upgrade release 1.2.5-DEV to 1.2.6-DEV
# 2005.11.05
#
#####################################################
ALTER TABLE `phpwcms_user` ADD `usr_vars` MEDIUMTEXT NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_name` VARCHAR( 200 ) NOT NULL AFTER `group_id` ;
ALTER TABLE `phpwcms_usergroup` ADD `group_member` MEDIUMTEXT NOT NULL AFTER `group_name` ;
ALTER TABLE `phpwcms_usergroup` ADD `group_timestamp` TIMESTAMP NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_trash` INT( 1 ) NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_active` INT( 1 ) NOT NULL ;
CREATE TABLE `phpwcms_keyword` (
`keyword_id` int(11) NOT NULL auto_increment,
`keyword_name` varchar(255) NOT NULL default '',
`keyword_trash` int(1) NOT NULL default '0',
PRIMARY KEY (`keyword_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CVS-Version from 06.11.2005:
Code: Select all
#####################################################
#
# PHPWCMS SQL Update
#
# Upgrade release 1.2.5-DEV to 1.2.6-DEV
# 2005.11.05
#
#####################################################
ALTER TABLE `phpwcms_user` ADD `usr_vars` MEDIUMTEXT NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_name` VARCHAR( 200 ) NOT NULL AFTER `group_id` ;
ALTER TABLE `phpwcms_usergroup` ADD `group_member` MEDIUMTEXT NOT NULL AFTER `group_name` ;
ALTER TABLE `phpwcms_usergroup` ADD `group_timestamp` TIMESTAMP NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_trash` INT( 1 ) NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_active` INT( 1 ) NOT NULL ;
New ist the Keyword table...
Joachim
Posted: Thu 17. Nov 2005, 13:09
by 1996 328ti
It looks like I already had below when I upgraded to 1.2.6 (6.11.05)
Code: Select all
ALTER TABLE `phpwcms_user` ADD `usr_vars` MEDIUMTEXT NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_name` VARCHAR( 200 ) NOT NULL AFTER `group_id` ;
ALTER TABLE `phpwcms_usergroup` ADD `group_member` MEDIUMTEXT NOT NULL AFTER `group_name` ;
ALTER TABLE `phpwcms_usergroup` ADD `group_timestamp` TIMESTAMP NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_trash` INT( 1 ) NOT NULL ;
ALTER TABLE `phpwcms_usergroup` ADD `group_active` INT( 1 ) NOT NULL ;
So I added only
Code: Select all
CREATE TABLE `phpwcms_keyword` (
`keyword_id` int(11) NOT NULL auto_increment,
`keyword_name` varchar(255) NOT NULL default '',
`keyword_trash` int(1) NOT NULL default '0',
PRIMARY KEY (`keyword_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Did anyone else who gone from 1.2.5 (6.11.2005) to 16.11.2005 have that problem?
Posted: Thu 17. Nov 2005, 13:21
by jscholtysik
Hi 1996 328ti,
it's ok. The new cvs release from 16.11.2005 only adds the new table phpwcms_keyword compared to the cvs release from 06.11.2005, so if you use the upgrade.php and choose
13__1.2.5-DEV_to_1.2.6-DEV.sql
,
you will first get some errors, because the Alter Commands have already been made and then the script creates the new table phpwcms_keyword.
Joachim
Posted: Thu 17. Nov 2005, 13:39
by Kosse
Hi Joachim,
thx for the tip!
Cheers
Posted: Thu 17. Nov 2005, 23:00
by StudioZ
Hey... thanks Pappnase for taking care of these for us
Thumbs up!!!
Posted: Sun 20. Nov 2005, 04:55
by Pappnase
Hello
a little small update is out!
only changes in the following files
random_image.php
and the gt.func.inc.php
i also split up the file list in the cvs section of the docu page. and you will finde there also an upgrade file from the zipped sourceforge version 14.8.2005 (1.2.5) to the actual release 19.11.2005 (1.26).
-----
hallo
es gab ein kleines update.
nur 2 dateien wurden geändert und zwar
random_image.php
und gt.func.inc.php
ausserdem habe ich die dateiliste aufgesplittet in 1.2.5 und 1.2.6.
und ihr findet dort nun auch eine datei mit der es möglich ist von der der gepackten sourceforge version 1.2.5 vom 14.8.2005 auf die letzte cvs version 19.11.2005 zu updaten!
Posted: Tue 22. Nov 2005, 09:05
by SNap
was wurde denn im GT mod geändert?
Posted: Tue 22. Nov 2005, 17:58
by Pappnase
SNap wrote:was wurde denn im GT mod geändert?
hallo sorry hatte nicht die zeit nachzuschauen
Posted: Sun 27. Nov 2005, 00:38
by erodzina
well i will try to make update, but im still afraid what will happend...
Will the database will change also with the v.2 ?? im right now running 1.2.5 and updating to 1.2.6
well, what i mean is that the setup file should be the same, and update should take 2minutes so the users wouldnt whait while update... i don't know if you know what i mean
Posted: Sun 27. Nov 2005, 01:13
by erodzina
Ok, its working but all my changes i will have to do again
Posted: Sun 27. Nov 2005, 01:39
by cyrano
hi, yes and when use use a lotof wcms instalations you have to make notices when you uploaded what - not easy.
one tip: to check what is changed or what to override i use WinMerge, where you can control 2 files and see all differences.
Posted: Sun 27. Nov 2005, 15:24
by Kosse
And you can use winmerge with dreamweaver easily
http://www.phpwcms.de/forum/viewtopic.p ... aver#51819
Cheers