Category Archives: PHPRunner

How to Edit Landing Page (HTML File) Without Using PHPRunner

Applies to: PHPRunner version 10.4

Problem: the landing page — https://sot.sweetco.com.my/v.4.0/menu.php shows descriptions:-

 

If I want to edit the description, e.g. “Sot description”  change to “This form is to be filled by sales department” without using PHPRunner, how should I do it?

 

Solution: edit the file “.global_menu.htm”:

  1. Open “<Parent folder>/output/templates/.global_menu.htm” in Notepad++.
  2. Find the menu title, e.g: “Sales Order Tracking”. Go to “bs-welcome-content” <div> under the menu title <div>, change the text.
  3. Save the file and upload it to web server in the same path as where it is located in the local.
  4. Then reload the page.

Where Does PHPRunner Store the Database Settings?

PHPRunner version 10.x : ConnectionManager.php

 

protected function _setConnectionsData()
{
// content of this function can be modified on demo account
// variable names $data and $connectionsData are important

$connectionsData = array();

$data = array();
$data["dbType"] = 0;
$data["connId"] = "Tables";
$data["connName"] = "crm2017 at 00.00.00.00";
$data["connStringType"] = "mysql";
$data["connectionString"] = "mysql;00.00.00.00;crm;scale-UP;;crm2017;;1"; //currently unused

$this->_connectionsIdByName["crm2017 at 00.00.00.00"] = "Tables";

$data["connInfo"] = array();
$data["ODBCUID"] = "crm";
$data["ODBCPWD"] = "scale-UP";
$data["leftWrap"] = "`";
$data["rightWrap"] = "`";

$data["DBPath"] = "db"; //currently unused 
$data["useServerMapPath"] = 1; //currently unused

$data["connInfo"][0] = "00.00.00.00";
$data["connInfo"][1] = "crm";
$data["connInfo"][2] = "scale-UP";
$data["connInfo"][3] = "";
$data["connInfo"][4] = "crm2017";
$data["connInfo"][5] = ""; //currently unused
$data["connInfo"][6] = "1"; //currently unused
$data["ODBCString"] = "DRIVER={MySQL ODBC 5.1 Driver};Server=00.00.00.00;Uid=crm;Pwd=scale-UP;Database=crm2017;OPTION=3";
// encription set
$data["EncryptInfo"] = array();
$data["EncryptInfo"]["mode"] = 0;
$data["EncryptInfo"]["alg"] = 128;
$data["EncryptInfo"]["key"] = "";

$connectionsData["Tables"] = $data;
$this->_connectionsData = $connectionsData;
}

 

How to Solve “MySQL server has gone away” in PHPRunner?

Problem: when viewing in browser with URL “http://localhost:8086/menu.php”, this error message will appear — “Fatal error: MySQL server has gone away in C:\Users\Documents\PHPRunnerProjects\Stock Control\output\connections\Connection.php on line 626” .

 

Applies To: PHPRunner v. 10. 4

 

Cause: problem will appear when SSL Connection is selected.

 

Solution: uncheck “SSL connection”.

How to Solve “Unable to open database file” in PHPRunner

Problem: PHPRunner v.10 unable to open project files created using PHPRunner v. 5 with this error message …

 

TROUBLE SHOOTING

SOLUTION
 SOLVED?
Edit the “.phpr” file created by PHPRunner v. 5, change  the database connection variables. No.
Use PHPRunner v. 5 to re-build PHP files and update the “.phpr” with correct database settings. No.
Use PHPRunner v. 6.2 to re-build PHP files and update the “.phpr” created by PHPRunner v. 5 in above.

PHP v. 6.2 is able to open “.phpr” file created by v. 5.

 No. PHPRunner v. 10 us unable to open the “.phpr” file created by v. 6.2.
Use PHPRunner v. 10 to create a new project and connect to MySQL database server. Open the “.phpr” file to review the connection string. No because “.phpr” structure is different between PHPRunner v. 10 and v. 5
Use PHPRunner v. 8 to open “CRM.phpr”, re-build PHP files and update the “.phpr” created by PHPRunner v. 5 in above. Yes. PHPRunner v. 10 is able to open “.phpr” file created by v.8.

 

Conclusion: PHPRunner v. 10 cannot open project files created by PHPRunner v. 7 and earlier.

Solution: use PHPRunner v. 8 to  re-build project file created by earlier version of PHPRunner, then use v. 10 to open project files created by PHPRunner v.8.

NOTE

  1. PHP files generated by PHPRunner v. 5, 6, 7, 8 will have error message “mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead” when uploaded to crm.mobiteks80.com as they are NOT using “mysqli”.