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 ArturoRobles
#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,
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
Change template of reset password

Is possible to change the template is send by ma[…]

Display PDF OR Xlsx OR Xls in Panel

Hi, It is not working. can you please share pmx f[…]

open case through dashboard

Thank you

I have done using session id. I have used version […]