Custom post types not showing on the standard WordPress Category page

You don’t need to return $query it is passed by reference.Have a look at the codex

The return statement might be shortcircuiting the page load. Try removing it.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)