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_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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_9' in 'field list']
[backtrace] => Array
(
[0] => Array
(
[file] => /www/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB.php
[line] => 739
[function] => pear_error
[class] => db_error
[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_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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_9' in 'field list']
)
)
[1] => Array
(
[file] => /www/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/PEAR.php
[line] => 523
[function] => db_error
[class] => db_error
[type] => ->
[args] => Array
(
[0] => -19
[1] => 1
[2] => 1024
[3] => SELECT DISTINCT object.id AS object_id,
object.additional_info_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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_9' in 'field list']
)
)
[2] => Array
(
[file] => /www/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/common.php
[line] => 500
[function] => raiseerror
[class] => pear
[type] => ::
[args] => Array
(
[0] =>
[1] => -19
[2] =>
[3] =>
[4] => SELECT DISTINCT object.id AS object_id,
object.additional_info_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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_9' in 'field list']
[5] => DB_Error
[6] => 1
)
)
[3] => Array
(
[file] => /www/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/mysql.php
[line] => 776
[function] => raiseerror
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => -19
[1] =>
[2] =>
[3] =>
[4] => 1054 ** Unknown column 'object.additional_info_9' in 'field list'
)
)
[4] => Array
(
[file] => /www/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/mysql.php
[line] => 228
[function] => mysqlraiseerror
[class] => db_mysql
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /www/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/common.php
[line] => 1146
[function] => simplequery
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT object.id AS object_id,
object.additional_info_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/pear/DB/common.php
[line] => 1596
[function] => query
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT object.id AS object_id,
object.additional_info_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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/bulgarianestates.org.uk/root.new1.bulgarianestates.org.uk/offers.php
[line] => 648
[function] => getall
[class] => db_mysql
[type] => ->
[args] => Array
(
[0] => SELECT DISTINCT object.id AS object_id,
object.additional_info_9 AS additional_info,
object.brief_description_9 AS brief_description,
object.view_9 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_9 as city_name,city.id as ct_id,
pt.name_9 as pt_name, pt.id as pt_id,
object.metric_yard,object.metric_size,
object.new_offer_postdate
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] =>
)