symphonycms/symphony-2 — Issue #987: Symphony Fatal Database Error
Author: fla
Created: 2012-01-10 12:15:33+00:00
State: open

I'm getting this error when I go to datasources page and try to add new datasource or edit existing one. Once I open a datasource I get this error, so is not when I save it.
Last things I've made was to add a new textbox field (to use it for my titles) to some of my sections and removed the old title text field. Might that be a problem ? Shouldn't symphony take care of those changes ?

Running Symphony 2.2.5

Table 'flavy_p.sym_entries_data_1' doesn't exist
An error occurred while attempting to execute the following query
SHOW COLUMNS FROM `sym_entries_data_1` LIKE 'value'
Backtrace:
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/class.mysql.php:463] MySQL->__error();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/class.mysql.php:609] MySQL->query();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/class.mysql.php:697] MySQL->fetch();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/fields/field.select.php:131] MySQL->fetchVar();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/fields/field.select.php:37] fieldSelect->findAndAddDynamicOptions();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/fields/field.select.php:376] fieldSelect->getToggleStates();
[/home/flavy/public_html/prew/p/symphony/content/content.blueprintsdatasources.php:303] fieldSelect->displayDatasourceFilterPanel();
[/home/flavy/public_html/prew/p/symphony/content/content.blueprintsdatasources.php:23] contentBlueprintsDatasources->__form();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/class.administrationpage.php:440] contentBlueprintsDatasources->__viewEdit();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/class.administrationpage.php:397] AdministrationPage->__switchboard();
[/home/flavy/public_html/prew/p/symphony/lib/toolkit/class.administrationpage.php:260] AdministrationPage->view();
[/home/flavy/public_html/prew/p/symphony/lib/core/class.administration.php:230] AdministrationPage->build();
[/home/flavy/public_html/prew/p/symphony/lib/core/class.administration.php:383] Administration->__buildPage();
[/home/flavy/public_html/prew/p/index.php:25] Administration->display();
Database Query Log:
SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'; [0.0105]
SET CHARACTER SET 'utf8'; [0.0099]
SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = 'c54c498593241b5738f455555e4da457' LIMIT 1; [0.0098]
SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled'; [0.0099]
SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` = 'admin' AND `password` = 'd033e22ae348aeb5660fc2140aec35850c4da997' LIMIT 1; [0.0322]
UPDATE sym_authors SET `last_seen` = '2012-01-10 12:02:01' WHERE `id` = '1'; [0.0098]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC; [0.0009]
SELECT SQL_CACHE * FROM `sym_extensions`; [0.0098]
SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '8'; [0.0222]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '8' ORDER BY `sortorder` ASC; [0.0100]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '61' LIMIT 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_fields_memberusername` WHERE `field_id` = '61' LIMIT 1; [0.0089]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '60' LIMIT 1; [0.0100]
SELECT SQL_CACHE * FROM `sym_fields_memberemail` WHERE `field_id` = '60' LIMIT 1; [0.0093]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '67' LIMIT 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_fields_memberpassword` WHERE `field_id` = '67' LIMIT 1; [0.0086]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '68' LIMIT 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_fields_memberactivation` WHERE `field_id` = '68' LIMIT 1; [0.0177]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '66' LIMIT 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_fields_memberrole` WHERE `field_id` = '66' LIMIT 1; [0.0089]
SELECT SQL_CACHE * FROM `sym_sections` ORDER BY `sortorder` ASC; [0.0256]
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.0285]
SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` ORDER BY `s`.`name` ASC; [0.0003]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '5' ORDER BY t1.`sortorder` ASC; [0.0066]
SELECT SQL_CACHE * FROM `sym_fields_memberusername` WHERE `field_id` = '34' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_memberemail` WHERE `field_id` = '35' LIMIT 1; [0.0076]
SELECT SQL_CACHE * FROM `sym_fields_memberpassword` WHERE `field_id` = '36' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_memberrole` WHERE `field_id` = '37' LIMIT 1; [0.0116]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '2' ORDER BY t1.`sortorder` ASC; [0.0090]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '9' LIMIT 1; [0.0096]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '10' LIMIT 1; [0.0038]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '7' ORDER BY t1.`sortorder` ASC; [0.0053]
SELECT SQL_CACHE * FROM `sym_fields_memberemail` WHERE `field_id` = '47' LIMIT 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_fields_memberusername` WHERE `field_id` = '48' LIMIT 1; [0.0022]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '50' LIMIT 1; [0.0019]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '52' LIMIT 1; [0.0057]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '53' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '56' LIMIT 1; [0.0096]
SELECT SQL_CACHE * FROM `sym_fields_memberrole` WHERE `field_id` = '59' LIMIT 1; [0.0099]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '4' ORDER BY t1.`sortorder` ASC; [0.0010]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '27' LIMIT 1; [0.0064]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '23' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '24' LIMIT 1; [0.0222]
SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` = '25' LIMIT 1; [0.0085]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '26' LIMIT 1; [0.0052]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '1' ORDER BY t1.`sortorder` ASC; [0.0009]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '76' LIMIT 1; [0.0037]
SELECT SQL_CACHE * FROM `sym_fields_author` WHERE `field_id` = '2' LIMIT 1; [0.0027]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '3' LIMIT 1; [0.0014]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '4' LIMIT 1; [0.0040]
SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` = '11' LIMIT 1; [0.0183]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '6' LIMIT 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_fields_taglist` WHERE `field_id` = '7' LIMIT 1; [0.0006]
SELECT SQL_CACHE * FROM `sym_fields_incrementnumber` WHERE `field_id` = '31' LIMIT 1; [0.0174]
SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` = '71' LIMIT 1; [0.0019]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '8' ORDER BY t1.`sortorder` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '62' LIMIT 1; [0.0013]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '63' LIMIT 1; [0.0062]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '64' LIMIT 1; [0.0009]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '65' LIMIT 1; [0.0090]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '3' ORDER BY t1.`sortorder` ASC; [0.0012]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '77' LIMIT 1; [0.0023]
SELECT SQL_CACHE * FROM `sym_fields_author` WHERE `field_id` = '13' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '14' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '15' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '17' LIMIT 1; [0.0058]
SELECT SQL_CACHE * FROM `sym_fields_taglist` WHERE `field_id` = '18' LIMIT 1; [0.0014]
SELECT SQL_CACHE * FROM `sym_fields_youtube_video` WHERE `field_id` = '21' LIMIT 1; [0.0073]
SELECT SQL_CACHE * FROM `sym_fields_incrementnumber` WHERE `field_id` = '32' LIMIT 1; [0.0100]
SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` = '72' LIMIT 1; [0.0037]
SELECT SQL_CACHE * FROM `sym_members_roles` ORDER BY `id` ASC; [0.0054]
SELECT SQL_CACHE `page_id` FROM `sym_members_roles_forbidden_pages` WHERE `role_id` = 1; [0.0099]
SELECT SQL_CACHE * FROM `sym_members_roles_event_permissions` WHERE `role_id` = 1; [0.0100]
SELECT SQL_CACHE `page_id` FROM `sym_members_roles_forbidden_pages` WHERE `role_id` = 2; [0.0003]
SELECT SQL_CACHE * FROM `sym_members_roles_event_permissions` WHERE `role_id` = 2; [0.0097]
SELECT SQL_CACHE `page_id` FROM `sym_members_roles_forbidden_pages` WHERE `role_id` = 3; [0.0001]
SELECT SQL_CACHE * FROM `sym_members_roles_event_permissions` WHERE `role_id` = 3; [0.0097]
SELECT SQL_CACHE * FROM `sym_members_roles` ORDER BY `id` ASC; [0.0186]
SHOW COLUMNS FROM `sym_entries_data_1` LIKE 'value'; [0.0000]