Web Development

Windows and Linux-based Web development: PHP – Node,js – ASP.NET – C#
IIS – Apache / Visual Studio – Atom – Notepad++

ERROR: Unreadable CAPTCHA cookie – RESOLVED!

2017/08/07
By
Modified: 2017/06/25
WordPress -  Unreadable CAPTCHA cookie

RESOLVED!  One of the test WordPress instances had an impossible, unpleasant and not covered on Google error message.  When user is trying to register, the CAPTCHA code is displayed properly and validation is correct, but when the button Register is press, the page would display this: ERROR: Unreadable CAPTCHA cookie I have a plugin “SI CAPTCHA Anti-Spam” installed.  The error message is from this plugin. I’ve tried changing browsers, clear cache and cookies. Nothing worked.  No luck on Internet search either.  What to do? Finally I changed one of the settings on the plugin itself.  I check an option for: Use CAPTCHA without PHP session And it worked!  The error message…

Read more »


MySQL: Fantastic adventures – WordPress users and their roles

2017/08/05
By
Modified: 2017/06/25
MySQL: Fantastic adventures – WordPress users and their roles

This was exciting. After years of neglect, I have decided to examine, who is registering on my WordPress site, and what is that they are doing. I knew that most of them are just a result of robot activities, and they are just a dead weight in the database (useless users). However, what about the active users, who post in forums, and leave comments, and return regularly? Let me identify and cherish those. I knew I needed a monstrous SQL statement to link several files, and to count various record types, and sort all this in alphabetic order. So the plan was to learn the WordPress (WP) table structure, to start…

Read more »

Can I debug PHP site on IIS? – Yes

2017/08/03
By
Modified: 2017/06/25
Xdebug-PHP-Info

If you have WordPress or any other PHP site hosted on IIS you can debug it for free.  No Apache server is required. You can use NetBeans with Xdebug. This article records all the steps required to debug a PHP site on IIS.  It seems that actual WEB server used is irrelevant.  However, all steps here were tested on Windows 7 SP1 with IIS 7.5. (01) Download JAVA and IDE (Integrated Develop / Design Environment)  This is analogous to MS Visual Studio (VS).  Oracle offers a combo pack – JAVA SDK + NetBeans.  You need both.  Search for “JDK 6 Update 24 with NetBeans 6.9.1″. http://www.oracle.com/technetwork/java/javase/downloads/jdk-netbeans-jsp-142931.html   (02) From Xdebug download…

Read more »

Remotely Power Up or Wake Your Wired PCs Over the Internet

2017/07/26
By
Modified: 2017/06/25
Power-Up

Idea – Reduce Noise, Save on Electricity My electric company installed an electricity consumption gadget, and ability to monitor usage online. A few month into the experiment I realized, that I can easily reduce electric usage, if I turned off my server. It is been over a year since I migrated all my sites to Amazon cloud, so now my server only needs to be on, when I need it on. All the nights and 90% of all work hours it can be off.  But how to do that? I recall seeing something in BIOSes of Intel motherboards called Wake-On-LAN.  First time I saw something like this was in May of…

Read more »

Adding a new WordPress site to an Existing Installation

2017/07/12
By
Modified: 2017/06/25

Task You already have a working WordPress (WP) site.  Now, you need to add one more site with a new MySQL database.  This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip it to your future site location. Open IIS Admin Create a new virtual directory pointing to that location Side Notes – Change root password You need to know existing root user password. Login into MySQL Command Line Client. Select database: use mysql; Reset user password: update user set password=PASSWORD(“NewPassword”) where User=’root'; Allpy new password: flush privileges;   Create a New Database…

Read more »

What it Takes to Run Your Own Web Site (ever in progress)

2017/07/08
By
Modified: 2017/06/25
New-Web-Area

Joy of Web Publishing Very early on I noticed that Web content is a very special type of content, and Web development is a very special type of development.  Everything you say and everything you design is immediately available not just to millions, but to an entire Earth population with electricity and Internet.  And that is amazing.   And that is a true lure of running a Web site. Your thoughts and ideas are buried deep inside your head, but with Internet these ideas can find their customer, and your thoughts can find their reader.  Your site is your creation.  It is another dimension of you. Answer Fundamental Questions What is your Angle?…

Read more »

Set up bbPress as WP Plugin: Convert from bbPress standalone

2017/07/04
By
Modified: 2017/06/25

We went live with new bbPress plugin on January 28, 2013.   bbPress as a plugin for WordPress I started preparing for series of upgrades to the latest WP version (3.5), and Theme and all the plugings.  It was immediately obvious that among other things, I would have to look into migrating from integrated bbPress to a bbPress as a WP plugin. So far my experience was pretty intense.  I will try to log my progress here as I am moving forward preparing a production roll-out on my test site. Migrate your bbPress data from “bb_” tables into your “wp_” database I was able to migrate all the content from old…

Read more »

Domains for Sale – Домены на Продажу

2017/06/30
By
Modified: 2017/07/22
Domains for Sale

Here is an exciting list of domains for sales: ANDREY.COM, AVTOR.COM, CDMIR.COM, DATEWEBCENTER.COM, DEPUTAT.COM, EVREI.ORG, FIZIKA.COM, FOMKA.COM, FOOTBALLWEBCENTER.COM, FUNWEBCENTER.COM, GAMEWEBCENTER.COM, GREATBLUEHILLS.COM, HEPTAGONPROJECT.COM, HOCKEYWEBCENTER.COM, KARTINA.COM, KARTOCHKA.COM, KOLOBOK.COM, KOMANDA.COM, LEADERANDPOWER.COM, LISTOVKA.COM, MARKETWEBCENTER.COM, MOZG.COM, MOZGI.COM, MSICOUNCIL.COM, NALOGI.COM, NEKRASOV.COM, OKMI.COM, ORDERANDPOWER.COM, OTVET.COM, PEOPLEWEBCENTER.COM, PODVAL.COM, POWERANDORDER.COM, PROGRAMIST.COM, RODINA.COM, SDELKA.COM, SHARIK.NET, SOCIALSELECTION.COM, SPORTWEBCENTER.COM, STARWEBCENTER.COM, STOLB.COM, SUNWEBCENTER.COM, TEAMWEBCENTER.COM, UDARGROMOV.COM, UTRO.COM, VOPROS.COM, X--X.COM, YOURQUESTION.NET, YOURTRADINGSECRETS.COM, YOURTRADINGSTRATEGY.COM, YTRO.COM

Read more »

SQL DB2: Concatenate TEXT from multiple records

2017/06/30
By
Modified: 2017/06/25
Concatenation Road in Winter

    Scenario   Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field.  This should be a numeric field indicating the sequence in which to concatenate the records.  This field doesn’t not need to be  consecutive. Second. The difference between lowest and highest line numbers should be a reasonably low number.  In this example the max difference is 11, and it means that at the very maximum we would need to concatenate 11 text fields together.   Step One Generate a driver file with MIN…

Read more »

Properly Validate TextArea Length (IE vs. Firefox)

2017/06/26
By
Modified: 2017/11/12
TextArea Length - Firefox

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type="text/javascript"> function TTLength(objTT){ var tt= document.getElementById('TXT1'); tt.value = objTT.value.length; } </script> <textarea onKeyDown="TTLength(this);" onKeyUp="TTLength(this);" rows="10"> This Text Area Contains a string With Newline Characters </textarea>  <input type="text" id="TXT1" value="TT Length"/> Let’s see how this page behaves in IE8 and in Firefox 3.6.11. IE8 Firefox As you can see that IE and FF return two different values for the length of an identical  string in TextArea and that could be a serious problem, if you are trying to validate the string length before updating the…

Read more »