some user profile showing error see pic bellow?

Question

how to fixed it?

site link

Comments

"A full description of the failure is available in the web server's log file."

So, what does that log file say?

---

error log file says, qa-db.php line 227
Subquery returns more than 1 row - Query: SELECT 1+COUNT(*) AS `rank` FROM qa_userpoints WHERE points>COALESCE((SELECT points FROM qa_userpoints WHERE userid=(SELECT userid FROM qa_users WHERE handle='idname' LIMIT 1)), 0)

now what can i do? remember that all profile not same problem. maximum work well.

---

Run the query directly on the database and check what results are returned. Also run each the subqueries by themselves and check the results of those as well.

---

hey..... thank you for your feedback. i found a solution.
Now the problem become solved