The menu does not display properly after logging in. Console error "Uncaught SyntaxError: Unexpected token u in JSON at position 0" appears. #17465

A-Wat · 2022-03-31T06:42:24Z

Describe the bug

I downloaded the source files for phpMyAdmin version 5.1.3 from the official site.
Using that source file, I installed phpMyAdmin on my server.

I can log in correctly, but the menu does not display correctly on the page after logging in.

like this...

However, the moment the page is displayed, the list of databases is displayed for a moment and then disappears immediately.

I found the following issue and tried it but the condition did not improve.
#17426

To Reproduce

Steps to reproduce the behavior:

Go to http://localhost/phpMyAdmin/
Log in to phpMyAdmin
Display the phpMyAdmin top page
See error

Expected behavior

Displays a list of databases in the connected database server.

Screenshots

Console error

DevTools LocalStorage

DevTools Network

The description "index.php?route=/error-report" indicates that an error has occurred.

Server configuration

Operating system:MiracleLinux8.3
Web server:Nginx1.20.1
Database version:5.5.57-log - MySQL Community Server (GPL)
PHP version:php8.0.12
phpMyAdmin version:5.1.3

Client configuration

Browser:GoogleChrome 87.0.4280.88、GoogleChrome 56.0.2924.87
Operating system:Windows10

Additional context

#17426
I have tried re-uploading new source files with this issue as a reference, but no improvement.

We tried all possible measures, but to no avail.
I would like to know if you have any similar problems or information that might be relevant.

williamdes · 2022-03-31T09:58:17Z

Hi
Could you try to see what the URL outputs instead of json contents?
It may be a server misconfiguration

ghost · 2022-04-01T13:10:37Z

This appears to be identical to the problems I have, which I asked about on Stack Overflow yesterday. https://stackoverflow.com/questions/71697154/phpmyadmin-databases-appear-fleetingly-then-disappear

matthieumarrast · 2022-04-11T21:20:07Z

Same error for me.

Version : 5.1.3deb1+focal2
PHP 8.1.4
Ubuntu 20.04

A-Wat · 2022-04-12T01:33:17Z

Thank you.
I have been trying to find out what I can hint at myself.

I tried these.

Installed and checked phpMyAdmin 4.9.10.
Installed and checked phpMyAdmin 5.2.0-rc1.

As a result, the following PHP error was returned.

Installed and checked phpMyAdmin 4.9.10.

thrown in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/UserPreferences.php on line 177" while reading response header from upstream, client: client-ip, server: server-host, request: "POST /phpMyAdmin/error_report.php HTTP/1.1", upstream: "fastcgi://unix:/var/opt/remi/php80/run/php-fpm/www.sock:", host: "server-ip"
2022/04/04 13:38:09 [error] 18096#18096: *545377 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught TypeError: PhpMyAdmin\UserPreferences::apply(): Argument #1 ($config_data) must be of type array, null given, called in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/Config.php on line 939 and defined in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/UserPreferences.php:177
Stack trace:
#0 /usr/share/nginx/dev/phpMyAdmin/libraries/classes/Config.php(939): PhpMyAdmin\UserPreferences->apply()
#1 /usr/share/nginx/dev/phpMyAdmin/libraries/common.inc.php(459): PhpMyAdmin\Config->loadUserPreferences()
#2 /usr/share/nginx/dev/phpMyAdmin/db_structure.php(14): require_once('...')
#3 {main}
thrown in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/UserPreferences.php on line 177" while reading response header from upstream, client: client-ip, server: server-host, request: "GET /phpMyAdmin/db_structure.php?server=1&db=convert_utf8&ajax_request=true&ajax_page_request=true&_nocache=1649047088978295963&token=4a4c6e3e455c464a395b3c5a776a5752 HTTP/1.1", upstream: "fastcgi://unix:/var/opt/remi/php80/run/php-fpm/www.sock:", host: "server-ip"

Installed and checked phpMyAdmin 5.2.0-rc1.

2022/04/04 10:40:57 [error] 24035#24035: *482829 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught TypeError: PhpMyAdmin\UserPreferences::apply(): Argument #1 ($config_data) must be of type array, null given, called in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/Config.php on line 450 and defined in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/UserPreferences.php:187
Stack trace:
#0 /usr/share/nginx/dev/phpMyAdmin/libraries/classes/Config.php(450): PhpMyAdmin\UserPreferences->apply()
#1 /usr/share/nginx/dev/phpMyAdmin/libraries/classes/Common.php(286): PhpMyAdmin\Config->loadUserPreferences()
#2 /usr/share/nginx/dev/phpMyAdmin/index.php(40): PhpMyAdmin\Common::run()
#3 {main}
thrown in /usr/share/nginx/dev/phpMyAdmin/libraries/classes/UserPreferences.php on line 187" while reading response header from upstream, client: client-ip, server: server-host, request: "GET /cck/phpMyAdmin/index.php?route=/&route=%2F HTTP/1.0", upstream: "fastcgi://unix:/var/opt/remi/php80/run/php-fpm/www.sock:", host: "server-ip"

IP addresses and other information are hidden for business reasons.

I identified the relevant source file from this error statement.
I thought that the value of SESSION was incorrect and $config_data was null.

Maybe there is a mistake in my server settings.

However, I don't have any idea of a setting that might be affected, so if you know of any, I would like to get some ideas.

williamdes · 2022-04-16T10:59:07Z

Hi @A-Wat
Reading the code I would need to have the data from:

SELECT `config_data` FROM `pma__userconfig`

Can you send the query answer here ?
See:

phpmyadmin/libraries/classes/UserPreferences.php

Line 102 in ddf0d96

'config_data' => $row ? json_decode($row['config_data'], true) : [],

A-Wat · 2022-04-18T04:36:57Z

Hello, @williamdes

I have tried running the query.
SELECT `config_data` FROM `pma__userconfig`

The following values were returned as a result.

array(1) { ["config_data"]=> string(13) "{"lang":"ja"}" }

Can you see what is happening?

JoelLisenby · 2022-04-22T01:54:13Z

I am seeing this occur as well after upgrading from Ubuntu 18.04 to 20.04 and also upgrading PHP from 7 to 8.1

jquery-migrate.js?v=5.1.3deb1%2Bfocal2:69 JQMIGRATE: Migrate is installed with logging active, version 3.3.2
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100 JQMIGRATE: jQuery.expr[':'] is deprecated; use jQuery.expr.pseudos
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100
get @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:113
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102 console.trace
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102
get @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:113
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100 JQMIGRATE: jQuery.expr.filters is deprecated; use jQuery.expr.pseudos
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100
get @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:113
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:2
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:2
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102 console.trace
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102
get @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:113
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:2
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:2
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100 JQMIGRATE: jQuery.isArray is deprecated; use Array.isArray
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100
obj.<computed> @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:125
$.widget @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:3
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102 console.trace
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102
obj.<computed> @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:125
$.widget @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:3
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100 JQMIGRATE: jQuery.isFunction() is deprecated
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:100
obj.<computed> @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:125
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
each @ jquery.min.js?v=5.1.3deb1%2Bfocal2:1
$.widget @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:3
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102 console.trace
migrateWarn @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:102
obj.<computed> @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:125
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
each @ jquery.min.js?v=5.1.3deb1%2Bfocal2:1
$.widget @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:3
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
(anonymous) @ jquery-ui.min.js?v=5.1.3deb1%2Bfocal2:1
VM132:1 Uncaught SyntaxError: Unexpected token u in JSON at position 0
    at JSON.parse (<anonymous>)
    at Object.success (functions.js?v=5.1.3deb1%2Bfocal2:5430:30)
    at fire (jquery.min.js?v=5.1.3deb1%2Bfocal2:2:12157)
    at Object.fireWith [as resolveWith] (jquery.min.js?v=5.1.3deb1%2Bfocal2:2:13328)
    at done (jquery.min.js?v=5.1.3deb1%2Bfocal2:4:27808)
    at XMLHttpRequest.<anonymous> (jquery.min.js?v=5.1.3deb1%2Bfocal2:4:31149)
success @ functions.js?v=5.1.3deb1%2Bfocal2:5430
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fireWith @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
done @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
(anonymous) @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
load (async)
send @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
ajax @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
jQuery.ajax @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:305
Functions.configGet @ functions.js?v=5.1.3deb1%2Bfocal2:5410
treeInit @ navigation.js?v=5.1.3deb1%2Bfocal2:1368
Navigation.ResizeHandler @ navigation.js?v=5.1.3deb1%2Bfocal2:1371
(anonymous) @ navigation.js?v=5.1.3deb1%2Bfocal2:289
mightThrow @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
process @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
setTimeout (async)
(anonymous) @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fireWith @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fireWith @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
ready @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
completed @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
VM133:1 Uncaught SyntaxError: Unexpected token u in JSON at position 0
    at JSON.parse (<anonymous>)
    at Object.success (functions.js?v=5.1.3deb1%2Bfocal2:5430:30)
    at fire (jquery.min.js?v=5.1.3deb1%2Bfocal2:2:12157)
    at Object.fireWith [as resolveWith] (jquery.min.js?v=5.1.3deb1%2Bfocal2:2:13328)
    at done (jquery.min.js?v=5.1.3deb1%2Bfocal2:4:27808)
    at XMLHttpRequest.<anonymous> (jquery.min.js?v=5.1.3deb1%2Bfocal2:4:31149)
success @ functions.js?v=5.1.3deb1%2Bfocal2:5430
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fireWith @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
done @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
(anonymous) @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
load (async)
send @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
ajax @ jquery.min.js?v=5.1.3deb1%2Bfocal2:4
jQuery.ajax @ jquery-migrate.js?v=5.1.3deb1%2Bfocal2:305
Functions.configGet @ functions.js?v=5.1.3deb1%2Bfocal2:5410
initialize @ console.js?v=5.1.3deb1%2Bfocal2:77
(anonymous) @ console.js?v=5.1.3deb1%2Bfocal2:1576
mightThrow @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
process @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
setTimeout (async)
(anonymous) @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fireWith @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fire @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
fireWith @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
ready @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2
completed @ jquery.min.js?v=5.1.3deb1%2Bfocal2:2

Related to phpmyadmin#17465. Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>

HazNet · 2022-05-10T19:11:01Z

sudo sed -i -e 's/newInstanceArgs($arguments)/newInstanceArgs(array_values($arguments))/g' /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php && cat /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php | grep "newInstanceArgs"

run this in terminal if you get "become following error: Fatal error: Uncaught Error: Unknown named parameter $$response in /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php:1140 Stack trace: #0"

williamdes · 2022-05-10T20:31:26Z

sudo sed -i -e 's/newInstanceArgs($arguments)/newInstanceArgs(array_values($arguments))/g' /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php && cat /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php | grep "newInstanceArgs"

run this in terminal if you get "become following error: Fatal error: Uncaught Error: Unknown named parameter $$response in /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php:1140 Stack trace: #0"

This is #16301 and #16968

A-Wat · 2022-07-05T08:00:42Z

Thank you very much.
I can confirm that the problem I was facing can be resolved by installing version 5.2.0!

williamdes added the Bug A problem or regression with an existing feature label Apr 11, 2022

williamdes added this to the 5.1.4 milestone Apr 11, 2022

williamdes mentioned this issue Apr 22, 2022

Fixed the errors coming up #17490

Closed

6 tasks

MauricioFauth added a commit to MauricioFauth/phpmyadmin that referenced this issue Apr 24, 2022

Improve type check for UserPreferences::load method

449d922

Related to phpmyadmin#17465. Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>

ibennetch modified the milestones: 5.1.4, 5.2.1 May 11, 2022

A-Wat closed this as completed Jul 5, 2022

williamdes self-assigned this Jul 5, 2022

williamdes modified the milestones: 5.2.1, 5.2.0 Jul 5, 2022

github-actions bot locked as resolved and limited conversation to collaborators Jul 6, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

The menu does not display properly after logging in. Console error "Uncaught SyntaxError: Unexpected token u in JSON at position 0" appears. #17465

The menu does not display properly after logging in. Console error "Uncaught SyntaxError: Unexpected token u in JSON at position 0" appears. #17465

A-Wat commented Mar 31, 2022

williamdes commented Mar 31, 2022

ghost commented Apr 1, 2022

matthieumarrast commented Apr 11, 2022 •

edited

A-Wat commented Apr 12, 2022

williamdes commented Apr 16, 2022

A-Wat commented Apr 18, 2022

JoelLisenby commented Apr 22, 2022 •

edited

HazNet commented May 10, 2022

williamdes commented May 10, 2022

A-Wat commented Jul 5, 2022

The menu does not display properly after logging in. Console error "Uncaught SyntaxError: Unexpected token u in JSON at position 0" appears. #17465

The menu does not display properly after logging in. Console error "Uncaught SyntaxError: Unexpected token u in JSON at position 0" appears. #17465

Comments

A-Wat commented Mar 31, 2022

Describe the bug

To Reproduce

Expected behavior

Screenshots

Server configuration

Client configuration

Additional context

williamdes commented Mar 31, 2022

ghost commented Apr 1, 2022

matthieumarrast commented Apr 11, 2022 • edited

A-Wat commented Apr 12, 2022

williamdes commented Apr 16, 2022

A-Wat commented Apr 18, 2022

JoelLisenby commented Apr 22, 2022 • edited

HazNet commented May 10, 2022

williamdes commented May 10, 2022

A-Wat commented Jul 5, 2022

matthieumarrast commented Apr 11, 2022 •

edited

JoelLisenby commented Apr 22, 2022 •

edited