DB Error: no such field
DB_Error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -19
[message] => DB Error: no such field
[userinfo] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[nativecode=1054 ** Unknown column 'object.additional_info_10' in 'field list']
[backtrace] => Array
(
[0] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB.php
[line] => 739
[function] => PEAR_Error
[class] => PEAR_Error
[object] => DB_Error Object
*RECURSION*
[type] => ->
[args] => Array
(
[0] => DB Error: no such field
[1] => -19
[2] => 1
[3] => 1024
[4] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[nativecode=1054 ** Unknown column 'object.additional_info_10' in 'field list']
)
)
[1] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/PEAR.php
[line] => 523
[function] => DB_Error
[class] => DB_Error
[object] => DB_Error Object
*RECURSION*
[type] => ->
[args] => Array
(
[0] => -19
[1] => 1
[2] => 1024
[3] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[nativecode=1054 ** Unknown column 'object.additional_info_10' in 'field list']
)
)
[2] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/common.php
[line] => 495
[function] => raiseError
[class] => PEAR
[object] => DB_mysql Object
(
[connection] => Resource id #14
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[25] => 33
[26] => 4
[30] => 21
[31] => 15
[32] => 5197
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[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
[1048] => -3
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1216] => -3
[1217] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[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] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] =>
[1] => -19
[2] =>
[3] =>
[4] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[nativecode=1054 ** Unknown column 'object.additional_info_10' in 'field list']
[5] => DB_Error
[6] => 1
)
)
[3] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/mysql.php
[line] => 776
[function] => raiseError
[class] => DB_common
[object] => DB_mysql Object
(
[connection] => Resource id #14
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[25] => 33
[26] => 4
[30] => 21
[31] => 15
[32] => 5197
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[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
[1048] => -3
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1216] => -3
[1217] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[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] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => -19
[1] =>
[2] =>
[3] =>
[4] => 1054 ** Unknown column 'object.additional_info_10' in 'field list'
)
)
[4] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/mysql.php
[line] => 228
[function] => mysqlRaiseError
[class] => DB_mysql
[object] => DB_mysql Object
(
[connection] => Resource id #14
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[25] => 33
[26] => 4
[30] => 21
[31] => 15
[32] => 5197
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[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
[1048] => -3
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1216] => -3
[1217] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[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] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/common.php
[line] => 1135
[function] => simpleQuery
[class] => DB_mysql
[object] => DB_mysql Object
(
[connection] => Resource id #14
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[25] => 33
[26] => 4
[30] => 21
[31] => 15
[32] => 5197
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[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
[1048] => -3
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1216] => -3
[1217] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[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] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
)
)
[6] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/common.php
[line] => 1572
[function] => query
[class] => DB_common
[object] => DB_mysql Object
(
[connection] => Resource id #14
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[25] => 33
[26] => 4
[30] => 21
[31] => 15
[32] => 5197
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[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
[1048] => -3
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1216] => -3
[1217] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[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] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
)
)
[7] => Array
(
[file] => /www.storage/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/offers.php
[line] => 748
[function] => getAll
[class] => DB_common
[object] => DB_mysql Object
(
[connection] => Resource id #14
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[25] => 33
[26] => 4
[30] => 21
[31] => 15
[32] => 5197
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[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
[1048] => -3
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1216] => -3
[1217] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[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] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT object.id AS object_id,
object.additional_info_10 AS additional_info,
object.brief_description_10 AS brief_description,
object.view_10 AS view,
object.price_is_from,
object.post_date ,
object.size,
object.yard,
object.ref_no,
(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
object.price_eur,
object.price_usd,
object.price_gbr,
object.price_bgn,
object.offer_type,
object.is_new,
object.is_top,
city.name_10 as city_name,city.id as ct_id,
pt.name_10 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate,
object.newprice_eur,
object.newprice_usd,
object.newprice_gbr,
object.newprice_bgn,
object.discount
FROM rea_object AS object
LEFT JOIN rea_city AS city ON city.id = object.city_id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
WHERE object.edate = 0 AND object.is_active < 1
AND object.property_type_id = '0'
ORDER BY object.id DESC
LIMIT 0, 10
)
)
)
[callback] =>
)