Problem with Slow queries killing Mysql.

The hack need to be rewritten to do a better performance and be nice with the Mysql, the slow queries just point to the hack and the server load hits the skies.

sample of the slow queries log:

# Time: 090423 15:08:23
# User@Host: xxxxx_xxxxx[xxxxx_xxxxx] @ localhost []
# Query_time: 45 Lock_time: 0 Rows_sent: 2 Rows_examined: 1000521
use zonabb_foro;

SELECT thanks.dateline, thread.title, post.postid, user.userid, user.username
FROM thanks as thanks
LEFT JOIN post as post ON (post.postid = thanks.postid)
LEFT JOIN thread as thread ON (thread.threadid = post.threadid)
LEFT JOIN user as user ON (user.userid = thanks.userid)
WHERE post.userid = 27650
ORDER BY thanks.dateline DESC LIMIT 10;

# Time: 090423 15:19:40
# User@Host: xxxxx_xxxxx[xxxxx_xxxxx] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 10 Rows_examined: 499579

SELECT thanks.dateline, thread.title, post.postid, user.userid, user.username
FROM thanks as thanks
LEFT JOIN post as post ON (post.postid = thanks.postid)
LEFT JOIN thread as thread ON (thread.threadid = post.threadid)
LEFT JOIN user as user ON (user.userid = thanks.userid)
WHERE post.userid = 24506
ORDER BY thanks.dateline DESC LIMIT 10;

I hope the developer takes the time to optimize and solve this critical issue

In my opinion, this coder should be removed from the site. Their attitude towards support is screw you, fix it yourself. After paying for the expanded version I have had nothing but problems and 0 support. Do yourself a favor, do NOT use this until these folks change their attitude towards those that download and install this mod.

Is there an alternative Hide-system?

Installed and work correctly but the problem occurs.

Mine quick reply button is not working , whenever i click it , it shows / does nothing.

what to do ?

Marshal

totally agree, you know the answer given on the other site... basically fix it yourself

man on the latest version the buttons on the quick reply do not work, if you have used previous version you have to undone every template change...

if you find a good one, please let us know.

I installed the latest ver. ! have to wait now for the working ver. :D

Removed

Can we set default group? like HIDE tag? Thanks,