We are pleased to announce that phpMyAdmin has accepted 6
students/projects as part of Google Summer of Code 2014 [0] :
- Interface Improvements - Ashutosh Dhundhara
- User interface enhancements - Chirayu Chiripal
- php Error Reporting - Dhananjay Nakrani
- SQL Query Console - Edward Cheng
- Structure Tools - Smita Kumari
- Refactoring: Designer/schema integration - Kankanamge Bimal Yashodha
Details about the projects can be found on our wiki [1].
We wish all students good luck and look forward to their contributions
to the project. The students are advised to go through the student
guide at [2].
[0] http://www.google-melange.com/gsoc/projects/list/google/gsoc2014
[1] http://wiki.phpmyadmin.net/pma/GSoC_2014_Projects
[2] http://wiki.phpmyadmin.net/pma/GSoC_2014_Student_Guide
--
Warm Regards
Atul Pratap Singh
GSoC 2014 org co-admin
for the phpMyAdmin project
Hi,
I would like to talk about this ticket:
https://sourceforge.net/p/phpmyadmin/bugs/4070/
The issue is that when you want to limit the number of items (last
level) by page in navigation tree, you can have an issue with the last
group.
Imagine that you set the config to 25 items, you have a first group of 20
DB, and another one of 15 DB. Here, the last group will contain only 5
items and not all the group. But there is no information that there is
other children of this group, so you can believe that you see all the items
of the group.
I think that we better have to filter on the first level, than on the
number of the last level items…
The list of DB could be get by one query:
select s.*
from INFORMATION_SCHEMA.SCHEMATA s,
(
select DB_first_level
from (
SELECT SCHEMA_NAME, SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level
FROM INFORMATION_SCHEMA.SCHEMATA
) t
ORDER BY DB_first_level ASC
LIMIT 1, 3
) t2
where 1 = locate(concat(DB_first_level, '_'), concat(s.SCHEMA_NAME, '_'))
order by s.SCHEMA_NAME;
(Here, I assume that the first level separator is "_" and that we want 3
items of first level.)
(If someone has basics of optimisation and have some idea to improve this
query, it could be useful.)
What do you think about removing limit number of last level items and
replace it by a limit of first level items?
Or any idea to fix the issue in another way?
Thanks,
Hugues.
Hi,
I would like to know if my workflow is correct. I had a look at [0]
which pointed me to [1] (private link). In this collection of reports, I
don't see this incident for phpMyAdmin 4.1.9 and more recent (the
4.2.0-dev reference is probably at an early stage of 4.2.0).
We got 25 incidents for this one in version 4.1.8.
Can I deduce that this bug has been indirectly fixed, starting with 4.1.9?
[0] https://sourceforge.net/p/phpmyadmin/bugs/4329/
[1] https://reports.phpmyadmin.net/reports/view/1572
--
Marc Delisle
Hi,
I would like to thank phpMyAdmin team especially Isaac sir for selecting my
proposal "User Interface Enhancements" for Google Summer of Code 2014.
I don't have words to express my feelings but I assure you that I will not
let you down and will complete my tasks on time.
Thanks again.
--
Chirayu Chiripal
Hi,
I'm doing some tests on DB grouping, and I met a case where group is not
done…
If you create a DB "test", another one "test_test" and third one
"test_again" (with DB separator = "_"), you'll have a group "test" with
children "test", "test_test" and "test_again".
But if you just create "test" and "test_test", you won't have a group and
both DB will be at top level. I expected to have a first level item "test"
and children "test" and "test_test".
Please, is this the expected behavior?
Thanks,
Hugues.
Hi,
I'm working on bug ticket http://sourceforge.net/p/phpmyadmin/bugs/3733/
I already replaced all & in PHP files by the separator defined in php.ini.
I also replaced a part of & in JS files (almost all). But I still have an
issue... with Jquery method $.get...
This method have many parameters, and one could be a JSON object of URL
parameters.
Something like this:
var params = {
aPath: $expandElem.find('span.aPath').text(),
vPath: $expandElem.find('span.vPath').text()
};
And this:
$.get(url, params, function (data) {
...
});
Imagine that you set the arg_separator to "|" in your php.ini, the result
will be:
- initial URL: http://myurl.com/mypage.php?p1=v1|p2=V2
- params: var params = {
p3: "v3",
p4: "v4"
};
- generated URL: http://myurl.com/mypage.php?p1=v1|p2=V2&p3=v3|p4=v4
As you can see, there is a & between the initial URL and the added
parameters...
Do you know a way to manage the arg_separator used by Jquery please?
Thanks a lot !
Hugues.
Hi,
It seems like, the latest PMA_RecentFavoriteTable is trying to behave as
singleton design pattern. Is that a requirement ? I mean is there any
reason for making it singleton ? By the way, there is good possibility to
create new instances again and again with current logic.
And the class has $table_type instance variable and more. Isn't it risky
behaviour to share a static instance throughout the web server, which has
instance variable which used in functions of that instance ?
Regards !
--
Chanaka Dharmarathna
*http://chanakaindrajith.blogspot.com/*<http://chanakaindrajith.blogspot.com/>
Hi,
I would be interested to learn if someone is able to see the upload
progress bar, either via the APC or the pecl upload progress.
I am scratching my head because, in my tests, there is a problem
when import_status.php tries to session_start(). I believe that the
current session is locked, so import_status.php stalls and cannot report
anything until the file is completely uploaded.
--
Marc Delisle