Add mail to PostMaster mail Accounts failure to 3.1.2

[kajeflento]

I'm using OTRS on windows 7 and i was familiar with otrs 1.0 which was perfect and everything works very well.
When i tried to upgrade from version 3.1.0 to 3.1.2 everything works expect the Postaster mail which is not working and i tried to enter the address it gives the following error:
Unknown column 'imap_folder' in 'field list', SQL: 'INSERT INTO mail_account (login, pw, host, account_type, valid_id, comments, queue_id, imap_folder, trusted, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-03-30 12:36:12' , ?, '2012-03-30 12:36:12' , ?)'

Could you please help me to know what should be the problem and how to correct it?
Thx for your continuous support!

[jojo]

there is no 3.1.0 except the betas. If you were using a beta pleas read the UPGRADING file

[kajeflento]

there is no 3.1.0 except the betas. If you were using a beta pleas read the UPGRADING file

For further information and clarification, i'm upgrading from OTRS-3.0.10-win to OTRS-3.1.2-win.
Where is UPGRADE File? i don't know where it is, could you please help me to find out?
Thanks for your help and support!

[jojo]

in the OTRS main directory

[kajeflento]

in the OTRS main directory

Thx Jojo for your guidance, but i've followed all steps as they are indicated, and i'm getting this error message while trying to add PostMaster email account:
Could you please analyse and let me know what should be the problem:

Unknown column 'imap_folder' in 'field list', SQL: 'INSERT INTO mail_account (login, pw, host, account_type, valid_id, comments, queue_id, imap_folder, trusted, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-04-03 12:10:27' , ?, '2012-04-03 12:10:27' , ?)'

Thx a lot for your kindness

[jojo]

Again read the UPGRADING file!

20) Database Upgrade During Beta Phase
----------------------------------

This step is ONLY needed if you upgrade from 3.1.beta1 or 3.1.beta2!

Please apply the required database changes as follows:

MySQL:
shell> cat scripts/DBUpdate-3.1.beta.mysql.sql | mysql -p -f -u root otrs

PostgreSQL 8.2+:
shell> cat scripts/DBUpdate-3.1.beta.postgresql.sql | psql otrs

PostgreSQL, older versions:
shell> cat scripts/DBUpdate-3.1.beta.postgresql_before_8_2.sql | psql otrs

[kajeflento]

Again read the UPGRADING file!

20) Database Upgrade During Beta Phase
----------------------------------

This step is ONLY needed if you upgrade from 3.1.beta1 or 3.1.beta2!

Please apply the required database changes as follows:

MySQL:
shell> cat scripts/DBUpdate-3.1.beta.mysql.sql | mysql -p -f -u root otrs

PostgreSQL 8.2+:
shell> cat scripts/DBUpdate-3.1.beta.postgresql.sql | psql otrs

PostgreSQL, older versions:
shell> cat scripts/DBUpdate-3.1.beta.postgresql_before_8_2.sql | psql otrs

Sorry Jojo for disturbing you, i realy need a help to achieve this and i'm getting stack i don't know why,
For first step has worked, then shell> cat scripts/DBUpdate-3.1.beta.postgresql.sql | psql otrs and shell> cat scripts/DBUpdate-3.1.beta.postgresql_before_8_2.sql | psql otrs i'm told that psql is notrecognised as an internal or external command, operable program or batch file,
Could you please help me to know what should be the meaning and the problem of psql?
Thank Jojo and i'm so sorry for alla this, i'm also enjoying learning with you!
God bless you

[jojo]

these are actions for users of PostgreSQL as stated in the line above the command

[kajeflento]

these are actions for users of PostgreSQL as stated in the line above the command

Yes Thx Jojo, I've found. u're genius