Web Development

Windows based Web Development
IIS – ASP.NET – Visual Studio – C#

How to Move MySQL D/B Files (Windows)

2017/05/27
By
Modified: 2017/04/30

Locate your MySQL installation files and central configuration file basedir="C:/Program Files/MySQL/MySQL Server 5.1/" Your MySQL configuration is stored in "my.ini" file Locate your MySQL Database location: datadir="C:/Documents and Settings/All Users/ Application Data/MySQL/MySQL Server 5.1/Data/" Stop MySQL service. Modify My.ini file to point to a new D/B location and Save. Move your Data directory to a new location Restart MySQL service. You are done.  All pages (even if you were in the middle of the editing) continue to work.  Amazing!

Read more »


WordPress Error 500 – Internal server error on Empty Comment

2017/05/17
By
Modified: 2017/04/30
WordPress Error 500 – Internal server error on Empty Comment

Problem – Embarrassing Error 500 I am running latest Word Press 3.0.1 on IIS 7.0.  If visitor tries to leave an empty comment or forgets to enter name or email, an ugly 500 – Internal server error will appear on the screen.  This is extremely embarrassing for the host and for the site. I approximately know that I have three ways to approach this problem: – Disable error 500 on IIS side to allow WordPress to handle it; – Lower level of error generated in WordPress code (IIS will not catch it then) or – Write a local JavaScript to prevent user from posting with empty fields. Solution – One click in…

Read more »

Integrating bbPress Forum with WordPress Theme

2017/05/13
By
Modified: 2017/04/30
WordPress-plus-bbPress

Problem When I was preparing to roll out bbPress forum as a part of  WordPress site,  I discovered that process of bbPress user and login integration has a very good coverage on the Internet. This article deals with integrating bbPress forum “look and feel” with WordPress. How to make bbPress forum look like your  regular WordPress page?  How to create a deep integration,  so users wouldn’t feel that they are leaving one site and now are in a completely different site. You can judge, how well this advice works based on how close our Forum interface integrated with WordPress theme. One should be able to tell the difference between bbPress styles and WordPress…

Read more »

Move WordPress to a new Windows Server 2012 on Amazon AWS

2017/05/11
By
Modified: 2017/04/30
Move WordPress to a new Windows Server 2012 on Amazon AWS

This article is about moving your Windows-based WordPress and other sites (some ASP, some ASP.NET) from older to a newer instance using AMAZON cloud server  instances.  Procedures described here do not involve any installation.  Just copy files and edit CONFIG files.  We do not manipulate Registry as well (except to change inbound RDP port). Sample installation in this article was tested on Amazon Small instance.  Image used  was Windows 2012 Server x64 with SQL Server2012 Express.  This article can be used to create you own check list while preparing to migrate to a new Amazon server. Why would you decide to upgrade or move to a new instance/server?  Here are some driving reasons:  Something is no…

Read more »

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’

2017/05/09
By
Modified: 2017/04/30

ASP.NET page returns this erorr: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’. (1) First try runing this command/wizard: %WinDir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe   (2) If this doesn’t work, try this query:  -- Add user ASPNET to DB role USE YourDB GO sp_addrolemember 'aspnet_Membership_FullAccess', 'ASPNET' These steps should resolve your issue.

Read more »

Use DELEGATE in C# to Communicate Between Controls

2017/05/05
By
Modified: 2017/04/30

As your custom ASP.NET Web control grows, you might realize that it is time to split it into two or more controls. But how new pieces will communicate with each other? This article describes how event in one control can trigger a method in other control. [Environment: Visual Studio 2008, VS2008]

Read more »

ASP.NET Combine Validators and Client OnClick Events

2017/05/03
By
Modified: 2017/04/30

  Imagine you need to use control validators, and you also need to attach  additional logic to OnClick event. These two will fight with each other, if you use conventional interface features. If you add OnClick attribute too early (say in GridView_RowEditing event)  it will be overwritten by Validators.  If you add OnClick  attribute very late (say in  Render event) Validators logic will be lost. To make this work, you need to  use a special JavaScript function that combines both procedures. Here is how you do it: You need to change  a few things on the button that causes validation:                     <asp:ImageButton ID="imgUpdate" runat="server" CausesValidation="false"                         OnClientClick="return isValid(this);" ImageUrl="~/Images/Update32x32.png"                         Text="Update"…

Read more »

Using Ajax Toolkit Controls on Pages With Other Scripts and Master Pages

2017/04/25
By
Modified: 2017/03/03
Ajax Extended Calendar

[ASP.NET – This  material was tested on Win7, W2K8 Server,  IS7 and IIS 7.5  and Microsoft Visual Web Developer 2010]   Install Proper Version Download and unzip proper version form http://ajaxcontroltoolkit.codeplex.com/releases/view/76976 Open the site where you intend to uses Ajax Controls, Follow  generic instruction and add a new control tab inside your Visual Studio or Web Dev. By doing this, you copy a file “AjaxControlToolkit.dll” and others into your site Bin directory. Text file  “/Bin/AjaxControlToolkit.dll.refresh” has a pointer to a folder where you unzipped your Ajax Toolkit. If you move Toolkit installation files somewhere, you can always update the pointer manually.   Use Ajax Control Open the page that you intend to…

Read more »

Work with MySQL – Basic WordPress Queries

2017/04/24
By
Modified: 2017/04/30

This article was born, as I was searching for ways to handle thousands of registered WordPress users, who never do anything, never return to the site, and never even change their default password.               Table of Topics -1030- List all registered users sorted by date -1060- Group registered users by email domain name -1090- Users who ever posted articles -1120- List of registered users who ever posted comments -1150- List of users, who posted messages in your bbPress Forum -1180- Group users by year and month of registration -1210- Count users in different roles -1240-  Users who never changed their default password -1270-  Users who changed their default password -1300-…

Read more »

Store ASP.NET User Security Inside Your SQL Database

2017/04/21
By
Modified: 2017/03/03

How to move all ASP.NET security tables to your custom SQL database and how make it all work together. Consists of three steps: -01- Create security tables in your current custom database; -02- Generate a machine key -03- Modify web.config

Read more »

XML Parsing Error in Firefox; Cannot Display This Feed in IE

2017/04/19
By
Modified: 2017/03/29
Firefox-XML-Parsing-Error

This article describes, how to fix RSS Feed error messages in WordPress. In Firefox the error is “XML Parsing Error”.  In IE you see “Internet Explorer cannot display this feed”.   Symptoms When you click on RRS link in WordPress (or bbPress), you are getting this error message (see images bellow).  The message is different depending on your browser. Firefox Internet Explorer XML Parsing Error: XML or text declaration not at start of entity  Location: http://www.domainwebcenter.com/wp-content/bbpress/rss.php?topic=29 Line Number 4, Column 1:<?xml version=”1.0″ encoding=”UTF-8″?>   Internet Explorer cannot display this feed  This feed contains code errors. Go back to the previous page. More information Invalid xml declaration. Line: 4 Character: 3 <?xml…

Read more »