LG G4 Screen goes black during a call – after screen replacement

So I bought new LG G4 phones for my wife and I.  They were the new leather-backed model.  Seemed nice.  Be careful – the leather does not protect from a fall at all.  I had mine for  about 3 hours when it fell off my desk and cracked. This thing is light and fragile.  Before you leave the store buy an Otterbox and screen protector.  Assuming you didn’t……..

I bought a new screen and digitizer off of ebay from FlashtecLLC.  It came quick and then I made a discovery:  ALWAYS BUT THE ONE WITH THE BEZEL.  It will save you lots of trouble.   So, I contacted them and sent back and bought the one with the bezel (also from them).

Last night I installed. it I had to watch several videos to get it right.  None of them, however, mentioned that there are 2 little plastic pieces on the top of your old screen that may not be in your replacement (they weren’t in mine.).

One of them has 2 little holes – it is for the proximity sensor.  With out it it the sensor is near sighted and thinks the proximity is always 0 CM – meaning the phone thinks it is up against your ear so it blacks out the screen,  What’s the big deal? Well once the call is connected the screen goes blank and no amount of pressing buttons gets it back until the call is disconnected.  If you get a voice mail box you have to wait till it hangs up on you till your phone is usable again.


These are the things you need to transfer from the old screen.
These are the things you need to transfer from the old screen.


Good luck.  Watch lots of videos before you do it.  I think I opened mine up about 10 times before I found these little doodads.


Classic ASP on Windows 7, IIS 7 is SLOW!

So I have this show web app thingy that runs local. Put it on a new laptop and it ran like a dog. After sorting out the installation of classic ASP, tweaking the recycling, permissions, timeouts and everything else – I finally remembered: SQL initially uses named piped and shared memory. These sound neat and fast but they are BOFFO.

1: Edit your hosts file and add localhost
2: Go to SQL Configuration Tool, Interfaces and get rid of named pipes and shared memory.

There you go – instant fast IIS on Windows 7 with SQL 2008.

New Book – MySQL and PHP – an introduction – Now with Real World Examples!

When I am learning something I get pretty discouraged by the books available. They are too long and too damned expensive. I will buy a 400 page book for 50 bucks and read the 30 pages I need. So, I wrote an e-book called MySQL and PHP an Introduction and published it on Amazon (Link here). It is 9.99, about 60 pages and comes with a complete web application. I just today added some real world examples. It demonstrates how to do things like sub queries, in clauses, not in clauses and when they are useful.

Click here to view the samples and working web application.

mysqlimport – can’t get stat of file

So on my server here I have a process that ftps some data from a SQL server and loads it to MySQL. All was well until I got:
Can’t get stat of ‘/home/username/www/data’ (Errcode: 13)

I tried chmod and chown and running the file as root and everything. No success. I then found a post that said – move the file to /tmp. So I tried it and it worked! Here are my scripts.

Please note – you will have to add a user to mysql that has import permissions!


truncate table equipment_in;

LOAD DATA INFILE ‘/tmp/equipment.csv’
INTO TABLE equipment_in


cd /tmp
rm *.csv*
wget ftp://username:password@servername/*.csv
mysql –user=username –password=thepassword databasename < /folder/with/the/sql

MySQL Documents

SEO and You

So you are thinking you need the services of an SEO (Search Engine Optimization) company. My experience with them so far is less than stellar. They seem to be good at using lots of words and “exciting phrases of the day”. Here are the basics that cover 95% of SEO:

1: Page Titles should be descriptive.
2: Description meta tag should be complete. When you do a google search and see a paragraph under the result, that comes from the description.
3: Keywords meta tag should be complete.
4: Important words in your content should be bold or strong.
5. Use H1, H2 and H3 tags to identify page sections.

Finally, If you are a member of a trade group or organization in your field, link to their pages. Ask if they will link back. If your site has lots of information about “Bees” that is great. If it also links to other pages about “Bees” that is better. If other sites dealing with “Bees” link back to you, that is best.


Lockboxdata.com – secure, online stuff

So a while ago – in fact years ago – I had this idea. I thought, “what happens if something happens to me or my house?” I mean, would my wife know the username and password to my business account? Where the life insurance is? What we need is an online lockbox to save this stuff. So – I wrote Lockboxdata.com. It does all that and more. You can share documents safely and keep all sorts of records. The data is all encrypted and each account has it’s own key.

Anyway – if you want to use it – use the code LBOXWELCOME for a free account.


Geeks and Message Boards

When I go to a message board and ask something like, “how do I limit port 3306 to one computer using iptables?” and you know the answer, please just answer the damned question. I know you have it in your iptables config file. It is probably simple. Don’t point us to a website on iptables (we already found that and said, “WTF?”. Copy the lines in question and post them.

Some of us like to go outside. We want to get the answer and use it. We do not want to understand every technology like you do. The ones we use all the time we’ll master. These other things – no chance.

Then there are the, “oh – a newbie question – what goes in the newbie section” responses. You know what? Bite me. Once again we are trying to solve a problem. Answers like that do not help. They piss us off.

There. I said it. I will probably loose my geek membership card but that’s okay with me.

by the way – here is the answer that worked for me:

/sbin/iptables -A INPUT -i eth0 -p tcp --dport mysql -j DROP
/sbin/iptables -A INPUT -i eth0 -p udp --dport mysql -j DROP
/sbin/iptables -I INPUT -i eth0 -p tcp -s --dport mysql -j ACCEPT
/sbin/iptables -I INPUT -i eth0 -p udp -s --dport mysql -j ACCEPT

just replace with the ip you need to allow

Disconnected Recordsets in ASP

I am a huge fan of disconnected recordsets especially when we are displaying reports or any other database driven content on a web page. Once the data is returned to the recordset object, why maintain a connection to the database? Let it go do database things and let the web server play with the data. Here is my function. I call it getrs() because I am lazy. Most of it I copied from somewhere. I also assumes you have an open global database connection called db and a table called SQLError (for logging purposes).

Function GetRS(strSQL)

Const adOpenStatic = 3
Const adUseClient = 3
Const adLockBatchOptimistic = 4

Dim oRS
Set oRS = Server.CreateObject("ADODB.Recordset")
oRS.CursorLocation = adUseClient
on error resume next
oRS.Open strSQL, db, adOpenStatic, adLockBatchOptimistic
if err <> 0 then
dim rsx
set rsx=server.CreateObject("adodb.recordset")
rsx.open "select * from sqlerror where 1=2",db,3,2
set rsx=nothing
response.write "Your request created a system error. The error has been logged. Please make sure any fields you entered are the correct data types. "
end if
Set oRS.ActiveConnection = Nothing
Set GetRS = oRS
End Function

And you use it like this:

set rs=getrs("select username from users")
while not rs.eof
response.write rs("username") & "<br>"

It is simple and makes reading your code pretty damned easy. An added benefit is that you can move to the end of the recordset with rs.movelast and then move to the first with rs.movefirst as often as you’d like.

Android Text Messaging and the Damned Small Fonts

So – you can’t change the font settings on android phones. Stupid. Some of us have passed the big four oh and can’t see good any more. What’s my solution?

Download Handcent. It has a bazillion options – including fonts, colors, themes and it is free. It does have some ads in the admin section and i’d be happy to pay a buck or three to use this software. So far, I like it.