June 2014 - Developers - lists.phpmyadmin.net

Re: [Phpmyadmin-devel] GSoC 2014 - Refactoring: Designer/schema integration
by Bimal Yashodha 22 Jun '14

22 Jun '14

Hi, After integrating schema editor to the designer, now the user would be able to manage pdf pages from the designer itself. But it seems, there is another limitation such that, user would not be able to delete a table from a page. So I thought of addressing this issue by adding a delete button to the table itself as shown here <http://kbyashodha.blogspot.com/2014/06/gsoc-2014-week-3.html>: I'd like to know will this be a good solution. Thanks. On Mon, Jun 9, 2014 at 11:48 PM, Bimal Yashodha <kb.yashodha(a)gmail.com> wrote: > Hi, > > After integrating schema editor to the designer, now the user would be > able to manage pdf pages from the designer itself. But it seems, there is > another limitation such that, user would not be able to delete a table from > a page. So I thought of addressing this issue by adding a delete button to > the table itself as show below: > > [image: Inline image 1] > I'd like to know will this be a good solution. > > Thanks. > > > > On Mon, May 26, 2014 at 11:56 PM, Bimal Yashodha <kb.yashodha(a)gmail.com> > wrote: > >> Hi, >> >> Currently, for the functionality "Import/Export coordinates for PDF >> schema", redirects to another page and after selecting a page we have to >> aging come back to the designer page manually. >> >> So instead of redirecting to a new page, I think a dialog box and ajax >> calls would be handy. >> >> Also I removed the "import/export coordinates from/to pdf pages" button >> and the UI looks as follows: >> >> [image: Inline image 1] >> >> PS: I put another email with the revised design earlier, but it seems >> that mail has not been sent. I Think it might be of the attached image >> size, so need to get the admin's permission. >> >> Thanks. >> >> >> >> On Tue, May 20, 2014 at 10:05 AM, Madhura Jayaratne <madhura.cj(a)gmail.com >> > wrote: >> >>> >>> >>> >>> On Tue, May 20, 2014 at 12:05 AM, Bimal Yashodha <kb.yashodha(a)gmail.com> >>> wrote: >>> >>>> Hi, >>>> >>>> As the 1st phase of my GSoC project - "Refactoring: Designer/schema >>>> integration", I've started the task 1, which is "Providing a single GUI >>>> editor for schema". >>>> >>>> As the "Designer" and "Edit relational schema" pages share overlapping >>>> functionalities, the idea is to bring these two pages and have a more >>>> improved page alone.Under this, functionalities of the "Designer" will be >>>> improved in such a way, by combining features of the "Edit relational >>>> schema" page. >>>> >>>> For that I've created some mockups, and already published in my blog >>>> <http://kbyashodha.blogspot.com/2014/05/first-week-of-gsoc-2014.html>. >>>> >>> >>> Great! >>> >>> >>>> >>>> [image: Inline image 2] >>>> >>>> As shown in the above figure, I've introduced two new buttons into the >>>> "Designer" page, and followings are the functionalities: >>>> >>>> *Edit page: *A user can edit/delete an existing page. >>>> >>>> *Save as: *coordinates of the table layout can be saved to an existing >>>> page or to a new page. >>>> >>>> Apart from these two, while the user is loading the designer page, >>>> >>>> - if there are previously saved pages exist, the the first page >>>> will be loaded into the designer by default. >>>> >>>> It would be useful to display the loaded page's name somewhere, so the >>> user is not confused. >>> >>>> >>>> - if there are no such saved pages, then the default table layout >>>> will be loaded. >>>> >>>> In this case the page name can be *New or something similar. >>> >>> The second icon from right side used to provide functionality to >>> import/export coordinates from/to pdf pages. This needs to be removed. >>> >>> -- >>> Thanks and Regards, >>> >>> Madhura Jayaratne >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE >>> Instantly run your Selenium tests across 300+ browser/OS combos. >>> Get unparalleled scalability from the best Selenium testing platform >>> available >>> Simple to use. Nothing to install. Get started now for free." >>> http://p.sf.net/sfu/SauceLabs >>> _______________________________________________ >>> Phpmyadmin-devel mailing list >>> Phpmyadmin-devel(a)lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel >>> >>> >> >

3 6

[Phpmyadmin-devel] PMASA-2014-3 wrong fix version stated
by Chirayu Chiripal 22 Jun '14

22 Jun '14

Hi, The security announcement PMASA-2014-3 says: Affected Versions Versions 4.1.x (prior to 4.1.15) and 4.2.x (prior to 4.2.4) are affected. Solution Upgrade to phpMyAdmin 4.1.15 or newer, or 4.2.4 or newer, or apply the patch listed below. However, I cannot see 4.1.15 in downloads or is it supposed to be 4.1.14.1? -- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/

3 3

[Phpmyadmin-devel] phpMyAdmin 4.1.14.1 is released
by Marc Delisle 21 Jun '14

21 Jun '14

Welcome to phpMyAdmin 4.1.14.1, containing a minor security fix. The announcement for the security fix will be published soon on http://www.phpmyadmin.net/home_page/security/ as PMASA-2014-3. Details will appear on http://phpmyadmin.net. You can also visit https://sourceforge.net/projects/phpmyadmin/files to download. The phpMyAdmin team

1 0

[Phpmyadmin-devel] phpMyAdmin 4.2.4 is released
by Marc Delisle 20 Jun '14

20 Jun '14

Welcome to phpMyAdmin 4.2.4, a bugfix release with minor security fixes. Announcements for the security fixes will be published soon on http://www.phpmyadmin.net/home_page/security/ as PMASA-2014-2 and PMASA-2014-3. Details will appear on http://phpmyadmin.net. You can also visit https://sourceforge.net/projects/phpmyadmin/files to download. The phpMyAdmin team

1 0

[Phpmyadmin-devel] RFE #1490 Dynamic process list
by Chirayu Chiripal 20 Jun '14

20 Jun '14

Hi, The RFE #1490 says "In Server > Status > Processes, it would be interesting to add a button to start dynamic refreshing of the process list, with a configurable refresh rate like in Server > Status > Monitor > Settings." Does it mean the processes table on Server > Status > Server tab? Also, does it require to refresh the processes table only or the other table such as Traffic statistics and Connections with it? -- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/

3 5

[Phpmyadmin-devel] Error 500 viewing only bug 3860
by Isaac Bennetch 19 Jun '14

19 Jun '14

Hi, when I try to view bug 3860 [1], I get an error 500. Does anyone else see this behavior? I can escalate with SourceForge if it's a legitimate problem, but at this point I can't discount that it may for instance be limited to my user account. Oddly, that's the only bug for which this occurs, making me think it's specific to that particular artifact. I'd appreciate a second look if anyone has a chance. 1 - https://sourceforge.net/p/phpmyadmin/bugs/3860/

3 3

[Phpmyadmin-devel] Linking Error Report to existing SF bug Ticket
by Dhananjay Nakrani 17 Jun '14

17 Jun '14

Hi everyone, I'm working on 'Linking Error Reports with existing Bug Tickets on Sourceforge' feature of error-reporting-server. See Issue#26 [0] for more details. Before starting the coding, I want community's opinion on some matters. What information should be put as a comment on bug ticket??!! There'll definitely be a link to error report. But what else in addition to it? Following are all the available details. 1. Error Type (Notice, ReferenceError, etc..) 2. Error Message 3. PMA version 4. PHP version 5. Browser 6. User OS 7. Server Software 8. Script Name 9. Line Number 10. Stack Trace 11. Description (User defined steps to reproduce the error) 12. Exception type (php or js) 13. Configuration Storage (disabled or enabled) Please suggest which ones of above to include while posting a comment on SF bug ticket. [0]: https://github.com/phpmyadmin/error-reporting-server/issues/26/ Regards, Dhananjay Nakrani.

2 1

[Phpmyadmin-devel] RFE #755: export with table/column name changes
by Chirayu Chiripal 16 Jun '14

16 Jun '14

Hello Isaac Sir, Please review this branch: https://github.com/D-storm/phpmyadmin/tree/FR-755 Tasks to be done yet (Will be pushed soon): 1) Fix failing test cases and improve test cases. -- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/

2 7

[Phpmyadmin-devel] Simulate UPDATE query
by Ashutosh Dhundhara 16 Jun '14

16 Jun '14

Hi, I was working on RFE #861 (Simulate UPDATE query). Lets say I have two tables: `table_1` +----+----------+ | id | value | +----+----------+ | 10 | value_10 | | 20 | value_20 | +----+----------+ `table_2` +----+----------+ | id | value | +----+----------+ | 10 | value_10 | | 20 | value_20 | +----+----------+ UPDATE Query: UPDATE table_1, table_2 SET table_1.value = 'NEW_VALUE', table_2.value='NEW_VALUE' WHERE table_1.id > 10 AND table_2.id > 10; This will affect 2 rows. How to simulate this query using SELECT statement? I was trying: SELECT DISTINCT table_1.value, table_2.value FROM table_1, table_2 WHERE table_1.value <> 'NEW_VALUE' AND table_2.value <> 'NEW_VAUE' AND table_1.id > 10 AND table_2.id > 10; but this only returns 1 row. Can this be done in a single query only? Regards, Ashutosh Dhundhara

4 8

[Phpmyadmin-devel] open an account in phpmyadmin
by monika thakur 16 Jun '14

16 Jun '14

dear sir i m monika student of PGD in IT. I will Make a project with the help of PHPMYADMIN. Please guide me how to open an account on phpmyadmin. Regards

2 1