Archive for April, 2010

Stop Error IRQL_NOT_LESS_OR_EQUAL

Microsoft reason for the error:
This problem typically occurs because drivers call either the IoQueueWorkItem function or the ExQueueWorkItem function two times on the same work item before the work item has been executed.

Device drivers that statically allocate either the IO_WORKITEM structure or the WORK_QUEUE_ITEM structure are particularly prone to this problem. Device drivers that perform such a static allocation must guarantee that they do not try to use the statically allocated item while it is already queued.

================================
WHAT.. that was very technical …

===============
The cause is due to a corrupt hardware driver. you will need to locate the hardware that is having the problem and disabled it. Then install the latest driver for the harddrive before enabling it.

We ran install this issue when playing with out wireless card.
=================

M$ Knowledgbase on it

April 29, 2010 Posted Under: Windows   Read More

Windows XP cdrom missing from my computer

Remove the Upperfilters and Lowerfilters values completely from the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{4D36E965-E325-11CE-BFC1-08002BE10318}
NOTE: If you are getting a code 39 message, it may be that additional third-party filter drivers were added to UpperFilters and LowerFilters values in addition to Adaptec filter drivers. In that case, you may try to remove the non-Adaptec filter drivers first, leaving the Easy Creator filters in place to see if the Code 39 goes away. If you still receive an error code 39, 32, or 31 message, remove the Upperfilters and Lowerfilters values completely in the preceding key.

Restart your computer.

M*KB

April 27, 2010 Posted Under: Windows   Read More

HTTP Error 401.3 – Unauthorized Error -IIS 7.0

The 401.3 error message was being displayed due to the Anonymous Authentication app pool settings. I changed the identity to the app pool instead of using the iusr account. This can be found under IIS > Authentication > Anonymous > click edit on the right. You will then need to select “application pool identity”

April 25, 2010 Posted Under: Windows   Read More

Plesk Billing – internal error has occurred- license

Error:
When trying to activate the plesk billing license you receive a internal error message: ok , so what does this mean.. if you ask plesk , you will need to wait 72 hours for a answer. so this is why we have openkb.org

Reason: check and make sure fopen is on in the php.ini file and openssl has been compiled with php.

other error you may receive
You must have the OpenSSL extension enabled in your PHP installation in order to use Parallels Plesk Billing. You do not.
Invalid license data found in system. You need to update your license to a Parallels Plesk Billing 6.x license key. Please contact support for help with this process.

April 7, 2010 Posted Under: PHP   Read More

SQL 2000 – search all tables


CREATE PROC SearchAllTables
(
@SearchStr nvarchar(100)
)
AS
BEGIN

-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
-- Purpose: To search all columns of all tables for a given search string
-- Written by: Narayana Vyas Kondreddi
-- Site: http://vyaskn.tripod.com
-- Tested on: SQL Server 7.0 and SQL Server 2000
-- Date modified: 28th July 2002 22:50 GMT

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ''
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
), 'IsMSShipped'
) = 0
)

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)

IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
FROM ' + @TableName + ' (NOLOCK) ' +
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
)
END
END
END

SELECT ColumnName, ColumnValue FROM #Results
END

To execute
EXEC SearchAllTables ‘hi mom’
GO

April 4, 2010 Posted Under: SQL   Read More