For some reason, trying to view any node of a certain content type leads to a 404 error. When viewed in a View table, they display just fine. What could be happening?
Viewing the database with phpMyAdmin shows the data just fine.
The problematic node type was created with CCK.
Does your Drupal log show 'page not found' errors when you attempt to access those URLs? If it doesn't, the requests are never making it to Drupal, which would likely indicate you've got a misconfigured .htaccess file.