Can you look at that products_id 8 in your database table products ... and see what the products_type value is?

Then look and see what you have in the table product_types

You should have at least 5 Product Types ...

What is the matching type_id for this?