[go: nahoru, domu]
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.

Sign up for GitHub

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

Jump to bottom

Error when browsing table #13604

Closed
jormaster3k opened this issue Aug 22, 2017 · 23 comments
Closed

Error when browsing table #13604

jormaster3k opened this issue Aug 22, 2017 · 23 comments
Assignees
@nijel
Labels
Bug A problem or regression with an existing feature
Milestone
4.7.5

Comments

@jormaster3k
Copy link

Steps to reproduce

  1. User logs in to phpMyAdmin
  2. User goes to database TMSPublicSafety
  3. User browses table tf_time_off_request

Expected behaviour

User should be able to view data in tf_time_off_request table

Actual behaviour

User encounters message "Some errors have been detected on the server!"
(See attachment)

Note that this is only happening for one user on the system; I have not been able to reproduce it with other users.

image

image

Server configuration

Operating system: Ubuntu 14.04

Web server:
Apache
Database client version: libmysql - 5.5.55
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 5.5.9-1ubuntu4.21

Database: 5.5.55-0ubuntu0.14.04.1-log - (Ubuntu)

PHP version: 5.6

phpMyAdmin version: 4.72

Client configuration

Browser: Multiple browsers including Google Chrome, Firefox, Edge/IE

Operating system: Microsoft Windows
@ibennetch
Copy link
Member

Is there anything special about the user name or table structure; special characters or MySQL reserved names or anything like that? Since it's limited to one user, I wonder particularly if there's something special about that user account. Could you export the user permission information and post it here (obscuring any sensitive information)? You can do so when logged in as an administrative user (such as root) from the User Privileges tab. Look for the "Export" action link next to the affected user's account.

@ibennetch ibennetch added question Used when we need feedback from the submitter or when the issue is a question about PMA and removed question Used when we need feedback from the submitter or when the issue is a question about PMA labels Aug 26, 2017
@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34687

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34686

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34685

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34684

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34683

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34682

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 1
Link Report#34681

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.6
Incident count 22
Link Report#34535

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.0
Incident count 2
Link Report#33977

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017

What is your setting of lower_case_table_names?

You can get it by following SQL:

SELECT @@lower_case_table_names

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.3
Incident count 10
Link Report#35335

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017

Also might be related to #13152....

@nijel nijel self-assigned this Sep 4, 2017
@nijel nijel added the Bug A problem or regression with an existing feature label Sep 4, 2017
@nijel nijel added this to the 4.7.5 milestone Sep 4, 2017
@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.2
Incident count 2
Link Report#35588

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.3
Incident count 16
Link Report#35333

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.3
Incident count 4
Link Report#35331

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.3
Incident count 4
Link Report#35330

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.0
Incident count 3
Link Report#35317

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.0
Incident count 3
Link Report#35316

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.6.5.2
Incident count 3
Link Report#34689

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Trying to get property of non-object
Exception Type php
phpMyAdmin version 4.7.0
Incident count 8
Link Report#33984

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel
Copy link
Contributor
nijel commented Sep 4, 2017
Param Value
Error Type Notice
Error Message Undefined offset: 3
Exception Type php
phpMyAdmin version 4.7.0
Incident count 131
Link Report#34550

This comment is posted automatically by phpMyAdmin's error-reporting-server.

@nijel nijel mentioned this issue Sep 4, 2017
Closed
nijel added a commit that referenced this issue Sep 4, 2017
@nijel
Remove tested propery
aa75d66 
Originally the code could delete PROP_COLUMN_ORDER when asking for
PROP_COLUMN_VISIB.

Issue #13604

Signed-off-by: Michal Čihař <michal@cihar.com>
nijel added a commit that referenced this issue Sep 4, 2017
@nijel
Share code for getting column params
00485eb 
Issue #13604

Signed-off-by: Michal Čihař <michal@cihar.com>
@nijel nijel closed this as completed in 483324d Sep 4, 2017
@nijel
Copy link
Contributor
nijel commented Sep 4, 2017

I've fixed similar error I've found on our error reporting server. It would be great if you could verify whether that really fixes your problem as well. In case it does not, please provide more details to reproduce this.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 22, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@nijel nijel

Labels
Bug A problem or regression with an existing feature
Projects
None yet
Milestone
4.7.5
Development

No branches or pull requests
3 participants
@nijel @jormaster3k @ibennetch