Conclusion: Email Inspector  is unable to determine whether an e-mail address is valid or not.

Problem: after stating the game Hue, music can be heard, but the screen stays blank (black colour). Then the game crashes. Log file shows:-

D3D shader create error for vertex shader [0x887a0005]
D3D shader create error for pixel shader [0x887a0005]
WARNING: Shader Unsupported: ‘Custom/CutoutShader’ – Pass ” has no vertex shader
WARNING: Shader Unsupported: ‘Custom/CutoutShader’ – Setting to default shader.
d3d11: failed to create 2D texture id=94 w=128 h=256 mips=1 d3dfmt=77 [887a0005]
d3d11: failed to create 2D texture view id=94 [80070057]
…

D3D shader create error for vertex shader [0x887a0005]
D3D shader create error for pixel shader [0x887a0005]
WARNING: Shader Unsupported: ‘Custom/Unlit Single Color’ – Pass ” has no vertex shader
WARNING: Shader Unsupported: ‘Custom/Unlit Single Color’ – Setting to default shader.
d3d11: failed to create 2D texture id=104 w=128 h=128 mips=8 d3dfmt=77 [887a0005]
d3d11: failed to create 2D texture view id=104 [80070057]
D3D shader create error for vertex shader [0x887a0005]
D3D shader create error for pixel shader [0x887a0005]
WARNING: Shader Unsupported: ‘Unlit/Transparent’ – Pass ” has no vertex shader
WARNING: Shader Unsupported: ‘Unlit/Transparent’ – Setting to default shader.
d3d11: failed to create 2D texture id=106 w=204 h=343 mips=1 d3dfmt=28 [887a0005]
d3d11: failed to create 2D texture view id=106 [80070057]
…

d3d11: attempt to lock null vertex buffer
d3d11: attempt to lock null index buffer
Unloading 6 Unused Serialized files (Serialized files now loaded: 0)
d3d11: failed to create 2D texture id=562 w=40 h=91 mips=1 d3dfmt=28 [887a0005]
d3d11: failed to create 2D texture view id=562 [80070057]
D3D shader create error for vertex shader [0x887a0005]
D3D shader create error for pixel shader [0x887a0005]
WARNING: Shader Unsupported: ‘Mobile/Particles/Alpha Blended’ – Pass ” has no vertex shader
WARNING: Shader Unsupported: ‘Mobile/Particles/Alpha Blended’ – Setting to default shader.
d3d11: failed to create 2D texture id=564 w=2048 h=2048 mips=1 d3dfmt=77 [887a0005]
d3d11: failed to create 2D texture view id=564 [80070057]
d3d11: failed to create 2D texture id=566 w=2048 h=2048 mips=1 d3dfmt=77 [887a0005]
d3d11: failed to create 2D texture view id=566 [80070057]
UnloadTime: 2.002275 ms

Unloading 10 unused Assets to reduce memory usage. Loaded Objects now: 21250.
Total: 28.089157 ms (FindLiveObjects: 0.868564 ms CreateObjectMapping: 0.596149 ms MarkObjects: 26.562433 ms DeleteObjects: 0.061582 ms)

d3d11: failed to create vertex buffer of size 12240 [0x887A0005]
d3d11: failed to create index buffer of size 612 [0x887A0005]
d3d11: attempt to lock null vertex buffer
d3d11: attempt to lock null index buffer
d3d11: failed to create vertex buffer of size 5280 [0x887A0005]
d3d11: failed to create index buffer of size 264 [0x887A0005]
d3d11: attempt to lock null vertex buffer
d3d11: attempt to lock null index buffer
d3d11: failed to create vertex buffer of size 4194304 [0x887A0005]
d3d11: failed to create vertex buffer of size 4194304 [0x887A0005]
Crash!!!

Solution: run the game using “Integrated graphics” instead of “NVIDA” by setting it in NVIDIA Control Panel -> Manage 3D Settings.

Problem:  after upgrading NVIDA driver from v. 445.87 to v. 456.38, Epic Games Laucher cannot be opened or started, it keeps opening then close, mouse could be blinking.

Solution:  right click on the Epic Games Launcher -> Run with graphics processor -> Integrated graphics

Other Solutions:-

1. Epic Games Launcher displays incorrectly or appears blank
2. Epic Games Launcher Not Working? Here Are 4 Solutions

Problem: In “Stock Card” table, it records the stock movement, “In” and “Out”  of each item (ITEM ID).  There are different items that belongs to same group (GROUP).  And there are many groups (GROUP).

How to get the sum (TOTAL BALANCE) of each group as below?

Solution: using this SQL statement

SELECT `Group`,
(SELECT COUNT(Stock_Description.`Group`) FROM Stock_Description WHERE Stock_Description.`Group` = sd.`Group`) As `TOTAL RECORDS`,
(SELECT SUM(COALESCE(a.`IN`,0) – COALESCE(a.`OUT`,0)) FROM Stock_Card a WHERE a.Item_ID LIKE CONCAT(sd.`Group, ‘%’) AND a.Balance IS NOT NULL) AS `TOTAL BALANCE` FROM Stock_Description sd GROUP BY `Group`;

SELECT SUM(COALESCE(a.`IN`,0) – COALESCE(a.`OUT`,0)) FROM Stock_Card a WHERE a.Item_ID LIKE CONCAT(sd.`Group`, ‘%’) AND a.Balance IS NOT NULL) AS Total_Balance

the above SQL statement will display  a “TOTAL BALANCE” of each “GROUP” by:-

• summing all “In” records of “EKONOR” minus the sum of all “Out” of EKONOR”
  • (20 + 40) – (10 + 10 + 20)
  • = 20
• summing all “In” records of “SAGA” minus the sum of all “Out” of  “SAGA”
  • (10 + 5 + 10 + 10) – (5 + 20)
  • = 10

SELECT COUNT(Stock_Description.`Group`) FROM Stock_Description WHERE Stock_Description.`Group` = sd.`Group`) As `TOTAL RECORDS`

the above SQL statement will display  a “TOTAL RECORDS” of each “GROUP” by:-

• summing all records in “EKONOR” group
• summing all records in “SAGA” group

Source:-

• COALESCE MySQL function — https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-ver15
• CONCAT MySQL function — https://www.w3resource.com/mysql/string-functions/mysql-concat-function.php

Spammer or hacker will always change the e-mail address to avoid being flag as spam based on the sender’s e-mail address.

Solution: block the SMTP domain of spammer or hacker by using “Global Email Filters” tool in cPanel

1. Goto “Global Email Filters”
2. Click “Edit” on “Block E-mail Based on Header”
   
3. Click on “+” button to add a new entry
   
4. Change to “Any Header” and enter the header information that will be blocked by mail server and will be diverted to spam folder
   
5. Finally, click “Save” button