Error Logs

[3/3] Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("Unable to execute SELECT statement [SELECT `id`, `advertiser_id`, `name`, `description`, `dealer_class`, `is_new_car_dealer`, `is_used_car_dealer`, `logo`, `email_address`, `site_url`, `facebook_url`, `twitter_url`, `youtube_url`, `linked_in_url`, `google_plus_url`, `pinterest_url`, `blog_url`, `address`, `contact_info`, `use_contact_info`, `fax_info`, `date_created`, `city_id`, `slug`, `profile_image_file_name`, `location_latitude`, `location_longitude`, `year_founded`, `status_text`, `opening_hours`, `mission`, `award`, `sulit_id`, `show_tutorials`, `is_sulit_listings_imported`, `import_stage`, `rank_value` FROM `dealer` WHERE `id` = :p0] [wrapped: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinterest_url' in 'field list']") in PATMainBundle:Frontend/Default:index.html.twig at line 17. [2/3] PropelException: Unable to execute SELECT statement [SELECT `id`, `advertiser_id`, `name`, `description`, `dealer_class`, `is_new_car_dealer`, `is_used_car_dealer`, `logo`, `email_address`, `site_url`, `facebook_url`, `twitter_url`, `youtube_url`, `linked_in_url`, `google_plus_url`, `pinterest_url`, `blog_url`, `address`, `contact_info`, `use_contact_info`, `fax_info`, `date_created`, `city_id`, `slug`, `profile_image_file_name`, `location_latitude`, `location_longitude`, `year_founded`, `status_text`, `opening_hours`, `mission`, `award`, `sulit_id`, `show_tutorials`, `is_sulit_listings_imported`, `import_stage`, `rank_value` FROM `dealer` WHERE `id` = :p0] [wrapped: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinterest_url' in 'field list'] [1/3] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinterest_url' in 'field list' Logs 2 errors DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". INFO - Matched route "pat_main_frontend_homepage" (parameters: "_controller": "PAT\MainBundle\Controller\Frontend\DefaultController::indexAction", "_route": "pat_main_frontend_homepage") DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\Fragment\FragmentHandler::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DeprecationLoggerListener::injectLogger". DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". DEBUG - time: 0.271 sec | mem: 27.4 MB | connection: default | SELECT premier_headline_photo.id, premier_headline_photo.dealer_id, premier_headline_photo.image_file_name, premier_headline_photo.text_label, premier_headline_photo.date_created, premier_headline_photo.target_url, premier_headline_photo.title, premier_headline_photo.description, premier_headline_photo.slug, premier_headline_photo.position, premier_headline_photo.is_outbound FROM `premier_headline_photo` INNER JOIN `advertisement` ON (premier_headline_photo.id=advertisement.generic_id) WHERE advertisement.product_id = 13 AND advertisement.start_date <= '2013-07-16' AND advertisement.end_date >= '2013-07-16' AND advertisement.status = 1 ORDER BY premier_headline_photo.position ASC LIMIT 4 DEBUG - time: 0.204 sec | mem: 33.6 MB | connection: default | SELECT used_car.id, used_car.dealer_id, used_car.car_maker_id, used_car.car_model_id, used_car.car_model_variant_id, used_car.title, used_car.slug, used_car.description, used_car.price, used_car.model_year, used_car.mileage, used_car.city_id, used_car.body_type_id, used_car.fuel_type_id, used_car.engine_type_id, used_car.transmission_type_id, used_car.color_id, used_car.original_color_id, used_car.door_count, used_car.reason_for_selling, used_car.date_created, used_car.photo_count, used_car.cylinder_id, used_car.valve_id, used_car.engine_size_id, used_car.status, used_car.registration_number, used_car.step, used_car.sulit_id, RAND() AS `random_rank` FROM `used_car` INNER JOIN `advertisement` ON (used_car.id=advertisement.generic_id) INNER JOIN `used_car_rank_value` ON (used_car.id=used_car_rank_value.used_car_id) WHERE advertisement.generic_id = used_car.id AND advertisement.product_id = 10 AND advertisement.start_date <= '2013-07-16' AND advertisement.end_date >= '2013-07-16' AND advertisement.status = 1 AND used_car_rank_value.effective_date='2013-07-16 00:00:00' AND used_car.status=1 ORDER BY random_rank ASC LIMIT 1 DEBUG - time: 0.001 sec | mem: 33.6 MB | connection: default | SELECT used_car.id, used_car.dealer_id, used_car.car_maker_id, used_car.car_model_id, used_car.car_model_variant_id, used_car.title, used_car.slug, used_car.description, used_car.price, used_car.model_year, used_car.mileage, used_car.city_id, used_car.body_type_id, used_car.fuel_type_id, used_car.engine_type_id, used_car.transmission_type_id, used_car.color_id, used_car.original_color_id, used_car.door_count, used_car.reason_for_selling, used_car.date_created, used_car.photo_count, used_car.cylinder_id, used_car.valve_id, used_car.engine_size_id, used_car.status, used_car.registration_number, used_car.step, used_car.sulit_id FROM `used_car` INNER JOIN `used_car_rank_value` ON (used_car.id=used_car_rank_value.used_car_id) INNER JOIN `advertisement` ON (used_car.id=advertisement.generic_id) WHERE used_car.status=1 AND (1=1 AND advertisement.generic_id = used_car.id AND advertisement.start_date <= '2013-07-16' AND advertisement.end_date >= '2013-07-16' AND advertisement.status = 1) AND used_car_rank_value.effective_date='2013-07-16 00:00:00' GROUP BY used_car.id ORDER BY used_car_rank_value.value DESC LIMIT 10 DEBUG - time: 0.087 sec | mem: 34.4 MB | connection: default | SELECT featured_dealer.id, featured_dealer.dealer_id, featured_dealer.image_file_name, featured_dealer.text_label, featured_dealer.date_created, RAND() AS `random_rank` FROM `featured_dealer` INNER JOIN `advertisement` ON (featured_dealer.id=advertisement.generic_id) WHERE advertisement.product_id IN (21) AND advertisement.start_date <= '2013-07-16' AND advertisement.end_date >= '2013-07-16' AND advertisement.status = 1 AND featured_dealer.dealer_id<>1 ORDER BY random_rank DESC LIMIT 1 DEBUG - time: 0.062 sec | mem: 36.8 MB | connection: default | SELECT blog_post.id, blog_post.title, blog_post.slug, blog_post.content, blog_post.date_created, blog_post.image_file_name, blog_post.status, blog_post.is_featured, blog_post.blog_post_author_id, blog_post.blog_cobrand_id FROM `blog_post` INNER JOIN `featured_blog_post` ON (blog_post.id=featured_blog_post.blog_post_id) WHERE featured_blog_post.page_id=1 AND blog_post.status=1 ORDER BY blog_post.date_created DESC LIMIT 1 DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\Fragment\FragmentHandler::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DeprecationLoggerListener::injectLogger". DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". DEBUG - Notified event "kernel.response" to listener "Symfony\Bridge\Monolog\Handler\FirePHPHandler::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\CacheListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\Fragment\FragmentHandler::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\Fragment\FragmentHandler::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DeprecationLoggerListener::injectLogger". DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". DEBUG - Notified event "kernel.response" to listener "Symfony\Bridge\Monolog\Handler\FirePHPHandler::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\CacheListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\Fragment\FragmentHandler::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". DEBUG - Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse". ERROR - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinterest_url' in 'field list' DEBUG - Notified event "kernel.exception" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelException". DEBUG - Notified event "kernel.exception" to listener "Symfony\Component\HttpKernel\EventListener\ExceptionListener::onKernelException". CRITICAL - Uncaught PHP Exception Twig_Error_Runtime: "An exception has been thrown during the rendering of a template ("Unable to execute SELECT statement [SELECT `id`, `advertiser_id`, `name`, `description`, `dealer_class`, `is_new_car_dealer`, `is_used_car_dealer`, `logo`, `email_address`, `site_url`, `facebook_url`, `twitter_url`, `youtube_url`, `linked_in_url`, `google_plus_url`, `pinterest_url`, `blog_url`, `address`, `contact_info`, `use_contact_info`, `fax_info`, `date_created`, `city_id`, `slug`, `profile_image_file_name`, `location_latitude`, `location_longitude`, `year_founded`, `status_text`, `opening_hours`, `mission`, `award`, `sulit_id`, `show_tutorials`, `is_sulit_listings_imported`, `import_stage`, `rank_value` FROM `dealer` WHERE `id` = :p0] [wrapped: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pinterest_url' in 'field list']") in "PATMainBundle:Frontend/Default:index.html.twig" at line 17." at /Volumes/PatDev/Aston/pat/app/cache/dev/classes.php line 6064 DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\Fragment\FragmentHandler::onKernelRequest". DEBUG - Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DeprecationLoggerListener::injectLogger". DEBUG - Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". DEBUG - Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".