patch 15-2 and 17-2 over 22-1 release question

[Moozie]

I want to use the patch 15-2 and 17-2 over 22-1 release. Have some questions:


Q1:
Can I just replace the new files or do I have to run the upgrade.php again?

Q2:
Are there new entries in the database made?

[pSouper]

ther is a change in you password table.
I just use phpmyadmin to make the change - simple

open the .sql file to see the changes you need to make

[Moozie]

Thanks, I see 2 .sql files:

1. phpwcms_init.sql
2. phpwcms_update.sql

The first one is a complete create of all tables. But I already have these. Or are there any changes made in this file so that I have to run in anyway?

The 2nd file only contains a replcement of the field 'usr_pass' in table 'phpscms_user': VARCHAR( 255 ) NOT NULL instead of (50).

Does the phpwcms_init.sql contain more changes???

[Pappnase]

Thanks, I see 2 .sql files:

1. phpwcms_init.sql
2. phpwcms_update.sql

The first one is a complete create of all tables. But I already have these. Or are there any changes made in this file so that I have to run in anyway?

The 2nd file only contains a replcement of the field 'usr_pass' in table 'phpscms_user': VARCHAR( 255 ) NOT NULL instead of (50).

Does the phpwcms_init.sql contain more changes???

NO!!

Only insert the phpwcms_update.sql file

Pappnase

[Moozie]

Thanks. That's what I thought. Gonna try it now.

[pSouper]

Pappnase is correct but you must KNOW you have udated all the previous patches too.
if not just work back throught patches updating the update.sql files until you are sure you have covered any missing amendments.

[Moozie]

I had the full version installed of 22-1.

So I added the patches of 15-2 and 17-2. I think that I am up to date then.