Error msg in app.log #72

New issue

Closed

opened 2020-10-27 13:10:56 +01:00 by AndyHee · 3 comments

AndyHee commented

2020-10-27 13:10:56 +01:00

(Migrated from github.com)

I get lots of error messages like this in the app.log. what's going?

2020-10-27 11:56:16 - ERROR {"uid":"687192a"}: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `friendica-directory`.`profile`.`available` at row 1:
#0 /var/www/directory/vendor/atlas/pdo/src/Connection.php(138): PDOStatement->execute()
#1 /var/www/directory/src/classes/Pollers/Profile.php(248): Atlas\Pdo\Connection->perform('INSERT INTO `pr...', Array)
#2 /var/www/directory/src/classes/Controllers/Cron.php(203): Friendica\Directory\Pollers\Profile->__invoke('https://soc.vis...')
#3 /var/www/directory/src/classes/Controllers/Cron.php(79): Friendica\Directory\Controllers\Cron->pollProfiles(58)
#4 /var/www/directory/bin/cron.php(22): Friendica\Directory\Controllers\Cron->execute()
#5 {main} []

All tables in that db are utf8mb4_general_ci collation. Have I misconfigured something?

I get lots of error messages like this in the app.log. what's going? ``` 2020-10-27 11:56:16 - ERROR {"uid":"687192a"}: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `friendica-directory`.`profile`.`available` at row 1: #0 /var/www/directory/vendor/atlas/pdo/src/Connection.php(138): PDOStatement->execute() #1 /var/www/directory/src/classes/Pollers/Profile.php(248): Atlas\Pdo\Connection->perform('INSERT INTO `pr...', Array) #2 /var/www/directory/src/classes/Controllers/Cron.php(203): Friendica\Directory\Pollers\Profile->__invoke('https://soc.vis...') #3 /var/www/directory/src/classes/Controllers/Cron.php(79): Friendica\Directory\Controllers\Cron->pollProfiles(58) #4 /var/www/directory/bin/cron.php(22): Friendica\Directory\Controllers\Cron->execute() #5 {main} [] ``` All tables in that db are `utf8mb4_general_ci` collation. Have I misconfigured something?

MrPetovan commented

2020-10-27 14:09:42 +01:00

(Migrated from github.com)

You do not, it just means we're trying to save an empty string in an integer field, which MySQL rightfully rejects.

AndyHee commented

2020-10-27 14:13:17 +01:00

(Migrated from github.com)

Thanks for shedding light on this so swiftly @MrPetovan !

❤️ 1

MrPetovan commented

2024-04-30 02:41:49 +02:00

Owner

Probably fixed in #90, specifically by 9ff681a460

Probably fixed in https://git.friendi.ca/friendica/friendica-directory/pulls/90, specifically by https://git.friendi.ca/friendica/friendica-directory/commit/9ff681a460b70a80f16d636793a6d64d3dd19916