DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -19 [message] => DB Error: no such field [userinfo] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn [nativecode=1054 ** Unknown column 'artist.name_chn' in 'where clause'] [backtrace] => Array ( [0] => Array ( [file] => /home/classicalm/html/libraries/PEAR/DB.php [line] => 888 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => DB Error: no such field [1] => -19 [2] => 1 [3] => 1024 [4] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn [nativecode=1054 ** Unknown column 'artist.name_chn' in 'where clause'] ) ) [1] => Array ( [file] => /usr/share/php/PEAR.php [line] => 531 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -19 [1] => 1 [2] => 1024 [3] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn [nativecode=1054 ** Unknown column 'artist.name_chn' in 'where clause'] ) ) [2] => Array ( [file] => /home/classicalm/html/libraries/PEAR/DB/common.php [line] => 1849 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 ) [connection] => Resource id #40 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => classicalm [password] => urnfhd4r58 [protocol] => tcp [hostspec] => 192.168.0.41 [port] => 3306 [socket] => [database] => classicalm_db ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => classicalm_db [fetchmode] => 2 [fetchmode_object_class] => stdClass [was_connected] => 1 [last_query] => [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => [1] => -19 [2] => [3] => [4] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn [nativecode=1054 ** Unknown column 'artist.name_chn' in 'where clause'] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /home/classicalm/html/libraries/PEAR/DB/mysql.php [line] => 894 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 ) [connection] => Resource id #40 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => classicalm [password] => urnfhd4r58 [protocol] => tcp [hostspec] => 192.168.0.41 [port] => 3306 [socket] => [database] => classicalm_db ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => classicalm_db [fetchmode] => 2 [fetchmode_object_class] => stdClass [was_connected] => 1 [last_query] => [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => -19 [1] => [2] => [3] => [4] => 1054 ** Unknown column 'artist.name_chn' in 'where clause' ) ) [4] => Array ( [file] => /home/classicalm/html/libraries/PEAR/DB/mysql.php [line] => 324 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 ) [connection] => Resource id #40 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => classicalm [password] => urnfhd4r58 [protocol] => tcp [hostspec] => 192.168.0.41 [port] => 3306 [socket] => [database] => classicalm_db ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => classicalm_db [fetchmode] => 2 [fetchmode_object_class] => stdClass [was_connected] => 1 [last_query] => [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /home/classicalm/html/libraries/PEAR/DB/common.php [line] => 1162 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 ) [connection] => Resource id #40 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => classicalm [password] => urnfhd4r58 [protocol] => tcp [hostspec] => 192.168.0.41 [port] => 3306 [socket] => [database] => classicalm_db ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => classicalm_db [fetchmode] => 2 [fetchmode_object_class] => stdClass [was_connected] => 1 [last_query] => [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn ) ) [6] => Array ( [file] => /home/classicalm/html/libraries/PEAR/DB/common.php [line] => 1609 [function] => query [class] => DB_common [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 ) [connection] => Resource id #40 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => classicalm [password] => urnfhd4r58 [protocol] => tcp [hostspec] => 192.168.0.41 [port] => 3306 [socket] => [database] => classicalm_db ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => classicalm_db [fetchmode] => 2 [fetchmode_object_class] => stdClass [was_connected] => 1 [last_query] => [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn ) ) [7] => Array ( [file] => /home/classicalm/html/modules/artists.php [line] => 189 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 ) [connection] => Resource id #40 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => classicalm [password] => urnfhd4r58 [protocol] => tcp [hostspec] => 192.168.0.41 [port] => 3306 [socket] => [database] => classicalm_db ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => classicalm_db [fetchmode] => 2 [fetchmode_object_class] => stdClass [was_connected] => 1 [last_query] => [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => select * from genre where exists ( select * from composition_artist inner join composition on composition_artist.composition_id=composition.id inner join artist on artist.id=composition_artist.artist_id where (genre_id =genre.id or genre2_id =genre.id ) and inlist=1 and (lower(artist.name_chn) REGEXP '[[:<:]]h.' or lower(artist.name_chn) REGEXP '[[:<:]]h.') limit 1) order by name_chn ) ) [8] => Array ( [file] => /home/classicalm/html/coreIndex.php [line] => 53 [args] => Array ( [0] => /home/classicalm/html/modules/artists.php ) [function] => include_once ) ) [callback] => )