Announcement

Symphony's issue tracker has been moved to Github.

Issues are displayed here for reference only and cannot be created or edited.

Browse

Closed#441: Author queried twice for each page load

Looking at the query log for a new blank page, I see the Author being queried twice.

SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` = 'test' AND `password` = 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3' LIMIT 1
UPDATE sym_authors SET `last_seen` = '2010-12-21 19:16:07' WHERE `id` = '1'
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC
...
SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` = 'test' AND `password` = 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3' LIMIT 1
UPDATE sym_authors SET `last_seen` = '2010-12-21 19:16:07' WHERE `id` = '1'
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC

It should only need to perform this once.

This issue is closed.

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