Error
Error:
Message: Incorrect DATETIME value: ''
SELECT (SELECT GROUP_CONCAT(times_datetime SEPARATOR '###') FROM programs_times WHERE times_program_id = programs.program_id AND times_datetime > '2025-10-11 09:17:40') as programs_less_time_view , (SELECT GROUP_CONCAT(times_datetime SEPARATOR '###') FROM programs_times WHERE times_program_id = programs.program_id) as program_times_datetime , (SELECT MAX(prices_living_price) as max_price FROM programs_prices WHERE programs_prices.prices_program_id = programs.program_id) as max_price , (SELECT MIN(prices_living_price) as min_price FROM programs_prices WHERE programs_prices.prices_program_id = programs.program_id) as min_price , programs.* , country_return_direction_from.country_name as country_return_from , country_return_direction_to.country_name as country_return_to , country_go_direction_from.country_name as country_go_from , country_direction_to.country_name as country_go_to , program_mecca_hotel.hotel_stars as hotel_hotel_stars_mecca, program_mecca_hotel.hotel_image_slide as hotel_image_slide_mecca, program_mecca_hotel.hotel_id as hotel_id_mecca, program_mecca_hotel.hotel_name as hotel_name_mecca, program_mecca_hotel.hotel_image as hotel_image_mecca , program_medina_hotel.hotel_stars as hotel_hotel_stars_medina, program_medina_hotel.hotel_image_slide as hotel_image_slide_medina, program_medina_hotel.hotel_id as hotel_id_medina, program_medina_hotel.hotel_name as hotel_name_medina, program_medina_hotel.hotel_image as hotel_image_medina , features.*, programs_features.*, features_image.*, programs_prices.*, living_type.*, programs_times.*, season.* FROM programs LEFT JOIN countrys as country_return_direction_to ON country_return_direction_to.country_id = programs.program_return_direction_to LEFT JOIN countrys as country_return_direction_from ON country_return_direction_from.country_id = programs.program_return_direction_from LEFT JOIN countrys as country_direction_to ON country_direction_to.country_id = programs.program_go_direction_to LEFT JOIN countrys as country_go_direction_from ON country_go_direction_from.country_id = programs.program_go_direction_from LEFT JOIN hotels as program_medina_hotel ON program_medina_hotel.hotel_id = programs.program_medina_hotel LEFT JOIN hotels as program_mecca_hotel ON program_mecca_hotel.hotel_id = programs.program_mecca_hotel LEFT JOIN programs_features ON programs_features.programs_features_program_id = programs.program_id LEFT JOIN features ON features.feature_id = programs_features.programs_features_feature_id LEFT JOIN features_image ON features_image.features_image_id = features.feature_image LEFT JOIN programs_prices ON programs_prices.prices_program_id = programs.program_id LEFT JOIN living_type ON living_type.living_id = programs_prices.prices_living_id LEFT JOIN programs_times ON programs_times.times_program_id = programs.program_id LEFT JOIN season ON season.season_id = programs.program_season WHERE program_name LIKE '%عمرة مستوي سياحي 15 يوم - 14 ليلة%' AND program_active = 0 AND programs_times.times_datetime > '' GROUP BY prices_id ORDER BY prices_living_price DESC
File: /home11/omraonline/public_html/app/models/programs/programs.php: at line ( 106 )
Line: 106
Class: Thisphp\system\library\models\models
Function: execute
Args: 'FETCH_ASSOC' , 'prices_living_price DESC' , 'prices_id' , ''
Trace:
#0 /home11/omraonline/public_html/app/models/programs/programs.php(106): Thisphp\system\library\models\models->execute('FETCH_ASSOC', 'prices_living_p...', 'prices_id', NULL)
#1 /home11/omraonline/public_html/app/controllers/programs/programs.php(92): Thisphp\app\models\programs\programs->getprograms(Array, 'prices_living_p...', 'prices_id')
#2 [internal function]: Thisphp\app\controllers\programs\programs->view('\xD8\xB9\xD9\x85\xD8\xB1\xD8\xA9_\xD9\x85\xD8\xB3\xD8\xAA...')
#3 /home11/omraonline/public_html/system/library/bootstrap/bootstrap.php(82): call_user_func_array(Array, Array)
#4 /home11/omraonline/public_html/system/library/bootstrap/bootstrap.php(49): Thisphp\system\library\bootstrap\bootstrap->_callControllerMethod()
#5 /home11/omraonline/public_html/index.php(52): Thisphp\system\library\bootstrap\bootstrap->__construct()
#6 {main}
Other Mistakes:
Message: Undefined index: HTTP_COOKIE
File: /home11/omraonline/public_html/system/library/request_variables/request_variables.php: at line ( 32 )