Tools

I get a database error when open front-end after update to 5.1.1

Author: Edward Hardin Reference Number: AA-00408 Views: 8083 Last Updated: 11/23/2009 03:16 PM

0 Rating/ Voters

I get a database error when open front-end after update to 5.1.1.

A Database Error Occurred
Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8

SELECT `lb`.`block_id`, `lbc`.`block_name`, `lbc`.`template` FROM `tpl_layouts_blocks` AS `lb` JOIN `tpl_blocks` AS `lbc` ON `lbc`.`block_id` = `lb`.`block_id` WHERE `layout_id` =

The admin site is still working.

To solve this you need to:

Login to the admin area
Go to Customization > Styling and Front-end Settings.
Select your front-end theme.
Click "Save".