• Welcome to Simple Machines Community Forum. Please login or sign up.
January 24, 2022, 02:17:38 PM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


Mods can't merge topics.

Started by TheMBC, July 28, 2008, 10:42:48 PM

Previous topic - Next topic

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

July 30, 2008, 01:20:45 AM #2 Last Edit: July 30, 2008, 01:22:17 AM by 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:
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.
"An important reward for a job well done is a personal sense of worthwhile achievement."


[ Themes ]

Advertisement: