Skip to content

forum/newforumposts_menu.php - SQL error #3757

@Jimmi08

Description

@Jimmi08

adding new newforumposts_menu.php to bootstrap3, I got SQL error

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY p.post_datestamp DESC LIMIT 0, 10' at line 12

Array
(
    [0] => Array
        (
            [file] => G:\php72\htdocs\e107-whisper\e107_handlers\mysql_class.php
            [line] => 551
            [function] => query
            [class] => PDO
            [type] => ->
            [args] => Array
                (
                    [0] => 
					SELECT
					p.post_user, p.post_id, p.post_datestamp, p.post_user_anon, p.post_entry,
					t.*,
					u.user_id, u.user_name, u.user_image, u.user_currentvisit,
					lu.user_name as thread_lastuser_username, 
					f.forum_name, f.forum_sef
					FROM e107_forum_post as p
					LEFT JOIN e107_forum_thread AS t ON t.thread_id = p.post_thread
					LEFT JOIN e107_forum as f ON f.forum_id = t.thread_forum_id
					LEFT JOIN e107_user AS u ON u.user_id = p.post_user
					LEFT JOIN e107_user AS lu ON t.thread_lastuser = lu.user_id
					WHERE  p.post_forum IN ()
					ORDER BY p.post_datestamp DESC LIMIT 0, 10 
                )

        )


There are no posts yet, so maybe this is the reason?

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions