From e87d8d98569df7405f76d17979d2e3254c811632 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Fri, 1 Nov 2019 17:46:28 +0100 Subject: Change llink column type and drop index --- install/schema_mysql.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 7faeb93dd..b0d3dd7ba 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -595,7 +595,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `layout_mid` char(191) NOT NULL DEFAULT '', `postopts` text NOT NULL, `route` text NOT NULL, - `llink` char(191) NOT NULL DEFAULT '', + `llink` text NOT NULL DEFAULT '', `plink` text NOT NULL, `resource_id` char(191) NOT NULL DEFAULT '', `resource_type` char(16) NOT NULL DEFAULT '', @@ -659,7 +659,6 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `commented` (`commented`), KEY `verb` (`verb`), KEY `obj_type` (`obj_type`), - KEY `llink` (`llink`), KEY `expires` (`expires`), KEY `revision` (`revision`), KEY `mimetype` (`mimetype`), -- cgit v1.2.3 From 308619a72650a11b55eaa00d2ea638d5e8722bd6 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Fri, 1 Nov 2019 17:47:16 +0100 Subject: Drop llink index --- install/schema_postgres.sql | 1 - 1 file changed, 1 deletion(-) diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index c1c222b37..c04ba9c67 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -644,7 +644,6 @@ create index "item_resource_type" on item ("resource_type"); create index "item_commented" on item ("commented"); create index "item_verb" on item ("verb"); create index "item_obj_type" on item ("obj_type"); -create index "item_llink" on item ("llink"); create index "item_expires" on item ("expires"); create index "item_revision" on item ("revision"); create index "item_mimetype" on item ("mimetype"); -- cgit v1.2.3 From fc658a25d7eb05f0c7f6ed90f5d53c7c327bed23 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Fri, 1 Nov 2019 19:37:46 +0100 Subject: Update schema_mysql.sql --- install/schema_mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index b0d3dd7ba..977d26232 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -595,7 +595,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `layout_mid` char(191) NOT NULL DEFAULT '', `postopts` text NOT NULL, `route` text NOT NULL, - `llink` text NOT NULL DEFAULT '', + `llink` text NOT NULL, `plink` text NOT NULL, `resource_id` char(191) NOT NULL DEFAULT '', `resource_type` char(16) NOT NULL DEFAULT '', -- cgit v1.2.3 From 74ef5f38e9bf4642c6e752ad365ae20ead394e56 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Sat, 2 Nov 2019 10:36:04 +0100 Subject: Fix start time to sync queries on photo cache purge --- Zotlabs/Daemon/Cron.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Zotlabs/Daemon/Cron.php b/Zotlabs/Daemon/Cron.php index 8835d8fca..7b951e7d4 100644 --- a/Zotlabs/Daemon/Cron.php +++ b/Zotlabs/Daemon/Cron.php @@ -97,7 +97,7 @@ class Cron { // Clean expired photos from cache - $sql_interval = db_utcnow() . ' - INTERVAL ' . db_quoteinterval(get_config('system','active_expire_days', '30') . ' DAY'); + $sql_interval = "'" . dbesc(datetime_convert()) . "' - INTERVAL " . db_quoteinterval(get_config('system','active_expire_days', '30') . ' DAY'); $r = q("SELECT DISTINCT xchan, content FROM photo WHERE photo_usage = %d AND expires < $sql_interval", intval(PHOTO_CACHE) ); -- cgit v1.2.3