SMF 2.0 - Quote issues - Post.php

[greyknight17]

Whenever a regular member (admin works) tries to quote someone's post, it's giving errors like the below in the error log:

http://.../index.php?action=quotefast;quote=22313;sesc;xml

Database 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 '))
LIMIT 1' at line 7

File: ..../Sources/Post.php
Line: 2204

I opened up Post.php and replaced:

Code Select Expand

AND (t.locked = 0 OR b.id_board IN (' . implode(', ', $moderate_boards) . '))') . "

With:

Code Select Expand

AND (t.locked = 0' . (empty($moderate_boards) ? '' : ' OR b.ID_BOARD IN (' . implode(', ', $moderate_boards) . ')') . ')') . "

That seems to have resolved the problem.

[SleePy]

Use the bug tracker

BTW, in 2.0 beta 1 or 2.0 beta 1.1?
Or are you using the latest cvs?

[nitins60]

The problem is also existing in SMF 1.1.x series. It's not yet solved in 1.1.4