got a folder
Array ( [sql] => SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50 [success] => [row_count] => 0 [new_sql] => SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50 [error] => Database Error (bp_database::Query): 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 's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50' at line 1 SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50 [pagination] => Array ( [max_rows] => 50 [start] => 51 [current_page] => 1.02 [first_page] => 1 [next_page] => 2.02 [prev_page] => 0.02 [last_page] => 0 [total_rows] => 0 ) ) =========================
=== DEBUG INFORMATION ===
=========================
Array ( [tables] => Array ( [subfiles] => subfiles [tvseries] => tv_series [movies] => movies [languages] => languages ) [sub_fields] => Array ( [0] => file_id [1] => file_name [2] => folder [3] => language [4] => type [5] => tv_series_id [6] => movie_id ) [tv_fields] => Array ( [0] => tv_id [1] => name as sName [2] => synopses as sSynopses [3] => genres as sGenre [4] => imdb_id as sImdb_id [5] => tmdb_id as sTmdb_id [6] => tvdb_id as sTvdb_id [7] => trakt_id as sTrakt_id ) [movie_fields] => Array ( [0] => movie_id [1] => name as mName [2] => synopses as mSynopses [3] => genres as mGenre [4] => imdb_id as mImdb_id [5] => tmdb_id as mTmdb_id [6] => tvdb_id as mTvdb_id [7] => trakt_id as mTrakt_id ) [lFields] => Array ( [0] => lang_id [1] => language [2] => lang_patterns [3] => displayed as lang_display ) [join] => Array ( [iTable] => Array ( [0] => tv_series [1] => movies [2] => languages ) [iField] => Array ( [0] => tv_id [1] => movie_id [2] => lang_id ) [mTable] => Array ( [0] => subfiles [1] => subfiles [2] => subfiles ) [mField] => Array ( [0] => tv_series_id [1] => movie_id [2] => language ) ) [query_fields] => Array ( [0] => `subfiles`.`file_id` [1] => `subfiles`.`file_name` [2] => `subfiles`.`folder` [3] => `subfiles`.`language` [4] => `subfiles`.`type` [5] => `subfiles`.`tv_series_id` [6] => `subfiles`.`movie_id` [7] => `tv_series`.`tv_id` [8] => `tv_series`.`name` as sName [9] => `tv_series`.`synopses` as sSynopses [10] => `tv_series`.`genres` as sGenre [11] => `tv_series`.`imdb_id` as sImdb_id [12] => `tv_series`.`tmdb_id` as sTmdb_id [13] => `tv_series`.`tvdb_id` as sTvdb_id [14] => `tv_series`.`trakt_id` as sTrakt_id [15] => `movies`.`movie_id` [16] => `movies`.`name` as mName [17] => `movies`.`synopses` as mSynopses [18] => `movies`.`genres` as mGenre [19] => `movies`.`imdb_id` as mImdb_id [20] => `movies`.`tmdb_id` as mTmdb_id [21] => `movies`.`tvdb_id` as mTvdb_id [22] => `movies`.`trakt_id` as mTrakt_id [23] => `languages`.`lang_id` [24] => `languages`.`language` [25] => `languages`.`lang_patterns` [26] => `languages`.`displayed` as lang_display ) [qWhere] => Array ( [0] => `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ) [db_subfiles] => Array ( [sql] => SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50 [success] => [row_count] => 0 [new_sql] => SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50 [error] => Database Error (bp_database::Query): 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 's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50' at line 1 SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassin's Creed (2016)%' ORDER BY file_id ASC LIMIT 1, 50 [pagination] => Array ( [max_rows] => 50 [start] => 51 [current_page] => 1.02 [first_page] => 1 [next_page] => 2.02 [prev_page] => 0.02 [last_page] => 0 [total_rows] => 0 ) ) ) =========================