phpMyAdmin 4.3.1

unihostbrasil · Dec 8, 2014

4.3.1.0 (2014-12-08)
- bug #4609 'Show all' checkbox label is not clickable
- bug #4610 JS error reporting: Hash fragment is reset
- bug Undefined index menuswork
- bug #4614 Separator between "Show All" and "Number of rows" disappears
- bug #4615 SQL highlighting in process list breaks on auto refresh
- bug #4616 Warning in db structure print view page
- bug Undefined index navwork, savedsearcheswork, fields
- bug #4620 Undefined index while adding to the central columns list
- bug #4618 Page scrolls while GIS visualization is zoomed in/out with mousewheel
- bug #4613 HHVM: method 'ob_gzhandler' not found
- bug #4593 Manual "SELECT" doesn't change active table
- bug #4623 Incomplete PHP OpenSSL support
- bug #4626 Ctrl + click on a column not in sort triggers a server call to erron
eous url
- bug #4625 "Insufficient space to save the file" on export SQL to file on server
- bug #4627 "file_get_contents(examples/create_tables.sql): failed to open stream" after update
- bug #4617 UI issues with sortable tables
- bug #4619 SELECT LENGTH(`field`) FROM `table` does not sort

Derevko · Dec 9, 2014

Updating from 4.2.X I got a lot of errors:

Notice in ./libraries/Util.class.php#1916

Undefined index: query

Backtrace

Code:

[COLOR=#000000][FONT=sans-serif]./libraries/Util.class.php#1821: PMA_Util::splitURLQuery(string '#')[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./libraries/Util.class.php#1277: PMA_Util::linkOrButton([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '#',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'Inline',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]array,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./libraries/DisplayResults.class.php#4552: PMA_Util::getMessage([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'SELECT * FROM `other`',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'success',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./libraries/sql.lib.php#1963: PMA_DisplayResults->getTable([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'urdr111111',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]array,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./libraries/sql.lib.php#2220: PMA_getHtmlForSqlQueryResultsTable([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'allmytv_lc',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string './themes/pmahomme/img/',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'urdr111101',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string ' LIMIT 0, 25 ',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]boolean true,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '1434',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]integer 25,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]array,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./libraries/sql.lib.php#2321: PMA_sendQueryResponseForResultsReturned([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]array,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'allmytv_lc',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'other',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string './themes/pmahomme/img/',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string ' LIMIT 0, 25 ',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '1434',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]integer 25,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'SELECT * FROM `other` LIMIT 0, 25 ',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'SELECT * FROM `other`',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./libraries/sql.lib.php#2432: PMA_sendQueryResponse([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]integer 25,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '1434',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]boolean false,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'allmytv_lc',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'other',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]array,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]object,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string './themes/pmahomme/img/',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string ' LIMIT 0, 25 ',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'SELECT * FROM `other` LIMIT 0, 25 ',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'SELECT * FROM `other`',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]./sql.php#204: PMA_executeQueryAndSendQueryResponse([/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]array,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]boolean true,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'allmytv_lc',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'other',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]boolean false,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string '',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string './themes/pmahomme/img/',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]string 'SELECT * FROM `other`',[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif]NULL,[/FONT][/COLOR]
[COLOR=#000000][FONT=sans-serif])[/FONT][/COLOR]

Vaporizer · Dec 9, 2014

I have the same problem as Derevko on a clean 4.3.1 install on CentOS 7 running PHP-fpm, Nginx/Apache 2.4 and MariaDB 5.5.4.

Another thing I noticed is that the script for configuring the configuration storage (http://help.directadmin.com/item.php?id=564) needs an update for the latest phpMyAdmin.
The line:

Code:

for v in controlhost controluser controlpass pmadb bookmarktable relation table_info table_coords pdf_pages column_info history table_uiprefs tracking designer_coords userconfig recent users usergroups navigationhiding savedsearches; do

Must be replaced with:

Code:

for v in controlhost controluser controlpass pmadb bookmarktable relation table_info table_coords pdf_pages column_info history table_uiprefs tracking userconfig recent favorite users usergroups navigationhiding savedsearches central_columns; do

Derevko · Dec 10, 2014

Fixed with this https://github.com/phpmyadmin/phpmy...08e934f51b6a6e58a76ecd761db3f0b1?diff=unified

DirectAdmin Support · Dec 10, 2014

@Vaporizer: Thanks, I've updated the script, but left designer_coords, in case an old PMA is used (won't hurt the new PMA)
@Derevko: Hmm.. I would assume they'll release an update, if it's a common issue... if not, we'll have to patch the tar.gz on our end.

John

Derevko · Dec 10, 2014

DirectAdmin Support said:
@Derevko: Hmm.. I would assume they'll release an update, if it's a common issue... if not, we'll have to patch the tar.gz on our end.

Sure, probably in 4.3.2

zEitEr · Dec 11, 2014

phpMyAdmin 4.3.1 seems to have a bug, when we try to import MySQL dump, it drops an error:

Code:

/*!40101 SET character_set_client = @saved_cs_client */;

#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

For testing purposes we had to downgrade to 4.2.13.1 and imports went fine.

Does anybody else have the issue?

phpMyAdmin 4.3.1

unihostbrasil

Verified User

Derevko

Verified User

Vaporizer

Verified User

Derevko

Verified User

DirectAdmin Support

Administrator

Derevko

Verified User

zEitEr

Super Moderator