[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: xxxr@gmail.com On smtp.gmail.com SMTP Server
Sending a test mail to: xxx@gmail.com
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 ','safian.cheros@greenpacket.com','\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.

[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 = '';

[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://pmlearning.info
Thanks

[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 !

[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://pmlearning.info
Thanks

[petergroft]

Cannot send emails: How to fix email sending issues
Check your internet connection.
Check your SMTP server details.
Verify all usernames and passwords.
Check your SMTP server connection.
Change your SMTP port.
Control your antivirus or firewall settings.

This May Work,
Peter