- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Increase the height of sql query form / window
by Alexander Rutkowski 30 Jul '09

30 Jul '09

Hi all, there is a feature request on http://sourceforge.net/tracker/?func=detail&aid=2823686&group_id=23067&atid… and I think its a good idea to increase the height of the sql query form. What you think ? Best regards Alex

5 6

[Phpmyadmin-devel] ideas / concerns / problems [about|with] user settings feature
by Zeeshan Mughal 30 Jul '09

30 Jul '09

Hi, I have few things that I want to discuss. I see some of the settings do not have their own user interface to edit them such as “PropertiesIconic”. I might have to change plans about implementing separate user interfaces for each settings, as they virtually do not exist for some of them. I am beginning to feel like this project is not just about having a feature to store settings permanently, but also providing users an interface to change those settings that they were not able to do so before because of not having access to config files on the server. I see all of the settings (currently under consideration) also have configuration options in ./libraries/config.default.php. Are these configs only there for initial installation purpose? What would happen if sysadmins change value for these options? Will these new settings override those stored in DB? Would it not be a decent idea to simply apply user settings to relative vars in ./libraries/config.default.php by extracting them from db? May be also have a mechanism to allow sysadmins to override DB stored settings? I see there are several settings in ./libraries/config.default.php that can easily be imported to permanent settings user interface. Is there a limit on the number of settings that can have a place in the central admin interface due to performance, or some other issues? *Now, some coding questions:* Following UPDATE query does not happen to perform any change to the table: PMA_DBI_try_query("UPDATE pma_perm_usr_pref SET maxRows = 20 WHERE username = root") And following SELECT query actually gives me a rather weird result: PMA_DBI_try_query("SELECT maxRows FROM pma_perm_usr_pref WHERE username = root") results in: *Resource Id #61 *Of course, changeable values are not hard-coded in the actual script. :) Is there something wrong with the sql query? For the later, I tried adding $link ( = PMA_DBI_select_db($cfg['Servers'][1]['pmadb']) ) parameter just to test if not having it was the problem. But, no luck. Well, this brings me to my last question. For now, I am manually setting $i equal to 1. Is there a way to extract this server parameter from some automatically generated script? Thank so much! Your help is much appreciated! -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

4 21

[Phpmyadmin-devel] slave replication, load data from master
by Tomas Srnka 29 Jul '09

29 Jul '09

Hello, I've been working on my design for managing slave replication and I've run into a problem. To explain, slave replication works in a way, that it loads master log (located on master server), where information about transactions are stored. Everything is fine, if you are setting up replication on empty server. However, once you have some data on master, you have to copy them to slave server before slave replication is started. My original idea was to use LOAD DATA FROM MASTER, but this feature is no longer supported (http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html) One of my ideas is to create some sort of export/import function for copying data from master to slave with phpMyAdmin. Another possibility (for large databases/tables) is to ask root (=user) to do it manually (with mysqldump+mysql client). If anyone has any better idea how to solve this problem, please let me know. Thank you. Tomas

3 3

[Phpmyadmin-devel] phpMyAdmin crashes several times a day
by Bill Hernandez 29 Jul '09

29 Jul '09

I am running on OS X 10.5.7 on an iMac 24 Intel machine, spend 10-14 hours a day programming, and hardly ever experience any kind of an application hang, much less a crash. Several days ago I downloaded Zend Server CE, which came with phpMyAdmin. I have been using Navicat with mySQL and pgSQL for a long time, and for the most part have no problems. I have tried to move away from Navicat over the past few days, but phpMyAdmin crashes almost every time I use it. I have been reading in an sql file that creates some tables, triggers, adds a few records. There's less than 10 records involved and 3 tables. ( 1 ) Select the database ( 2 ) Click on SQL icon ( 3 ) Click on "Import Files" link ( 4 ) Import the file containing the Structure and Data ( 5 ) Try to select a table to view the records ( 6 ) Everything appears fine, but as soon as I try to select a Table to view the records, phpMyAdmin crashes. I have also tried creating a table from scratch, adding a few records, and exporting the Structure and Data to a file. I will then drop the database, and create a new one. At this point I will try steps ( 1 ) through ( 6 ) It doesn't matter whether I try to import the sql file exported from Navicat, or the one exported from phpMyAdmin. It crashes regardless. BTW, I have had to go back to Navicat, and it has yet to crash. It does run rock solid, but has problems exporting out of mySQL and importing into pgSQL, so it's not perfect either. I would love to be able to use phpMyAdmin, hopefully somebody will have a clue. One other thing, when I log into phpMyAdmin, and select a database, it immediately goes back to the Login Screen and makes me login again. phpMyAdmin seems to work OK from what I've been able to tell with existing databases, the problems appear when I try either pasting the creation commands for a table, or actually try to import a file containing the Structure and Data Here are some observations that have nothing to do with the crashes, but they are just beginners observations.... -- NAVICAT SQL Dump -- version 3.2.0 -- http://www.navicat.com -- -- Host: localhost -- Generation Time: Jul 27, 2009 at 09:50 PM -- Server version: 5.1.32 -- PHP Version: 5.2.10 -- -------------------------------------------------------- -- MY OBSERVATIONS -- -------------------------------------------------------- -- Differences between phpMyAdmin and Navicat -- phpMyAdmin does the following : -- -------------------------------------------------------- -- ( 1 ) phpMySQL : Uses // for delimiters in TRIGGERS instead of using ;; -- -------------------------------------------------------- -- ( 1 ) NAVICAT : DELIMITER ;; -- ( 1 ) phpMySQL : DELIMITER // -- -------------------------------------------------------- -- ( 2 ) phpMySQL : DOES NOT put a semi-colon after the END on the triggers -- -------------------------------------------------------- -- ( 2 ) NAVICAT : -- ( 2 ) END; -- ( 2 ) ;; -- -------------------------------------------------------- -- ( 2 ) phpMySQL : -- ( 2 ) END -- ( 2 ) // -- -------------------------------------------------------- -- ( 3 ) phpMySQL : DOES a lot of the keywords in lowercase, not all -- -------------------------------------------------------- -- ( 4 ) phpMySQL : Puts all references to include the database for example: -- ( 4 ) CREATE TRIGGER `mvc_project_01`.`projects_insert_trigger`BEFORE INSERT ON `mvc_project_01`.`projects` -- -------------------------------------------------------- -- ( 4 ) NAVICAT : DOES NOT reference the database for example: -- ( 4 ) CREATE TRIGGER `projects_insert_trigger` BEFORE INSERT ON `projects` -- -------------------------------------------------------- -- ( 6 ) INSERT STATEMENTS -- -------------------------------------------------------- -- ( 6 ) NAVICAT : On the INSERT statements Navicat does not list the fields before the VALUES -- ( 6 ) INSERT INTO `projects` VALUES('1','mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','2009-07-27 20:48:54','2009-07-27 20:48:54','Bill Hernandez'); -- -------------------------------------------------------- -- ( 6 ) phpMySQL : Does NOT put single quotes around integers, has a space after each COMMA -- ( 6 ) INSERT INTO `projects` (`id`, `name`, `description`, `created`, `modified`, `modified_by`) VALUES(1,'mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','2009-07-27 20:48:54','2009-07-27 20:48:54','Bill Hernandez'); -- -------------------------------------------------------- Any Clues ? Bill Hernandez Plano, Texas

1 0

[Phpmyadmin-devel] Demo server and wiki are down
by Michal Čihař 28 Jul '09

28 Jul '09

Hi all as you might already have noticed, demo server, wiki and planet are down. As well as my email and jabber. This is caused by hardware failure and it's fixing is quite tricky right now because I'm in Spain till 4th August, but I hope to be able to restore at least something much sooner. For now I've set up mail temporarily using Google apps, so at least it should work, rest will hopefully come soon. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

3 5

[Phpmyadmin-devel] PMA_query_as_controluser
by Zeeshan M. 28 Jul '09

28 Jul '09

I see PMA_query_as_controluser (in relation.lib.php; thank to Alex for the help!) is written on the top of PMA_DBI_query and PMA_DBI_try_query methods. PMA_DBI_query is written on the top of PMA_DBI_try_query. I was wondering since PMA_DBI_try_query and PMA_DBI_fetch_result are part of a same class then what different using PMA_query_as_controluser makes? Also, I tried using it but I got Resource ID#63 error. I think SQL is fine as it worked with PMA_DBI_fetch_result. Thanks. -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

2 1

[Phpmyadmin-devel] GSoC tracking mechanism, status report July 18th - 24th
by Alexander Rutkowski 24 Jul '09

24 Jul '09

Hi all, KEY ACCOMPLISHMENTS LAST WEEK ============================= - I added a separate filter functionality to the tracking report. Now it is possible to list data definition, data manipulation or both kinds of statements. Date ranges are supported. - Secondly I added an user filter. PMA_Tracker tracks the logged in username. The tracking report page supports to list all tracked usernames (*), one username or a list of usernames with ',' as delimiter. - The export form uses the described filter settings. - I added a new export option: "SQL dump as file download". Users can directly download the statements. - I did some work on the SQL dump page. It shows the SQL query form now. The lines CREATE database IF NOT EXISTS pma_temp_db; USE pma_temp_db; will automatically added to the dump. The user can copy the whole dump to the clipboard or execute it by clicking on the submit button. If he submits it he gets a "temporary" table and can do fine things with it (use PMA export functionality for example). - I decided to cut off `dbname` . prefixes from tracked statements. I used a Perl regular expression for that. Only without these prefixes the dump export to other databases is possible. - I merged my Subversion branch with trunk/phpMyAdmin and committed the changes. Not a big job, but good to see that it worked. - German translation added. KEY TASKS THAT STALLED ====================== I tried to use libraries/sqlparser.lib.php within my PMA_Tracker but it produces a lot of notices. In addition PMA_SQP_analyze() works only for SELECT queries. Did not see an easy (time-efficient) way to enable it for my PMA_Tracker so I reduced the queue priority for this job. KEY CONCERNS ============ Tracking for whole databases is still open. TASKS IN THE UPCOMING WEEK ========================== - Create first prototype of tracking page for databases / set of tables. - Add handlers for CREATE/DROP INDEX, CREATE/ALTER/DROP VIEW. - Inform users about deactivated tracking versions (use an icon or notice message). Finally I want to call attention to http://demo.phpmyadmin.net/gsoc-alex/ Its a copy of my svn branch (thanks to Michal). Best regards and have a nice WE Alexander

1 0

[Phpmyadmin-devel] Problem in getting values from the url
by Zahra Naeem 24 Jul '09

24 Jul '09

Hi all, I am using the following piece of code in my java script file to retrieve the ids of checked check boxes from a div named "list". I am appending the arrays of ids in the url using the "location.href = location.href+"?array=true&0="+course;" etc. I can see the array in the address bar but using $REQUEST or $GET does not help me fetch the values. Please have a look at my code and help me as soon as possible. This problem has already taken a lot of my time. Thanx in advance. function ApplySelectedChanges() { var Checked_tables_ids = new Array(); var div = document.getElementById("list"); var input_fields = div.getElementsByTagName('input'); var x = input_fields.length; var i; var append_string; for (i=0; i<x; i++) { if (input_fields[i].type == 'checkbox') { if (i == 0) { append_string = "?abc="+1234+"&"; } else { append_string += "&"; } Checked_tables_ids[i] = input_fields[i].id; append_string += i+"="+input_fields[i].id; } } location.href += append_string; }

3 2

[Phpmyadmin-devel] #1064 - You have an error in your SQL syntax near ''utf8'; ' at line 1 error
by Zeeshan Mughal 24 Jul '09

24 Jul '09

Hi, I was doing work, and all the sudden I got this error message when I tried to log in: Error > > SQL query: > > SET CHARACTER SET 'utf8'; > > MySQL said: > > #1064 - You have an error in your SQL syntax near ''utf8';' at line 1 > I tried restarting MySQL server, but it did not help. I am supposing it should not be a big problem. Hope someone can help me out! Thanks! -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

3 2

[Phpmyadmin-devel] Question about dbname . tablename in PMA
by Alexander Rutkowski 23 Jul '09

23 Jul '09

Hi all, does anybody know if there exist a config var in PMA that define the style of generated tablenames ? Is there a rule for programmers ? When I edit the structure of a field, PMA produces only "tablename" as table name. When I insert data it produces "dbname" . "tablename". Example: ALTER TABLE `table1` CHANGE `field3` `field3` INT( 14 ) NOT NULL ; INSERT INTO `test`.`table1` ( `field1` , `field2` , `field3` ) VALUES ( '1', '2', '3' ); Thank you Alex

3 3