PHP Fatal error: Uncaught ServerException: [500]: Empty primary key ('id') value was given to query for a "File" object
thrown in /var/www/gnusocial/classes/Managed_DataObject.php on line 403
GS debug log:
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] sprintf(): Too few arguments (/var/www/gnusocial/plugins/StoreRemoteMedia/scripts/deleteRemoteMedia.php:69)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:1647)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:1415)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_keys() expects parameter 1 to be array, object given (/var/www/gnusocial/extlib/DB/DataObject.php:1759)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_flip() expects parameter 1 to be array, null given (/var/www/gnusocial/extlib/DB/DataObject.php:1759)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_keys() expects parameter 1 to be array, object given (/var/www/gnusocial/extlib/DB/DataObject.php:1773)
It says "Too few arguments" on first line of debug; i've tried combinations (-ldate, --limit date --limit date, -a, --all, -i) without success.
When executing this:
php deleteRemoteMedia.php --all -l20210401
I get this:
PHP Fatal error: Uncaught ServerException: [500]: Empty primary key ('id') value was given to query for a "File" object
thrown in /var/www/gnusocial/classes/Managed_DataObject.php on line 403
GS debug log:
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] sprintf(): Too few arguments (/var/www/gnusocial/plugins/StoreRemoteMedia/scripts/deleteRemoteMedia.php:69)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_query(): Empty query (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:805)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:1647)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:1415)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_keys() expects parameter 1 to be array, object given (/var/www/gnusocial/extlib/DB/DataObject.php:1759)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_flip() expects parameter 1 to be array, null given (/var/www/gnusocial/extlib/DB/DataObject.php:1759)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_keys() expects parameter 1 to be array, object given (/var/www/gnusocial/extlib/DB/DataObject.php:1773)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] Invalid argument supplied for foreach() (/var/www/gnusocial/extlib/DB/DataObject.php:1773)
2021-05-05 09:12:26 LOG_NOTICE: [gnusocial.net:deleteRemoteMedia.php:2967] [8] Undefined property: DB_DataObject::$file_id (/var/www/gnusocial/plugins/StoreRemoteMedia/scripts/deleteRemoteMedia.php:73)
It says "Too few arguments" on first line of debug; i've tried combinations (-ldate, --limit date --limit date, -a, --all, -i) without success.
Diogo Cordeiro
When executing this:
php deleteRemoteMedia.php --all -l20210401
I get this:
PHP Fatal error: Uncaught ServerException: [500]: Empty primary key ('id') value was given to query for a "File" object
thrown in /var/www/gnusocial/classes/Managed_DataObject.php on line 403
GS debug log:
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] sprintf(): Too few arguments (/var/www/gnusocial/plugins/StoreRemoteMedia/scripts/deleteRemoteMedia.php:69)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_query(): Empty query (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:805)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:1647)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given (/var/www/gnusocial/extlib/MDB2/Driver/mysqli.php:1415)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_keys() expects parameter 1 to be array, object given (/var/www/gnusocial/extlib/DB/DataObject.php:1759)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_flip() expects parameter 1 to be array, null given (/var/www/gnusocial/extlib/DB/DataObject.php:1759)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] array_keys() expects parameter 1 to be array, object given (/var/www/gnusocial/extlib/DB/DataObject.php:1773)
2021-05-05 09:12:26 LOG_WARNING: [gnusocial.net:deleteRemoteMedia.php:2967] [2] Invalid argument supplied for foreach() (/var/www/gnusocial/extlib/DB/DataObject.php:1773)
2021-05-05 09:12:26 LOG_NOTICE: [gnusocial.net:deleteRemoteMedia.php:2967] [8] Undefined property: DB_DataObject::$file_id (/var/www/gnusocial/plugins/StoreRemoteMedia/scripts/deleteRemoteMedia.php:73)
It says "Too few arguments" on first line of debug; i've tried combinations (-ldate, --limit date --limit date, -a, --all, -i) without success.
Fixed with
fbeadc1d49