Questions and discussion around ProcessMaker 2 documentation

Moderator: amosbatto

By tamilventhan
#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.
By ArturoRobles
#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,
By tamilventhan
#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
By ArturoRobles
#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,
#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
By tamilventhan
#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
By tamilventhan
#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
By ArturoRobles
#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,
By tamilventhan
#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
By tamilventhan
#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
By tamilventhan
#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
pdf preview in processmker

Hi, You must create a panel in your form, then cre[…]

claim multiple unassigned case

Hi, I have created "User Friendly Panel"[…]

Stop download file on click of link

Hi, You can this link for get download url: https[…]

i want to check the checkbox on certain condition.[…]