Error msg in app.log #72

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.

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 !

Thanks for shedding light on this so swiftly @MrPetovan !
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
Sign in to join this conversation.
No milestone
No project
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: friendica/friendica-directory#72
No description provided.