(UPDATE/NEW) phpWCMS Update Packs 26.04.2006

Pappnase · Post by **Pappnase** » Thu 17. Nov 2005, 04:50

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

sustia · Post by **sustia** » Thu 17. Nov 2005, 08:59

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?

Kosse · Post by **Kosse** » Thu 17. Nov 2005, 11:18

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

jscholtysik · Post by **jscholtysik** » Thu 17. Nov 2005, 12:05

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

1996 328ti · Post by **1996 328ti** » Thu 17. Nov 2005, 13:09

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?

jscholtysik · Post by **jscholtysik** » Thu 17. Nov 2005, 13:21

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

Kosse · Post by **Kosse** » Thu 17. Nov 2005, 13:39

Hi Joachim,

thx for the tip!

Cheers

StudioZ · Post by **StudioZ** » Thu 17. Nov 2005, 23:00

Hey... thanks Pappnase for taking care of these for us

Thumbs up!!!

Pappnase · Post by **Pappnase** » Sun 20. Nov 2005, 04:55

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!

SNap · Post by **SNap** » Tue 22. Nov 2005, 09:05

was wurde denn im GT mod geändert?

Pappnase · Post by **Pappnase** » Tue 22. Nov 2005, 17:58

SNap wrote:was wurde denn im GT mod geändert?

hallo sorry hatte nicht die zeit nachzuschauen

erodzina · Post by **erodzina** » Sun 27. Nov 2005, 00:38

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

erodzina · Post by **erodzina** » Sun 27. Nov 2005, 01:13

Ok, its working but all my changes i will have to do again

cyrano · Post by **cyrano** » Sun 27. Nov 2005, 01:39

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.

Kosse · Post by **Kosse** » Sun 27. Nov 2005, 15:24

And you can use winmerge with dreamweaver easily

http://www.phpwcms.de/forum/viewtopic.p ... aver#51819

Cheers