1 users online. Create an account or sign in to join them.Users

Search

Any guesses why this is happening? I just installed with the default workspace.

Error when clicking to edit a page:

Symphony Fatal Database Error
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 'FROM `sym_pages` AS p WHERE id = '64' LIMIT 1' at line 1
An error occurred while attempting to execute the following query
SELECT SQL_CACHE FROM `sym_pages` AS p WHERE id = '64' LIMIT 1
Backtrace:
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:458] MySQL->__error();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:604] MySQL->query();
[/Applications/MAMP/htdocs/extensions/page_lhandles/lib/class.pagelhandles.php:264] MySQL->fetch();
[/Applications/MAMP/htdocs/extensions/page_lhandles/extension.driver.php:88] PageLHandles->append_page_form_content();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.extensionmanager.php:566] Extension_page_lhandles->append_page_content();
[/Applications/MAMP/htdocs/symphony/content/content.blueprintspages.php:576] ExtensionManager->notifyMembers();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:440] contentBlueprintsPages->__viewEdit();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:397] AdministrationPage->__switchboard();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:260] AdministrationPage->view();
[/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-20 00:20:51' WHERE `id` = '1'; [0.0002]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC; [0.0002]
SELECT SQL_CACHE * FROM `sym_extensions`; [0.0002]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = '' LIMIT 1; [0.0002]
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.0006]
SELECT SQL_CACHE p.* FROM `sym_pages` AS p WHERE p.id = '64' LIMIT 1; [0.0002]
SELECT SQL_CACHE p.type FROM `sym_pages_types` AS p WHERE p.page_id = '64' ORDER BY p.type ASC; [0.0002]
SELECT SQL_CACHE p.* FROM `sym_pages` AS p WHERE p.id != '64' ORDER BY p.title ASC; [0.0003]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '66' OR p.handle = '66' LIMIT 1; [0.0002]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '68' OR p.handle = '68' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '69' OR p.handle = '69' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '70' OR p.handle = '70' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '75' OR p.handle = '75' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '76' OR p.handle = '76' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '67' OR p.handle = '67' LIMIT 1; [0.0001]
SELECT SQL_CACHE `type` FROM `sym_pages_types` ORDER BY `type` ASC; [0.0002]
SELECT SQL_CACHE FROM `sym_pages` AS p WHERE id = '64' LIMIT 1; [0.0000]

Error when creating new page:

Symphony Fatal Database Error
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 'FROM `sym_pages` AS p WHERE id = '' LIMIT 1' at line 1
An error occurred while attempting to execute the following query
SELECT SQL_CACHE FROM `sym_pages` AS p WHERE id = '' LIMIT 1
Backtrace:
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:458] MySQL->__error();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.mysql.php:604] MySQL->query();
[/Applications/MAMP/htdocs/extensions/page_lhandles/lib/class.pagelhandles.php:264] MySQL->fetch();
[/Applications/MAMP/htdocs/extensions/page_lhandles/extension.driver.php:88] PageLHandles->append_page_form_content();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.extensionmanager.php:566] Extension_page_lhandles->append_page_content();
[/Applications/MAMP/htdocs/symphony/content/content.blueprintspages.php:576] ExtensionManager->notifyMembers();
[/Applications/MAMP/htdocs/symphony/content/content.blueprintspages.php:277] contentBlueprintsPages->__viewEdit();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:440] contentBlueprintsPages->__viewNew();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:397] AdministrationPage->__switchboard();
[/Applications/MAMP/htdocs/symphony/lib/toolkit/class.administrationpage.php:260] AdministrationPage->view();
[/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-20 00:24:17' WHERE `id` = '1'; [0.0002]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC; [0.0002]
SELECT SQL_CACHE * FROM `sym_extensions`; [0.0002]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = '' LIMIT 1; [0.0002]
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.0006]
SELECT SQL_CACHE p.* FROM `sym_pages` AS p WHERE p.id != '' ORDER BY p.title ASC; [0.0003]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '66' OR p.handle = '66' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '68' OR p.handle = '68' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '69' OR p.handle = '69' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '70' OR p.handle = '70' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '64' OR p.handle = '64' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '75' OR p.handle = '75' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '76' OR p.handle = '76' LIMIT 1; [0.0001]
SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = '67' OR p.handle = '67' LIMIT 1; [0.0001]
SELECT SQL_CACHE `type` FROM `sym_pages_types` ORDER BY `type` ASC; [0.0002]
SELECT SQL_CACHE FROM `sym_pages` AS p WHERE id = '' LIMIT 1; [0.0000]

You forgot to mention that you have installed and enabled the Page LHandles extension...

Ah yes, disabling it fixes the issue. I was using Page LHandles just find yesterday before I reinstalled Symphony to use utf-8 though. It also says Page LHandles is 2.2.1 compatible, and I have the same extensions installed from yesterday.

Can you log this as an issue for that extension and see if any resolution is available? Cheers.

Reported!

Took notice. I will check it soon. Page LHandles will be upgraded because there is code duplicating Language Redirect v1.0.2 (latest) functionality. So ... please be patient.

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.2 or above
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.0 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details