search

alkem-io / alkemio

START HERE! Cross project collaboration and shared documentation.
European Union Public License 1.2
23 stars 4 forks source link

BUG: SQL error #1368

Closed larssondenise closed 3 days ago

larssondenise commented 6 days ago

Describe the bug "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND activity.type IN ('callout-published','post-created','post-comment','callo' at line 2"

When opening the dashboard page

mentioned by Denise

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Smartphone (please complete the following information):

Additional context Add any other context about the problem here.

Comoque1 commented 6 days ago

The issue is reproducible also when:

  1. clean db
  2. run migrations
  3. start service
  4. register user
  5. Navigate to My dashboard page: "message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND activity.type IN ('callout-published','post-created','post-comment','callo' at line 2", image.png
me-andre commented 3 days ago

The issue is (was) reproducible only for a fresh user who's not a member of anything yet. Please mention crucial preconditions in the story as that can greatly reduce the time needed to create a fix.