Posts

Showing posts from September, 2018

Fixed Westinghouse Refrigerator WR4300WB NOT DEFROSTING & COOLING

Image
I've been trying to find out the problem on my refrigerator since last year when it stopped cooling and there was a layer of ice built up on the lower panel near the vegetable drawer. I tried to unplug the refrigerator and waited for a couple of days or more (in winter) to let the ice melt and it would be back to normal for a few months before the problem reoccurred. After researching on YouTube, I found out ways to test the refrigerator components as follows: Unplug the refrigerator power. Remove two screws from the bottom panel (on top of vegetable/fruit drawer). Remove a round plastic plug on the panel with a flat screw driver in order to enable you to pull the whole panel out using a finger. Unplug three plastic connectors (fan, thermostat defrost termination, defrost heating element). While the refrigerator is still cold, use ohm meter to check the resistance of the three components while unplug and all should show the following normal resistance: Fan: around

How to extract Infinity Intelledox Log using SQL statement

A few weeks ago I was researching for ways to extract Management Log | View Details on Infinity Intelledox Version 9 and Version 10 to analyse failed actions (CRM, BPOINT, REST) and finally found the following SQL statement that saved my day. Hopefully it will save yours too... Cheers... SELECT datetime_start as 'Start Date', iu.Username as 'User', t.Name as 'Project', messages.value('(Messages/Message/@Description)[1]','varchar(max)') as Message FROM dbo.template_log tl join dbo.Intelledox_User iu on tl.User_ID = iu.User_ID join dbo.Template_Group tg on tl.Template_Group_ID = tg.Template_Group_ID join dbo.Template t on tg.Template_Guid=t.Template_Guid WHERE messages.value('(Messages/Message/@Description)[1]','varchar(max)') is not null UNION SELECT  datetime_start as 'Start Date', iu.Username as 'User', t.Name as 'Project', messages.value('(Messages/Message/@Description)[2]','varchar(m

Google Bookmarks - Edit and Remove links not working and how to work around it

Image
When I clicked Edit or Remove links on my Google Bookmarks, nothing happened. I realised there's an error on the browser console when loading https://www.google. com.au /bookmarks To work around the problem, I changed the address to https://www.google. com /bookmarks and the problem went away. In case you encounter similar problem, I hope this article will help you. Have a good day everyone!