monicahq / monica

Personal CRM. Remember everything about your friends, family and business relationships.
https://beta.monicahq.com
GNU Affero General Public License v3.0
21.61k stars 2.16k forks source link

"Events in the next 3 months" is empty despite having contacts populated with valid reminders & events #5477

Open dchakro opened 3 years ago

dchakro commented 3 years ago

Since the month of June I have not been getting any reminders and neither do they display in the "Events in the next 3 months" on the dashboard. It just shows "No reminders for this month". Oddly enough there is this one event I noticed being displayed today after a long period with "No reminders".

Events in the next 3 months

I thought it could be a bug in a minor version and will get sorted out and updated monica today to 3.2.0 but the problem still exists. Although my dashboard looks like the screenshot above, I know for a fact there are several of my contacts with birthdays and events in the next few months. In the example contacts below, I can see the reminders being listed when I search & open the individual contacts.

Contacts with events in next few months

Troubleshooting: running php artisan monica:test-email works. I have the reminders configured via supervisord and they used to work fine before the end of June.

What can I do to investigate what went wrong with my database / monica instance. It has been frustrating missing important dates.

Information: Running Monica v 3.2.0 with this docker-compose and Dockerfile.

version: "3.4"

services:
  app:
    build: ./app
    image: monica-app
    depends_on:
      - mysql
    env_file: .env
    ports:
      - 82:80
    volumes:
      - /srv/monicahq/monica:/var/www/html/storage
    restart: always

  mysql:
    image: mysql:5.7
    container_name: monicahq-mysql
    ports:
        - 3306:3306
    environment:
      - MYSQL_RANDOM_ROOT_PASSWORD=true
      - MYSQL_DATABASE=monica
      - MYSQL_USER=homestead
      - MYSQL_PASSWORD=SuperSecretPassword
    volumes:
      - /srv/monicahq/mysql:/var/lib/mysql
    restart: always% 
# contents of DOCKERFILE
FROM monica:apache

# Use the default production configuration
RUN mv "$PHP_INI_DIR/php.ini-production" "$PHP_INI_DIR/php.ini"

# supervisord dependencies
RUN set -ex; \
    \
    apt-get update; \
    apt-get install -y --no-install-recommends \
        supervisor \
    ; \
    rm -rf /var/lib/apt/lists/*

COPY supervisord.conf /etc/supervisord.conf

CMD ["supervisord", "-c", "/etc/supervisord.conf"]
meijbaard commented 3 years ago

Did you do an upgrade or a fresh install? Is the users ID equal to the user ID with the reminders in the table?

dchakro commented 3 years ago

Did you do an upgrade or a fresh install? Is the users ID equal to the user ID with the reminders in the table?

I actually tried both. But got the same results... Here's a snapshot of the reminders table. The user#3 should be my user as there is no other user registered on the instance.

Screen Shot 2021-09-12 at 8 54 50 p m

The highlighted reminder is the only reminder that is displayed to me.

hppyworld commented 2 years ago

I have also same issue, when I create new event with option "Add a yearly reminder for this event" selected, still I do not see any yearly reminder for this event. Please fix this. thanks

yendor commented 2 years ago

I was able to fix this on a person by person basis by editing the person, removing the annual reminder and saving then adding the annual reminder again and saving again.

At this point the reminder shows for me in the events in the next 3 months section on the dashboard.

I suspect it may be a missing step / issue during person creation.

abinadi commented 1 year ago

I have the same issue and I'm on version 4.0.0