I don't think its merely a BIOS issue. Powerleap adapters work without BIOS upgrades ( they work on the same boards that wasn't compatible with the Compgeeks adapter). I suspect theres more underlying problems with the actual hardware itself.
And on your thread where it was linked ($12 adapter from Yahoo), the picture was clearly the Powerleap adapter ( even has the name 'Powerleap' on it). So either they are selling blackmarket adapters straight from the OEM who makes it or they just used the same picture pulled from the Powerleap site. Its the exact same picture, only made smaller.
from Compgeeks:
Only for use with non-northwood core Socket 478 CPU's.
Will not work with Socket 478 Celeron CPU's
And from Powerleap:
Supports Pentium-4 Northwood, Willamette, and P4 Celeron processors
So which one would you rather have? One is $10 (very limited compatibility), the other is $50 (more compatibility with a wider range of CPU's)