Board3

Code: Select all

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

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 ') AND i.image_status = 1) GROUP BY i.image_id ORDER BY RAND() LIMIT 1' at line 5 [1064]

SQL

SELECT i.*, a.album_name, a.album_id, a.album_user_id FROM phpbb_gallery_images i LEFT JOIN phpbb_gallery_albums a ON i.image_album_id = a.album_id WHERE (i.image_album_id IN () AND i.image_status = 1) GROUP BY i.image_id ORDER BY RAND() LIMIT 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 159
CALL: dbal_mysql->_sql_query_limit()

FILE: portal/includes/functions_album.php
LINE: 175
CALL: dbal->sql_query_limit()

FILE: portal/block/album.php
LINE: 42
CALL: gallery_images_block()

FILE: portal.php
LINE: 258
CALL: include('portal/block/album.php')