phpBB.de

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Unknown column 'NOTIFY_YES' in 'where clause' [1054]

SQL

SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber FROM phpbb_topics_watch w, phpbb_users u WHERE w.topic_id = 11 AND w.user_id NOT IN (1, 54) AND w.notify_status = NOTIFY_YES AND u.user_type IN (0, 3) AND u.user_id = w.user_id

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1211
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_posting.php
LINE: 2607
CALL: user_notification()

FILE: posting.php
LINE: 1253
CALL: submit_post()

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Unknown column 'NOTIFY_YES' in 'where clause' [1054]

SQL

SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber FROM phpbb_topics_watch w, phpbb_users u WHERE w.topic_id = 626 AND w.user_id NOT IN (1, 54) AND w.notify_status = NOTIFY_YES AND u.user_type IN (0, 3) AND u.user_id = w.user_id

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1211
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_posting.php
LINE: 2607
CALL: user_notification()

FILE: posting.php
LINE: 1252
CALL: submit_post()

Code: Alles auswählen

// forum notification is sent to those not already receiving topic notifications
	if ($topic_notification)
	{
		if (sizeof($notify_rows))
		{
			$sql_ignore_users .= ', ' . implode(', ', array_keys($notify_rows));
		}

		$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber
			FROM ' . FORUMS_WATCH_TABLE . ' fw, ' . USERS_TABLE . " u
			WHERE fw.forum_id = $forum_id
				AND fw.user_id NOT IN ($sql_ignore_users)
				AND fw.notify_status = " . NOTIFY_YES . '
				AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')
				AND u.user_id = fw.user_id';

Code: Alles auswählen

// -- get forum_userids	|| topic_userids
	$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber
		FROM ' . (($topic_notification) ? TOPICS_WATCH_TABLE : FORUMS_WATCH_TABLE) . ' w, ' . USERS_TABLE . ' u
		WHERE w.' . (($topic_notification) ? 'topic_id' : 'forum_id') . ' = ' . (($topic_notification) ? $topic_id : $forum_id) . "
			AND w.user_id NOT IN ($sql_ignore_users)
			AND w.notify_status = " . NOTIFY_YES . '
			AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')
			AND u.user_id = w.user_id';