Learn and Share

/********************************************************************************/ /* TITLE : How to solve the issue secure-file-priv in processmaker /* DESCRIPTION : To Get the secure-file-priv in processmaker /* CREATED BY   : Jemiris Selvi S /* CREATED ON : 12-June-2017 /* MODIFIED BY : Jemiris Selvi S /* MODIFIED ON : 12-June-2017 /********************************************************************************/ Step:1 ------- open the mysql directory : <INSTALLATION-DIRECTORY>\Proceess Maker 3.2\mysql Step: 2 -------- Open the my.ini file and if the line exists put empty string else insert this line secure-file-priv = "" Step: 3 --------- Save and Run a service

/*******************************************************************************/ /* TITLE : Backing up PM 3.0 workspace in windows /* DESCRIPTION : To Backing up Process Maker 3.0 workspace in windows /* CREATED BY   : Jemiris Selvi S /* CREATED ON : 12-June-2017 /* MODIFIED BY : Jemiris Selvi S /* MODIFIED ON : 12-June-2017 /*******************************************************************************/ Step : 1 --------- C:\Bitnami\processmaker-3.0.1.8-0\apps\processmaker\htdocs ********************************************************************************* Step : 2 --------- processmaker.bat workspace-backup workflow ********************************************************************************* C:\Bitnami\processmaker-3.1-1\apps\processmaker\htdocs>processmaker.bat workspace-backup workflow 'stty' is not recognized as an internal or external command, operable program or batch file. Backing up to C:\Bitnami\processmaker-...

The Port condifuration of XAMPP : Here is the solution step-by-step: Open up  httpd-ssl.conf  in  path2xampp\apache\conf\extra Look for the line  Listen 443 Change port number to anything you want. I use  4430 . ex.  Listen 4430 . Replace every  443  string in that file with  4430 . Save the file.

In every scenario, the date functions and calculations are more import and effective way to have it. Here I used to get the correct and notice date as an example.  I'm just converting the DateTime to the temp value and stored in a variable. Then I go for the calculation the differences of the dates (i.e). The current date and notice date /*  *@ TO Get the Date Difference of the Current_date and FirstNoticeDate *@ Param Current_date, FirstNoticeDate. *@ Return Due Days */ function Days_Different($current_date, $notice_date) { //To Change the Date Format to StringtoTime: $temp_current_date = strtotime($current_date); $temp_notice = strtotime($notice_date);   // Calculate the Date Difference for the Days   $days_difference = (($temp_current_date - $temp_notice) / (60*60*24));   return $days_difference; } Reference : http://stackoverflow.com/questions/2040560/finding-the-number-of-days-between-two-dates

/********************************************************************************/ /* TITLE :  Invalid arguments passed in php /* DESCRIPTION :  To Solve the Invalid arguments passed in php /* CREATED BY   :  Jemiris Selvi S /* CREATED ON :  24-May-2017 /* MODIFIED BY :  Jemiris Selvi S /* MODIFIED ON :  24-May-2017 /********************************************************************************/ Problem :   implode() invalid arguments passed in php Answer : //Need Initialize an Array while parsing in the parameter. $condition  =  array(); $finalcondition = implode(' AND ',$condition);

/******************************************************************************/ /* TITLE : Sub Query /* DESCRIPTION     : To Get the Multiple Values in a Diffent or Same Table /* CREATED BY   : Jemiris Selvi S /* CREATED ON : 23-May-2017 /* MODIFIED BY : Jemiris Selvi S /* MODIFIED ON : 23-May-2017 /******************************************************************************/ Example: SELECT municipality,        municipality_label                 AS COUNTY,        Count(*)                           AS PURCHASED,        ( Sum(CASE lrf_redeemed                WHEN '1' THEN 1                ELSE 0              END) )   ...

Deleting a Windows Service The first thing you’ll need to do is identify the name of the service, so open up Services through the start menu or control panel, and then find the service in the list that you want to delete. If you can’t figure out how to open it, use WIN + R and type in  services.msc. You’ll want to open up the properties by double-clicking on the service name, and then highlight the “Service name” value and copy it to the clipboard. This is what we’ll need to disable it. You’ll need to open up a command prompt, and if you are using Windows 7, Windows 8, Windows 10, or Vista you’ll need to right-click the command prompt and choose Run as Administrator. We’ll use the sc command to actually do the work. The syntax used to delete a service is this: sc delete ServiceName If your service name has spaces in it, you’ll need to wrap the service name in quotes, like this: sc delete “Adobe LM Service” Note that I’m not recommending deleting this par...