Page 1 of 1

upgrade to 3.1 error

Posted: Tue Oct 04, 2016 1:35 pm
by ajcosta
Hello,

Can any one help me on this?

Tried to upgrade from 3.0.1.8 to 3.1 but when running the "./processmaker upgrade" command I get the error:
"Updating Content...
Errors upgrading workspace xxx: It is not possible to execute the query. Please contact your system administrator"

Thank you,
Aj

Re: upgrade to 3.1 error

Posted: Tue Oct 04, 2016 2:56 pm
by amosbatto
What's your operating system and how did you install PM 3.0.1.8 ? I want to try to replicate your problem.

Re: upgrade to 3.1 error

Posted: Tue Oct 04, 2016 5:10 pm
by ajcosta
Ive attached the system info.

I started with 3.0.1.7 and upgraded to 3.0.1.8.
After some time I changed the root password of MySql and in PM. All is working fine thow in 3.0.1.8.

Do you think this passwd change might be the cause?
change it via command line in mysql, and then in the Admin>Casses List Cache Builder>Setup Mysql root Pass

Following the upgrade procedure and had two problems:

1- after extracting gz file, the processmaker file had no execute permissions, so had to chmod 755 processmaker.
2 - when running the ./processmaker upgrade got the error reported.

Re: upgrade to 3.1 error

Posted: Tue Oct 04, 2016 6:07 pm
by ajcosta
Amos,

Just rolled back to 3.0.1.8 and realised I have the same problema in this version.

Will have to do some more troubleshooting.

Sorry for taking your time.

AJ

Re: upgrade to 3.1 error

Posted: Tue Oct 04, 2016 6:41 pm
by amosbatto
Yes, the password change might cause problems when upgrading, if the password didn't get updated in the processmaker/shared/sites/workflow/db.php file. Try changing back to the old password and see if it works. You also might try this: http://wiki.processmaker.com/3.0/Changi ... r_then_2.0

Re: upgrade to 3.1 error

Posted: Thu Oct 06, 2016 6:26 am
by ajcosta
Hi Amos,

Just found the cause of my problem.
Had to DROP the CONTENT_BACKUP table and that did the trick.

Thanks

AJ