July 2011 - Developers - lists.phpmyadmin.net

Re: [Phpmyadmin-devel] Remember the last way user sorted tables
by Aris Feryanto 12 Aug '11

12 Aug '11

On 24 Mei 2011, at 18:56, Piotr Przybylski <piotr.prz(a)gmail.com> wrote: > 2011/5/24 Aris Feryanto <aris_feryanto(a)yahoo.com>: > Remember that when storing data per table you will have to set some > upper limit, or you may have data in which half of the tables don't > exist. Limiting eg. to 100 takes care of dealing with removed tables - > after some time you will just "forget" about them (they get pushed out > of saved table list). Thank you for the good suggestion, Piotr. I will limit the records if I store them per table. -- Aris Feryanto

2 2

Re: [Phpmyadmin-devel] qTip usage for more reusable code
by Aris Feryanto 09 Aug '11

09 Aug '11

Hi Tyron, On 20 Jul 2011, at 17:12, Tyron Madlener <tyronx(a)gmail.com> wrote: > > I have a good idea in this regard. When we have all "Hint"-tooltips > centralized, we could easily add a config setting to disable all hint > tooltips. That might be very convenient for advanced users. > I agree with you. Advanced users may not want to see the hints everytime they use phpMyAdmin. I'll try to add this configuration after I finish the grid editing feature. P.S. I think you accidentally press Reply instead of Reply All in your gmail, so your message only delivered to me, instead to the list. -- Aris Feryanto

2 4

[Phpmyadmin-devel] New navigation frame resize handler
by Rouslan Placella 08 Aug '11

08 Aug '11

Hi there, I rewrote the navigation frame resize handler and I'm looking for some feedback and opinions. The new handler keeps navigation frame width synchronised and there is an option to collapse the frame. I made a video [1] that showcases the functionality and there are a few words about it in my blog [2] and of course, it can be seen ion action on my demo site [3]. Rouslan [1]: http://www.youtube.com/watch?v=o-MFX3i3tQ0 [2]: http://roccivic.blogspot.com/2011/07/report-for-week-10.html [3]: http://demo.phpmyadmin.net/gsoc-rouslan/

4 14

[Phpmyadmin-devel] Grid editing versus Inline edit
by Marc Delisle 05 Aug '11

05 Aug '11

Hi, I just tried Aris's new feature: grid editing (or Edit mode). A few things are not ready, for example ENUM, SET and TEXT editing; however I feel that with this, we won't need inline edit (for rows) any more. -- Marc Delisle http://infomarc.info

5 24

[Phpmyadmin-devel] [phpMyAdmin] bug ID: 3306875
by Marcos Mendonça 05 Aug '11

05 Aug '11

Hi all, I've been using phpMyAdmin for a while now and recently started with a group focused on open source. Personally, I'd like to contribute with phpMyAdmin. So I joined the list and going through the buglist I run into issue: 3306875 Can't rename a database that contains views. I'm still getting familiar with the code, so I could use some pointers or directions that could help me find a solution for this one. Thanks any help in advance. -- Marcos Mendonça

3 5

[Phpmyadmin-devel] Zoom-search and initial data reading
by Marc Delisle 04 Aug '11

04 Aug '11

Ammar, With Firebug I had a look at the network traffic when I click a data point to edit it: I was surprised to see none. IMO this is not good: it means that all the columns for all rows are in memory, making the browser able to handle far less rows. Is there a reason why you are reading the complete rows to generate the plot? I expected that you would just read the necessary columns, then use AJAX to read a complete row when the user wants to edit it. -- Marc Delisle http://infomarc.info

4 9

[Phpmyadmin-devel] Error when opening phpmyadmin db
by Tyron Madlener 02 Aug '11

02 Aug '11

Whenever I try to browse the phpmyadmin db i get the following error: SELECT tracking_active FROM.WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY version DESC MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY vers' at line 1 --- Now I looked into the code and saw the culprit is Tracker.class.php in function init() where self::$pma_table is set. At that point $GLOBALS['cfg']['Server']['pmadb'] and ['tracking'] is just empty. Anyone know why?

3 5

[Phpmyadmin-devel] Syntax highlighted SQL editor
by Michal Čihař 02 Aug '11

02 Aug '11

Hi all as of now, the master branch contains CodeMirror 2 [1] editor which is being used for SQL editing. Please test and report any failures with it. The MySQL mode was written by me and keywords list is based on our SQL parser, so if something is missing there, most likely our SQL parser misses it as well :-). [1]:http://codemirror.net/ -- Michal Čihař | http://cihar.com | http://blog.cihar.com

5 15

[Phpmyadmin-devel] CheckStyle violations in export files
by Madhura Jayaratne 02 Aug '11

02 Aug '11

Hi all, Looking at the CheckStyle reports from the CI, all the export files show very high counts of indentation rule violations. The code in the 'else' block of 'if (isset($plugin_list))' condition is wrongly indented in all of these files. There are two possible ways to correct this. 1) Correctly indent the 'else' block 2) Add 'return' statement to the end of 'if' block and remove 'else {' part. Which one if preferred? -- Thanks and Regards, Madhura Jayaratne

3 8

[Phpmyadmin-devel] restricting or removing /setup
by Marc Delisle 01 Aug '11

01 Aug '11

Hi, we got a suggestion from a user about either restricting access to /setup or telling the installer to remove this directory after initial setup. Let's discuss this... -- Marc Delisle http://infomarc.info

5 7