YunoHost-Apps / friendica_ynh

Friendica package for YunoHost
http://friendi.ca/
Other
11 stars 13 forks source link

[ERROR]: DB Error {"code":1264,"error":"Out of range value for column 'registered-users' at row 1","callstack":"DBA::update #67

Closed isAAAc closed 2 years ago

isAAAc commented 2 years ago

does someone understand this log please ? and how to fix it ?

have a good day o/

# tail -f /var/log/friendica.log

2021-12-29T08:50:04Z worker [ERROR]: DB Error {"code":1264,"error":"Out of range value for column 'registered-users' at row 1","callstack":"DBA::update, GServer::detect, GServer::check, UpdateGServer::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"UPDATE `gserver` SET `detection-method` = 16, `site_name` = 'The Entire World', `info` = 'You think your fake numbers are impressive? Well, this instance contains all living humans.', `platform` = 'mastodon', `version` = '2.9.2+antifa', `network` = 'apub', `registered-users` = 7823881432, `directory-type` = 0, `poco` = '', `url` = 'https:\/\/you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me', `nurl` = 'http:\/\/you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me', `next_contact` = '2022-01-05 08:50:04', `last_contact` = '2021-12-29 08:50:04', `failed` = 0 WHERE (`nurl` = 'http:\/\/you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me')"} - {"file":"Database.php","line":766,"function":"e","uid":"26d0aa","process_id":16442}
2021-12-29T09:00:04Z worker [ERROR]: DB Error {"code":1264,"error":"Out of range value for column 'registered-users' at row 1","callstack":"DBA::update, GServer::detect, GServer::check, UpdateGServer::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"UPDATE `gserver` SET `detection-method` = 16, `site_name` = 'The Entire World', `info` = 'You think your fake numbers are impressive? Well, this instance contains all living humans.', `platform` = 'mastodon', `version` = '2.9.2+antifa', `network` = 'apub', `registered-users` = 7823882912, `directory-type` = 0, `poco` = '', `url` = 'https:\/\/you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me', `nurl` = 'http:\/\/you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me', `next_contact` = '2022-01-05 09:00:04', `last_contact` = '2021-12-29 09:00:04', `failed` = 0 WHERE (`nurl` = 'http:\/\/you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me')"} - {"file":"Database.php","line":766,"function":"e","uid":"1e69bf","process_id":18200}
isAAAc commented 2 years ago

https://you-think-your-fake-numbers-are-impressive.well-this-instance-contains-all-living-humans.lubar.me/ is just a joke or a POC

isAAAc commented 2 years ago

am i alone to have this log ? oO

isAAAc commented 2 years ago

https://fosstodon.org/@mlaunois/102429198261124208

Jul 12, 2019 It's another Gab protest (because they were faking their numbers). Personally, I think we should just ignore the problem – that way, it'll go away.

oh oh oh /o\

isAAAc commented 2 years ago

fixed by adding it to https://<my.domain.tld>/admin/blocklist/server