Page 1 of 1
Version update 2.0.35 to 3.0
Posted: Fri May 06, 2016 2:22 am
by tamilventhan
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
Posted: Fri May 06, 2016 10:34 am
by ArturoRobles
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
Posted: Mon May 09, 2016 5:19 am
by tamilventhan
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
Posted: Mon May 09, 2016 3:06 pm
by ArturoRobles
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
Posted: Tue May 10, 2016 1:12 am
by tamilventhan
ok, thank you
Error get when Version from 2.0.40 to 2.0.45
Posted: Fri May 20, 2016 3:39 am
by tamilventhan
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
Posted: Fri May 20, 2016 9:14 am
by tamilventhan
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
Posted: Tue May 24, 2016 1:31 am
by tamilventhan
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
Posted: Tue May 24, 2016 9:18 am
by ArturoRobles
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
Posted: Wed May 25, 2016 2:24 am
by tamilventhan
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
Posted: Thu May 26, 2016 1:54 am
by tamilventhan
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
Posted: Mon May 30, 2016 9:37 am
by ArturoRobles
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
Posted: Thu Jun 02, 2016 8:18 am
by tamilventhan
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