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

Unable to run migrations to install plugin #5

Closed
stuible opened this issue Jan 24, 2023 · 7 comments
Closed

Unable to run migrations to install plugin #5

stuible opened this issue Jan 24, 2023 · 7 comments

Comments

@stuible
Copy link

stuible commented Jan 24, 2023

In development I was able to this plugin but upon deploying to docker, the migrations seem unable to run when applying the configuration changes

Installing plugin "craft-hcaptcha" ... error: An error occurred while executing the "c10d\crafthcaptcha\migrations\Install migration: SQLSTATE[42883]: Undefined function: 7 ERROR:  function requesturl(integer) does not exist at character 82
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
The SQL being executed was: CREATE INDEX "idx_qpblxowlcijjgpzryizxuskayczhpvwffswp" ON "crafthcaptcha_logs" (requestUrl(40))
Aborting config apply process

Installing from scratch does not seem to trigger this error. Anything I can try to debug this issue?

@c10d-dev
Copy link
Owner

Hello,
This seems weird.
What is your Craft version and your database type (mysql, pgsql,...) and the database version ?
Thanks

@stuible
Copy link
Author

stuible commented Jan 25, 2023

I am running:
PostgreSQL v13.9
Craft CMS v4.3.6.1

@stuible
Copy link
Author

stuible commented Feb 10, 2023

Is there any other info I can provide that could help resolve this?

@c10d-dev
Copy link
Owner

Sorry for the delay, I don't have much time to look into this.

But I think I may have a solution, so I'll let you know!

@stuible
Copy link
Author

stuible commented Feb 10, 2023

Absolutely no problem, I appreciate the plugin and all the time you've put into developing it. Let me know if there's anything you want me to test!

@c10d-dev
Copy link
Owner

Thank you!

Could you try with the new v2.0.2 I just released?

Thanks again, let me know if it fixed the bug for you!

@stuible
Copy link
Author

stuible commented Feb 13, 2023

That fixed it!

Thanks a bunch :)

@stuible stuible closed this as completed Feb 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants