Page 1 of 1

Mail Problem When Installing PM Manually on Windows Server 2

Posted: Tue Oct 27, 2015 5:16 am
by scheros
Hi There..

I was hoping that someone could help me on the problem that I had installing PM 3.0.1.5 manually on Windows server 2012. FYI, i manually install the php, apache and mysql as well. The problem is with email, up till login in to smtp server (smtp.gmail.com) was ok, but sending gives me the below error meaase:

"Resolving Host Name: smtp.gmail.com
Checking port: 465
Establishing connection to host: smtp.gmail.com:465
Login as: [email protected] On smtp.gmail.com SMTP Server
Sending a test mail to: [email protected]
Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Table 'wf_workflow.app_message' doesn't exist] [User Info: INSERT INTO APP_MESSAGE (`APP_MSG_UID`,`MSG_UID`,`APP_UID`,`DEL_INDEX`,`APP_MSG_TYPE`,`APP_MSG_SUBJECT`,`APP_MSG_FROM`,`APP_MSG_TO`,`APP_MSG_BODY`,`APP_MSG_DATE`,`APP_MSG_CC`,`APP_MSG_BCC`,`APP_MSG_TEMPLATE`,`APP_MSG_STATUS`,`APP_MSG_ATTACH`,`APP_MSG_SEND_DATE`,`APP_MSG_SHOW_MESSAGE`,`APP_MSG_ERROR`) VALUES ('457153320562f3bdbd8a5f3006981285','','',0,'TEST','Test Email','GP-Test ','[email protected]','\n \n \n \n \n \n \n \n \n \n \n \n
\n \n
\n ProcessMaker Test Email [04:54:51] - SMTP (PHPMailer)\n
\n
\n
\n This Business Process is powered by ProcessMaker ver. 3.0.1.5-community.\n
\n www.processmaker.com \n
\n
','2015-10-27 04:54:51','','','','pending','a:1:{i:0;s:0:\"\";}','2015-10-27 04:54:51',1,'')]]


I noticed there was a bug trace reported on this issue but i failed to find any resolution on the problem. Would greatly appreciate any feedback, thanks.

Re: Mail Problem When Installing PM Manually on Windows Server 2

Posted: Tue Dec 10, 2019 10:15 am
by dan123dan
Hi.

if you are installing ProcessMaker 3.0.x make sure that you're installing
>> PHP 5.5
>> Apache 2.4
>> Mysql 5.5

If you're using other stack this can cause some issues. Because each version of ProcessMaker has been tested with their stacks.

If you're using MySql 5.6 make sure to disable sql_mode

You can use the following query:

>> SET GLOBAL sql_mode = '';

Re: Mail Problem When Installing PM Manually on Windows Server 2

Posted: Thu Dec 12, 2019 10:16 am
by programerboy
Hi,

You get this error:
Native Error: Table 'wf_workflow.app_message' doesn't exist

Please check if your main database has APP_MESSAGE table?

https://www.youtube.com/channel/UCYiyz1 ... 1iw/videos
Thanks

Re: Mail Problem When Installing PM Manually on Windows Server 2

Posted: Fri Mar 13, 2020 9:41 am
by iosman987
i upgraded from 2.0.44 to 2.0.45, and i using windows server 64 bit
i tried to install the https://www.krogerfeedback.nl/ fresh installation https://talktosonic.onl/ of version 2.0.45 on anther server https://talktowendys.vip/ that problem not available , So the problem happens Specifically after upgrading to 2.0.45 !
i tried to delete /opt/processmaker/shared/compiled , but that not solved the problem !

Re: Mail Problem When Installing PM Manually on Windows Server 2

Posted: Fri Mar 13, 2020 11:44 am
by programerboy
Hi,
You get this error because your main database doesn't have app_message table after your upgrade.
You have error in your upgrade or your upgrade didn't execute completely.

Please export app_message table structure from your new installation and import it in your current database.

https://www.youtube.com/channel/UCYiyz1y8Qf4EZjMXodwH1iw/videos
https://www.linkedin.com/in/pmlearning/
Thanks