- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] writing unit tests to sql.lib.php
by Supun Nakandala 26 Jul '13

26 Jul '13

Hi, I am trying to write unit tests for libraries/sql.lib.php script. I tried several times to write successful test cases but I was not successful. I think it is because I am missing some variable initialization. I tried to find where I am missing but I was not successful. I would appreciate if someone can provide me a sample test case for a method (for example PMA_getNewDatabase method in sql.lib.php) or any reference that I can refer to gain the required knowledge. Thank you Regards Supun

3 4

[Phpmyadmin-devel] Config option for hidden (tables | views | functions | events)
by Isaac Bennetch 25 Jul '13

25 Jul '13

Hi, Kasun has done a nice job adding the ability to hide navigation items (tables, views, functions, and events in the navigation pane). Any objections to the configuration option at [1]? I suggested $cfg...['hiddenTables'] which isn't completely accurate as non-table items can be hidden as well; Kasun suggests 'navigation' which might be too vague. Of course 'navigation_pane_hidden_items' is too long; does anyone have a strong opinion about this? Thanks

3 2

[Phpmyadmin-devel] see the results of the last query that returned at least a row
by Supun Nakandala 24 Jul '13

24 Jul '13

Hi, I would like to know is there a way to see the results of the last query that returned at least a row using phpMyAdmin. In import.php line 605 there is condition to check for this situation but I can't find the way to generate this situation to check it. Regards Supun.

3 2

[Phpmyadmin-devel] writing unit tests to libraries/sql.lib.php
by Supun Nakandala 24 Jul '13

24 Jul '13

Hi, I am trying to write unit tests sql.lib.php. In that I want to create an instance of the database interface (GLOBALS['dbi']) to test methods by executing queries. I tried to do it by including "libraries/database_interface.inc.php" but I get an error telling "Undefined index: Server". Am I doing something wrong here or is there any other better approach to do this. Regards Supun.

2 3

[Phpmyadmin-devel] Access control for the error reporting server
by Mohamed Ashraf 22 Jul '13

22 Jul '13

There are three levels of users that I can differentiate between in the error reporting system 1- A non logged in user 2- logged in user that does not have commit access to the phpmyadmin repo 3- logged in user with commit access to the phpmyadmin repo The system has a range of actions from viewing of error reports listing, full error reports to creating tickets on the error reporting system as well as changing the status of the report. do you need something to be for some privileged users or do you think that anyone should be able to do anything. should I require a login at any point or is there no use

3 9

[Phpmyadmin-devel] help with server_software
by Mohamed Ashraf 22 Jul '13

22 Jul '13

For the error reporting system I am trying to get some info onto the name of the server currently running. I am using the server signature to try and find the server and its version. I however have only apache so I was wondering if someone with nginx or IIS would run the following php script and reply with the output so that I am able to see the output of different server softwares so as to craft my regular expression. <?php echo $_SERVER["SERVER_SOFTWARE"]; echo "\n\n"; echo $_SERVER["SERVER_SIGNATURE"];

3 4

[Phpmyadmin-devel] simplified error report
by Mohamed Ashraf 21 Jul '13

21 Jul '13

I am collecting a lot of info about the configuration when an exception occurs to store in the report. it however is mostly useless except to help when trying to reproduce the problem. so I am thinking of offering 2 views for the report. one shows the most important info which is simplified such as browser name and major version only rather than the entire browser version. it allows me to show a lot of info about the various configurations of the reports of the same bug. The other view will be a pure json one. it will be pretty printed to be easier to read but mostly I will depend on the beautifier plugins in the browser to help navigate the complex json object such as [0] and [1] The main info I will show in the html view would be the pma versions affected, browser, error name and message as well as a stack trace. I will also show links to the json view as well as all the reports that have been marked as related [0]https://chrome.google.com/webstore/detail/chklaanhfefbnpoihckbnefhakgolnmc [1]https://addons.mozilla.org/en-us/firefox/addon/jsonview/

2 1

[Phpmyadmin-devel] error with sql.php refactoring? (first browse)
by Marc Delisle 19 Jul '13

19 Jul '13

Hi Supun, since a few days, I have started to see this problem. After my login, the first table I try to browse returns an error (the query seems empty). Then I browse again and all is fine. -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] problem with sql.php refactoring: sort remembering
by Marc Delisle 18 Jul '13

18 Jul '13

Hi Supun, I just noticed a bug. When the phpMyAdmin configuration storage is active, the last column on which you sorted a table is remembered. The next time you browse this table, it's sorted on the same column, and you see a small triangle next to the column name. The small triangle no longer appears when this sorting on remembered column is done (tested on sakila.actor). git bisect tells me that the problem started with https://github.com/phpmyadmin/phpmyadmin/commit/ebef06fa0df162a5852efab68fa… Regards, -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] support question
by Marcy 18 Jul '13

18 Jul '13

Hello I am wondering how I can get help on using PHPMyAdmin? I tried searching the forum but couldn't find an answer. I am not a programmer and am generally clueless on how this all works!! Anyway, my database is collecting customer information - there are a 8 data fields per customer record. When I do a CSV export of the data, each data item is on it's own line. So one customer record is 8 lines of export. I want to export to CSV so each customer record is one line and the data items are separated by commas (i.e. 1 line will contain the 8 data items per customer separated by a comma) Can you direct me to someone who can help me in PHPMyAdmin? Thanks so much. Marcy

2 1