phpBB.de

Code: Alles auswählen

		$sql = 'SELECT *
			FROM ' . GALLERY_IMAGES_TABLE . '
			WHERE image_album_id = ' . (int) $album_id . "
				$image_status_check
			ORDER BY $sql_sort_order";

Code: Alles auswählen

/**
* Last Additions Hack Start
*/
		if (request_var('mode', '') == 'last')
		{
		$sql = 'SELECT *
			FROM ' . GALLERY_IMAGES_TABLE . "
				$image_status_check
			ORDER BY $sql_sort_order";
		}
/**
* Last Additions Hack End
*/

Code: Alles auswählen

/gallery/album.php?album_id=2&mode=last

Code: Alles auswählen

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 ') ORDER BY c.comment_id DESC LIMIT 4' at line 6 [1064]

SQL

SELECT c.*, i.* FROM phpbb_gallery_comments c LEFT JOIN phpbb_gallery_images i ON c.comment_image_id = i.image_id WHERE i.image_album_id = '1' ) ORDER BY c.comment_id DESC LIMIT 4

BACKTRACE

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

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

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

FILE: gallery/includes/functions_recent.php
LINE: 213
CALL: dbal->sql_query_limit()

FILE: gallery/index.php
LINE: 140
CALL: recent_gallery_images()