Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Something went wrong Server error: Error 1390: Prepared statement contains too many placeholders at (myFaceGroups) #877

Open
muyd opened this issue Aug 16, 2023 · 1 comment
Labels
bug Something isn't working needs information Needs more information in order to fix pending response A issue or PR which is waiting for clarifications from OP

Comments

@muyd
Copy link

muyd commented Aug 16, 2023

Describe the bug

url http://ip:port/albums

Something went wrong
Server error: Error 1390: Prepared statement contains too many placeholders at (myFaceGroups)

url http://ip:port/people

Something went wrong
Server error: Error 1390: Prepared statement contains too many placeholders at (myAlbums)

select count() from albums; --116534
SELECT count(
) FROM user_albums; --116534

Your environment:
Feel free to remove and add what you think might be useful.

  • Are you using Docker? [yes]
  • Database [5.5.5-10.3.7-MariaDB]
  • Browser [chrome]
  • Version [2.3.9 (72cb02d)]

Additional context
Add any other context about the problem here.

@muyd muyd added the bug Something isn't working label Aug 16, 2023
@kkovaletp
Copy link
Contributor

@muyd, Can you please describe your setup in detail? You have 116 534 albums. What is inside: only pictures, only videos, a mix of both? How flat is the album's hierarchy: how deep is the deepest folder? How many faces do you have? Did you merge them or didn't touch at all?
Do you still see this issue or managed to fix it? How?
Is there something else to help us understand and reproduce it?

@kkovaletp kkovaletp added needs information Needs more information in order to fix pending response A issue or PR which is waiting for clarifications from OP labels Apr 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working needs information Needs more information in order to fix pending response A issue or PR which is waiting for clarifications from OP
Projects
None yet
Development

No branches or pull requests

2 participants