Different Grid Type in PHPRunner

  1. The difference of grid type as shown in table below.
  2. There is no difference between “advance” and “simple” in terms of web UI. The difference is in the “Designer” tab of PHPRunner.
    GRID TYPE

    		 WEB UI
    horizontal grid
    vertical grid
    columns

Renaming Column Name will Affect PHPRunner

If column name is renamed via PHPMyAdmin or PHPRunner, the records will be missing from the list page (tellow table) despite there are 3528 records:-

 

The following solutions DOES NOT work:-

  1. Remove all fields in stock card’s list page and add them all again.
  2. Delete current list page and add a new list page.
  3. Remove the table and add it again.

 

The only solution is to re-build the PHP project from scratch.

The possible root cause is the PHP project was built using old version (e.g. version 10.3) or trial version of PHPRunner. Then column name is renamed in the new version of PHPRunner, e.g. version 10.4.

SOP of Resetting Windows 10 for Acer Nitro 5

Resetting also refers to reinstalling.

  1. There are few ways to reset:-
    1. via cloud
    2. using local disk
    3. using recovery media/drive which is a USB thumb drive created via Windows 10
    4. goto https://www.microsoft.com/en-au/software-download/windows10 to create Windows 10 installation media; download “MediaCreationTool21H2.exe”, run it, downlaod download a Windows 10 installer into USB thumb drive
  2. Acer Nitro 5 fail to reset using method (a), (b), (c),  so need to use method (d).
  3. After Windows 10 is installed, avoid using Microsoft account to log into Windows.
  4. Rename PC, joing “MOBITEK” workgroup.
  5. Map “U:\” to “Usefule Software” network drive.
  6. Install the 3 Acer applications:-
    1. Care Center
    2. Nitrosense
    3. Quick Access
  7. Create a restore point.
  8. Run Windows Update to update all updates.
  9. Create a restore point if necessary.
  10. Reinstall applications and drivers:-
    • AnyDesk v. 5.3;
    • Classic Shell;
    • FreeCommander;
    • Intel via Intel-Driver-Support-Assistant (create a restore point after this);
    • from Acer Support
    • NVIDIA via GeForce Experience (create a restore point after this);
  11. Run System Image to create a system image of:-
    • newly installed Windows 10;
    • drivers installed;
    • essential software installed; and
    • Windows updated.
  12. Reinstall software as per “Remove Applications.html” generatged by Geek Uninstaller.
  13. Optional:-
    • create a recovery drive/media using USB thumb drive;
    • create a password reset key using USB thumb drive;

How to Remove Space using SQL Statement

Problem: there are leading space and trailing space in the records.

  • leading space
  • trailing space

 

Solution: to remove leading space, e.g. ” EKONOR-25M”, use

UPDATE `Stock_Card-20220218` SET `Item_ID`=TRIM(`Item_ID`) WHERE `Item_ID` LIKE '% ';
BEFORE AFTER

 

Solution: to remove trailing space, e.g. “EKONOR-25M “, SQL statement (“Trim”, “Rtrim”, “Replace”) CANNOT be used. The only way is to delete it manually.