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

Search

I was having great success with SymphonyCMS. IN fact, reallllly good success. It was awesome. Then whammo. Created a new datasource (not the first one)... and it went down with the following.

(This error only shows up in the admin area under Datasource)

Thanks for any pointers.

Symphony Fatal Database Error

Unknown column 'value' in 'field list'

An error occurred while attempting to execute the following query

* SELECT DISTINCT `value` FROM sym_entries_data_39 ORDER BY `value` ASC

Backtrace:

* [/home/public_html/symphony/lib/toolkit/class.mysql.php:267] MySQL->__error();
* [/home/public_html/symphony/lib/toolkit/class.mysql.php:305] MySQL->query();
* [/home/public_html/symphony/lib/toolkit/class.mysql.php:340] MySQL->fetch();
* [/home/public_html/symphony/lib/toolkit/fields/field.taglist.php:110] MySQL->fetchCol();
* [/home/public_html/symphony/lib/toolkit/fields/field.taglist.php:59] fieldTagList->findAllTags();
* [/home/public_html/symphony/content/content.blueprintsdatasources.php:260] fieldTagList->displayDatasourceFilterPanel();
* [/home/public_html/symphony/content/content.blueprintsdatasources.php:15] contentBlueprintsDatasources->__form();
* [/home/public_html/symphony/lib/toolkit/class.administrationpage.php:119] contentBlueprintsDatasources->__viewEdit();
* [/home/public_html/symphony/lib/toolkit/class.administrationpage.php:96] AdministrationPage->__switchboard();
* [/home/public_html/symphony/lib/toolkit/class.administrationpage.php:81] AdministrationPage->view();
* [/home/public_html/symphony/lib/core/class.administration.php:88] AdministrationPage->build();
* [/home/public_html/symphony/lib/core/class.administration.php:204] Administration->__buildPage();
* [/home/public_html/index.php:20] Administration->display();

Database Query Log:

* SET NAMES 'utf8'; [0.0002]
* SET CHARACTER SET 'utf8'; [0.0000]
* SELECT * FROM `sym_extensions`; [0.0002]
* SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '_session_config' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0004]
* SELECT `session_data` FROM `sym_sessions` WHERE `session` = 'c4c25bc2b97fa3769b43f368278ecf1d' LIMIT 1; [0.0003]
* DELETE FROM `sym_sessions` WHERE `session_expires` <= '1301531325'; [0.0057]
* SELECT `id` FROM `sym_authors` WHERE `username` = 'admin' AND `password` = '8c4205ec33d8f6caeaaaa0c10a14138c' LIMIT 1; [0.0003]
* UPDATE sym_authors SET `last_seen` = '2011-04-13 17:28:45' WHERE `id` = '1'; [0.0023]
* SELECT * FROM `sym_authors` WHERE `id` = '1' LIMIT 1; [0.0002]
* SELECT * FROM `sym_sections` ORDER BY `sortorder` ASC; [0.0002]
* SELECT `name` FROM `sym_extensions` WHERE `status` = 'enabled'; [0.0002]
* SELECT 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.0002]
* SELECT * FROM `sym_extensions_delegates` WHERE `delegate` = 'AddCustomPreferenceFieldsets'; [0.0001]
* SELECT `s`.*, count(`e`.`id`) as `entry_count` FROM `sym_sections` AS `s` LEFT JOIN `sym_entries` AS `e` ON `s`.id = `e`.`section_id` GROUP BY `s`.id ORDER BY `s`.`name` ASC; [0.0002]
* SELECT t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '5' ORDER BY t1.`sortorder` ASC; [0.0002]
* SELECT * FROM `sym_fields_select` WHERE `field_id` = '6' LIMIT 1; [0.0002]
* SELECT * FROM `sym_fields_textarea` WHERE `field_id` = '7' LIMIT 1; [0.0002]
* SELECT t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '1' ORDER BY t1.`sortorder` ASC; [0.0002]
* SELECT * FROM `sym_fields_input` WHERE `field_id` = '1' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_subsectionmanager` WHERE `field_id` = '13' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_textarea` WHERE `field_id` = '14' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_select` WHERE `field_id` = '15' LIMIT 1; [0.0000]
* SELECT * FROM `sym_fields_date` WHERE `field_id` = '16' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_taglist` WHERE `field_id` = '17' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_taglist` WHERE `field_id` = '18' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_select` WHERE `field_id` = '19' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_checkbox` WHERE `field_id` = '20' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_subsectionmanager` WHERE `field_id` = '21' LIMIT 1; [0.0001]
* SELECT t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '4' ORDER BY t1.`sortorder` ASC; [0.0001]
* SELECT * FROM `sym_fields_input` WHERE `field_id` = '4' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_author` WHERE `field_id` = '10' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_uniqueupload` WHERE `field_id` = '34' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_textarea` WHERE `field_id` = '11' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_checkbox` WHERE `field_id` = '37' LIMIT 1; [0.0000]
* SELECT * FROM `sym_fields_taglist` WHERE `field_id` = '39' LIMIT 1; [0.0001]
* SELECT t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '2' ORDER BY t1.`sortorder` ASC; [0.0001]
* SELECT * FROM `sym_fields_input` WHERE `field_id` = '2' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_output` WHERE `field_id` = '22' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_output` WHERE `field_id` = '23' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_textarea` WHERE `field_id` = '24' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_date` WHERE `field_id` = '25' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_selectbox_link` WHERE `field_id` = '26' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_checkbox` WHERE `field_id` = '27' LIMIT 1; [0.0001]
* SELECT t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '3' ORDER BY t1.`sortorder` ASC; [0.0001]
* SELECT * FROM `sym_fields_input` WHERE `field_id` = '3' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_uniqueupload` WHERE `field_id` = '28' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_textarea` WHERE `field_id` = '36' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_taglist` WHERE `field_id` = '30' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_input` WHERE `field_id` = '31' LIMIT 1; [0.0001]
* SELECT * FROM `sym_fields_output` WHERE `field_id` = '32' LIMIT 1; [0.0000]
* SELECT * FROM `sym_fields_select` WHERE `field_id` = '33' LIMIT 1; [0.0001]
* SELECT t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '6' ORDER BY t1.`sortorder` ASC; [0.0001]
* SELECT * FROM `sym_fields_textarea` WHERE `field_id` = '38' LIMIT 1; [0.0000]
* SELECT DISTINCT `value` FROM `sym_entries_data_4` ORDER BY `value` DESC; [0.0001]
* SELECT DISTINCT `value` FROM sym_entries_data_17 ORDER BY `value` ASC; [0.0001]
* SELECT DISTINCT `value` FROM sym_entries_data_18 ORDER BY `value` ASC; [0.0001]
* SELECT DISTINCT `value` FROM sym_entries_data_39 ORDER BY `value` ASC; [0.0000]

What version of Symphony are you running?

What is the structure of that table? It should something like:

`id` int(11) unsigned NOT NULL auto_increment,
`entry_id` int(11) unsigned NOT NULL,
`handle` varchar(255) default NULL,
`value` varchar(255) default NULL,

Is there anything unusual about how you set up this section, or any relationships in this section?

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