Posts Tagged ‘ Error ’

Count Number of Cell with Errors in Excel

2017/06/17
By
Modified: 2017/06/15

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »


Process **\MCSHIELD.EXE contains signed but untrusted code …

2017/05/25
By
Modified: 2017/04/30
mfehidk-EventID-516

This fix was tested with Windows XP Pro SP3 with Office 2003 SP3 and McAfee AntiVirus Plus. Finally.   Finally I found a solution for this really scary-looking error message that was bugging me since 12/24.  Marry Christmas! Description of a Problem Every time you restart you PC you see a very unpleasant Warning Event ID 516 in your system event log from mfehidk. This is the very last system message before computer reboots or goes to sleep. Process **\MCSHIELD.EXE pid (864) contains signed but untrusted code, but was allowed to perform a privileged operation with a McAfee driver. What is Causing it? It appears that most people (and I join them) …

Read more »

Cisco VPN Client Error 51 – Open Your Firewall

2017/05/23
By
Modified: 2017/04/30
Cisco Error 51

Annoying!  How Annoying! This very simple, very typical error message, but it is so hard to find a quick solution. Symptoms: You are starting a Cisco VPN Client and immediately you are getting this error message: Error 51: Unable to communicate with the VPN subsystem. Please make sure that you have at least one network interface that is currently active and has an IP address and start this application again.     Most of Internet discussions on this error message revolve around MAC OS.  But this error I was able to fix on Windows XP. Quickly – What to Do? Quickly – Open your firewall.  Each firewall solution is different, but…

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 »

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 »

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 »

SQL Error 80004005 – “Specified SQL server not found” – Solved

2017/03/08
By
Modified: 2017/03/03
SQL CFG Manager - Enable TCPIP

  Environment ASP or ASP.NET site is running on IIS 7.5. SQL Server 2008 R2 Express (10.50.1600.1) running on Windows 2008 Server R2 (W2K8 R2) x64.     Problem You will see one of two errors depending on whether you dealing with ASP or ASP.NET sites. On ASP.NET sites you will see  “Server Error – Error: 26 – Error Locating Server/Instance Specified” Server Error in '/YourApps' Application. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26…

Read more »

Error 2155348315 in Windows 7 Backup – Resolved

2017/02/08
By
Modified: 2017/01/18
Windows 7 Backup Error 2155348315

I started getting this error 2155348315 in Windows 7 Backup, when I switched from wired to a Wi-Fi connection on my desktop PC. Here is what happened...

Read more »