dimitry: При отправке сообщения (жалобы) на пост через меню /index.php?act=report&send=1&f=xxx&t=xxxx&p=xxxx&st=0
при MySQL 5 выдается ошибка:
Цитата
mySQL query error: SELECT m.name, m.email, mod.member_id FROM ibf_moderators mod, ibf_members m WHERE mod.forum_id='17' and mod.member_id=m.id
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod, ibf_members m WHERE mod.forum_id='17' and mod.member_id=m.id' at line 1
mySQL error code:
Date: Monday 16th of July 2007 05:33:28 AM
Исправление:
Найти:
Цитата (sources/misc/contact_member.php)
[color=green]// Check for mods in this forum[/color] [color=#048284]$DB[/color]->query("SELECT m.name, m.email, mod.member_id FROM ibf_moderators mod, ibf_members m WHERE mod.forum_id='$fid' and mod.member_id=m.id");
Заменить на:
[color=green]// Check for mods in this forum[/color] [color=#048284]$DB[/color]->query("SELECT m.name, m.email, md.member_id FROM ibf_moderators md, ibf_members m WHERE md.forum_id='$fid' and md.member_id=m.id");
dimitry: При отправке сообщения (жалобы) на пост через меню /index.php?act=report&send=1&f=xxx&t=xxxx&p=xxxx&st=0
при MySQL 5 выдается ошибка:
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod, ibf_members m WHERE mod.forum_id='17' and mod.member_id=m.id' at line 1
mySQL error code:
Date: Monday 16th of July 2007 05:33:28 AM
Исправление:
Найти:
[color=green]// Check for mods in this forum[/color] [color=#048284]$DB[/color]->query("SELECT m.name, m.email, mod.member_id FROM ibf_moderators mod, ibf_members m WHERE mod.forum_id='$fid' and mod.member_id=m.id");Заменить на:
[color=green]// Check for mods in this forum[/color] [color=#048284]$DB[/color]->query("SELECT m.name, m.email, md.member_id FROM ibf_moderators md, ibf_members m WHERE md.forum_id='$fid' and md.member_id=m.id");