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

The path you entered is not a valid directory or is not accessible.

Error:The path you entered is not a valid directory or is not accessible.

When trying to enable imagemagick within Gallery2 by Menalto

Check your php,ini file for a directive open_basedir

add the root path that contains the convert binary , so for example if convert is at /usr/bin/convert
set the basedir to
open_basedir = /your/home:/usr/bin

without this settings you will not have access to the /usr/bin folder.

March 21, 2010 Posted Under: Linux Maintenance   Read More