How to remove icq request in comments.class.php DLE?

Question

CMS

Hello everyone, I ran into this problem. I connected a couple of modules for DLE to reward users for comments, and now if there is at least one comment in the news, an error occurs

MySQL Error!
MySQL error in file: /engine/classes/comments.class.php at line 675
Error Number: 1054
The Error returned was:
Unknown column 'icq' in 'field list'
SQL query:
SELECT dle_comments.id, post_id, dle_comments.user_id, dle_comments.date, dle_comments.autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, group_concat(mid) as awards, name, dle_users.email, news_num, dle_users. comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, dle_users.xfields, dle_post.title, dle_post.date as newsdate, dle_post.alt_name, dle_post.category FROM dle_comments LEFT JOIN dle_awards ON uid = dle_comments.user_id LEFT JOIN dle_post ON dle_comments.post_id=dle_post.id LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id GROUP BY dle_comments.id ORDER BY id desc

I added this icq field to dle_comments in the database and the error disappeared, but now every news contains all the site comments that were written somewhere. Please tell me how to fix this, I did not find any mention of icq in the comments.class.php file itself, but the request goes with it

SELECT dle_comments.id, post_id, dle_comments.user_id, dle_comments.date, dle_comments.autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, group_concat(mid) as awards, name, dle_users.email, news_num, dle_users. comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq , dle_users.xfields, dle_post.title, dle_post.date as newsdate, dle_post.alt_name, dle_post.category FROM dle_comments LEFT JOIN dle_awards ON uid = dle_comments.user_id LEFT JOIN dle_post ON dle_comments.post_id=dle_post.id LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id GROUP BY dle_comments.id ORDER BY id desc

tell me where you can remove this request and fix this problem. The module that I connected for awards is called Awards 4.5

Answer 1

You have a choice:

1. We write to the author of the module, for sure he is already aware of the problem.
   
2. Open comments.class.php and remove all occurrences of icq in SELECT queries
   
3. Fill in the correct comments.class.php file from the current DLE version
   

Answer 2

The same trouble, with the same module. The rollback of the database and some files helped.