-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
dbjoin rendered as checkboxes
- Thread starter arie
- Start date
rob
Administrator
I could replicate this one, and have fixed it with this commit:
https://github.com/Fabrik/fabrik/commit/609ea0b2e1fdd8955704b3b26581b48be2a38a50
https://github.com/Fabrik/fabrik/commit/609ea0b2e1fdd8955704b3b26581b48be2a38a50
Hi,
I've committed the fix. Indeed, the bug gone but when I know publish this element in the list filters and try to use that filter, I get that (see the bold part, the IN clause is empty). Do you think is steel a bug or this is linked to my own setup?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY `ass_donator`.`name_donator` ASC, `ass_donator`.`first_donator` ' at line 10 SQL=SELECT DISTINCT `ass_donator`.`id` AS __pk_val0, `ass_donator_address`.`id` AS __pk_val1, `ass_donator_child`.`id` AS __pk_val2, `ass_donator_118_repeat`.`id` AS __pk_val3 FROM `ass_donator` LEFT JOIN `ass_donator_address` AS `ass_donator_address` ON `ass_donator_address`.`donator_id` = `ass_donator`.`id` LEFT JOIN `ass_donator_child` AS `ass_donator_child` ON `ass_donator_child`.`donator_id` = `ass_donator`.`id` LEFT JOIN `ass_donator_address_type` AS `ass_donator_address_type` ON `ass_donator_address_type`.`id` = `ass_donator_address`.`type_id` LEFT JOIN `ass_donator_type` AS `ass_donator_type` ON `ass_donator_type`.`id` = `ass_donator`.`type_id` LEFT JOIN `ass_donator_118_repeat` AS `ass_donator_118_repeat` ON `ass_donator_118_repeat`.`parent_id` = `ass_donator`.`id` LEFT JOIN `ass_country` AS `ass_country` ON `ass_country`.`id` = `ass_donator_address`.`country_donator` LEFT JOIN `ass_donator` AS `ass_donator_0` ON `ass_donator_0`.`id` = `ass_donator_child`.`donator_child_id` LEFT JOIN `ass_donator_child_type` AS `ass_donator_child_type` ON `ass_donator_child_type`.`id` = `ass_donator_child`.`donator_child_type` LEFT JOIN `ass_donator_title` AS `ass_donator_title` ON `ass_donator_title`.`id` = `ass_donator`.`title_id` WHERE ( ass_donator.association_id = 1 ) AND ( `ass_donator`.`id` IN () ) ORDER BY `ass_donator`.`name_donator` ASC, `ass_donator`.`first_donator` ASC
I've committed the fix. Indeed, the bug gone but when I know publish this element in the list filters and try to use that filter, I get that (see the bold part, the IN clause is empty). Do you think is steel a bug or this is linked to my own setup?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY `ass_donator`.`name_donator` ASC, `ass_donator`.`first_donator` ' at line 10 SQL=SELECT DISTINCT `ass_donator`.`id` AS __pk_val0, `ass_donator_address`.`id` AS __pk_val1, `ass_donator_child`.`id` AS __pk_val2, `ass_donator_118_repeat`.`id` AS __pk_val3 FROM `ass_donator` LEFT JOIN `ass_donator_address` AS `ass_donator_address` ON `ass_donator_address`.`donator_id` = `ass_donator`.`id` LEFT JOIN `ass_donator_child` AS `ass_donator_child` ON `ass_donator_child`.`donator_id` = `ass_donator`.`id` LEFT JOIN `ass_donator_address_type` AS `ass_donator_address_type` ON `ass_donator_address_type`.`id` = `ass_donator_address`.`type_id` LEFT JOIN `ass_donator_type` AS `ass_donator_type` ON `ass_donator_type`.`id` = `ass_donator`.`type_id` LEFT JOIN `ass_donator_118_repeat` AS `ass_donator_118_repeat` ON `ass_donator_118_repeat`.`parent_id` = `ass_donator`.`id` LEFT JOIN `ass_country` AS `ass_country` ON `ass_country`.`id` = `ass_donator_address`.`country_donator` LEFT JOIN `ass_donator` AS `ass_donator_0` ON `ass_donator_0`.`id` = `ass_donator_child`.`donator_child_id` LEFT JOIN `ass_donator_child_type` AS `ass_donator_child_type` ON `ass_donator_child_type`.`id` = `ass_donator_child`.`donator_child_type` LEFT JOIN `ass_donator_title` AS `ass_donator_title` ON `ass_donator_title`.`id` = `ass_donator`.`title_id` WHERE ( ass_donator.association_id = 1 ) AND ( `ass_donator`.`id` IN () ) ORDER BY `ass_donator`.`name_donator` ASC, `ass_donator`.`first_donator` ASC
https://www.mycerfa.com/COPIEPROD/donators
select an options into the group dbjoin
select an options into the group dbjoin
I have added this fix in my server file (bold part of the code):
/components/com_fabrik/helpers/string.php
line 522
if ($commaSeparated && !is_array($values2)) {
$values2 = explode(',', $values2);
}
line 538
if ($commaSeparated && !is_array($values2)) {
$values2 = implode(',', $values2);
}
previously, explode function was raised the bug below because trying to explode an array
/components/com_fabrik/helpers/string.php
line 522
if ($commaSeparated && !is_array($values2)) {
$values2 = explode(',', $values2);
}
line 538
if ($commaSeparated && !is_array($values2)) {
$values2 = implode(',', $values2);
}
previously, explode function was raised the bug below because trying to explode an array
cheesegrits
Support Gopher
None of the logins I have for you in Last Pass, or in your My Sites, work on that site.
-- hugh
-- hugh
cheesegrits
Support Gopher
Which "your login"? Your My Site details (username/pass) for COPIEPROD are empty. I've tried the ones from the other My Sites entry, including the standard 'ariouche' one I've always used in the past, both 'rob' ones (one form My Sites, and one Last Pass has), plus another couple of different names that Last Pass has for your sites. Nothing works for me on that COPIEPROD site.
-- hugh