MyBB Community Forums

1.8.3 Error after report user is used.

When a member uses the "Report User" button on another members profile, it gives a pop up with "An unknown error has occurred" 

They are unable to report a member and I get an error email with the following information.:

Quote:Type: 20

File: (Line no. 0)
Message
SQL Error: 1064 - 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 ') AND m.isgroup = '0'' at line 4
Query:
SELECT DISTINCT u.username, u.email, u.receivepms, u.uid
FROM mybb_moderators m
LEFT JOIN mybb_users u ON (u.uid=m.id)
WHERE m.fid IN () AND m.isgroup = '0'

Confirmed, send_report function doesn't consider empty parentlist at all. Should be fixed asap since it almost completely breaks Email/PM report functionality.

Hi,

Thank you for your report. We have pushed this issue to our Github repository for further analysis where you can track our commits and progress with fixing this bug. Discussions regarding this bug may also take place there too.

Follow this link to visit the issue on Github: https://github.com/mybb/mybb/issues/1698

Thanks for contributing to MyBB!

Regards,
The MyBB Group

Thank You.

Hello it says on the Github that this problem has been fixed, but after updating to 1.8.4 it's still not working for me.

Instead of the Error I first reported in this thread, I'm now getting a report with a link but the link gives a 404

This is the link I get when a profile report is made: http://MYURL/post-.html#pid

Thank you.

(2015-03-13, 12:12 PM)sarisisop Wrote: [ -> ]Hello it says on the Github that this problem has been fixed, but after updating to 1.8.4 it's still not working for me.

You replied to yourself in the next sentence..

(2015-03-13, 12:12 PM)sarisisop Wrote: [ -> ]Instead of the Error I first reported in this thread

So I'm not sure why you're bumping this thread saying that this major bug wasn't fixed (and then confirming later in the same post that it in fact is) while the issue is something entirely different now - connected with it, yes, but with another reproduction step required (reading the Email/PM).

A new thread should be made for each new report, please remember that.

Anyways, yes, some conditionals are needed for this line:
https://github.com/mybb/mybb/blob/featur...p.php#L202

And an issue was opened: https://github.com/mybb/mybb/issues/1906

OK Have a good weekend.

Thank you for your report @sarisisop.

(2015-03-18, 04:54 AM)Omar G. Wrote: [ -> ]Thank you for your report @sarisisop.

Thank You Omar G