Се појави грешка во базата на податоци при извршување на побараната процедура. За повеќе информации, прегледајте ја грешката опишана доле.
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}.