вопрос
Помогите пожалуйста разобрать и решить проблему с комментариями!
При попытке просмотреть и/или изменить комментарии выдаётся, вот такая ошибка:
При попытке просмотреть и/или изменить комментарии выдаётся, вот такая ошибка:
MySQL error in file: /engine/classes/comments.class.php at line 86
Error Number: 1052
The Error returned was:
Column 'ip' in field list is ambiguous
SQL query:
SELECT dle_comments.id, post_id, dle_comments.user_id, date, autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, name, dle_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM dle_comments LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id WHERE dle_comments.post_id = '8' ORDER BY date ASC LIMIT 0,30
Error Number: 1052
The Error returned was:
Column 'ip' in field list is ambiguous
SQL query:
SELECT dle_comments.id, post_id, dle_comments.user_id, date, autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, name, dle_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM dle_comments LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id WHERE dle_comments.post_id = '8' ORDER BY date ASC LIMIT 0,30
ID и IP автора новости, не одинаковы(тоесть они разные) в перечисленных файлах:
SELECT dle_comments.id, post_id, dle_comments.user_id, date, autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, name, dle_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM dle_comments LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id WHERE dle_comments.post_id = '8' ORDER BY date ASC LIMIT 0,30
Проверь и сделай везде одинаковый ID и IP
SELECT dle_comments.id, post_id, dle_comments.user_id, date, autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, name, dle_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM dle_comments LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id WHERE dle_comments.post_id = '8' ORDER BY date ASC LIMIT 0,30
Проверь и сделай везде одинаковый ID и IP