• 19-07-2009, 19:00:54
    #1
    Kimlik doğrulama veya yönetimden onay bekliyor.
    Bir PHP sayfasında başka bir sayfadaki fonksiyonu kullanmaya çalıştığımda

    Alıntı
    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 ') LEFT JOIN `dbadi_dbadi`.smf_log_mark_read AS lmr ON (lmr.ID_BOARD = m' at line 8
    şeklinde bir hata aldım. Sayfanın kodlarını veremiyorum.. Fakat hatayla ilgili SQL sorgusu şu şekilde :

    $request = db_query("
    		SELECT
    			m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, m.ID_BOARD, b.name AS bName,
    			IFNULL(mem.realName, m.posterName) AS posterName, " . ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
    			IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= m.ID_MSG_MODIFIED AS isRead,
    			IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . ", LEFT(m.body, 384) AS body, m.smileysEnabled
    		FROM ({$db_prefix}messages AS m, {$db_prefix}boards AS b)
    			LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)" . (!$user_info['is_guest'] ? "
    			LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = m.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
    			LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = m.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)" : '') . "
    		WHERE m.ID_MSG >= " . ($modSettings['maxMsgID'] - 25 * min($num_recent, 5)) . "
    			AND b.ID_BOARD = m.ID_BOARD" . (empty($exclude_boards) ? '' : "
    			AND b.ID_BOARD NOT IN (" . implode(', ', $exclude_boards) . ")") . "
    			AND $user_info[query_see_board]
    		ORDER BY m.ID_MSG DESC
    		LIMIT $num_recent", __FILE__, __LINE__);
    localhost'ta denediğimde sorunsuz bir şekilde çalışıyor. Hostta denediğimde hata veriyor. Nasıl düzeltebilirim acaba ?
  • 19-07-2009, 21:32:35
    #2
    include(''); leri doğru yaptığınızdan emin olun
  • 20-07-2009, 01:40:40
    #3
    Misafir adlı üyeden alıntı: mesajı görüntüle
    include(''); leri doğru yaptığınızdan emin olun
    Kontrol ettim, herhangi bir sorun gözükmüyor. Zaten localhost'ta çalışan dosyaları atıyorum hosta.
  • 20-07-2009, 10:25:04
    #4
    Üyeliği durduruldu
    $request = db_query("
            SELECT
                m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, m.ID_BOARD, b.name AS bName,
                IFNULL(mem.realName, m.posterName) AS posterName, " . ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
                IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= m.ID_MSG_MODIFIED AS isRead,
                IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . ", LEFT(m.body, 384) AS body, m.smileysEnabled
            FROM ({$db_prefix}messages AS m, {$db_prefix}boards AS b)
                LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)" . (!$user_info['is_guest']) ? "
                LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = m.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
                LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = m.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)" : '') . "
            WHERE m.ID_MSG >= " . ($modSettings['maxMsgID'] - 25 * min($num_recent, 5)) . "
                AND b.ID_BOARD = m.ID_BOARD" . (empty($exclude_boards) ? '' : "
                AND b.ID_BOARD NOT IN (" . implode(', ', $exclude_boards) . ")") . "
                AND $user_info[query_see_board]
            ORDER BY m.ID_MSG DESC
            LIMIT $num_recent", __FILE__, __LINE__);
    bu şekil yaparsan çalışması gerekiyor.
  • 20-07-2009, 20:32:13
    #5
    LoverzSoft adlı üyeden alıntı: mesajı görüntüle
    $request = db_query("
            SELECT
                m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, m.ID_BOARD, b.name AS bName,
                IFNULL(mem.realName, m.posterName) AS posterName, " . ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
                IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= m.ID_MSG_MODIFIED AS isRead,
                IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . ", LEFT(m.body, 384) AS body, m.smileysEnabled
            FROM ({$db_prefix}messages AS m, {$db_prefix}boards AS b)
                LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)" . (!$user_info['is_guest']) ? "
                LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = m.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
                LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = m.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)" : '') . "
            WHERE m.ID_MSG >= " . ($modSettings['maxMsgID'] - 25 * min($num_recent, 5)) . "
                AND b.ID_BOARD = m.ID_BOARD" . (empty($exclude_boards) ? '' : "
                AND b.ID_BOARD NOT IN (" . implode(', ', $exclude_boards) . ")") . "
                AND $user_info[query_see_board]
            ORDER BY m.ID_MSG DESC
            LIMIT $num_recent", __FILE__, __LINE__);
    bu şekil yaparsan çalışması gerekiyor.
    Parse error: syntax error, unexpected ',' in /xx/xx/xx/xx.php on line 267 şeklinde bir hata verdi.

    267. satır

    LIMIT $num_recent", __FILE__, __LINE__);