- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Problem using function PMA_DBI_get_columns_full
by Zahra Naeem 09 Aug '09

09 Aug '09

Hi, I am stuck in a strange problem. I am using function PMA_DBI_get_columns_full() from file database_interface.lib to extract columns' information for all tables and it is working properly in my local Working copy from trunk, but working partially in the branch code. I have compared the function both from database_interface.lib in branch as well as trunk. It is exactly the same but I cannot figure out the problem. Please guide me. Thanks, Zahra

2 1

[Phpmyadmin-devel] I'm back
by Marc Delisle 09 Aug '09

09 Aug '09

Whew! now back from a 2-week work trip to Niger, where the country's connectivity was poor due to a major cable broken. I'm now sorting my mail and will resume work on phpMyAdmin ASAP. -- Marc Delisle http://infomarc.info

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-svn] SF.net SVN: phpmyadmin:[12749] branches/gsoc/zahra
by Michal Čihař 05 Aug '09

05 Aug '09

Hi Dne Wed, 05 Aug 2009 09:23:31 +0000 zahranaeem(a)users.sourceforge.net napsal(a): > Revision: 12749 > http://phpmyadmin.svn.sourceforge.net/phpmyadmin/?rev=12749&view=rev > Author: zahranaeem > Date: 2009-08-05 09:23:31 +0000 (Wed, 05 Aug 2009) > > Log Message: > ----------- > > Once again: Do write commit messages! -- Michal Čihař | http://cihar.com | http://blog.cihar.com

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-svn] SF.net SVN: phpmyadmin:[12747] branches/gsoc/zahra/server_synchronize.php
by Michal Čihař 05 Aug '09

05 Aug '09

Hi Dne Wed, 05 Aug 2009 08:10:39 +0000 zahranaeem(a)users.sourceforge.net napsal(a): > Revision: 12747 > http://phpmyadmin.svn.sourceforge.net/phpmyadmin/?rev=12747&view=rev > Author: zahranaeem > Date: 2009-08-05 08:10:39 +0000 (Wed, 05 Aug 2009) > > Log Message: > ----------- > Please include commit message. Every time. > --- branches/gsoc/zahra/server_synchronize.php 2009-08-05 07:44:34 UTC (rev 12746) > +++ branches/gsoc/zahra/server_synchronize.php 2009-08-05 08:10:39 UTC (rev 12747) > @@ -318,7 +318,7 @@ > echo '</tr>'; > } > echo '</table>'; > - echo '<table id="serverstatusconnections" class="data" width="45%" > > + echo '<table id="serverstatusconnections" class="data" width="43%" > Do you really need fixed width of the table? -- Michal Čihař | http://cihar.com | http://blog.cihar.com

1 0

[Phpmyadmin-devel] GSoC tracking mechanism, status report July 25th - August 2nd
by Alexander Rutkowski 02 Aug '09

02 Aug '09

Hi all, my report is a little bit delayed, my great-grandfather had 90th birthday on friday. I hope I will reach this age too ;) KEY ACCOMPLISHMENTS LAST WEEK ============================= - Created an overview page for (un)tracked tables/views in a database. It gives a short status report of tracked tables/views and links to the "create version" page for untracked tables. - A new grey-colored icon indicates whether a table has versions but deactive tracking status. - Added handlers for CREATE/DROP INDEX, CREATE/ALTER/DROP VIEW. - Auto-creation functionality implemented. It creates a version of new tables and views automatically. - Some new config vars added. Here a short introduction: // Creates tracking of new tables and views automatically. Default value is true. $cfg['Servers'][$i]['tracking_version_auto_create'] = true|false // Adds "DROP VIEW" statement as prefix of "CREATE VIEW" logs. Default value is true. $cfg['Servers'][$i]['tracking_add_drop_view'] = true|false // Adds "DROP TABLE" statement as prefix of "CREATE TABLE" logs. Default value is true. $cfg['Servers'][$i]['tracking_add_drop_table'] = true|false // Defines the statements which the auto-creation mechanism uses for new tracked versions. // Default value is // CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE, // CREATE INDEX,DROP INDEX, // INSERT,UPDATE,DELETE,TRUNCATE,REPLACE, // CREATE VIEW,ALTER VIEW,DROP VIEW, // CREATE DATABASE,ALTER DATABASE,DROP DATABASE; $cfg['Servers'][$i]['tracking_default_statements'] = ... KEY TASKS THAT STALLED ====================== - KEY CONCERNS ============ Finishing list of deliverables. TASKS IN THE UPCOMING WEEK ========================== - I want to focus on structure snapshots. The snapshot is saved in a php array. A user-friendly visualisation of it would be fine. Comparison of snapshots is an idea. - Secondly I want to add an ouput of tracked CREATE/DROP/ALTER DATABASE statements to the "Tracking" overview page for databases. - When time is left: start first phase of testing and evaluation. Try to get more feedback from users and developers. Best regards Alexander

1 0

[Phpmyadmin-devel] Help regarding applying CSS to my page
by Zahra Naeem 01 Aug '09

01 Aug '09

Hi, Could some one explain how to add and apply my own CSS that I need for my page display settings. If I add the CSS to themes/original/css/themes_right.css.php then it does not get applied to my html code. And if I dare to write the CSS at the top of my page using <style type="text/css"></style> tags then it shows long warning notes as follows: *Warning* in .\libraries\core.lib.php#589 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\core.lib.php#589: setcookie( string pma_fontsize, string 82%, integer 1251744187, string /repository/phpMyAdmin/, string , boolean , boolean 1, ) .\libraries\Config.class.php#761: PMA_setCookie( string pma_fontsize, string 82%, string 82%, ) .\libraries\Config.class.php#408: PMA_Config->checkFontsize() .\libraries\Config.class.php#82: PMA_Config->load(string ./config.inc.php) .\libraries\common.inc.php#530: PMA_Config->__construct(string ./config.inc.php) .\Updated_copy_of_server_sync.php#22: require_once(.\libraries\common.inc.php) *Warning* in .\libraries\session.inc.php#82 session_start() [function.session-start<http://localhost/repository/phpMyAdmin/function.session-start>]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\session.inc.php#82: session_start() .\libraries\common.inc.php#286: require_once(.\libraries\session.inc.php) .\Updated_copy_of_server_sync.php#22: require_once(.\libraries\common.inc.php) *Warning* in .\libraries\core.lib.php#544 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\core.lib.php#544: setcookie( string pma_theme, string , integer 1249148587, string /repository/phpMyAdmin/, string , boolean , ) .\libraries\core.lib.php#572: PMA_removeCookie(string pma_theme) .\libraries\Theme_Manager.class.php#205: PMA_setCookie( string pma_theme, string original, string original, ) .\libraries\common.inc.php#803: PMA_Theme_Manager->setThemeCookie() .\Updated_copy_of_server_sync.php#22: require_once(.\libraries\common.inc.php) *Warning* in .\libraries\ob.lib.php#84 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\ob.lib.php#84: header(string X-ob_mode: 1) .\libraries\header.inc.php#24: PMA_outBufferPre() .\libraries\server_common.inc.php#45: require_once(.\libraries\header.inc.php) .\Updated_copy_of_server_sync.php#24: require(.\libraries\server_common.inc.php) *Warning* in .\libraries\header_http.inc.php#23 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\header_http.inc.php#23: header(string Expires: Sat, 01 Aug 2009 18:43:07 GMT) .\libraries\header.inc.php#30: require_once(.\libraries\header_http.inc.php) .\libraries\server_common.inc.php#45: require_once(.\libraries\header.inc.php) .\Updated_copy_of_server_sync.php#24: require(.\libraries\server_common.inc.php) *Warning* in .\libraries\header_http.inc.php#24 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\header_http.inc.php#24: header(string Last-Modified: Sat, 01 Aug 2009 18:43:07 GMT) .\libraries\header.inc.php#30: require_once(.\libraries\header_http.inc.php) .\libraries\server_common.inc.php#45: require_once(.\libraries\header.inc.php) .\Updated_copy_of_server_sync.php#24: require(.\libraries\server_common.inc.php) *Warning* in .\libraries\header_http.inc.php#25 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\header_http.inc.php#25: header(string Cache-Control: no-store, no-cache, must-revalidate, pre-check=0, post-check=0, max-age=0) .\libraries\header.inc.php#30: require_once(.\libraries\header_http.inc.php) .\libraries\server_common.inc.php#45: require_once(.\libraries\header.inc.php) .\Updated_copy_of_server_sync.php#24: require(.\libraries\server_common.inc.php) *Warning* in .\libraries\header_http.inc.php#26 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\header_http.inc.php#26: header(string Pragma: no-cache) .\libraries\header.inc.php#30: require_once(.\libraries\header_http.inc.php) .\libraries\server_common.inc.php#45: require_once(.\libraries\header.inc.php) .\Updated_copy_of_server_sync.php#24: require(.\libraries\server_common.inc.php) *Warning* in .\libraries\header_http.inc.php#29 Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\repository\phpMyAdmin\Updated_copy_of_server_sync.php:10) *Backtrace* .\libraries\header_http.inc.php#29: header(string Content-Type: text/html; charset=utf-8) .\libraries\header.inc.php#30: require_once(.\libraries\header_http.inc.php) .\libraries\server_common.inc.php#45: require_once(.\libraries\header.inc.php) .\Updated_copy_of_server_sync.php#24: require(.\libraries\server_common.inc.php Thanks in advance. Regards, Zahra

2 1

[Phpmyadmin-devel] [Create PHP Code] creates unexpected results when defining a trigger in SQL window ?
by Bill Hernandez 30 Jul '09

30 Jul '09

Thanks very much for the previous help... Basking in the SUN of my new found happiness, now that I have a non- crashing and fully functional Firefox/phpMyAdmin DUO, after sadly parting from a long friendship with Safari... I created a table via the phpMyAdmin GUI (NOT using the SQL window), with the following structure. ------------------------------------------------------ CREATE TABLE `mvc_project_01`.`telephones` ( `id` INT NOT NULL AUTO_INCREMENT, `fk_users_id` INT NOT NULL COMMENT 'Users Foreign Key', `location` VARCHAR(30) NOT NULL, `country_code` VARCHAR(4) NOT NULL, `area` VARCHAR(5) NOT NULL, `number` VARCHAR(8) NOT NULL, `created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, `modified_by` VARCHAR(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; ------------------------------------------------------ after saving the table, I clicked on [Create PHP Code] button, and it generated the correct php : ------------------------------------------------------ $sql = "CREATE TABLE `mvc_project_01`.`telephones` (`id` INT NOT NULL AUTO_INCREMENT, `fk_users_id` INT NOT NULL COMMENT \'Users Foreign Key \', `location` VARCHAR(30) NOT NULL, `country_code` VARCHAR(4) NOT NULL, `area` VARCHAR(5) NOT NULL, `number` VARCHAR(8) NOT NULL, `created` TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\', `modified` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\', `modified_by` VARCHAR(30) NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB;"; ------------------------------------------------------ I copied the text to BBEdit,and replaced every ',', with ',\n', and made a couple of other minor adjustments, which makes the php easier to read : ------------------------------------------------------ $sql = " CREATE TABLE `mvc_project_01`.`telephones` ( `id` INT NOT NULL AUTO_INCREMENT, `fk_users_id` INT NOT NULL COMMENT \'Users Foreign Key\', `location` VARCHAR(30) NOT NULL, `country_code` VARCHAR(4) NOT NULL, `area` VARCHAR(5) NOT NULL, `number` VARCHAR(8) NOT NULL, `created` TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\', `modified` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\', `modified_by` VARCHAR(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; "; ------------------------------------------------------ I didn't know how to add the trigger via the phpMyAdmin GUI, so I decided to use the SQL window. I put the following Trigger Definition in the SQL window, after creating the table : ------------------------------------------------------ DROP TRIGGER IF EXISTS `mvc_project_01`.`telephones_insert_trigger`; DELIMITER ;; CREATE TRIGGER `mvc_project_01`.`telephones_insert_trigger` BEFORE INSERT ON `mvc_project_01`.`telephones` FOR EACH ROW BEGIN SET NEW.created = NOW(); SET NEW.modified = NOW(); END; ;; DELIMITER ; ------------------------------------------------------ Everything went well, phpMyDamin was happy, but when I clicked on [Create PHP Code] the result below was not what I had expected : ------------------------------------------------------ $sql = "# MySQL returned an empty result set (i.e. zero rows).\n" . "\n" . "DELIMITER ;\n" . ""; ------------------------------------------------------ Any Ideas what I might be doing wrong ? Thank You Very Much... Bill Hernandez Plano, Texas

1 1

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

30 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 and installed 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 experienced no problems. Over the past few days I have tried to move away from Navicat, 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 ) again with the same results. 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, and with any luck someone will have a clue. One other thing, when I log into phpMyAdmin, it lets me in the door, but as soon as I select a database, it immediately takes me 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 commands to create 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 WITH --> SQL Dump -- -------------------------------------------------------- -- 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','null','null','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','null','null','Bill Hernandez'); -- -------------------------------------------------------- Any Clues ? Bill Hernandez Plano, Texas

3 9

Re: [Phpmyadmin-devel] [Phpmyadmin-svn] SF.net SVN: phpmyadmin:[12711] branches/gsoc/derek/phpMyAdmin
by Michal Čihař 30 Jul '09

30 Jul '09

Hi Dne Thu, 23 Jul 2009 19:33:42 +0000 drummingds1(a)users.sourceforge.net napsal(a): > Revision: 12711 > http://phpmyadmin.svn.sourceforge.net/phpmyadmin/?rev=12711&view=rev > Author: drummingds1 > Date: 2009-07-23 19:33:41 +0000 (Thu, 23 Jul 2009) > > Log Message: > ----------- > Added Excel import module. [...] > + * LICENSE: This source file is subject to version 3.0 of the PHP license > + * that is available through the world-wide-web at the following URI: > + * http://www.php.net/license/3_0.txt. If you did not receive a copy of > + * the PHP License and are unable to obtain it through the web, please > + * send a note to license(a)php.net so we can mail you a copy immediately. PHP license is AFAIK incompatible with GPL, so we can not include PHP licensed code. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

2 6

[Phpmyadmin-devel] User Preferences in Permanent Storage Project Updates
by Zeeshan M. 30 Jul '09

30 Jul '09

Hi, I uploaded a revision for patch #2825187<https://sourceforge.net/tracker/index.php?func=detail&aid=2825187&group_id=…>at sourceforge.net <http://zixan.info/?UlByGmx_>. Notes: - Please don't worry about changes in libraries/config.default.php other than the addition of $cfg['Servers'][$i]['enable_userprefs'] = TRUE;. I made other changes just for the sake of my local system. - I tried to generalize lang strings by excluding settings' name from the error message. Each setting name is set in server_perm_storage.php. I just had a thought that it may cause a conflict with other languages if some settings have different names. For example, 'foreign key maximum limit' may be called 'límite máximo de claves foráneas' in Spanish. (Thanks to Google translator, BTW.) - Error handling is implemented in this revision. Users see a success message if input meets the criteria, and an error message is displayed if there is an error found. - I see how I can use a loop to process settings, but I am wondering since not all of the settings have same test criterion it may not be a probable solution. What are your thoughts? - In the future release, I will write a little blurb about each setting somewhere in the interface. I believe it will better assist the users to know what each setting is about. I thought it may be important as some of these settings will be modified by some users for the first time. - Also for future release: input box is highlighted if incorrect value is entered, and previously entered value is also displayed instead of the one in DB. Of course, implement control over other settings, and use PMA_query_as_controluser() for querying db. Thanks! -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

2 2