Skip to content

Instantly share code, notes, and snippets.

@benharold
Last active January 27, 2017 19:51
Show Gist options
  • Save benharold/8ca1ed451732768a2e086e90070e4e9a to your computer and use it in GitHub Desktop.
Save benharold/8ca1ed451732768a2e086e90070e4e9a to your computer and use it in GitHub Desktop.
Changes needed to get Helix3 template working under PostgreSQL
diff --git a/plugins/system/helix3.php b/plugins/system/helix3.php
index ac6c71e..3ccf4b7 100644
--- a/plugins/system/helix3.php
+++ b/plugins/system/helix3.php
@@ -179,7 +179,7 @@ class plgSystemHelix3 extends JPlugin
$query->select($db->quoteName(array('template')));
$query->from($db->quoteName('#__template_styles'));
$query->where($db->quoteName('client_id') . ' = 0');
- $query->where($db->quoteName('home') . ' = 1');
+ $query->where($db->quoteName('home') . ' = ' . $db->quote(1));
$db->setQuery($query);
return $db->loadObject()->template;
diff --git a/plugins/system/layout/layout-settings/row-column-settings.php b/plugins/system/layout/layout-settings/row-column-settings.php
index 811e04a..cd31a0a 100644
--- a/plugins/system/layout/layout-settings/row-column-settings.php
+++ b/plugins/system/layout/layout-settings/row-column-settings.php
@@ -278,7 +278,7 @@ class RowColumnSettings{
$query->select($db->quoteName(array('template')));
$query->from($db->quoteName('#__template_styles'));
$query->where($db->quoteName('client_id') . ' = 0');
- $query->where($db->quoteName('home') . ' = 1');
+ $query->where($db->quoteName('home') . ' = ' . $db->quote(1));
$db->setQuery($query);
return $db->loadObject()->template;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment