From 2ad6f6e11f1d9eb99b4e7fc36d0bf4a8313d4c3c Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Fri, 7 May 2021 11:08:40 +0000
Subject: remove logging

---
 include/account.php | 1 -
 1 file changed, 1 deletion(-)

diff --git a/include/account.php b/include/account.php
index 6643f0988..cebcbd7e3 100644
--- a/include/account.php
+++ b/include/account.php
@@ -1295,7 +1295,6 @@ function get_pending_accounts($get_all = false) {
 }
 
 function remove_expired_registrations() {
-	hz_syslog('### expire reg', LOGGER_DEBUG);
 	q("DELETE FROM register WHERE (reg_expires < '%s' OR reg_expires = '%s') AND (reg_flags & %d) > 0",
 		dbesc(datetime_convert()),
 		dbesc(NULL_DATE),
-- 
cgit v1.2.3


From ebd0333256b8209de958085057848b649dbd9283 Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Fri, 7 May 2021 12:15:00 +0000
Subject: register: postgres - add default values for timestamps

---
 include/account.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/include/account.php b/include/account.php
index cebcbd7e3..d138dab41 100644
--- a/include/account.php
+++ b/include/account.php
@@ -875,9 +875,9 @@ function verify_register_scheme() {
 					. "reg_did2    text    DEFAULT '' NOT NULL,"
 					. "reg_hash    text    DEFAULT '' NOT NULL,"
 					. "reg_email   text    DEFAULT '' NOT NULL,"
-					. "reg_created timestamp  NOT NULL,"
-					. "reg_startup timestamp  NOT NULL,"
-					. "reg_expires timestamp  NOT NULL,"
+					. "reg_created timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',"
+					. "reg_startup timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',"
+					. "reg_expires timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',"
 					. "reg_byc     bigint  DEFAULT 0 NOT NULL,"
 					. "reg_uid     bigint  DEFAULT 0 NOT NULL,"
 					. "reg_atip    text    DEFAULT '' NOT NULL,"
-- 
cgit v1.2.3


From c2e007a8392be62c2698e5519b6d0dc0ec92a92b Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Fri, 7 May 2021 15:02:55 +0000
Subject: update 1245 to fix hubloc_hash index for postgres

---
 Zotlabs/Update/_1245.php    | 29 +++++++++++++++++++++++++++++
 boot.php                    |  2 +-
 install/schema_postgres.sql |  7 ++++---
 3 files changed, 34 insertions(+), 4 deletions(-)
 create mode 100644 Zotlabs/Update/_1245.php

diff --git a/Zotlabs/Update/_1245.php b/Zotlabs/Update/_1245.php
new file mode 100644
index 000000000..8212fde08
--- /dev/null
+++ b/Zotlabs/Update/_1245.php
@@ -0,0 +1,29 @@
+<?php
+
+namespace Zotlabs\Update;
+
+class _1245 {
+
+	function run() {
+
+		if(ACTIVE_DBTYPE == DBTYPE_MYSQL) {
+				return UPDATE_SUCCESS;
+		}
+
+		if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
+			q("START TRANSACTION");
+
+			$r = dbq("create index hubloc_hash on hubloc (hubloc_hash)");
+
+			if($r) {
+				q("COMMIT");
+				return UPDATE_SUCCESS;
+			}
+
+			q("ROLLBACK");
+			return UPDATE_FAILED;
+		}
+
+	}
+
+}
diff --git a/boot.php b/boot.php
index a6dfbf7a5..c057f8278 100644
--- a/boot.php
+++ b/boot.php
@@ -55,7 +55,7 @@ define ( 'PLATFORM_NAME',           'hubzilla' );
 define ( 'STD_VERSION',             '5.7' );
 define ( 'ZOT_REVISION',            '6.0' );
 
-define ( 'DB_UPDATE_VERSION',       1244 );
+define ( 'DB_UPDATE_VERSION',       1245 );
 
 define ( 'PROJECT_BASE',   __DIR__ );
 
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 52b44bd07..c18cc087b 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -506,6 +506,7 @@ CREATE TABLE "hubloc" (
 create index "hubloc_url" on hubloc ("hubloc_url");
 create index "hubloc_site_id" on hubloc ("hubloc_site_id");
 create index "hubloc_guid" on hubloc ("hubloc_guid");
+create index "hubloc_hash" on hubloc ("hubloc_hash");
 create index "hubloc_id_url" on hubloc ("hubloc_id_url");
 create index "hubloc_flags" on hubloc ("hubloc_flags");
 create index "hubloc_connect" on hubloc ("hubloc_connect");
@@ -1099,9 +1100,9 @@ CREATE TABLE "register" (
   "reg_did2"   text    DEFAULT '' NOT NULL,
   "reg_hash"   text    DEFAULT '' NOT NULL,
   "reg_email"  text    DEFAULT '' NOT NULL,
-  "reg_created" timestamp  NOT NULL,
-  "reg_startup" timestamp  NOT NULL,
-  "reg_expires" timestamp  NOT NULL,
+  "reg_created" timestamp  NOT NULL DEFAULT '0001-01-01 00:00:00',
+  "reg_startup" timestamp  NOT NULL DEFAULT '0001-01-01 00:00:00',
+  "reg_expires" timestamp  NOT NULL DEFAULT '0001-01-01 00:00:00',
   "reg_byc"    bigint  DEFAULT 0 NOT NULL,
   "reg_uid"    bigint  DEFAULT 0 NOT NULL,
   "reg_atip"   text    DEFAULT '' NOT NULL,
-- 
cgit v1.2.3


From 954d06bdb7c8ef9f73f799eec72fcbd8bbc56b9f Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Sat, 8 May 2021 08:29:04 +0000
Subject: remove redundant placeholder in query

---
 Zotlabs/Lib/Activity.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/Zotlabs/Lib/Activity.php b/Zotlabs/Lib/Activity.php
index e036c7b1e..6e8344def 100644
--- a/Zotlabs/Lib/Activity.php
+++ b/Zotlabs/Lib/Activity.php
@@ -132,8 +132,8 @@ class Activity {
 	}
 
 	static function fetch_profile($x) {
-		$r = q("select * from xchan where xchan_url like '%s' limit 1",
-			dbesc($x['id'] . '/%')
+		$r = q("select * from xchan where xchan_url = '%s' limit 1",
+			dbesc($x['id'])
 		);
 		if (!$r) {
 			$r = q("select * from xchan where xchan_hash = '%s' limit 1",
-- 
cgit v1.2.3