4 users online. Create an account or sign in to join them.Users

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.

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.2 or above
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.0 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details