Search

I have an Age-range field where data is stored like this '20-35'. I am using substring-before/after to extract two new fields: 'age-range-starts' and 'age-range-ends'.

Now, I am building a search form where there are two input boxes where people can enter age rage. I set up datasource with two filters:

{$url-age-range-start:0} to 100

and

100 to {$url-age-range-end:0}

This should work, right? In theory this should give me the correct results, but data source filters doesn't seem to work correctly on Reflection field. It doesn't find any entries and there is no error.

I've also tried 

greater than {$url-age-range-start:0}

and

less than {$url-age-range-end:100}

Only thing that has worked so far is if I just filter the datasource by static value

{$url-age-range-start}

But this is not useful since it only returns entries that have age-range-start while I want those who have 20 or greater.

Is it a reflection field bug or am I missing something?

Is it a reflection field bug or am I missing something?

Looking at the code it appears range filtering is not supported in this field.

was just thinking out loud today about a new fieldtype ('slugfield'?) that is somewhat like a reflectionfield: … works with textfields (only). E.g. 'linked' to a Title field. … 'handl-izes' values (Foo & Bar => foo-and-bar) of linked textfield … only auto-populates on first save (of linked text-field)

@davidhund It will be great

@bambocci yes, I still feel this could be worth-while. Might look into it myself (later when life's less busy, ahem…).

Does this field allow the usage of general parameters like $root or $workspace?

Looking through the code briefly, nope.

This is not working with xpath attributes. Like photo[@id]

Because your xPath is wrong...

photo/@id

will get the @id value, what you we're trying was a predicate, that would check that photo had an attribute of @id, not get it's value.

Hmm. ok. Thank you very much. Sorry for that!

Will this extension be updated for 2.3?

You could try the unstable branch.

I tested the unstable branch with 2.3 and got errors. It looks like this is work in progress.

Letting us know the errors would be helpful...

Yeah, sorry, you're right. When I install it and click in to edit a section I get this:

Symphony Warning: Invalid argument supplied for foreach()

An error occurred in /srv/www/dev7.eyes-down.net/public_html/extensions/reflectionfield/fields/field.reflection.php around line 98

93
94             $xsltfile = $this->get('xsltfile');
95             $options = array();
96             $options[] = array('', empty($xsltfile), __('Disabled'));
97
98             foreach ($utilities as $utility) {
99                 $options[] = array($utility, ($xsltfile == $utility), $utility);
100             }
101
102             $label->appendChild(Widget::Select(

stuartgpalmer, that's probably because there are no XSLT utitlites there. As a quick fix, try to change:

foreach ($utilities as $utility) {

to:

if (is_array($utilities)) foreach ($utilities as $utility) {

Thank you Marcin. That worked a treat. I have sent a pull request accordingly.

Thanks for the pull request, I will merge it later.

Community dev FTW!!

Is anyone using this extension successfully with 2.3? I've installed it but the refection field type doesn't show up in the add field pick list.

Is anyone using this extension successfully with 2.3?

Yeah, it's working for me. Have you enabled it from the Extensions page?

I get an error when I use this utility (I discovered the format-number() function, so I don't need this utility. But I'm not sure why this gives an error).

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:import href="zerodigit.xsl"/>

<xsl:template match="data">
    <data>
        <entry-id>
        <xsl:call-template name="zerodigit">
            <xsl:with-param name="number" select="{entry/@id}"/>
            <xsl:with-param name="length" select="5" />
        </xsl:call-template>
        </entry-id>
    </data>
</xsl:template>

</xsl:stylesheet>

Symphony Warning: XSLTProcessor::importStylesheet(): Invalid expression

An error occurred in /Applications/MAMP/htdocs/housex/extensions/reflectionfield/extension.driver.php around line 126

121                     $XSLProc = new XsltProcessor;
122
123                     $xslt = new DomDocument;
124                     $xslt->load($XSLTfilename);
125
126                     $XSLProc->importStyleSheet($xslt);
127
128                     // Set some context
129                     $XSLProc->setParameter('', array(
130                         'section-handle' => $section->get('handle'),
Backtrace
[:0]
    GenericErrorHandler::handler();
[/Applications/MAMP/htdocs/housex/extensions/reflectionfield/extension.driver.php:126]
    XSLTProcessor->importStylesheet();
[/Applications/MAMP/htdocs/housex/extensions/reflectionfield/fields/field.reflection.php:308]
    Extension_ReflectionField->getXPath();
[/Applications/MAMP/htdocs/housex/extensions/reflectionfield/extension.driver.php:161]
    FieldReflection->compile();
[/Applications/MAMP/htdocs/housex/symphony/lib/toolkit/class.extensionmanager.php:600]
    Extension_ReflectionField->compileBackendFields();
[/Applications/MAMP/htdocs/housex/symphony/content/content.publish.php:1012]
    ExtensionManager::notifyMembers();
[/Applications/MAMP/htdocs/housex/symphony/content/content.publish.php:76]
    contentPublish->__actionEdit();
[/Applications/MAMP/htdocs/housex/symphony/content/content.publish.php:62]
    contentPublish->__switchboard();
[/Applications/MAMP/htdocs/housex/symphony/lib/toolkit/class.administrationpage.php:398]
    contentPublish->action();
[/Applications/MAMP/htdocs/housex/symphony/lib/core/class.administration.php:302]
    AdministrationPage->build();
[/Applications/MAMP/htdocs/housex/symphony/lib/core/class.administration.php:490]
    Administration->__buildPage();
[/Applications/MAMP/htdocs/housex/index.php:25]
    Administration->display();
Database Query Log
[0.0001] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
[0.0001] SET CHARACTER SET 'utf8';
[0.0010] SELECT SQL_CACHE t1.name, t2.page, t2.delegate, t2.callback FROM `sym_extensions` as t1 INNER JOIN `sym_extensions_delegates` as t2 ON t1.id = t2.extension_id WHERE t1.status = 'enabled' ORDER BY t2.delegate, t1.name;
[0.0002] SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = '5214ef11d68e6e139d7bcfbf076ba372' LIMIT 1;
[0.0003] SELECT SQL_CACHE a.* FROM `sym_authors` AS `a` WHERE `username` = 'Pat' ORDER BY a.id ASC LIMIT 1;
[0.0001] UPDATE sym_authors SET `last_seen` = '2013-03-21 16:23:12' WHERE `id` = 1;
[0.0002] SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
[0.0003] SELECT SQL_CACHE * FROM `sym_extensions`;
[0.0004] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` ORDER BY `s`.`sortorder` asc;
[0.0003] SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'listings' LIMIT 1;
[0.0003] SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` WHERE `e`.`section_id` = '7';
[0.0003] SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'listings' LIMIT 1;
[0.0002] SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = 7 ORDER BY `sortorder` ASC;
[0.0001] SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '42' LIMIT 1;
[0.0002] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`id` IN ('42') AND `e`.`section_id` = '7';
[0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 7 ORDER BY `sortorder` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_25` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_45` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_50` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_47` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_48` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_71` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_85` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_26` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_23` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_29` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_44` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_30` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_62` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_46` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_32` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_36` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_72` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_63` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_33` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_37` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_64` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_34` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_35` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_49` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_42` WHERE `entry_id` IN (42) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(25);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` IN (25);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(45);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_reflection` WHERE `field_id` IN (45);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(50);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (50);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(47);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_textbox` WHERE `field_id` IN (47);
[0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(48);
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_textbox` WHERE `field_id` IN (48);
[0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(71);
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_textbox` WHERE `field_id` IN (71);
[0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(85);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` IN (85);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(26);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` IN (26);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(23);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (23);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(29);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_datetime` WHERE `field_id` IN (29);
[0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(44);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_number` WHERE `field_id` IN (44);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(30);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_maplocation` WHERE `field_id` IN (30);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(62);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (62);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(46);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_incrementnumber` WHERE `field_id` IN (46);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(32);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` IN (32);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(36);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (36);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(72);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (72);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(63);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (63);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(33);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (33);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(37);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (37);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(64);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (64);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(34);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (34);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(35);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (35);
[0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(49);
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (49);
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(42);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` IN (42);
[0.0002] SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = 7 ORDER BY `sortorder` ASC;
[0.0002] SELECT SQL_CACHE f.id FROM `sym_entries_data_47` AS f WHERE f.handle = 'testing' AND f.entry_id != '42' LIMIT 1;
[0.0004] SELECT SQL_CACHE f.id FROM `sym_entries_data_48` AS f WHERE f.handle = 'this-is-a-test' AND f.entry_id != '42' LIMIT 1;
[0.0002] SELECT SQL_CACHE f.id FROM `sym_entries_data_48` AS f WHERE f.entry_id = '42' AND f.value = '<p>this is a test</p>n' AND f.handle = 'this-is-a-test' LIMIT 1;
[0.0002] SELECT SQL_CACHE f.id FROM `sym_entries_data_48` AS f WHERE f.handle = 'this-is-a-test-2' AND f.entry_id != '42' LIMIT 1;
[0.0001] SELECT SQL_CACHE f.id FROM `sym_entries_data_71` AS f WHERE f.handle = '' AND f.entry_id != '42' LIMIT 1;
[0.0004] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`parent_section` = '7' ORDER BY t1.`sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` IN (25,32,42);
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_reflection` WHERE `field_id` IN (45);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (50,36,34,35,49);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_textbox` WHERE `field_id` IN (47,48,71);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` IN (85);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` IN (26);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (23,62,72,63,33,37,64);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_datetime` WHERE `field_id` IN (29);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_number` WHERE `field_id` IN (44);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_maplocation` WHERE `field_id` IN (30);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_incrementnumber` WHERE `field_id` IN (46);
[0.0001] UPDATE sym_entries SET `modification_date` = '2013-03-21T16:23:12-04:00', `modification_date_gmt` = '2013-03-21T20:23:12+00:00' WHERE `id` = 42;
[0.0001] DELETE FROM sym_entries_data_25 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_25` (`entry_id`, `value`) VALUES ('42', NULL);
[0.0001] DELETE FROM sym_entries_data_45 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_45` (`entry_id`, `handle`, `value`, `value_formatted`) VALUES ('42', NULL, NULL, NULL);
[0.0001] DELETE FROM sym_entries_data_50 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_50` (`entry_id`, `value`) VALUES ('42', 'yes');
[0.0001] DELETE FROM sym_entries_data_47 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_47` (`entry_id`, `handle`, `value`, `value_formatted`, `word_count`) VALUES ('42', 'testing', 'Testing ', 'Testing ', '1');
[0.0001] DELETE FROM sym_entries_data_48 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_48` (`entry_id`, `handle`, `value`, `value_formatted`, `word_count`) VALUES ('42', 'this-is-a-test-2', 'this is a test', '<p>this is a test</p>n', '4');
[0.0001] DELETE FROM sym_entries_data_71 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_71` (`entry_id`, `handle`, `value`, `value_formatted`, `word_count`) VALUES ('42', NULL, NULL, NULL, '0');
[0.0001] DELETE FROM sym_entries_data_85 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_85` (`entry_id`, `relation_id`) VALUES ('42', '21');
[0.0001] DELETE FROM sym_entries_data_26 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_26` (`entry_id`, `value`, `date`) VALUES ('42', '2013-03-21T12:20:00-04:00', '2013-03-21 16:20:00');
[0.0001] DELETE FROM sym_entries_data_23 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_23` (`entry_id`, `value`, `handle`) VALUES ('42', 'Room', 'room');
[0.0001] DELETE FROM sym_entries_data_44 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_44` (`entry_id`, `value`) VALUES ('42', '1432');
[0.0001] DELETE FROM sym_entries_data_30 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_30` (`entry_id`, `latitude`, `longitude`, `centre`, `zoom`) VALUES ('42', '40.7143528', '-74.0059731', '40.7143528, -74.0059731', '11');
[0.0001] DELETE FROM sym_entries_data_62 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_62` (`entry_id`, `value`, `handle`) VALUES ('42', 'Female', 'female');
[0.0001] DELETE FROM sym_entries_data_46 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_46` (`entry_id`, `value`) VALUES ('42', '25');
[0.0001] DELETE FROM sym_entries_data_32 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_32` (`entry_id`, `value`) VALUES ('42', NULL);
[0.0001] DELETE FROM sym_entries_data_36 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_36` (`entry_id`, `value`) VALUES ('42', 'no');
[0.0001] DELETE FROM sym_entries_data_72 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_72` (`entry_id`, `value`, `handle`) VALUES ('42', NULL, NULL);
[0.0001] DELETE FROM sym_entries_data_63 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_63` (`entry_id`, `value`, `handle`) VALUES ('42', NULL, NULL);
[0.0001] DELETE FROM sym_entries_data_33 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_33` (`entry_id`, `value`, `handle`) VALUES ('42', 'Shared', 'shared');
[0.0001] DELETE FROM sym_entries_data_37 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_37` (`entry_id`, `value`, `handle`) VALUES ('42', '0', '0');
[0.0001] DELETE FROM sym_entries_data_64 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_64` (`entry_id`, `value`, `handle`) VALUES ('42', NULL, NULL);
[0.0001] DELETE FROM sym_entries_data_34 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_34` (`entry_id`, `value`) VALUES ('42', 'yes');
[0.0001] DELETE FROM sym_entries_data_35 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_35` (`entry_id`, `value`) VALUES ('42', 'no');
[0.0001] DELETE FROM sym_entries_data_49 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_49` (`entry_id`, `value`) VALUES ('42', 'yes');
[0.0001] DELETE FROM sym_entries_data_42 WHERE `entry_id` = 42;
[0.0001] INSERT INTO `sym_entries_data_42` (`entry_id`, `value`) VALUES ('42', NULL);
[0.0001] DELETE FROM sym_entries_data_29 WHERE `entry_id` = 42;
[0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND id IN (73) ORDER BY t1.`sortorder` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_uniqueinput` WHERE `field_id` IN (73);
[0.0002] SELECT SQL_CACHE e.id, e.section_id, s.name, s.handle FROM `sym_entries` AS `e` LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id) WHERE e.id IN (21);
[0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`parent_section` = '9' AND t1.show_column = 'yes' ORDER BY t1.`sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_textbox` WHERE `field_id` IN (74,65,67,68,70);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_enhancedtaglist` WHERE `field_id` IN (75);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (79);
[0.0002] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`id` IN ('21') AND `e`.`section_id` = '9' ORDER BY ( SELECT `ed`.value FROM sym_entries_data_73 AS `ed` WHERE entry_id = e.id ) ASC;
[0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 9 AND `element_name` IN ('facebook-id') ORDER BY `sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_73` WHERE `entry_id` IN (21) ORDER BY `id` ASC;

The imported utility is from here http://getsymphony.com/download/xslt-utilities/view/52346/

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details