Добрый вечер , появилась ошибка с чатом , Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'datingdb.PROFILE' doesn't exist in chat-users.php:90 Stack trace: #0 /chat-users.php(90): PDOStatement->execute() #1 {main} thrown in chat-users.php on line 90 так же прилагаю проблемный кусок кода ( 90 строчку подписал ) <?php session_start(); ini_set('display_errors', 'on'); require_once("./Connector/DbConnectorPDO.php"); require("./helper/helperFunctions.php"); $userId = isset($_SESSION["userId"]) && !IsVariableIsSetOrEmpty($_SESSION["userId"]) ? $_SESSION["userId"] : 0; $connection = getConnection(); $userObj = $userId !== 0 && !IsVariableIsSetOrEmpty($_SESSION["user"]) ? $_SESSION["user"] : ""; $msgList = []; $recentMsgList = []; $msgToUserId = isset($_GET["id"]) && !IsVariableIsSetOrEmpty($_GET["id"]) ? $_GET["id"] : 0; if (isset($_POST["SendMessage"]) && !IsVariableIsSetOrEmpty($_POST["SendMessage"])) { $msg = $_POST["msg"]; if (isset($msg) && !IsVariableIsSetOrEmpty($msg)) { $insertMessageQuery = "INSERT INTO messages(msg_from_user_id,msg,msg_to_user_id,msg_date,is_msg_read) valuesuserId,:msg,:msgToUserId,NOW(),0)"; $insertStmt = $connection->prepare($insertMessageQuery); $insertStmt->bindParam(':userId', $userId); $insertStmt->bindParam(':msg', $msg); $insertStmt->bindParam(':msgToUserId', $msgToUserId); $insertStmt->execute(); } } if ($userId === 0 || (!isset($_GET["id"]) && !isset($msgToUserId))) { header("location:./view-profiles.php"); } if ($msgToUserId !== 0) { $recentMsgQuery = "SELECT * FROM ( SELECT PROFILE .id, PROFILE.firstName, PROFILE.lastName, PROFILE.imgUrl, ( SELECT msg FROM messages WHERE messages.msg_from_user_id = PROFILE.id OR messages.msg_to_user_id = PROFILE.id ORDER BY id DESC LIMIT 1 ) AS lastMessage, ( SELECT msg_date FROM messages WHERE messages.msg_from_user_id = PROFILE.id OR messages.msg_to_user_id = PROFILE.id ORDER BY id DESC LIMIT 1 ) AS msgDate FROM PROFILE WHERE id <> :userId ) X LEFT JOIN ( Select DISTINCT ids from ( select msg_from_user_id as ids from messages where msg_from_user_id =:userId or msg_to_user_id=:userId UNION select msg_to_user_id as ids from messages where msg_from_user_id =:userId or msg_to_user_id=:userId )uniqueIdList where ids <> :userId )IdList on X.id=IDList.ids WHERE ids IS NOT NULL AND lastMessage IS NOT NULL ORDER BY msgDate desc"; $recentQueryStmt = $connection->prepare($recentMsgQuery); $recentQueryStmt->bindParam(':userId', $userId); $recentQueryStmt->execute(); - 90 строчка - $recentMsgList = $recentQueryStmt->fetchAll();
1. Для размещения кода есть тегии специальные, а не выделение жирным 2 Текст ошибки перевели? Есть гугло, Яндекс итд переводчики. Как только переведете - поймете в чем дело