Schema Migration
Track actions performed on sections and pages in a convenient way.
New#1: SQL syntax error when editing a page
I think I found a solution to the syntax error. On line 42 of the MigrationManager
class, the query is missing FROM
, so it needs to change from this:
$guid = Symphony::Database()->fetchVar('guid', 0, "SELECT guid `sym_pages` WHERE id = {$type['page_id']}");
to this:
$guid = Symphony::Database()->fetchVar('guid', 0, "SELECT guid FROM `sym_pages` WHERE id = {$type['page_id']}");
This appears to solve my issue.
Please login to comment.
Using the latest Symphony integration branch, I'm getting the following error when editing a page:
The backtrace refers to: