SQLSTATE error code: HY000
Msg: View 'pmc.pmc_view_artists_songs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

SQL: [387] SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(actions, ',', numbers.n), ',', -1) id, COUNT(*) nb FROM (SELECT 1 n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) numbers INNER JOIN pmc_view_artists_songs ON CHAR_LENGTH(actions)-CHAR_LENGTH(REPLACE(actions, ',', ''))>=numbers.n-1 WHERE art_id = 15 GROUP BY SUBSTRING_INDEX(SUBSTRING_INDEX(actions, ',', numbers.n), ',', -1) ORDER BY n Params: 2 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2
SQLSTATE error code: HY000
Msg: View 'pmc.pmc_view_artists_songs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

SQL: [106] SELECT alb_id id, COUNT(*) nb FROM pmc_view_artists_songs WHERE alb_id = ? AND art_id = ? GROUP BY alb_id Sent SQL: [115] SELECT alb_id id, COUNT(*) nb FROM pmc_view_artists_songs WHERE alb_id = '119' AND art_id = '1285' GROUP BY alb_id Params: 2 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2
SQLSTATE error code: HY000
Msg: View 'pmc.pmc_view_artists_songs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

SQL: [79] SELECT COUNT(*) nb FROM pmc_view_artists_songs WHERE alb_id = ? AND art_id = ? Sent SQL: [88] SELECT COUNT(*) nb FROM pmc_view_artists_songs WHERE alb_id = '119' AND art_id = '1285' Params: 2 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2
The Paul McCartney project
The Paul McCartney Project
SQLSTATE error code: HY000
Msg: View 'pmc.pmc_view_artists_songs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

SQL: [87] SELECT COUNT(*) nb FROM pmc_view_artists_songs WHERE alt_id NOT IN (3,4) AND art_id = ? Sent SQL: [92] SELECT COUNT(*) nb FROM pmc_view_artists_songs WHERE alt_id NOT IN (3,4) AND art_id = '1285' Params: 1 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2

Hugh Padgham

Producer of official Paul McCartney records

Too many songs listed? Narrow down the list by using the following filters:

Showing 1 - 0 of 0 results
SQLSTATE error code: HY000
Msg: View 'pmc.pmc_view_artists_songs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

SQL: [98] SELECT * FROM pmc_view_artists_songs WHERE alb_id = ? AND art_id = ? ORDER BY trk_name LIMIT 0,50 Sent SQL: [107] SELECT * FROM pmc_view_artists_songs WHERE alb_id = '119' AND art_id = '1285' ORDER BY trk_name LIMIT 0,50 Params: 2 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2