Mods can't merge topics.

[TheMBC]

The moderators of the forum I help run cannot merge topics, it seems to be happening to Global Moderators and regular Moderators.  I don't know what the problem is.  Here's a screenshot of the error.

Any help will be greatly appreciated.




It says: "The database value you're trying to insert does not exist: is_approve"

[ccbtimewiz]

Did you install any modifications? Do you get any errors in the error log?

[TheMBC]

Yes, we have some modifications, but none are applied that aren't compatible with SMF 2.0 as far as I know.

This showed up in the critical section of the error log...what's colored out is his IP address.
hxxp:img520.imageshack.us/my.php?image=errordb2.png [nonactive]

Here's what's on line 915, the code starts at line 900 and ends on 925:

Code Select Expand

FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
WHERE t.id_board = {int:id_board}
AND t.id_topic != {int:id_topic}' . ($onlyApproved ? '
AND t.approved = {int:is_approved}' : '') . '
ORDER BY {raw:sort}
LIMIT {int:offset}, {int:limit}',
array(
'id_board' => $_REQUEST['targetboard'],
'id_topic' => $_GET['from'],
'sort' => (!empty($modSettings['enableStickyTopics']) ? 't.is_sticky DESC, ' : '') . 't.id_last_msg DESC',
'offset' => $_REQUEST['start'],
'limit' => $modSettings['defaultMaxTopics'],
)
);
$context['topics'] = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
censorText($row['subject']);

$context['topics'][] = array(
'id' => $row['id_topic'],
'poster' => array(
'id' => $row['id_member'],
'name' => $row['poster_name'],

[Rumbaar]

What mods do you have installed?  What changed?  Were they ever able too?  Can you attach your whole file, as it appears some modifications inside the file have shift the code from the normal line numbers.