Search

I deleted a section, basically a lookup section that contained 4 entries for use in dropdowns one other section. I realized I could just create a static enumerated list, since the number of entries probably wasn't going to grow much.

After I deleted the section, I'm getting a Fatal Database Error whenever I try to view or create a Data Source:

Symphony Fatal Database Error
Table 'publicweb.sym_entries_data_81' doesn't exist
An error occurred while attempting to execute the following query
SHOW COLUMNS FROM `sym_entries_data_81` LIKE 'value'

Any suggestions on troubleshooting this?

OK, I fixed this by viewing the section that used the deleted section in a dynamic Select Box, changing it to a predefined list, then saving the changes.

I'm guessing the fatal error occurred when Symphony was attempting to reflect all of the sections for populating the Source and Included Elements form items.

I'm guessing the fatal error occurred when Symphony was attempting to reflect all of the sections for populating the Source and Included Elements form items.

You got it :-) Resaving the other sections, and/or related data sources, usually does the trick.

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