- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Really long ENUM and SET values in table structure
by Lori Lee 19 Jul '10

19 Jul '10

When there are a lot of ENUM and SET values, they all show up when viewing the table's structure and you end up having to scroll for a while to get to the right side of the table. I'm wondering if it would make sense to truncate them/limit the maximum cell width to 200px or something. I'm partly also asking because when the table gets too wide for the screen, it squishes the "More" cell (under Table Actions), moving the down arrow underneath. I haven't been able to figure out what exactly is causing it and how to fix it. Picture of what I'm talking about: http://lorilee1.files.wordpress.com/2010/07/screenshot-2.png -- Thanks, Lori

3 2

[Phpmyadmin-devel] phpMyAdmin 3.3.5-rc1 is released
by Marc Delisle 18 Jul '10

18 Jul '10

Welcome to the first release candidate of phpMyAdmin 3.3.5, a bugfix release. 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

Re: [Phpmyadmin-devel] Export tab (lirilee fork)
by Michal Čihař 17 Jul '10

17 Jul '10

Hi Dne Mon, 12 Jul 2010 11:14:56 -0700 Lori Lee <leelorik(a)gmail.com> napsal(a): > Do you think that this is reasonable (vertical space issue)? To me it > doesn't seem like a huge enough problem for me to be worth spending the > amount of time it would require to change it especially considering the many > other things of greater importance that I still have to do. I'm not really sure, that's why I did not join this discussion. On my travel notebook, I need to scroll down four times to see all options of SQL export (I need two pages using the original code). On the other side I really don't remember last time using them, so the "Quick" mode works fine for me and there everything fits perfectly on the screen. While thinking more about that I don't really see reason for compacting the advanced options, but that might be just mine idea. PS: Moving the discussion back to phpmyadmin-devel list, because I don't feel this needs to be private. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 1

[Phpmyadmin-devel] Table statistics for a newly created table?
by Ninad Pundalik 14 Jul '10

14 Jul '10

Hi, For the last few hours, I've been working on appending a newly created table's details to the list of tables we see on db_structure.php. I have been able to generate most of the HTML necessary for this in tbl_create.php, but I have not understood how the table size and overhead are calculated. Even though it's a new table and has zero rows, it would occupy some space, and it should not have any overhead. I tried understanding the code in db_structure.php that generates the HTML, but I'm slightly lost. Pointers anyone? I've pushed my changes in commit 10a9e69, so everyone can see the stage I am at. At the moment, I'm filling in a dummy value for the size column, and leaving overhead as '-'. -- Ninad S. Pundalik

2 2

[Phpmyadmin-devel] (no subject)
by Ninad Pundalik 13 Jul '10

13 Jul '10

Hi, For the last few hours, I've been working on appending a newly created table's details to the list of tables we see on db_structure.php. I have been able to generate most of the HTML necessary for this in tbl_create.php, but I have not understood how the table size and overhead are calculated. Even though it's a new table and has zero rows, it would occupy some space, and it should not have any overhead. I tried understanding the code in db_structure.php that generates the HTML, but I'm slightly lost. Pointers anyone? I've pushed my changes in commit 10a9e69, so everyone can see the stage I am at. At the moment, I'm filling in a dummy value for the size column, and leaving overhead as '-'. -- Ninad S. Pundalik

1 0

[Phpmyadmin-devel] about export and CSV
by Marc Delisle 12 Jul '10

12 Jul '10

Lori, your wrote on your blog ---- It is confusing why the default column termination symbol for CSV is a semi-colon when a comma is expected ("comma-separated values"). ---- I agree it's confusing but the semi-colon is there by default for a reason: this is the character that Excel expects and we can't deny that most users will use Excel to read back this file. -- Marc Delisle http://infomarc.info

3 3

[Phpmyadmin-devel] [ Exporting Relations Schema] Project
by ADnan 12 Jul '10

12 Jul '10

Hi, First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <http://www.imblog.info/export-relations-schema-project-google-summer-of-cod…> I expect to get the feedback about my proposal from the Community :) Thanks! I will write weekly status reports at my blog and will regularly tweet my progress. My twitter: @hiddenpearls Regards Muhammad Adnan -- Failure takes you higher than success ..!

6 33

[Phpmyadmin-devel] behavior when no userconfig is possible
by Marc Delisle 10 Jul '10

10 Jul '10

Piotr, let's say pma_userconfig is undefined; you are still offering a Save button. You wrote in Documentation.html that settings will be saved in the browser's local storage or until the end of session but some users will be disappointed to see that these have not been saved permanently (some don't read the doc :) ) Maybe the "Save" button could be changed in this case to indicate the non-permanent status of this saving operation? Also, when I save I get: ---------- Could not save configuration #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 '(`username`, `config_data`) VALUES ('root', 'a:1:{s:' at line 1 ---------- and ---------- Notice in ./libraries/user_preferences.lib.php#69 Undefined index: userconfig Backtrace ./prefs_forms.php#58: PMA_save_userprefs(array) ---------- -- Marc Delisle http://infomarc.info

2 3

[Phpmyadmin-devel] Martynas tree - Errorhandling and integration
by Herman van Rink 09 Jul '10

09 Jul '10

Martynas, I've seen that you implemented some error messages, especially concerning GD. However what struck me was the unconditional nature of the error messages. I see them on all pages where a chart is drawn... I guess you need to actually check for errors in PMA_handle_chart_err() The "Unknown data format." message could be more informative. It now shows up instead of a chart when the number of columns is not 2 or 3. Although I expect the number of supported data format's to increase, it is currently not clear what is used. One other thing I'm missing is a way back after choosing 'Display chart'. Do you plan to integrate this further with the query result data table? -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions

1 0

[Phpmyadmin-devel] Export tab (lirilee fork)
by Piotr Przybylski 09 Jul '10

09 Jul '10

Hi, Because Export forms are more or less finished, I wanted to share some my thoughts on it. It takes up too much vertical space. How about displaying it in two columns: Table(s) and Output in one, Format and Format-Specific Options in the other? I would like to always have Table(s) and Output shown, but form height right now annoys me more :) Is there an option in the $cfg array to have "Custom" checked by default? I would like to see something like that: $cfg['Export']['form_type'] = 'quick'; // custom, custom-no-form (like custom but Export Method is never displayed) -- Piotr Przybylski

2 2