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 create a view from tree view button #17944

Closed
joomlahenk opened this issue Dec 2, 2022 · 11 comments
Closed

Unable to create a view from tree view button #17944

joomlahenk opened this issue Dec 2, 2022 · 11 comments
Assignees
Labels
Bug A problem or regression with an existing feature
Milestone

Comments

@joomlahenk
Copy link

Describe the bug

Maybe a bug or just a question how to solve:
Unable to create a view. I get no error or any other message. The loading... is displayed for 0.5 sec

To Reproduce

Steps to reproduce the behavior:

  1. Collapse views
  2. Click on new

Expected behavior

The box for creating a view is displayed

Server configuration

I use the Official phpMyAdmin Docker image, running on a Synology system for a local site.

Database server:
Server: MariaDB Docker (192.168.178.23 via TCP/IP)
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.10.2-MariaDB-1:10.10.2+maria~ubu2204 - mariadb.org binary distribution
Protocol version: 10
User: root@172.17.0.1
Server charset: cp1252 West European (latin1)

Webserver:
Apache/2.4.53 (Debian)
Database client version: libmysql - mysqlnd 8.0.19
PHP extension: mysqli Documentation curl Documentation mbstring Documentation
PHP version: 8.0.19

phpMyAdmin version: 5.2.0

Client configuration

  • Browser: Chrome
  • Operating system: Windows 10

Additional context

I created many views in the past, but now I am unable to create one.
If I press view->new I get no error or any other message. Only loading... is displayed for 0.5 sec and then nothing happens.
It happens with all databases and mysql and mariadb servers. The databases are working well.
It looks like there is a limit or cache issue, but I could not find.

@williamdes williamdes self-assigned this Dec 2, 2022
@williamdes williamdes added Bug A problem or regression with an existing feature duplicate labels Dec 2, 2022
@williamdes williamdes added this to the 5.2.1 milestone Dec 2, 2022
@williamdes
Copy link
Member

Duplicate of #17390

@williamdes williamdes marked this as a duplicate of #17390 Dec 2, 2022
@williamdes
Copy link
Member

Can you try the latest 5.2 version in development (phpMyAdmin 5.2+snapshot) also available as a non official docker image?

It should be fixed now

@joomlahenk
Copy link
Author

Tried the latest 5.2 version in development (phpMyAdmin 5.2+snapshot). There are two versions in that image. The 5.2 snapshot gives the same issue, the 5.3 snapshot gives a warning "View name can not be empty". I click to dismiss and then still nothing happens.

@joomlahenk
Copy link
Author

OK. Since this does not work, I changed back to PMA version 5.1.3 and now its working!
Maybe you need to reopen this issue, because it's not fixed.

@williamdes williamdes reopened this Dec 2, 2022
@williamdes
Copy link
Member

Oh, I will check this once more then

@williamdes williamdes added affects/5.2 This issue or pull-request affects 5.2.x releases (and maybe further versions) affects/6.0 This issue or pull-request affects 6.0.x releases (and maybe further versions) confirmed/5.2 This issue is confirmed to be reproduced on 5.2 at the time this label was set confirmed/6.0 This issue is confirmed to be reproduced on 6.0 at the time this label was set and removed duplicate labels Dec 7, 2022
@williamdes
Copy link
Member

I can confirm the bug, I have an idea of what it could be. Given that if you are on a table's result page the button works.

@williamdes williamdes changed the title Unable to create a view. Unable to create a view from tree view button Dec 12, 2022
williamdes added a commit that referenced this issue Dec 12, 2022
Signed-off-by: William Desportes <williamdes@wdes.fr>
@williamdes williamdes removed affects/5.2 This issue or pull-request affects 5.2.x releases (and maybe further versions) affects/6.0 This issue or pull-request affects 6.0.x releases (and maybe further versions) confirmed/5.2 This issue is confirmed to be reproduced on 5.2 at the time this label was set confirmed/6.0 This issue is confirmed to be reproduced on 6.0 at the time this label was set labels Jan 2, 2023
@eagle1978
Copy link

eagle1978 commented Feb 20, 2023

I suffered from the same issue in PhpMyAdmin 5.2
A normal browser refresh on even opening a new window or a new browser (Edge) did not work.
Somehow a hard refresh (Ctrl + Shift + R) did seem to resolve the issue

@williamdes
Copy link
Member

I suffered from the same issue in PhpMyAdmin 5.2 A normal browser refresh on even opening a new window or a new browser (Edge) did not work. Somehome a hard refresh (Ctrl + Shift + R) did seem to resolve the issue

Can you still reproduce this issue reliability in 5.2.1?

@eagle1978
Copy link

Hi @williamdes, sorry I am not in control of the PhpMyAdmin version.
I am able to work around the issue by continuously using hard browser refreshes in version 5.2.0

@williamdes
Copy link
Member

Hi @williamdes, sorry I am not in control of the PhpMyAdmin version. I am able to work around the issue by continuously using hard browser refreshes in version 5.2.0

That's good you found a workaround, can you let me know when you tried 5.2.1?

@eagle1978
Copy link

I will if that is the case. Unfortunately the use of this PhpMyAdmin environment is temporary (3-week assignment)

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Feb 24, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Bug A problem or regression with an existing feature
Projects
None yet
Development

No branches or pull requests

3 participants