Symphony.

I tried creating a section, and got the following error. Note, the errors below are from different sections being added/deleted, but is easily replicated

Symphony Fatal Database Error Column 'value' cannot be part of FULLTEXT index An error occurred while attempting to execute the following query CREATE TABLE IF NOT EXISTS sym_entries_data_34 ( id int(11) unsigned NOT NULL autoincrement, entry_id int(11) unsigned NOT NULL, value text, value_formatted text, PRIMARY KEY (id), UNIQUE KEY entry_id (entry_id), FULLTEXT KEY value (value) ) ENGINE=MyISAM; Backtrace: [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:458] MySQL->error(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/fields/field.textarea.php:275] MySQL->query(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.field.php:1083] fieldTextarea->createTable(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/fields/field.textarea.php:62] Field->commit(); [/Applications/MAMP/htdocs/symphony/content/content.blueprintssections.php:727] fieldTextarea->commit(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:440] contentBlueprintsSections->actionNew(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:409] AdministrationPage->switchboard(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:242] AdministrationPage->action(); [/Applications/MAMP/htdocs/symphony/lib/core/class.administration.php:222] AdministrationPage->build(); [/Applications/MAMP/htdocs/symphony/lib/core/class.administration.php:375] Administration->buildPage(); [/Applications/MAMP/htdocs/index.php:25] Administration->display(); Database Query Log: SET charactersetconnection = 'utf8', charactersetdatabase = 'utf8', charactersetserver = 'utf8'; [0.0002] SET CHARACTER SET 'utf8'; [0.0001] SELECT SQLCACHE session_data FROM sym_sessions WHERE session = '0b3045154f34ec9c3832113b60d3a2df' LIMIT 1; [0.0002] SELECT SQLCACHE name FROM sym_extensions WHERE status = 'enabled'; [0.0002] SELECT SQLCACHE id FROM sym_authors WHERE username = 'Pat' AND password = '8cb706dccb601ec747367471e6cf0c8af283562e' LIMIT 1; [0.0002] UPDATE symauthors SET last_seen = '2011-06-19 23:27:42' WHERE id = '1'; [0.0002] SELECT SQLCACHE * FROM sym_authors WHERE id IN (1) ORDER BY id ASC; [0.0002] SELECT SQLCACHE * FROM sym_extensions; [0.0003] SELECT SQLCACHE id FROM sym_sections WHERE handle = '' LIMIT 1; [0.0002] SELECT SQLCACHE s.* FROM sym_sections AS s ORDER BY s.name ASC; [0.0002] SELECT SQLCACHE * FROM sym_sections ORDER BY sortorder ASC; [0.0002] SELECT SQLCACHE t1.name, t2.page, t2.delegate, t2.callback FROM sym_extensions as t1 INNER JOIN sym_extensions_delegates as t2 ON t1.id = t2.extensionid WHERE t1.status = 'enabled'; [0.0005] SELECT SQLCACHE * FROM sym_sections WHERE handle = 'test' LIMIT 1; [0.0001] SELECT SQLCACHE MAX(sortorder) + 1 AS next FROM symsections LIMIT 1; [0.0001] INSERT INTO sym_sections (name, navigation_group, handle, sortorder, static) VALUES ('test', 'Content', 'test', '4', 'no'); [0.0002] INSERT INTO sym_fields (element_name, label, parent_section, location, required, type, show_column, sortorder) VALUES ('adfsdfad', 'adfsdfad', '9', 'main', 'no', 'input', 'yes', '0'); [0.0002] CREATE TABLE IF NOT EXISTS sym_entries_data_33 ( id int(11) unsigned NOT NULL autoincrement, entry_id int(11) unsigned NOT NULL, handle varchar(255) default NULL, value varchar(255) default NULL, PRIMARY KEY (id), UNIQUE KEY entry_id (entry_id), KEY handle (handle), KEY value (value) ) ENGINE=MyISAM;; [0.1212] DELETE FROM sym_fields_input WHERE field_id = '33' LIMIT 1; [0.0002] INSERT INTO sym_fields_input (field_id, validator) VALUES ('33', NULL); [0.0002] UPDATE symfields SET multilanguage = '1' WHERE id=33; [0.0002] INSERT INTO sym_fields (element_name, label, parent_section, location, required, type, show_column, sortorder) VALUES ('adsfasdffgg', 'adsfasdffgg', '9', 'main', 'no', 'textarea', 'no', '1'); [0.0002] CREATE TABLE IF NOT EXISTS sym_entries_data_34 ( id int(11) unsigned NOT NULL autoincrement, entry_id int(11) unsigned NOT NULL, value text, value_formatted text, PRIMARY KEY (id), UNIQUE KEY entry_id (entry_id), FULLTEXT KEY value (value) ) ENGINE=MyISAM;; [0.0000]

The section was still created if you go back to the sections page. This seems to only affect sections with textareas. Sections w/ text inputs work just fine. Any fields after the textarea disappear until re-added.

I tried with both multilanguage active and inactive, same errors.

Likewise, when you go create an entry, you get the following error, b/c there is no table for the textarea in the database.

Symphony Fatal Database Error Table 'symphony.symentriesdata24' doesn't exist An error occurred while attempting to execute the following query INSERT INTO sym_entries_data_24 (entry_id, value, value_formatted) VALUES ('8', '??????2000????????????????????????????????????????????????rn', '??????2000???????????????????????????????????????????????? ?> n') Backtrace: [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:458] MySQL->error(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:541] MySQL->query(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.entrymanager.php:220] MySQL->insert(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.entry.php:295] EntryManager->edit(); [/Applications/MAMP/htdocs/symphony/content/content.publish.php:615] Entry->commit(); [/Applications/MAMP/htdocs/symphony/content/content.publish.php:40] contentPublish->actionNew(); [/Applications/MAMP/htdocs/symphony/content/content.publish.php:26] contentPublish->switchboard(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:242] contentPublish->action(); [/Applications/MAMP/htdocs/symphony/lib/core/class.administration.php:222] AdministrationPage->build(); [/Applications/MAMP/htdocs/symphony/lib/core/class.administration.php:375] Administration->buildPage(); [/Applications/MAMP/htdocs/index.php:25] Administration->display(); Database Query Log: SET charactersetconnection = 'utf8', charactersetdatabase = 'utf8', charactersetserver = 'utf8'; [0.0002] SET CHARACTER SET 'utf8'; [0.0002] SELECT SQLCACHE session_data FROM sym_sessions WHERE session = '0b3045154f34ec9c3832113b60d3a2df' LIMIT 1; [0.0002] DELETE FROM sym_sessions WHERE session_expires <= '1307287423'; [0.0002] SELECT SQLCACHE name FROM sym_extensions WHERE status = 'enabled'; [0.0002] SELECT SQLCACHE id FROM sym_authors WHERE username = 'Pat' AND password = '8cb706dccb601ec747367471e6cf0c8af283562e' LIMIT 1; [0.0002] UPDATE symauthors SET last_seen = '2011-06-19 23:23:43' WHERE id = '1'; [0.0002] SELECT SQLCACHE * FROM sym_authors WHERE id IN (1) ORDER BY id ASC; [0.0002] SELECT SQLCACHE * FROM sym_extensions; [0.0002] SELECT SQLCACHE id FROM sym_sections WHERE handle = 'home-slideshow' LIMIT 1; [0.0002] SELECT SQLCACHE s.* FROM sym_sections AS s WHERE s.id = '7'; [0.0002] SELECT SQLCACHE * FROM sym_sections ORDER BY sortorder ASC; [0.0002] SELECT SQLCACHE t1.name, t2.page, t2.delegate, t2.callback FROM sym_extensions as t1 INNER JOIN sym_extensions_delegates as t2 ON t1.id = t2.extensionid WHERE t1.status = 'enabled'; [0.0005] SELECT SQLCACHE id FROM sym_sections WHERE handle = 'home-slideshow';; [0.0001] SELECT SQLCACHE id, element_name, type FROM sym_fields WHERE parent_section=7 AND multilanguage=1;; [0.0002] SELECT SQLCACHE id FROM sym_sections WHERE handle = 'home-slideshow' LIMIT 1; [0.0001] SELECT SQLCACHE id, element_name, type, location FROM sym_fields WHERE parent_section = '7' ORDER BY sortorder ASC; [0.0002] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.id = '23' LIMIT 1; [0.0001] SELECT SQLCACHE * FROM sym_fields_input WHERE field_id = '23' LIMIT 1; [0.0001] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.id = '24' LIMIT 1; [0.0001] SELECT SQLCACHE * FROM sym_fields_textarea WHERE field_id = '24' LIMIT 1; [0.0001] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.id = '25' LIMIT 1; [0.0002] SELECT SQLCACHE * FROM sym_fields_upload WHERE field_id = '25' LIMIT 1; [0.0001] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.id = '26' LIMIT 1; [0.0002] SELECT SQLCACHE * FROM sym_fields_input WHERE field_id = '26' LIMIT 1; [0.0001] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.id = '27' LIMIT 1; [0.0001] SELECT SQLCACHE * FROM sym_fields_input WHERE field_id = '27' LIMIT 1; [0.0001] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.id = '28' LIMIT 1; [0.0001] SELECT SQLCACHE * FROM sym_fields_checkbox WHERE field_id = '28' LIMIT 1; [0.0003] INSERT INTO sym_entries (section_id, author_id, creation_date, creation_date_gmt) VALUES ('7', '1', '2011-06-19 23:23:43', '2011-06-19 15:23:43'); [0.0002] SELECT SQLCACHE id, element_name, type, location FROM sym_fields WHERE parent_section = '7' ORDER BY sortorder ASC; [0.0002] SELECT SQLCACHE * FROM sym_entries_data_25 WHERE entry_id = 8 LIMIT 1; [0.0004] SELECT SQLCACHE type FROM sym_fields WHERE id = '23' LIMIT 1; [0.0003] SELECT SQLCACHE type FROM sym_fields WHERE id = '24' LIMIT 1; [0.0001] SELECT SQLCACHE type FROM sym_fields WHERE id = '25' LIMIT 1; [0.0001] SELECT SQLCACHE type FROM sym_fields WHERE id = '26' LIMIT 1; [0.0001] SELECT SQLCACHE type FROM sym_fields WHERE id = '27' LIMIT 1; [0.0001] SELECT SQLCACHE type FROM sym_fields WHERE id = '28' LIMIT 1; [0.0001] SELECT SQLCACHE t1.* FROM symfields as t1 WHERE 1 AND t1.parent_section = '7' ORDER BY t1.sortorder ASC; [0.0003] DELETE FROM symentriesdata23 WHERE entry_id = '8'; [0.0003] INSERT INTO sym_entries_data_23 (entry_id, value, handle) VALUES ('8', '?????!', '?????'); [0.0002] DELETE FROM symentriesdata24 WHERE entry_id = '8'; [0.0000] INSERT INTO sym_entries_data_24 (entry_id, value, value_formatted) VALUES ('8', '??????2000????????????????????????????????????????????????rn', '

??????2000????????????????????????????????????????????????

n'); [0.0000]

Then if you try to the delete the section, you get more errors. If you try deleting twice, it is deleted

Symphony Fatal Database Error Unknown table 'symentriesdata_40' An error occurred while attempting to execute the following query DROP TABLE sym_entries_data_40 Backtrace: [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:458] MySQL->error(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.fieldmanager.php:151] MySQL->query(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.sectionmanager.php:97] FieldManager->delete(); [/Applications/MAMP/htdocs/symphony/content/content.blueprintssections.php:818] SectionManager->delete(); [/Applications/MAMP/htdocs/symphony/content/content.blueprintssections.php:824] contentBlueprintsSections->actionNew(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:440] contentBlueprintsSections->actionEdit(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:409] AdministrationPage->switchboard(); [/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:242] AdministrationPage->action(); [/Applications/MAMP/htdocs/symphony/lib/core/class.administration.php:222] AdministrationPage->build(); [/Applications/MAMP/htdocs/symphony/lib/core/class.administration.php:375] Administration->__buildPage(); [/Applications/MAMP/htdocs/index.php:25] Administration->display(); Database Query Log: SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'; [0.0002] SET CHARACTER SET 'utf8'; [0.0001] SELECT SQL_CACHE session_data FROM sym_sessions WHERE session = '0b3045154f34ec9c3832113b60d3a2df' LIMIT 1; [0.0002] SELECT SQL_CACHE name FROM sym_extensions WHERE status = 'enabled'; [0.0002] SELECT SQL_CACHE id FROM sym_authors WHERE username = 'Pat' AND password = '8cb706dccb601ec747367471e6cf0c8af283562e' LIMIT 1; [0.0002] UPDATE sym_authors SET last_seen = '2011-06-19 23:32:50' WHERE id = '1'; [0.0002] 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 id FROM sym_sections WHERE handle = '' LIMIT 1; [0.0001] SELECT SQL_CACHE s.* FROM sym_sections AS s ORDER BY s.name ASC; [0.0002] SELECT SQL_CACHE * FROM sym_sections ORDER BY sortorder ASC; [0.0002] 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.0005] SELECT SQL_CACHE id, element_name, type FROM sym_fields WHERE parent_section=13 AND multilanguage=1;; [0.0002] SELECT SQL_CACHE sortorder FROM sym_sections WHERE id = '13'; [0.0001] SELECT SQL_CACHE id FROM sym_entries WHERE section_id = '13'; [0.0001] DELETE FROM sym_entries WHERE id IN (''); [0.0001] SELECT SQL_CACHE id FROM sym_fields WHERE parent_section = '13'; [0.0001] SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.id = '40' LIMIT 1; [0.0001] SELECT SQL_CACHE * FROM sym_fields_textarea WHERE field_id = '40' LIMIT 1; [0.0001] DELETE FROM sym_fields WHERE id = '40'; [0.0002] DELETE FROM sym_fields_textarea WHERE field_id = '40'; [0.0001] DELETE FROM sym_sections_association WHERE child_section_field_id = '40'; [0.0001] DROP TABLE sym_entries_data_40; [0.0000]

Extension list

•   Author Roles    Not Installed   Enable to install 1.0   Giel Berkers
•   Author Section  Not Installed   Enable to install 0.8.1 Giel Berkers
•   Backend Language Switcher   Not Installed   Enable to install 1.0   John J. Camilleri
•   Calendar Overlay    1.0.6   Yes Rowan Lewis
•   Clean URL Params    1.0.2   Yes Rowan Lewis
•   Cross-Site Scripting (XSS) Filter   1.0 Yes Symphony Team
•   Debug DevKit    1.1 Yes Rowan Lewis
•   Export Ensemble 1.13    Yes Alistair Kearney, Symphony Team
•   Field: Multilingual Text    Not Installed   Enable to install 1.3   Guillem Lorman
•   Field: Select Box Link  1.19    Yes Symphony Team
•   File Manager    0.9 Yes Symphony Team
•   Image Index Preview Not Installed   Enable to install 1.2.1 Nils Hörrmann
•   JIT Image Manipulation  1.10    Yes Alistair Kearney
•   Language Redirect   1.0.1   Yes Jonas Coch
•   Maintenance Mode    1.4 Yes Alistair Kearney, Symphony Team
•   Markdown Guide  Not Installed   Enable to install 1.3   Carson Sasser
•   Multilanguage support for Symphony 2.0.7 and 2.1    0.33    Yes Giel Berkers
•   Order Entries   Not Installed   Enable to install 1.9.6 Nick Dunn
•   Page LHandles   1.1 Yes Vlad Ghita
•   Profile Devkit  1.0.4   Yes Rowan Lewis
•   Resize Upladed Image Files  1   Yes Thomas Appel
•   Site Name   1.1 Yes Stephen Bau
•   Static Section  1.6.1   Yes Nathan Martin, Rainer Borene, Vlad Ghita
•   Subsection Manager  Not Installed   Enable to install 1.2   Nils Hörrmann
•   Text Formatter: Markdown    1.13    Yes Alistair Kearney

This is a minor inconvenience, as using the Text Box extension avoids this error.

Has anyone else experienced this error? A colleague has just tried installing 2.2.1 and following the tutorials but gets pretty much the same errors after trying to add a basic textarea to a section?

Does this issue apply to you?

Thanks @brendo looks like the same issue. We deleted the database and install and performed another clean install and this seems to have worked. Comparing my settings we are running same versions of MySQL.