Search

Still I think that the limit for the "snappy" original solution (writing all elements to the source) is very high. I tried it with some thousand options, and the live-search JS reacted instantly. So if you plan to integrate the asynchronous approach, could it maybe be optional (i.e. configurable in the field's settings)?

Are y'all having any trouble with the Reference Link field working with Symphony 2.2.3 or Symphony 2.2.4. It seems that wherever I have the Reference Link field as an optional field. If I leave it blank (or leave it a NULL value) then I get the following Fatal Database error...

Symphony Fatal Database Error

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 ')' at line 4

An error occurred while attempting to execute the following query

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 ()

Backtrace:
[/home/public/symphony/lib/toolkit/class.mysql.php:463] MySQL->__error();
[/home/public/symphony/lib/toolkit/class.mysql.php:609] MySQL->query();
[/home/public/extensions/selectbox_link_field/fields/field.selectbox_link.php:233] MySQL->fetch();
[/home/public/extensions/selectbox_link_field/fields/field.selectbox_link.php:474] fieldSelectBox_Link->findRelatedValues();
[/home/public/extensions/reflectionfield/extension.driver.php:102] fieldSelectBox_Link->appendFormattedElement();
[/home/public/extensions/reflectionfield/fields/field.reflection.php:263] Extension_ReflectionField->getXPath();
[/home/public/extensions/reflectionfield/extension.driver.php:131] FieldReflection->compile();
[/home/public/symphony/lib/toolkit/class.extensionmanager.php:559] Extension_ReflectionField->compileBackendFields();
[/home/public/symphony/content/content.publish.php:897] ExtensionManager->notifyMembers();
[/home/public/symphony/content/content.publish.php:40] contentPublish->__actionEdit();
[/home/public/symphony/content/content.publish.php:26] contentPublish->__switchboard();
[/home/public/symphony/lib/toolkit/class.administrationpage.php:242] contentPublish->action();
[/home/public/symphony/lib/core/class.administration.php:230] AdministrationPage->build();
[/home/public/symphony/lib/core/class.administration.php:383] Administration->__buildPage();
[/home/public/index.php:25] Administration->display();

Database Query Log:
SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'; [0.0001]
SET CHARACTER SET 'utf8'; [0.0001]
SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = 'p5odq1hnm5icn084kabukuqdl2' LIMIT 1; [0.0001]
SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled'; [0.0002]
SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` = 'webmaster' AND `password` = 'e9c738498865cdc094eae67e2ce7d5d7675335bd' LIMIT 1; [0.0001]
UPDATE sym_authors SET `last_seen` = '2011-10-25 12:01:36' WHERE `id` = '1'; [0.0010]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC; [0.0003]
SELECT SQL_CACHE * FROM `sym_extensions`; [0.0002]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `username` = 'webmaster' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_sections` ORDER BY `sortorder` ASC; [0.0003]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `username` = 'webmaster' LIMIT 1; [0.0001]
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'; [0.0003]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'events' LIMIT 1; [0.0001]
SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '13'; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` ORDER BY `s`.`name` ASC; [0.0003]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '20' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '6' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '15' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '43' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '26' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '7' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '19' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '18' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '9' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '40' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '12' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '39' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '22' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '21' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '10' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '28' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '32' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '31' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '33' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '38' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '44' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '11' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '14' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '37' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '17' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '27' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '24' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '25' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '16' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '29' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '46' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '45' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '47' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '50' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '49' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '48' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '51' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '23' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '41' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '35' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '30' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '34' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '36' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'events' LIMIT 1; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'events' LIMIT 1; [0.0001]
SELECT SQL_CACHE `field_id`, `section_id` FROM sym_autocompleter_fields  WHERE `section_id` = 13; [0.0001]
SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '6955' LIMIT 1; [0.0001]
SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`id` IN ('6955') AND `e`.`section_id` = '13'; [0.0001]
SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 13; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_66` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_67` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_68` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_69` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_70` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_72` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_73` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_76` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_77` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_78` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_81` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_82` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_83` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_84` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_85` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_86` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_87` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_88` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_89` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_93` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_94` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_95` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_114` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_115` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_120` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_121` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_122` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_157` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_156` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_133` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_137` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_138` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_139` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_278` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_208` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_158` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_167` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_168` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_207` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_232` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_248` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_249` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_258` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_265` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_271` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_272` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_346` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_347` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_348` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_458` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_466` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '66' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '66' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '466' LIMIT 1; [0.0004]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '466' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '346' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '346' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '76' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` = '76' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '347' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '347' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '67' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '67' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '69' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '69' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '70' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '70' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '156' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '156' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '158' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '158' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '114' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '114' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '168' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '168' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '73' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '73' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '72' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '72' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '77' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '77' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '78' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '78' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '248' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '248' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '167' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '167' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '87' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '87' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '88' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '88' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '89' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '89' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '122' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '122' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '81' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '81' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '137' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '137' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '138' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '138' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '139' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '139' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '458' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '458' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '85' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '85' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '82' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '82' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '86' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '86' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '93' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '93' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '83' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '83' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '94' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '94' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '348' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '348' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '84' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '84' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '95' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '95' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '249' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '249' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '68' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '68' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '232' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '232' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '115' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '115' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '121' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '121' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '157' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '157' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '120' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '120' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '133' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '133' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '207' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_subsectionmanager` WHERE `field_id` = '207' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '258' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '258' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '271' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '271' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '272' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '272' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '208' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_subsectionmanager` WHERE `field_id` = '208' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '278' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '278' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '265' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_reflection` WHERE `field_id` = '265' LIMIT 1; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '13' ORDER BY t1.`sortorder` ASC; [0.0003]
DELETE FROM sym_entries_data_66 WHERE `entry_id` = '6955'; [0.0010]
INSERT INTO `sym_entries_data_66` (`entry_id`, `value`, `handle`) VALUES ('6955', 'test', 'test'); [0.0002]
DELETE FROM sym_entries_data_68 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_68` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', '2011-10-25T11:23:00-05:00', '1319559780', '1319559780'); [0.0001]
DELETE FROM sym_entries_data_69 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_69` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', '2011-10-25T11:23:00-05:00', '1319559780', '1319559780'); [0.0001]
DELETE FROM sym_entries_data_70 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_70` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', '2011-10-25T11:23:00-05:00', '1319559780', '1319559780'); [0.0001]
DELETE FROM sym_entries_data_72 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_72` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', '<p>test</p>rn', '<p>test</p>rn'); [0.0001]
DELETE FROM sym_entries_data_73 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_73` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', '<p>test</p>rn', '<p>test</p>rn'); [0.0002]
DELETE FROM sym_entries_data_76 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_76` (`entry_id`, `value`, `handle`) VALUES ('6955', NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_83 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_83` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_84 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_84` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_85 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_85` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_86 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_86` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_93 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_93` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_94 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_94` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_95 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_95` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_114 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_114` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_115 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_115` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_120 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_120` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_122 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_122` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_156 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_156` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_133 WHERE `entry_id` = '6955'; [0.0120]
INSERT INTO `sym_entries_data_133` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_137 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_137` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_138 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_138` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_139 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_139` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_158 WHERE `entry_id` = '6955'; [0.0007]
INSERT INTO `sym_entries_data_158` (`entry_id`, `value`) VALUES ('6955', 'yes'); [0.0001]
DELETE FROM sym_entries_data_167 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_167` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_232 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_232` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_248 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_248` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_249 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_249` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', NULL, NULL); [0.0001]
DELETE FROM sym_entries_data_258 WHERE `entry_id` = '6955'; [0.0006]
INSERT INTO `sym_entries_data_258` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_265 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_265` (`entry_id`, `handle`, `value`, `value_formatted`) VALUES ('6955', NULL, NULL, NULL); [0.0001]
DELETE FROM sym_entries_data_271 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_271` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_272 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_272` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_346 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_346` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_347 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_347` (`entry_id`, `relation_id`) VALUES ('6955', NULL); [0.0001]
DELETE FROM sym_entries_data_348 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_348` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', NULL, NULL); [0.0001]
DELETE FROM sym_entries_data_458 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_458` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_466 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_466` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_67 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_168 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_77 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_78 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_87 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_88 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_89 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_81 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_82 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_121 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_157 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_207 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_208 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_278 WHERE `entry_id` = '6955'; [0.0001]
SELECT SQL_CACHE * FROM `sym_sections_association` AS `sa`, `sym_sections` AS `s` WHERE `sa`.`parent_section_id` = 13 AND `s`.`id` = `sa`.`child_section_id` ORDER BY `s`.`sortorder` ASC; [0.0001]
SELECT SQL_CACHE count(*) AS `count` FROM `sym_entries_data_207` WHERE `entry_id` = '6955'; [0.0001]
SELECT SQL_CACHE count(*) AS `count` FROM `sym_entries_data_208` WHERE `entry_id` = '6955'; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '262' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '262' LIMIT 1; [0.0001]
SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_262` WHERE `relation_id` = 6955; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '260' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '260' LIMIT 1; [0.0001]
SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_260` WHERE `relation_id` = 6955; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '263' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '263' LIMIT 1; [0.0001]
SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_263` WHERE `relation_id` = 6955; [0.0001]
SELECT SQL_CACHE s.handle FROM `sym_sections` AS s WHERE s.id = '10' LIMIT 1; [0.0003]
SELECT SQL_CACHE s.handle FROM `sym_sections` AS s WHERE s.id = '22' LIMIT 1; [0.0002]
SELECT SQL_CACHE s.handle FROM `sym_sections` AS s WHERE s.id = '30' LIMIT 1; [0.0002]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND id IN (341) ORDER BY t1.`sortorder` ASC; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '341' LIMIT 1; [0.0001]
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 (); [0.0000]

Is anyone facing this issue?

My thought is that since the Select Box Link Field was updated both for the 2.2.3 and 2.2.4 installations, it might have a problem with those changes since this extension is dependent on the Select Box Link Field.

Unfortunately, my site is huge and can't just uninstall the extension (since I have many sections that are dependent on that field.

Any thoughts on what I can and should do? Your help is much appreciated.

FYI... I'm running Symphony 2.2.4 with PHP 5.3.8, MySQL 5.1.4.1, I cleared out my browser cache and the sym_cache table. I also enabled the extension.

I have tried using the master and dev repositiories of the Reference Link Field and both generate the same error.

ALSO, in 2.2.4, the autocomplete feature doesn't seem to be working.

@bzerangue, I'm not seeing that problem with Reference Link not set to be required and without entries selected. Did you find out any more?

Oh... I'm so sorry... this issue was addressed when they fixed the Select Box Link Field. I forgot to post a follow up. @DavidOliver, thanks for following up with this post. Again, please forgive me for not following up a post saying this issue was solved.

Ah, good; thanks for the info. No worries - I just happened to see your post as I'm trying out this field so thought I'd do a quick test.

In 2.3: Fatal error: Call to a member function addScriptToHead() on a non-object in ....

Hey Marcio.... any luck fixing this issue?... I'm having the same problem updating to the 2.3 from 2.2.1.

@abocati - what version of the reference link field is installed? You need to upload the latest version to work with Symphony 2.3.x... http://symphonyextensions.com/extensions/referencelink/

Just noticed this has been updated for 2.5.2. I recently migrated from it to Association Field for an upgrade. Is there a significant difference between this and the Association field group of extensions (aside from the additional editing and output features of the latter)? They seem to be quite close.

Thanks.

Is there a significant difference between this and the Association field group of extensions (aside from the additional editing and output features of the latter)?

Yes there is: Association Field works, Reference Link Field doesn't.

That's at least true for the autocomplete part - and as far as I understand that's the only reason one would choose Reference Link Field instead of a standard SBL-Field.

The Issues with Autocomplete date back to Symphony 2.3.3 and the accompanying move from jquery 1.X to 2.X. I posted an Issue back then and neither did it get solved nor do things look any better now that we are at version 2.5.2 - Autocomplete View doesn't offer any suggestions in the current version 1.5. Just checked that with a fresh install on firefox and chrome.

If you have a look at the code "Reference Link Field" still relies on a jquery autocomplete-plugin that has been deprecated in 2010.

So I don't know why this has been marked as compatible with Symphony 2.5.2 - it may work theoretically (as a kind of SBL-Clone), but without a working autocomplete solution it's a pretty useless extension imho.

I'll post a note on github (Edit: Just did), as I think the best way would be to mark this extension as deprecated and focus on the new "Association UI"-Solution Nils started.

Is there a significant difference between this and the Association field group of extensions (aside from the additional editing and output features of the latter)?

The association field loads autocomplete asynchronically which is a big plus for very large association entries. It prevents long page loads. It's been tested with 100,000 entries and working like a charm.

Thanks for the responses. I figured the migration to Association UI was the better choice, but I was curious when I saw this tagged for 2.5.2.

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