February 2011 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Weird error
by Michal Čihař 10 Feb '11

10 Feb '11

Hi all I've just noticed this and don't have time to debug and the tracker is not working, so I'm reporting it here. When trying to browse empty table, I get following error: #1050 - Table 'ASSIGNMENT' already exists CREATE TABLE ASSIGNMENT( ProjectID Int NOT NULL , EmployeeNumber Int NOT NULL , HoursWorked Numeric( 6, 2 ) NULL , CONSTRAINT ASSIGNMENT_PK PRIMARY KEY ( ProjectID, EmployeeNumber ) , CONSTRAINT ASSIGN_PROJ_FK FOREIGN KEY ( ProjectID ) REFERENCES PROJECT( ProjectID ) ON UPDATE NO ACTION ON DELETE CASCADE , CONSTRAINT ASSIGN_EMP_FK FOREIGN KEY ( EmployeeNumber ) REFERENCES EMPLOYEE( EmployeeNumber ) ON UPDATE NO ACTION ON DELETE NO ACTION ); Yes, phpMyAdmin is trying to CREATE TABLE, when going to following URL: http://demo.phpmyadmin.net/master-config/sql.php?db=Ashley&table=ASSIGNMENT The dump of this database can be found here: http://tmp.cihar.com/Ashley.sql -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

2 3

[Phpmyadmin-devel] XML export/import : view of view
by Dieter Adriaenssens 08 Feb '11

08 Feb '11

Hi all, I'd like your opinion about exporting view of view in xml format. Aamir Khan prepared a patch [0] that creates an XML export in the way this is handled in SQL export, ie first all tables and views are exported. All views are exported as standin tables with the same structure. Then all views are recreated, first dropping the standin tables, and creating the real views. The reason for this is to make sure that when creating a view that uses another view, it at least exists, thus avoiding an error upon importing it again. Downside of this is that the xml export of the structure schema gets a bit confusing with a <pma:table>, <pma:drop> and <pma:view> tag for every view, as the xml export is intended to be used by custom scripting. Another idea is just to export the schema structure with one tag for a view (without the extra table and drop parts), and make some changes to the xml import code, to handle the correct creation of the views. Any ideas? [0] http://sourceforge.net/tracker/?func=detail&aid=3141565&group_id=23067&atid… -- Kind regards and Merry Christmas, Dieter Adriaenssens

4 9

[Phpmyadmin-devel] phpMyAdmin 2.11.11.2 and 3.3.9.1 are released
by Marc Delisle 08 Feb '11

08 Feb '11

(Sorry for the typo in the previous message). Welcome to phpMyAdmin 2.11.11.2 and 3.3.9.1, two security releases. Please refer to the upcoming PMASA-2011-1 announcement on http://www.phpmyadmin.net/home_page/security/. Download 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

[Phpmyadmin-devel] Git and mailing list links
by Michal Čihař 08 Feb '11

08 Feb '11

Hi all looking at main phpMyAdmin page, I do not see good reason why there should be direct links to Git and mailing lists. I think people are rather looking for some more generic information, so how about changing them to Support and Contribute leading to our online pages for that? Patch is attached. The second patch changes it so that all links are printed in same way. It makes the box slightly longer, but I think it is easier to read. Comments? -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 3

[Phpmyadmin-devel] phpMyAdmin 2.11.11.2 and 3.3.9.2 are released
by Marc Delisle 08 Feb '11

08 Feb '11

Welcome to phpMyAdmin 2.11.11.2 and 3.3.9.2, two security releases. Please refer to the upcoming PMASA-2011-1 announcement on http://www.phpmyadmin.net/home_page/security/. Download 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

[Phpmyadmin-devel] Testing the interface
by Michal Čihař 07 Feb '11

07 Feb '11

Hi all one of talks I've visited on FOSDEM was about Sahi [1], tool to test interface of web applications. It seemed to be really easy to create new tests, but it was only short talk to get to know details. Simply I think it's worth of looking at if we will be somehow extend level of testing. [1]: http://sahi.co.in/w/ -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

2 1

[Phpmyadmin-devel] translating date/time related strings in js/messages.php
by Dieter Adriaenssens 06 Feb '11

06 Feb '11

Hi, I noticed that date/time related strings, like days of week, name of months, are listed in js/messages.php, using gettext. It seems a bit strange that these should be translated, as these translations are already done and available. (using strftime(), f.e.). Why is it done this way in js/messages.php? -- Kind regards, Dieter Adriaenssens

3 2

[Phpmyadmin-devel] Notifications about new versions
by Michal Čihař 05 Feb '11

05 Feb '11

Hi all I've played a little bit with javascript and hacked notifications about newer version available on phpMyAdmin main page. It is asynchronous so it should not block page loading and if the request is blocked for whatever reason, nothing happens. Patch is attached. Such feature is quite common for web applications, however I'm still not sure if we want to introduce such thing on main page. Opinions? PS: We already have check in setup, but it requires server side access to download from remote sites what is often prohibited. And nobody visits setup after the application is installed. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

5 9

[Phpmyadmin-devel] discussing wiki changes
by Isaac Bennetch 05 Feb '11

05 Feb '11

Hello, For those of you who are involved with the wiki, there are a few large changes we're discussing. Michal proposed that this might be the best vehicle for discussion, which seems to make good sense to me. First: Marc basically suggested creating subcategories for "Google Summer of Code"; that would be the parent category with subcategories like "Google Summer of Code 2011". Then pages like "GSoC 2011 Ideas List" would be in "Category: Google Summer of Code 2011" which would then in turn be "Category: Google Summer of Code". "GSoC 2011 Ideas List" would not appear directly in "Google Summer of Code". Any objections? Second: It's been proposed to completely abandon namespaces (such as Devel:) -- in some cases they can help, such as when a page clearly belongs only to one namespace or the other, but many of our pages (for instance, the GSoC pages) either live in the wrong namespace or could be assigned to both. I do agree that everything currently in Devel: belongs there, but some things in the (Main) namespace probably belong in Devel: and it might be easier to administrate only one namespace...Then we wouldn't have to think about (or discuss) which namespace a page belongs to or move it if content changes. What do you think?

4 11

[Phpmyadmin-devel] Visualizing GIS data.
by Madhura Jayaratne 05 Feb '11

05 Feb '11

Hi all, I read about the project idea 'Zoom search' [0] on GSoC 2011 Ideas List and I think the concept applies to GIS data more than anything else. Unlike other data types spatial data almost always needs a graphic visualizer to make it more useful. Unless visualized you can't figure out what the the data relates to, can'f figure out geographical data in your head without projecting longitude/latitude pairs onto a map. So I propose a data visualizer for GIS data as a part of 'OpenGIS support' [1], suggested in GSoC 2011 Ideas List. Zooming, text on hovering and other actions suggested under Zoom search would make this visualization also a source for search and clicking on an item would take you to browse the corresponding data. This would make GIS data compatible with Zoom search proposed. I would much appreciate your comments on this idea. [0] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#Zoom-search [1] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support <http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support> -- Thanks and Regards, Madhura Jayaratne

2 2