September 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] LoginCookieValidity in user preferences
by Piotr Przybylski 21 Sep '10

21 Sep '10

Hi, Adding this setting in user preferences will not work correctly, as all overrides to config.inc.php's values are loaded after auth is done, when database is available. The only solution for this to work, is to try loading user overrides from session cache ($_SESSION['cache']['server_?']['userprefs']) just after config.inc.php is read. -- Piotr Przybylski

2 3

[Phpmyadmin-devel] sql export : functions/routines
by Dieter Adriaenssens 20 Sep '10

20 Sep '10

Hi all, Bug #3062455 (Functions/Procedures should come first in export), suggest to export functions and procedures before views, because on import, on error might occur when a view uses a function/procedure that is not existent. Now, the export of Functions/Procedures/Events is done in PMA_exportDBFooter(). Is there any specific reason why they are exported last? Otherwise, I'll move them to PMA_exportDBCreate(), and test if it works. -- Kind regards, Dieter Adriaenssens

2 7

[Phpmyadmin-devel] AJAXification and edit privileges
by Marc Delisle 19 Sep '10

19 Sep '10

Hi, Can someone reproduce this? 1. Click Edit privileges for a user 2. Add a global privilege (let's say SELECT) 3. Click Go 4. Close the popup if needed 5. Click Edit privileges for the same user 6. What I did at step 2 does not reflect in the popup -- Marc Delisle http://infomarc.info

4 19

[Phpmyadmin-devel] PBXT table type
by Isaac Bennetch 13 Sep '10

13 Sep '10

Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines" I can't determine if this is user error or really represents a problem as neither I nor the demo server have PBXT available. Any thoughts?

4 6

[Phpmyadmin-devel] jQuery question
by Michael Keck 12 Sep '10

12 Sep '10

Hi Marc, On Sat, 11 Sep 2010 08:37:59 -0400, Marc Delisle <marc(a)infomarc.info> wrote: > Hi, > this works on a input element: > > var this_name = $(this).attr('name'); > > so I'm trying to do the same to extract the code inside the onchange > "attribute": > > var this_onchange = $(this).attr('onchange'); this won't work. > but Firebug tells me that this_onchange is an event; yepp that's right > it does not contain the code. I need to do subsequent string matching and > replacement in this code. Please use a function call for this, and replace silly the params: $(this).unbind('change'); $(this).bind('change', function(e) { // your function call // something like: // pma_js_function_to_call(param1, param2, para,X) }); Other solution is to work with a string, make your string replacement and after this use the eval-function. Sample: $(this).unbind('change'); $(this).bind('change', function(e) { eval(your_replaced_string); }); But eval is devil: The eval function (and its relatives, Function, setTimeout, and setInterval) provide access to the JavaScript compiler. This is sometimes necessary, but in most cases it indicates the presence of extremely bad coding. The eval function is the most misused feature of JavaScript. Regards Michael

2 4

[Phpmyadmin-devel] Keeping older releases to download
by Michal Čihař 12 Sep '10

12 Sep '10

Hi all our current policy was to delete old releases from sf.net once newer release is available. I find this not so good idea, for following reasons: - people might be interested in looking at older releases without using vcs - distributions ship some older releases and it is good if users can verify that they ship intact tarball as we've distributed it - most free software projects simply keep all their released files around Are there any objections against keeping all what we've released? -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 6

[Phpmyadmin-devel] PHPExcel 1.7.4
by Dieter Adriaenssens 11 Sep '10

11 Sep '10

Hi all, Recently, version 1.7.4 of the PHPExcel library was released, containing mainly bugfixes. Any objections if I upgrade PHPExcel in QA_3_3 and master? -- Regards, Dieter Adriaenssens

2 2

[Phpmyadmin-devel] jQuery question
by Marc Delisle 11 Sep '10

11 Sep '10

Hi, this works on a input element: var this_name = $(this).attr('name'); so I'm trying to do the same to extract the code inside the onchange "attribute": var this_onchange = $(this).attr('onchange'); but Firebug tells me that this_onchange is an event; it does not contain the code. I need to do subsequent string matching and replacement in this code. Thanks, -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] GSoC 2010 Charts: merged
by Herman van Rink 08 Sep '10

08 Sep '10

Hi, The gsoc branch of Martynas Mickevičius with the charts implementation has just been merged into master. I've made a few security enhancements to prevent xss, and changed a text to a tooltip. And during the merge I renumbered his faq item from 6.28.to 6.29. So we now have charts in the status page, the profiling fieldset and for query results. Implementation details: http://wiki.phpmyadmin.net/pma/Devel:Charts -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions

3 4

[Phpmyadmin-devel] phpMyAdmin 2.11.11 and 3.3.7 are released
by Marc Delisle 07 Sep '10

07 Sep '10

Welcome to phpMyAdmin 2.11.11 and 3.3.7 which are bugfix releases. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team

1 0