search

joshp23 / YOURLS-Expiry

YOURLS plugin to define conditions under which links will expire - time and click limited links
GNU General Public License v3.0
35 stars 13 forks source link

Revert "Memory consumption predictability on prune action" #29

Closed joshp23 closed 3 years ago

joshp23 commented 3 years ago

Reverts joshp23/YOURLS-Expiry#18 due to error

joshp23 commented 3 years ago

@vitalyzhakov I am reverting this after testing due to the following error while pruning from admin:

2020/09/02 09:30:43 [error] 15238#15238: *433049 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'MY-DB-NAME.yourls_url' doesn't exist in /var/www/YOURLS/includes/vendor/aura/sql/src/ExtendedPdo.php:748
Stack trace:
#0 /var/www/YOURLS/includes/vendor/aura/sql/src/ExtendedPdo.php(748): PDOStatement->execute()
#1 /var/www/YOURLS/includes/vendor/aura/sql/src/ExtendedPdo.php(523): Aura\Sql\ExtendedPdo->perform('SELECT count(1)...', Array)
#2 /var/www/YOURLS/user/plugins/expiry/plugin.php(1345): Aura\Sql\ExtendedPdo->fetchObjects('SELECT count(1)...')
#3 /var/www/YOURLS/user/plugins/expiry/plugin.php(704): expiry_db_flush('expired')
#4 /var/www/YOURLS/user/plugins/expiry/plugin.php(44): expiry_flush()
#5 /var/www/YOURLS/includes/functions-plugins.php(637): expiry_do_page()
#6 /var/www/YOURLS/admin/plugins.php(8): yourls_plugin_admin_page('expiry')
#7 {main}
  thrown in /var/www/YOURLS/includes/vendor/aura/sql/src/ExtendedPdo.php on line 748" while reading upstream, client: 2001:470:c308:0:cd27:a179:2993:91fa, server: 0eq2.com, request: "POST /admin/plugins.php?page=expiry HTTP/2.0", upstream: "fastcgi://unix:/run/php/php7.2-fpm.sock:", host: "0eq2.com"