Dec 31

Here is the best syntax to use to perform a redirect with mod_rewrite based on HTTP_HOST. I found it after trolling many forums and trying many different combinations. I don’t plan on actually learning the syntax of each character, just know it works.

RewriteEngine on
RewriteCond %{HTTP_HOST} ^jw0rd.com$ [OR]
RewriteCond %{HTTP_HOST} ^www.jw0rd.com$
RewriteRule ^(.*)$ http://www.jw0rd.net [R=301,L]

Dec 24

ASP connecting with MySQL throws the following error:
ADODB.Field error ‘800a0bcd’

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Based on the error returned it sounds like an empty recordset however it wasn’t. I wasted a lot of time debugging when in fact the problem was the MySQL ODBC driver. If you see a similar error be sure to update the driver to the latest version (3.51.27.00)

http://www.mysql.com/products/connector/odbc/

Dec 18

I recently upgraded my gaming system to XP SP3. Upon initial boot I got a BSOD saying my system was not ACPI compliant. I rebooted and went in the BIOS to disable the only relative ACPI option I was aware of, no luck. After further digging I realized I was not alone and this is a well documented problem, with no permanent fix from either manufacturer, ASUS or Microsoft. The only way I can get my system to boot into Windows is to plug in a USB flash drive before POST. I will be downgrading to SP2 shortly. BIOS is version 1405.

http://www.pcworld.com/article/145689/xp_sp3_cripples_some_pcs_with_endless_reboots.html

Notice how this is referenced as an “Endless reboot” problem. That is only because upon receiving the BSOD most systems will force reboot so fast most do not notice the outputted error codes.

Dec 2
Overclocking X2 3800+
icon1 admin | icon2 Hardware | icon4 12 2nd, 2008| icon35 Comments »

This is my current setup. I decided instead of building a secondary I would boost this chip and upgrade the graphics in the near future (probably 9800gt)

AMD X2 3800+ @ 2.6ghz (ships @ 2.0ghz)

3GB Corsair

A8N32-SLI Deluxe

EVGA 7800GT

74GB Raptor

PC Power & Cooling 750W PSU

2_6

Oct 21
Impersonate XP
icon1 admin | icon2 Server 2003 | icon4 10 21st, 2008| icon3No Comments »

If you’re like me and you like using your server as a desktop you have probably run into the issue where an installer won’t initialize in Server 2003 even though you are sure it would run just fine. If so all you need is Application Verifier from Microsoft to trick the executable.

http://www.microsoft.com/downloads/details.aspx?FamilyID=bd02c19c-1250-433c-8c1b-2619bd93b3a2&displaylang=en

Use is fairly simple, add the installer .exe and change the following attributes under Compatibility -> High VersionLie

Major Version: 5

Minor Version: 1

Build number: 2600

Service pack major: 2

Service pack minor: 1

Suite Mask: 0

Product Type: 0

CSD Version:

Sep 30

Ever migrated a Wordpress blog and ended up using a new domain name? You won’t be able to get in wp-admin due to the fact that WordPress redirects based on 2 values in the wp_options table. Below are the update queries you can run to update the URL in the MySQL database. You need access to phpMyAdmin, the MySQL prompt or you can execute it via PHP.

mysql> USE databasename;

mysql> update wp_options set option_value = ‘http://jw0rd.net’ where option_name = ‘home’ or option_name = ’siteurl’;
Query OK, 2 rows affected (0.04 sec)
Rows matched: 2 Changed: 2 Warnings: 0

Sep 30

I was dealing with a ColdFusion application at work that had locked an Access database and the customer was very upset. Access databases become locked when they are being edited, an .ldb file is generated with the same name.  I usually resolve this issue with a trick of running a query against an existing table with a non-existant column name. Don’t ask me how this works but it does -> http://www.hostmysite.com/support/programming/locked-db/

In this situation no .ldb file was generated, my quirky query didn’t do the trick, and the ColdFusion app was still throwing ODBC errors stating ‘admin’ had locked the database.

This was on a live, shared web server so I couldn’t just reboot. All I needed to do in fact was copy the .mdb somewhere, rename it, and update it in some way. I then deleted the original file and renamed the copied one back and the web application could then perform its tasks. No reboot, no connection string updating. The summary is, if you are still using Access for a web application you should migrate it to MySQL or MS SQL.

Next Entries »

Hosted by HostMySite.com