SequelizeDatabaseError

Help me!
1

Failure Logs

Hello , I have this error : [forest] :deciduous_tree::deciduous_tree::deciduous_tree: Cannot set the Date derniere connexion value because of an unexpected error: column user.ios_sign_in_count does not existPreformatted text

[forest] 🌳🌳🌳  Cannot set the Date derniere connexion  value because of an unexpected error: column user.ios_sign_in_count does not exist
{
  "name": "SequelizeDatabaseError",
  "parent": {
    "length": 191,
    "name": "error",
    "severity": "ERROR",
    "code": "42703",
    "hint": "Perhaps you meant to reference the column \"user.web_sign_in_count\".",
    "position": "1797",
    "file": "parse_relation.c",
    "line": "3563",
    "routine": "errorMissingColumn",
    "sql": "SELECT \"identities\".\"id\", \"identities\".\"sergic_id\" AS \"sergicId\", \"identities\".\"phone_number\" AS \"phoneNumber\", \"identities\".\"phone_checked\" AS \"phoneChecked\", \"identities\".\"first_name\" AS \"firstName\", \"identities\".\"last_name\" AS \"lastName\", \"identities\".\"email\", \"identities\".\"title\", \"identities\".\"sergic_update_time\" AS \"sergicUpdateTime\", \"identities\".\"birth_date\" AS \"birthDate\", \"identities\".\"invited\", \"identities\".\"created_at\" AS \"createdAt\", \"identities\".\"updated_at\" AS \"updatedAt\", \"identities\".\"real_name\" AS \"realName\", \"identities\".\"home_phone\" 
AS \"homePhone\", \"identities\".\"representative\", \"identities\".\"legal_kind\" AS \"legalKind\", \"identities\".\"user_id\" AS \"userIdKey\", \"user\".\"id\" AS \"user.id\", \"user\".\"email\" AS \"user.email\", \"user\".\"encrypted_password\" AS \"user.encryptedPassword\", \"user\".\"reset_password_token\" AS \"user.resetPasswordToken\", \"user\".\"reset_password_sent_at\" AS \"user.resetPasswordSentAt\", \"user\".\"created_at\" AS \"user.createdAt\", \"user\".\"updated_at\" AS \"user.updatedAt\", \"user\".\"sales_optin\" AS \"user.salesOptin\", \"user\".\"invitation_token\" AS \"user.invitationToken\", \"user\".\"invitation_created_at\" 
AS \"user.invitationCreatedAt\", \"user\".\"invitation_sent_at\" AS \"user.invitationSentAt\", \"user\".\"invitation_accepted_at\" AS \"user.invitationAcceptedAt\", \"user\".\"invitation_limit\" AS \"user.invitationLimit\", \"user\".\"invited_by_type\" AS \"user.invitedByType\", \"user\".\"invited_by_id\" AS \"user.invitedById\", \"user\".\"invitations_count\" AS \"user.invitationsCount\", \"user\".\"sign_in_count\" AS \"user.signInCount\", \"user\".\"current_sign_in_at\" AS \"user.currentSignInAt\", \"user\".\"last_sign_in_at\" AS \"user.lastSignInAt\", \"user\".\"current_sign_in_ip\" AS \"user.currentSignInIp\", \"user\".\"last_sign_in_ip\" 
AS \"user.lastSignInIp\", \"user\".\"web_sign_in_count\" AS \"user.webSignInCount\", \"user\".\"ios_sign_in_count\" AS \"user.iosSignInCount\", \"user\".\"android_sign_in_count\" AS \"user.androidSignInCount\", \"user\".\"last_connection_syndicone\" AS \"user.lastConnectionSyndicone\", \"user\".\"term_version_syndicone\" AS \"user.termVersionSyndicone\", \"user\".\"failed_attempts\" AS \"user.failedAttempts\", \"user\".\"locked_at\" AS \"user.lockedAt\" FROM \"public\".\"identities\" AS \"identities\" LEFT OUTER JOIN \"public\".\"users\" AS \"user\" ON \"identities\".\"user_id\" = \"user\".\"id\" WHERE \"identities\".\"id\" = 9218;

Context

Project name: .Sergic
Team name: gestion
Environment name: Développement
Agent (forest package) name & version: 9
Database type: Postgres
Recent changes made on your end if any: upgrade to v9

2

Hello @Soufiane,

Thanks for your message :raised_hands:

Was it working before?
Is the field ios_sign_in_count well defined in your Sequelize model definition?
Can you show me that definition?

Thanks.