Database Error

Се појави грешка во базата на податоци при извршување на побараната процедура. За повеќе информации, прегледајте ја грешката опишана доле.

system/libraries/drivers/Database/Mysql.php [371]:

Се појави SQL грешка: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group by d.id, do.id ORDER BY d.id ASC, do.active DESC, disabled_sort_fla...' at line 70 - SELECT d.is_general_deal, d.id AS deal_id, d.category_id, d.subcategory_id, d.vraboten_id, d.partner_id, do.title_mk, do.title_mk_clean, do.content_short_mk, d.visible, d.primary1, d.primary2, d.primary3, d.primary4, d.primary5, d.start_time, d.end_time, d.min_ammount, do.max_ammount, d.max_per_person, do.price, do.price_discount, do.valid_from, do.valid_to, d.locked, d.created, d.edited, d.main_img, d.side_img, d.card, d.demo, d.tip, do.price_voucher, d.prati_mail_do_partner, d.ponuda_video, d.tip_danocna_sema, d.ddv_stapka, d.email_content_buy, d.email_content_buy_switch, d.platena_reklama, d.platena_reklama_date, do.fiktivni_kuponi_num, d.partner_notified_for_active_offer, d.additional_img_1, d.additional_img_2, d.additional_img_3, d.additional_img_4, d.additional_img_5, do.id AS deal_option_id, do.default_option, do.active, IF(d.tip = 'cena_na_vaucer', do.price_voucher, do.price_discount) AS finalna_cena, (COUNT(v.id) +do.fiktivni_kuponi_num) AS voucher_count, IF( (do.valid_to <> '0000-00-00 00:00:00' AND do.valid_to < NOW() ) OR (do.max_ammount > 0 AND (COUNT(v.id) +do.fiktivni_kuponi_num) >= do.max_ammount) , 1, 0) AS disabled_sort_flag, d.title_mk AS title_mk_deal, d.title_mk_clean AS title_mk_clean_deal, d.content_short_mk AS content_short_mk_deal, (SELECT COUNT(doc.id) FROM deal_options AS doc WHERE doc.deal_id = d.id) AS options_cnt, COUNT(v.id) AS soldVoucherCount, d.plakjanje_pri_prezemanje, d.plakjanje_pri_prezemanje_nacin_podiganje, d.proizvod_flag, d.proizvod_besplatna_dostava, d.proizvod_besplatna_dostava_otkup FROM deals AS d INNER JOIN deal_options AS do ON do.deal_id = d.id LEFT JOIN voucher AS v ON v.deal_id = do.deal_id AND v.deal_option_id = do.id AND v.confirmed = 1 WHERE d.id = 10090 AND do.id = all group by d.id, do.id ORDER BY d.id ASC, do.active DESC, disabled_sort_flag ASC, finalna_cena ASC

Вчитано за {execution_time} секунди, употребено {memory_usage} меморија. Креирано со Kohana v{kohana_version}.