Hey all,
I am Smita, 1st Year postgraduate student at IIIT, Hyderabad. I am looking
forward to participate in GSOC 2014, and thought of contributing to
PhpMyAdmin. I have set up the system and was going through the codebase and
the buglist. I know its little early but As currently I have my winter
vacation, its good time for me to understand the codebase the system.
I was able to reproduce the bug #3909[0] and I think I am able to find the
reason for the same, the problem is, we are saving the order by preference
in the pma db as tablname.column_name and when we query again on same db
and the table, it append the saved order by preference tablname.column_name
but when using alias it doesn't find tablname.column_name instead it needs
either alias.column_name or just order by column_name. so for fixing it,
either we can check if the query is using aliasing and if yes then while
appending replace the table_name with alias_name in saved preference or
while appending the order by just append the column_name from saved
preference instead of appending tablname.column_name, I have used latter
one to fix it and working fine on my local system. I'm not getting any test
case where it may fail. Please suggest if it would be fine.
Also, while fixing this bug, i got another bug that is, if instead of
ordering on a column using UI we make a query having order by caluse
tablname.coloname or just column_name without backquoting. it doesn't
retain the preference , actually it saves and delete next time as it
doesn't matches with backquoted tablename.colum_name. I have also fixed
this issue, by matching the saved preference with unquoted column names
from the given table.
I think all I have written is not very clear, so I have already sent a
pull request, here is the Url
https://github.com/phpmyadmin/phpmyadmin/pull/784
Waiting for your feedback!!
[0]http://sourceforge.net/p/phpmyadmin/bugs/3903/
Thanks and Regards
- Smita Kumari
Welcome to phpMyAdmin 4.1.0.
This release contains many improvements and bug fixes. With this release
the minimum supported PHP version is now 5.3 and the minimum MySQL
version is 5.5.
A few highlights include:
*Allow specifying a port when connecting to the controlhost
*User interface improvements to server privileges, view creation, the
Operations tab, Relation View, and when creating new users
*Added support for AES_ENCRYPT on BLOB columns
*Added support for relations with ndbcluser
*Added optional ReCAPTCHA support during login
*Added support for fractional seconds in time, datetime, and timestamp
columns
*Added find and replace by column
*Added the Error Reporting Component, an optional feature allowing
users to report certain errors directly to the phpMyAdmin bug team
*Added configurable menus (so an administrator can hide certain
features)
The SQP and MySQLManual* configuration directives have been removed.
For complete information, please view changelog.php or the ChangeLog
file, included with this release.
Details will appear on http://phpmyadmin.net. In a hurry? you can visit
https://sourceforge.net/projects/phpmyadmin/files to download.
The phpMyAdmin team
Hi Rouslan,
I'm trying to debug a case where clicking on SQL does not bring the SQL
panel. Firebug shows me that the call to db_sql.php returns a null value
in message.
I found how to trigger this behavior: having a public bookmark whose
label contains a character like "é". This server runs PHP 5.3.25.
I think it happens because json_encode() is not happy with the content.
I have read on http://php.net/json_encode that this function expects
string data to be UTF-8 encoded.
I have tried to use utf8_encode() on the results of $this->_getDisplay()
before assigning it to $this->_JSON['message'] but it produces mangled
HTML on my SQL page.
Any hint?
--
Marc Delisle
http://infomarc.info | http://phpmyadmin.net
> From: mynetx(a)live.de
> To: phpmyadmin-devel(a)lists.sourceforge.net
> Subject: RE: [Phpmyadmin-devel] Testing and documenting browser support
> Date: Sun, 8 Dec 2013 20:07:11 +0100
>
>> Date: Sun, 24 Nov 2013 07:12:02 -0500
>> From: marc(a)infomarc.info
>> To: phpmyadmin-devel(a)lists.sourceforge.net
>> Subject: Re: [Phpmyadmin-devel] Testing and documenting browser support
>>
>> Le 2013-11-23 12:28, J.M. . a écrit :
>>> Hello there,
>>>
>>> I suggest we maintain a list of browsers that phpMyAdmin gets tested with and for which we are willing to accept and fix interface bugs.
>>> This list should include browser names and their versions. Since we have access to BrowserStack, I suggest we support the latest 3 versions of all major browsers.
>>>
>>> At the moment, these are:
>>>
>>> - Internet Explorer 8, 9, 10, 11 (sic: IE8 is the latest version that XP users may use)
>>> - Mozilla Firefox 24, 25, 26
>>> - Google Chrome 29, 30, 31
>>> - Opera 12, 15, 18
>>> - Apple Safari 5, 6, 7
>>>
>>> Questions:
>>>
>>> - Is anyone willing to test the interface in these browsers?
>>> - Where is (are) the best place(s) to document this?
>>> - Which role do Selemium tests and planned mobile support play?
>>>
>>> Please share your opinion.
>>
>> And just to add a question:
>>
>> - If this testing happens, on which platform(s) should it be done?
>>
>>
>> --
>> Marc Delisle
>> http://infomarc.info | http://phpmyadmin.net
>
>
Added to meeting agenda.
@all: Please think about this item before the meeting, too.
- JM
Hi devs,
Now that we are near the 4.1.0 release, I have started the MAINT_4_1_0
branch and switched QA_4_1 to 4.1.1-dev.
MAINT_4_1_0 is currently identical to the rc3. I suggest we first
discuss on this list, before merging anything to MAINT_4_1_0.
Normal bug fixes may go to QA_4_1 for 4.1.1.
--
Marc Delisle
http://infomarc.info | http://phpmyadmin.net
Hello all,
I am trying to fix the bug
https://sourceforge.net/p/phpmyadmin/bugs/4154/. I have few
observations regarding this:
if you do
SELECT * FROM `sortunion1`UNIONSELECT * FROM `sortunion2`
what I think is that when you are trying to query the above one it
transforms it into query as follows
SELECT * FROM `sortunion1`
UNION
SELECT * FROM `sortunion2` ORDER BY `sortunion2`.`id` DESC
LIMIT 0, 25
but instead if it transforms the same query as
SELECT * FROM `sortunion1`
UNION
(SELECT * FROM `sortunion2` ORDER BY `sortunion2`.`id` DESC )
LIMIT 0, 25
Then there won't be any issue.
Please tell me whether my understanding is correct or not. If yes,then
I would like to take up the bug, else please suggest if there is any
mistake in my approach.
Thanks,
Lakshit Arora
Welcome to the third release candidate for phpMyAdmin 4.1.0.
This release contains many improvements and bug fixes. With this release
the minimum supported PHP version is now 5.3 and the minimum MySQL
version is 5.5.
A few highlights include:
*Allow specifying a port when connecting to the controlhost
*User interface improvements to server privileges, view creation, the
Operations tab, Relation View, and when creating new users
*Added support for AES_ENCRYPT on BLOB columns
*Added support for relations with ndbcluser
*Added optional ReCAPTCHA support during login
*Added support for fractional seconds in time, datetime, and timestamp
columns
*Added find and replace by column
*Added the Error Reporting Component, an optional feature allowing
users to report certain errors directly to the phpMyAdmin bug team
*Added configurable menus (so an administrator can hide certain
features)
The SQP and MySQLManual* configuration directives have been removed.
For complete information, please view changelog.php or the ChangeLog
file, included with this release.
Details will appear on http://phpmyadmin.net. In a hurry? you can visit
https://sourceforge.net/projects/phpmyadmin/files to download.
The phpMyAdmin team