DB Error: syntax errorDB_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => -2 [message] => DB Error: syntax error [userinfo] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [nativecode=1064 ** 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 time_from > '2008-11-19 23:32:51' LIMIT 10' at line 1] [backtrace] => Array ( [0] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB.php [line] => 748 [function] => PEAR_Error [class] => PEAR_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => DB Error: syntax error [1] => -2 [2] => 16 [3] => error_handler [4] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [nativecode=1064 ** 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 time_from > '2008-11-19 23:32:51' LIMIT 10' at line 1] ) ) [1] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/PEAR.php [line] => 536 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -2 [1] => 16 [2] => error_handler [3] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [nativecode=1064 ** 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 time_from > '2008-11-19 23:32:51' LIMIT 10' at line 1] ) ) [2] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/common.php [line] => 500 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => [1] => -2 [2] => [3] => [4] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [nativecode=1064 ** 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 time_from > '2008-11-19 23:32:51' LIMIT 10' at line 1] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/mysql.php [line] => 775 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => -2 [1] => [2] => [3] => [4] => 1064 ** 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 time_from > '2008-11-19 23:32:51' LIMIT 10' at line 1 ) ) [4] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/mysql.php [line] => 227 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/common.php [line] => 1144 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 ) ) [6] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/common.php [line] => 1581 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 ) ) [7] => Array ( [file] => /var/www/clients/beautcamppilates/lib/noddy_Database.lib.php [line] => 84 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 ) ) [8] => Array ( [file] => /var/www/clients/beautcamppilates/lib/bp_Trainer.class.php [line] => 25 [function] => get_all [class] => noddy_Database [object] => noddy_Database Object ( [db] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [modes] => STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ) [type] => -> [args] => Array ( [0] => SELECT id FROM classes WHERE trainer_id = AND time_from > '2008-11-19 23:32:51' LIMIT 10 ) ) [9] => Array ( [file] => /var/www/clients/beautcamppilates/controllers/trainer.php [line] => 10 [function] => get_future_classes [class] => bp_Trainer [object] => bp_Trainer Object ( [data] => [person] => bp_User Object ( [data] => Array ( [login] => guest [status] => guest [id] => 0 ) [alert_if_credits_below] => 5 ) ) [type] => -> [args] => Array ( [0] => 10 ) ) [10] => Array ( [file] => /var/www/clients/beautcamppilates/www/index.php [line] => 27 [args] => Array ( [0] => /var/www/clients/beautcamppilates/controllers/trainer.php ) [function] => require_once ) ) [callback] => error_handler )

DB Error: no such fieldDB_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => -19 [message] => DB Error: no such field [userinfo] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [nativecode=1054 ** Unknown column 'D' in 'where clause'] [backtrace] => Array ( [0] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB.php [line] => 748 [function] => PEAR_Error [class] => PEAR_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => DB Error: no such field [1] => -19 [2] => 16 [3] => error_handler [4] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [nativecode=1054 ** Unknown column 'D' in 'where clause'] ) ) [1] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/PEAR.php [line] => 536 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -19 [1] => 16 [2] => error_handler [3] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [nativecode=1054 ** Unknown column 'D' in 'where clause'] ) ) [2] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/common.php [line] => 500 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => [1] => -19 [2] => [3] => [4] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [nativecode=1054 ** Unknown column 'D' in 'where clause'] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/mysql.php [line] => 775 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => -19 [1] => [2] => [3] => [4] => 1054 ** Unknown column 'D' in 'where clause' ) ) [4] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/mysql.php [line] => 227 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/common.php [line] => 1144 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D ) ) [6] => Array ( [file] => /var/www/clients/beautcamppilates/lib/pear/DB/common.php [line] => 1280 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D ) ) [7] => Array ( [file] => /var/www/clients/beautcamppilates/lib/noddy_Database.lib.php [line] => 96 [function] => getRow [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [type] => -> [args] => Array ( [0] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D ) ) [8] => Array ( [file] => /var/www/clients/beautcamppilates/lib/bp_Class.class.php [line] => 165 [function] => get_row [class] => noddy_Database [object] => noddy_Database Object ( [db] => DB_mysql Object ( [connection] => Resource id #18 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => beautcamppilates [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1048] => -3 [1216] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 4 [optimize] => portability ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => beautcamp [password] => P1lat35 [protocol] => [hostspec] => localhost [port] => [socket] => [database] => beautcamppilates ) ) [modes] => STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ) [type] => -> [args] => Array ( [0] => SELECT classes.id,classes.created,classes.time_from,classes.places,classes.specialprice,classes.description,classes.classtype_id,classes.classrate_id,classes.trainer_id,classes.pa_id,classes.room_id, classrates.name as rate_name,classrates.description as rate_description,classrates.price as rate_price, classtypes.name as type_name,classtypes.description as type_description, rooms.name as room_name, locations.code as location_code,locations.name as location_name, locations.phone as location_phone, locations.email as location_email FROM classes LEFT JOIN classrates ON classrates.id = classrate_id LEFT JOIN classtypes ON classtypes.id = classtype_id LEFT JOIN rooms ON room_id = rooms.id LEFT JOIN locations ON rooms.location_id = locations.id WHERE classes.id=D ) ) [9] => Array ( [file] => /var/www/clients/beautcamppilates/lib/bp_Class.class.php [line] => 6 [function] => get_data [class] => bp_Class [object] => bp_Class Object ( ) [type] => -> [args] => Array ( [0] => D ) ) [10] => Array ( [file] => /var/www/clients/beautcamppilates/lib/bp_Trainer.class.php [line] => 27 [function] => bp_Class [class] => bp_Class [object] => bp_Class Object ( ) [type] => -> [args] => Array ( [0] => D ) ) [11] => Array ( [file] => /var/www/clients/beautcamppilates/controllers/trainer.php [line] => 10 [function] => get_future_classes [class] => bp_Trainer [object] => bp_Trainer Object ( [data] => [person] => bp_User Object ( [data] => Array ( [login] => guest [status] => guest [id] => 0 ) [alert_if_credits_below] => 5 ) [classes] => Array ( [] => bp_Class Object ( ) ) ) [type] => -> [args] => Array ( [0] => 10 ) ) [12] => Array ( [file] => /var/www/clients/beautcamppilates/www/index.php [line] => 27 [args] => Array ( [0] => /var/www/clients/beautcamppilates/controllers/trainer.php ) [function] => require_once ) ) [callback] => error_handler )