phpBB.de

Code: Alles auswählen

Could not update topics watch table

DEBUG MODE

SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back

UPDATE forum_topics_watch SET topic_id = WHERE topic_id = 419 AND user_id IN (52, 118, 19, 52)

Line : 1497
File : modcp.php

Code: Alles auswählen

					message_die(GENERAL_ERROR, 'Could not update topics watch table', '', __LINE__, __FILE__, $sql);

Code: Alles auswählen

				// Update topic watch table, switch users whose posts
				// have moved, over to watching the new topic
				$sql = "UPDATE " . TOPICS_WATCH_TABLE . "
					SET topic_id = $new_topic_id
					WHERE topic_id = $topic_id
						AND user_id IN ($user_id_sql)";
				if (!$db->sql_query($sql))
				{
					message_die(GENERAL_ERROR, 'Could not update topics watch table', '', __LINE__, __FILE__, $sql);
				}

				$sql_where = (!empty($HTTP_POST_VARS['split_type_beyond'])) ? " post_time >= $post_time AND topic_id = $topic_id" : "post_id IN ($post_id_sql)";

				$sql = 	"UPDATE " . POSTS_TABLE . "
					SET topic_id = $new_topic_id, forum_id = $new_forum_id
					WHERE $sql_where";
				if (!$db->sql_query($sql, END_TRANSACTION))
				{
					message_die(GENERAL_ERROR, 'Could not update posts table', '', __LINE__, __FILE__, $sql);
				}

				sync('topic', $new_topic_id);
				sync('topic', $topic_id);
				sync('forum', $new_forum_id);
				sync('forum', $forum_id);

				$template->assign_vars(array(
					'META' => '<meta http-equiv="refresh" content="3;url=' . "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'] . '">')
				);

				$message = $lang['Topic_split'] . '<br /><br />' . sprintf($lang['Click_return_topic'], '<a href="' . "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'] . '">', '</a>');
				message_die(GENERAL_MESSAGE, $message);
			}
		}
		else
		{

Code: Alles auswählen

$new_topic_id = $db->sql_nextid();

Code: Alles auswählen

$new_topic_id = $db->sql_nextid();

Code: Alles auswählen

				if ( $new_topic_id === FALSE )
				{
				  $sql = "SELECT MAX(topic_id) AS max_id FROM " . TOPICS_TABLE;
				  if ( !$result = $db->sql_query($sql) )
				  {
				    message_die(GENERAL_ERROR, 'Could not obtain next topic id');
				  }
				  $row = $db->sql_fetchrow($result);
				  $new_topic_id = intval($row['max_id']);
				}