Version update 2.0.35 to 3.0

Reply

Version update 2.0.35 to 3.0#785345

By tamilventhan - Fri May 06, 2016 2:22 am

- Fri May 06, 2016 2:22 am #785345

We have used process maker version 2.0.35, but i need update latest version (3.0)

so how to update my process maker (2.0.35) and data base data to latest version (3.0)

please let me the procedure.

Re: Version update 2.0.35 to 3.0#785352

By ArturoRobles - Fri May 06, 2016 10:34 am

- Fri May 06, 2016 10:34 am #785352

Hello tamilventhan,

In order to upgrade your ProcessMaker 2.0.35 server to the latest 3.0.1.7 version, you need to do it gradually through several stages like this:

1. Upgrade to ProcessMaker 2.0.40.
2. Upgrade to ProcessMaker 2.0.45
3. Upgrade to ProcessMaker 2.5.2.
4. Upgrade to ProcessMaker 3.0.1.7

Each upgrade needs to be performed following the procedure found in the ProcessMaker Wiki here: http://wiki.processmaker.com/index.php/ ... ocessMaker for ProcessMaker 2.x and here: http://wiki.processmaker.com/3.0/UpgradingProcessMaker for ProcessMaker 3.x.

Best regards,

Re: Version update 2.0.35 to 3.0#785368

By tamilventhan - Mon May 09, 2016 5:19 am

- Mon May 09, 2016 5:19 am #785368

Hi,

How to migrate database version 2.0.35 to version 3.0?
how to manually migrate the database?
In version 2.0.35 i have totally 3 databases with 82 tables (in database there are 75 tables , another two database in 7 tables)
But In version 3.0 i have only one database with 138 tables .
How to migrate the database?
Can you guide me to resolve the issues?

Thanks in advance
Tamizhina venthan.E

Re: Version update 2.0.35 to 3.0#785372

By ArturoRobles - Mon May 09, 2016 3:06 pm

- Mon May 09, 2016 3:06 pm #785372

Hello tamilvedan,

There's no way to migrate the ProcessMaker database from an older version to a newer one. You have to follow the procedure that I detailed in a previous post in order to take your ProcessMaker (both: source code and data) from version 2.0.35 to version 3.x.

Best regards,

Re: Version update 2.0.35 to 3.0#785383

By tamilventhan - Tue May 10, 2016 1:12 am

- Tue May 10, 2016 1:12 am #785383

ok, thank you

Error get when Version from 2.0.40 to 2.0.45#785462

By tamilventhan - Fri May 20, 2016 3:39 am

- Fri May 20, 2016 3:39 am #785462

Hi

when i migrating Version from 2.0.40 to 2.0.45
i am getting bellow Error message when i login to the process maker 2.0.45

Chrome and Firefox browser : form.js was not loaded

Internet explore : The TRANSLATIONS global object is not loaded

please let me the procedure.

Thanks in advance
Tamizhina venthan.E

Version update 2.0.45 to 2.5.2#785474

By tamilventhan - Fri May 20, 2016 9:14 am

- Fri May 20, 2016 9:14 am #785474

Hi

when i migrating Version from 2.0.45 to 2.5.2
i am getting bellow Error message when i click home menu to the process maker 2.5.2

Error:
[wrapped: Could not execute query [Native Error: Unknown column 'APP_CACHE_VIEW.DEL_LAST_INDEX' in 'field list'] [User Info: SELECT APP_CACHE_VIEW.APP_UID, APP_CACHE_VIEW.DEL_INDEX, APP_CACHE_VIEW.DEL_LAST_INDEX, APP_CACHE_VIEW.APP_NUMBER, APP_CACHE_VIEW.APP_STATUS, APP_CACHE_VIEW.USR_UID, APP_CACHE_VIEW.PREVIOUS_USR_UID, APP_CACHE_VIEW.TAS_UID, APP_CACHE_VIEW.PRO_UID, APP_CACHE_VIEW.DEL_DELEGATE_DATE, APP_CACHE_VIEW.DEL_INIT_DATE, APP_CACHE_VIEW.DEL_TASK_DUE_DATE, APP_CACHE_VIEW.DEL_FINISH_DATE, APP_CACHE_VIEW.DEL_THREAD_STATUS, APP_CACHE_VIEW.APP_THREAD_STATUS, APP_CACHE_VIEW.APP_TITLE, APP_CACHE_VIEW.APP_PRO_TITLE, APP_CACHE_VIEW.APP_TAS_TITLE, APP_CACHE_VIEW.APP_CURRENT_USER, APP_CACHE_VIEW.APP_DEL_PREVIOUS_USER, APP_CACHE_VIEW.DEL_PRIORITY, APP_CACHE_VIEW.DEL_DURATION, APP_CACHE_VIEW.DEL_QUEUE_DURATION, APP_CACHE_VIEW.DEL_DELAY_DURATION, APP_CACHE_VIEW.DEL_STARTED, APP_CACHE_VIEW.DEL_FINISHED, APP_CACHE_VIEW.DEL_DELAYED, APP_CACHE_VIEW.APP_CREATE_DATE, APP_CACHE_VIEW.APP_FINISH_DATE, APP_CACHE_VIEW.APP_UPDATE_DATE, APP_CACHE_VIEW.APP_OVERDUE_PERCENTAGE, APP_CACHE_VIEW.DEL_INIT_DATE, APP_CACHE_VIEW.TAS_UID, APP_CACHE_VIEW.PRO_UID, CU.USR_UID AS USR_UID, CU.USR_FIRSTNAME AS USR_FIRSTNAME, CU.USR_LASTNAME AS USR_LASTNAME, CU.USR_USERNAME AS USR_USERNAME, APPCVCR.APP_TAS_TITLE AS APPCVCR_APP_TAS_TITLE, USRCR.USR_UID AS USRCR_USR_UID, USRCR.USR_FIRSTNAME AS USRCR_USR_FIRSTNAME, USRCR.USR_LASTNAME AS USRCR_USR_LASTNAME, USRCR.USR_USERNAME AS USRCR_USR_USERNAME, PU.USR_FIRSTNAME AS PREVIOUS_USR_FIRSTNAME, PU.USR_LASTNAME AS PREVIOUS_USR_LASTNAME, PU.USR_USERNAME AS PREVIOUS_USR_USERNAME FROM APP_CACHE_VIEW LEFT JOIN USERS CU ON (APP_CACHE_VIEW.USR_UID=CU.USR_UID) LEFT JOIN USERS PU ON (APP_CACHE_VIEW.PREVIOUS_USR_UID=PU.USR_UID) LEFT JOIN APP_CACHE_VIEW APPCVCR ON (APP_CACHE_VIEW.APP_UID=APPCVCR.APP_UID AND APPCVCR.DEL_LAST_INDEX=1) LEFT JOIN USERS USRCR ON (APPCVCR.USR_UID=USRCR.USR_UID) WHERE APP_CACHE_VIEW.APP_STATUS='TO_DO' AND APP_CACHE_VIEW.USR_UID='00000000000000000000000000000001' AND APP_CACHE_VIEW.DEL_FINISH_DATE IS NULL AND APP_CACHE_VIEW.APP_THREAD_STATUS='OPEN' AND APP_CACHE_VIEW.DEL_THREAD_STATUS='OPEN' ORDER BY APP_CACHE_VIEW.APP_NUMBER DESC LIMIT 25]]

please let me the procedure.

Thanks in advance
Tamizhina venthan.E

Re: Version update 2.0.35 to 3.0#785515

By tamilventhan - Tue May 24, 2016 1:31 am

- Tue May 24, 2016 1:31 am #785515

tamilventhan wrote:Hi

when i migrating Version from 2.0.45 to 2.5.2
i am getting bellow Error message when i click home menu to the process maker 2.5.2

Error:
[wrapped: Could not execute query [Native Error: Unknown column 'APP_CACHE_VIEW.DEL_LAST_INDEX' in 'field list'] [User Info: SELECT APP_CACHE_VIEW.APP_UID, APP_CACHE_VIEW.DEL_INDEX, APP_CACHE_VIEW.DEL_LAST_INDEX, APP_CACHE_VIEW.APP_NUMBER, APP_CACHE_VIEW.APP_STATUS, APP_CACHE_VIEW.USR_UID, APP_CACHE_VIEW.PREVIOUS_USR_UID, APP_CACHE_VIEW.TAS_UID, APP_CACHE_VIEW.PRO_UID, APP_CACHE_VIEW.DEL_DELEGATE_DATE, APP_CACHE_VIEW.DEL_INIT_DATE, APP_CACHE_VIEW.DEL_TASK_DUE_DATE, APP_CACHE_VIEW.DEL_FINISH_DATE, APP_CACHE_VIEW.DEL_THREAD_STATUS, APP_CACHE_VIEW.APP_THREAD_STATUS, APP_CACHE_VIEW.APP_TITLE, APP_CACHE_VIEW.APP_PRO_TITLE, APP_CACHE_VIEW.APP_TAS_TITLE, APP_CACHE_VIEW.APP_CURRENT_USER, APP_CACHE_VIEW.APP_DEL_PREVIOUS_USER, APP_CACHE_VIEW.DEL_PRIORITY, APP_CACHE_VIEW.DEL_DURATION, APP_CACHE_VIEW.DEL_QUEUE_DURATION, APP_CACHE_VIEW.DEL_DELAY_DURATION, APP_CACHE_VIEW.DEL_STARTED, APP_CACHE_VIEW.DEL_FINISHED, APP_CACHE_VIEW.DEL_DELAYED, APP_CACHE_VIEW.APP_CREATE_DATE, APP_CACHE_VIEW.APP_FINISH_DATE, APP_CACHE_VIEW.APP_UPDATE_DATE, APP_CACHE_VIEW.APP_OVERDUE_PERCENTAGE, APP_CACHE_VIEW.DEL_INIT_DATE, APP_CACHE_VIEW.TAS_UID, APP_CACHE_VIEW.PRO_UID, CU.USR_UID AS USR_UID, CU.USR_FIRSTNAME AS USR_FIRSTNAME, CU.USR_LASTNAME AS USR_LASTNAME, CU.USR_USERNAME AS USR_USERNAME, APPCVCR.APP_TAS_TITLE AS APPCVCR_APP_TAS_TITLE, USRCR.USR_UID AS USRCR_USR_UID, USRCR.USR_FIRSTNAME AS USRCR_USR_FIRSTNAME, USRCR.USR_LASTNAME AS USRCR_USR_LASTNAME, USRCR.USR_USERNAME AS USRCR_USR_USERNAME, PU.USR_FIRSTNAME AS PREVIOUS_USR_FIRSTNAME, PU.USR_LASTNAME AS PREVIOUS_USR_LASTNAME, PU.USR_USERNAME AS PREVIOUS_USR_USERNAME FROM APP_CACHE_VIEW LEFT JOIN USERS CU ON (APP_CACHE_VIEW.USR_UID=CU.USR_UID) LEFT JOIN USERS PU ON (APP_CACHE_VIEW.PREVIOUS_USR_UID=PU.USR_UID) LEFT JOIN APP_CACHE_VIEW APPCVCR ON (APP_CACHE_VIEW.APP_UID=APPCVCR.APP_UID AND APPCVCR.DEL_LAST_INDEX=1) LEFT JOIN USERS USRCR ON (APPCVCR.USR_UID=USRCR.USR_UID) WHERE APP_CACHE_VIEW.APP_STATUS='TO_DO' AND APP_CACHE_VIEW.USR_UID='00000000000000000000000000000001' AND APP_CACHE_VIEW.DEL_FINISH_DATE IS NULL AND APP_CACHE_VIEW.APP_THREAD_STATUS='OPEN' AND APP_CACHE_VIEW.DEL_THREAD_STATUS='OPEN' ORDER BY APP_CACHE_VIEW.APP_NUMBER DESC LIMIT 25]]

please let me the procedure.

Thanks in advance
Tamizhina venthan.E

Re: Version update 2.0.35 to 3.0#785522

By ArturoRobles - Tue May 24, 2016 9:18 am

- Tue May 24, 2016 9:18 am #785522

Hello Tamizhina,

Can you give me your ProcessMaker server's OS exact version number as well as the exact version numbers of Apache, PHP and MySQL that you are running there? Thank you.

Best regards,

Re: Version update 2.0.35 to 3.0#785537

By tamilventhan - Wed May 25, 2016 2:24 am

- Wed May 25, 2016 2:24 am #785537

Hi ArturoRobles,

Process Maker Server details :

OS : Red Hat Enterprise Linux Server release 5 (Tikanga) (Linux)
Apache: 2.2.17
PHP : 5.3.5
Mysql : 5.5.8

Thanks
Tamizhina venthan

Version update 2.0.35 to 3.0.17#785544

By tamilventhan - Thu May 26, 2016 1:54 am

- Thu May 26, 2016 1:54 am #785544

Hi,

when i migrating Version from 2.5.2 to 3.0.17
i am getting bellow Error message.

System Error:
Sistem Configuration Error:
Please review your apache virtual host configuration file, and be sure you have the following rules:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ /app.php [QSA,L]
</IfModule>

can you give me a hint on what to do?

Regards,
Tamizhina venthan

Re: Version update 2.0.35 to 3.0#785558

By ArturoRobles - Mon May 30, 2016 9:37 am

- Mon May 30, 2016 9:37 am #785558

Hello Tamizhina,

Yes, you need to make changes to the pmos.conf virtual host configuration file in version 3.x of ProcessMaker, in accordance to the ProcessMaker Wiki here: http://wiki.processmaker.com/3.0/Proces ... Apache_2.2

You'll also need to upgrade your PHP version to 5.4.x for ProcessMaker 3.0.1.7 to work fine.

Best regards,

Re: Version update 2.5.2 to 3.0#785620

By tamilventhan - Thu Jun 02, 2016 8:18 am

- Thu Jun 02, 2016 8:18 am #785620

I did upgraded in PHP version to 5.4 and Lampp 1.8
But when i migrating Version from 2.5.2 to 3.0.17
i am able to login page
then i am getting bellow Error message:
Notice: Undefined index: HTTP_REFERER in /opt/lampp/htdocs/processmaker-prod/workflow/engine/methods/login/authentication.php on line 59
please let me the procedure.
Thanks
Tamizhina ventha