“Fatal SQL error, how to fix it?” – Forum Thread – Discuss – Symphony.

Fatal SQL error, how to fix it?

This is an open discussion with 1 reply, filed under General.

Search

You are looking at page 1 of 1

- Manaus
- 04 Jan 17, 2:09 am
- Comment #1

Hello, I was trying to set up a section, and on viewing entries, out of the blue, the system replied with a

Symphony Fatal Database Error: Table 'sym_mywebsite.sym_entries_data_52' doesn't exist
SELECT SQL_CACHE `e`.`id`, `e`.section_id, `e`.`author_id`, `e`.`creation_date` AS `creation_date`, `e`.`modification_date` AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`section_id` = 12 ORDER BY ( SELECT `ed`.value FROM sym_entries_data_52 AS `ed` WHERE entry_id = e.id ) ASC LIMIT 0, 20

Is this fixable?
Thanks

- Manaus
- 04 Jan 17, 2:15 am
- Comment #2

Ok I think I made it, I just removed all the fields from the Section, then recreating them one by one...

Create an account or sign in to comment.

Quick Links

Contact the team

Found a bug on this website?

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

Create Account

Sign in