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

Latest Plugins Page Displays an Error #13

Closed
Ryonez opened this issue Jun 29, 2019 · 8 comments · Fixed by kanboard/website#170
Closed

Latest Plugins Page Displays an Error #13

Ryonez opened this issue Jun 29, 2019 · 8 comments · Fixed by kanboard/website#170

Comments

@Ryonez
Copy link

Ryonez commented Jun 29, 2019

When clicking the link added by this extension called 'Latest Plugins" I get the following back:

Internal Error: SQL Error: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "plugin_dates" does not exist LINE 1: INSERT INTO "plugin_dates" ("name", "date_creation") VALUES ... ^

I don't know if this plugin uses it's own database file, but Kanban's database is postgres for me.

@creecros
Copy link
Collaborator

Postgres. Sadface. I'll have to retest. Dont generally have a postgres container laying around.

@creecros
Copy link
Collaborator

creecros commented Jul 1, 2019

@Ryonez
Copy link
Author

Ryonez commented Jul 1, 2019

The plugin version still shows 1.4.2, and the error is still the same when using the release download.

@creecros
Copy link
Collaborator

creecros commented Jul 1, 2019

I just double checked install file, and tested. Everything works.

Please confirm you are using the latest install file: https://github.com/kenlog/UpdateNotifier/releases/download/v1.4.3/UpdateNotifier-1.4.3.zip

Make sure you restart your server in order for the DB migration to take effect.

Working test site with latest plugin installed, running KB 1.2.10 and Postgres:
https://projects.nachostudio.ml

user: admin
pw: admin

Configuration
Application version: v1.2.10
PHP version: 7.3.6
PHP SAPI: fpm-fcgi
HTTP Client: cURL
OS version: Linux 4.9.45-rancher
Database driver: postgres
Database version: 11.4 (Debian 11.4-1.pgdg90+1)
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36

@Ryonez
Copy link
Author

Ryonez commented Jul 1, 2019

Alright, restarting the docker is what did the trick. Not sure how it loaded the old deleted files, but hey.

Thank you for your time and help Creecros.

@creecros
Copy link
Collaborator

creecros commented Jul 1, 2019

The docker container is set to cache php files. You have to restart for changes to code, or update the php.ini to not cache php files.

@Ryonez
Copy link
Author

Ryonez commented Jul 1, 2019

Interesting. I would have though seeing as it removes plugins when deleted, and adds them when it detects it, that is was more dynamic. I'll have to keep that in mind for the future.

@creecros
Copy link
Collaborator

creecros commented Jul 1, 2019

If you wanted to change that, go to
etc/php7/conf.d/local.ini

Set the below to "on"
opcache.validate_timestamps = On

And add this line
opcache.revalidate_freq = 0

Restart container. Now, all changes to php code will be immediate and not require restarts.

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

Successfully merging a pull request may close this issue.

2 participants