DB Error: no such table<br>
<pre>db_error Object
(
    [error_message_prefix] => 
    [mode] => 1
    [level] => 1024
    [code] => -18
    [message] => DB Error: no such table
    [userinfo] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		 [nativecode=1146 ** Table 'bulgariansunproperties.rea_object_pics' doesn't exist]
    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/DB.php
                    [line] => 739
                    [function] => pear_error
                    [class] => db_error
                    [type] => ->
                    [args] => Array
                        (
                            [0] => DB Error: no such table
                            [1] => -18
                            [2] => 1
                            [3] => 1024
                            [4] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		 [nativecode=1146 ** Table 'bulgariansunproperties.rea_object_pics' doesn't exist]
                        )

                )

            [1] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/PEAR.php
                    [line] => 523
                    [function] => db_error
                    [class] => db_error
                    [type] => ->
                    [args] => Array
                        (
                            [0] => -18
                            [1] => 1
                            [2] => 1024
                            [3] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		 [nativecode=1146 ** Table 'bulgariansunproperties.rea_object_pics' doesn't exist]
                        )

                )

            [2] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/DB/common.php
                    [line] => 495
                    [function] => raiseerror
                    [class] => pear
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
                            [1] => -18
                            [2] => 
                            [3] => 
                            [4] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		 [nativecode=1146 ** Table 'bulgariansunproperties.rea_object_pics' doesn't exist]
                            [5] => DB_Error
                            [6] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/DB/mysql.php
                    [line] => 770
                    [function] => raiseerror
                    [class] => db_mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => -18
                            [1] => 
                            [2] => 
                            [3] => 
                            [4] => 1146 ** Table 'bulgariansunproperties.rea_object_pics' doesn't exist
                        )

                )

            [4] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/DB/mysql.php
                    [line] => 233
                    [function] => mysqlraiseerror
                    [class] => db_mysql
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [5] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/DB/common.php
                    [line] => 1135
                    [function] => simplequery
                    [class] => db_mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		
                        )

                )

            [6] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/pear/DB/common.php
                    [line] => 1572
                    [function] => query
                    [class] => db_mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		
                        )

                )

            [7] => Array
                (
                    [file] => /www/bulgariansunproperties.com/root/offers.php
                    [line] => 230
                    [function] => getall
                    [class] => db_mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					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) as pic,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				   AND pt.id = '22'    
				    AND object.offer_type < '2'   
			GROUP BY object.id
			ORDER BY object.pos
		
                        )

                )

        )

    [callback] => 
)
</pre>