ProcessMaker Forum | BPM Workflow Simplified

amosbatto wrote:Go to Admin > Settings > Case List Cache Builder and click on the "Build Cache" button.

If that doesn't solve the problem, then go to the command line of your server and change to the directory where PM is installed and do the upgrade and rebuild the APP_CACHE_VIEW table. For example, in Linux:
cd /opt/processmaker
php processmaker upgrade --buildACV

See: http://wiki.processmaker.com/processmak ... nd#upgrade

amosbatto wrote:Run these two commands:

Code: Select all

cd /opt/processmaker
php processmaker database-verify-consistency 
php processmaker database-verify-migration-consistency

What is the output of those two commands?

What version of ProcessMaker are you using?
If PM 3.1 or later, then run this command:
php processmaker migrate-content

amosbatto wrote:Run these two commands:

Code: Select all

cd /opt/processmaker
php processmaker database-verify-consistency 
php processmaker database-verify-migration-consistency

What is the output of those two commands?

What version of ProcessMaker are you using?
If PM 3.1 or later, then run this command:
php processmaker migrate-content

amosbatto wrote:What do you mean by "upgrade"? Did you export the workspace from version 3.0.8 and then import it into version 3.2.1? If you did that, then you will probably see problems. Did you try to use the database from 3.0.8 in version 3.2.1. Again, you will probably see problems.

Explain exactly how you upgraded.

amosbatto wrote:If you did a clean install of PM 3.2.1, and you are using a new /shared directory and a new database, then you should not have these problems.
Your errors say that you have network problems because something in your network changed. Did you change your IP number, port number or proxy server and did you use an IP number, port or proxy when configuring ProcessMaker?

$CASENO = @@M01;
$CTIC = @@M02;
$CDESC = @@M03;
$result = executeQuery("UPDATE PMT_CUSTOMER SET CTIC='$CTIC',CDESC='$CDESC'  WHERE CASENO='$CASENO'");

amosbatto wrote:Try using this code:

Code: Select all

]$CASENO = mysql_real_escape_string(@@M01);
$CTIC = mysql_real_escape_string(@@M02);
$CDESC = mysql_real_escape_string(@@M03);
$result = executeQuery("UPDATE PMT_CUSTOMER SET CTIC='$CTIC',CDESC='$CDESC'  WHERE CASENO='$CASENO'");

If that doesn't work, then try:

Code: Select all

$CASENO = mysql_real_escape_string(@@M01);
$CTIC = mysql_real_escape_string(@@M02);
$CDESC = mysql_real_escape_string(@@M03);
$result = executeQuery("UPDATE PMT_CUSTOMER SET CTIC=\"$CTIC\",CDESC=\"$CDESC\" WHERE CASENO=\"$CASENO\"");

This should also protect you from SQL code injection attacks.

Farmhouse ve fizy için promosyon sipariş söz konusu(125000-150000 m2 arası) özel fiyat verildi. nirvana, ageless, plush,retro overloklu olarak üretilecek. Farmhouse, fizy ve illusion yapıştırma yapılacak.

amosbatto wrote:I wonder if executeQuery() is truncating at 256 characters. You need to turn on MySQL query log and look at the SQL query in the log file to see if it is being cut short.
See: https://stackoverflow.com/questions/647 ... -query-log

18 Query SELECT TRIGGERS.TRI_UID, TRIGGERS.TRI_TITLE, STEP_TRIGGER.ST_CONDITION, TRIGGERS.TRI_TYPE, TRIGGERS.TRI_WEBBOT FROM STEP_TRIGGER LEFT JOIN TRIGGERS ON (STEP_TRIGGER.TRI_UID=TRIGGERS.TRI_UID) WHERE STEP_TRIGGER.STEP_UID='6140747075a16c864917b41027221335' AND STEP_TRIGGER.TAS_UID='6036682125a166614276544010043922' AND STEP_TRIGGER.ST_TYPE='AFTER' ORDER BY STEP_TRIGGER.ST_POSITION ASC
18 Query SET AUTOCOMMIT=0
18 Query BEGIN

amosbatto wrote:Also, in your workflow/engine/config/execute-query-blacklist.ini file, change the line from:

Code: Select all

queries  = "INSERT|UPDATE|REPLACE|DELETE|TRUNCATE"

To:

Code: Select all

queries  = "INSERT|REPLACE|DELETE|TRUNCATE"

See: http://wiki.processmaker.com/3.0/Consul ... ore_Tables

Another thing to try is to change from varchar to longvarchar fields in your PM Table. If I recall correctly, PM was limiting varchar fields to 256 characters in some of the older versions of PM.

queries  = "INSERT|UPDATE|REPLACE|DELETE"

<200> Jan 19 10:50:39 sqlExecution INFO: Sql Execution {"ip":"::1","timeZone":"2018-01-19 10:01:39","workspace":"workflow","action":"execute-query","sql":"UPDATE PMT_CUSTOMER SET MUSTERIYORUM=\"Farmhouse ve fizy için promosyon sipariş söz konusu(125000-150000 m2 arası) özel fiyat verildi. nirvana, ageless, plush,retro overloklu olarak üretilecek. Farmhouse, fizy v\" WHERE CASENO=\"925\""} {"file":"C:\\opt\\processmaker\\gulliver\\system\\class.monologProvider.php","line":99,"class":"MonologProvider","function":"addLog"}