Developers

developers@phpmyadmin.net

2 participants
7003 discussions

[Phpmyadmin-devel] Problem regarding Foreign Key.
by Zahra Naeem 20 Jul '09

20 Jul '09

Hi all, I tried to make a column in the table 'student_course' foreign key using the query "ALTER TABLE student_course ADD FOREIGN KEY (Course_Id) REFERENCES course(Id)"; I also got the success message that the query has been executed successfully. But when I tried the query "SHOW TABLE STATUS FROM db_name LIKE 'student_course' ;" to get foreign key information from the comments, the comments were empty. I also used the function in libraries/relation.lib.php PMA_getForeigners() but the result is empty. I think the foreign key is not being created properly so tell me the correct syntax for creating the foreign key. I need help ASAP. Regard, Zahra.

2 1

[Phpmyadmin-devel] phpMyAdmin 3.2.1-rc1 is released
by Marc Delisle 20 Jul '09

20 Jul '09

Welcome to the first release candidate for phpMyAdmin 3.2.1. This version contains bug fixes and a new language: Uzbek. 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 --- http://infomarc.info

1 0

[Phpmyadmin-devel] config settings for sysadmins
by Zeeshan Mughal 17 Jul '09

17 Jul '09

Hi, I am creating a configuration file to allow sysadmins to enable/disable permanently stored settings, or simply the entire permanent storage feature itself. Would it be a good idea to include these options in an already existing file? If so, which file? Or, I should create a new file (which is according to plan)? The file is currently in the root dir, and will be included in * libraries/header.inc.php. *Thanks! -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

4 8

[Phpmyadmin-devel] GSoC 2009 - tracking mechanism for PhpMyAdmin (Mid Term Evaluation)
by Alexander Rutkowski 17 Jul '09

17 Jul '09

Hi all, I finished my part for Googles mid term evaluation. Please feel free to try out my code, you will find it as attachment. KEY ACCOMPLISHMENTS LAST WEEKS ============================== Finished following functionalities: - Tables can be tracked by mechanism now - System logs data definition and data manipulation statements: INSERT, UDATE, DELETE, TRUNCATE, ALTER TABLE, RENAME TABLE - Tracking can be activated for a subset of these commands - Tables with active tracking are marked with an "eye" icon. - Simple versioning system. User can create new tracking versions. - Deactivation and Reactivation of tracking jobs is possible. - Simple schema (structure) snapshot, uses SHOW FULL COLUMNS FROM and SHOW INDEX FROM - When user is selecting a tracked table, a notice will printed out - Switching between tables within a database is possible - Tracking report is available. Contains dates and statements. - Simple export form added, it can be used for undo action. (structure only|data only|both) -> (SQL dump|SQL execution) - Date_from - Date_to range selection for exports added. KEY CONCERNS ============ I want to teach the tracker more SQL statements: ALTER VIEW, CREATE INDEX, DROP INDEX Tracker should handle whole databases. TASKS IN THE UPCOMING WEEK(S) ============================= - Evaluate your feedback to my PMA_Tracker - Localize english-only strings - Add more export possibilities - Snapshot comparison would be fine - Prettify some layout elements I hope you are happy about the new Tracker, please send me your feedback. I need it for a successful progress. Thank you very much and my best regards Alexander Rutkowski

2 4

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

17 Jul '09

Hi Dne Fri, 17 Jul 2009 05:42:57 +0000 webskippa(a)users.sourceforge.net napsal(a): > Revision: 12669 > http://phpmyadmin.svn.sourceforge.net/phpmyadmin/?rev=12669&view=rev > Author: webskippa > Date: 2009-07-17 05:42:56 +0000 (Fri, 17 Jul 2009) > > @@ -331,6 +338,7 @@ > id="checkbox_tbl_<?php echo $i; ?>"<?php echo $checked; ?> /></td> > <th><label for="checkbox_tbl_<?php echo $i; ?>" > title="<?php echo $alias; ?>"><?php echo $truename; ?></label> > + <label><?=$tracking_icon?> </label> Please use long php tags <?php and stick with verbose using of echo. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 1

[Phpmyadmin-devel] Automated testing
by Herman van Rink 17 Jul '09

17 Jul '09

Hi, I've played around with phpunit a bit as of late, and think we could make better use of this for pma. The PMA_formatNumberByteDown_test test still fails for me on a conversion.... does this pass on other systems? I've setup several new testcases that uses Selenium RC [1] to replay actual browser behaviour. My first test in this is a case where I log in and do some basic browsing and change the test users password. The test scenario's are easily recorded using the Firefox Selenium IDE add-on. [2] Testing can happen in Firefox, Internet Explorer and other browsers. I've set up a cronjob which would run the test suite e.g. every day on trunk, and plan to expand this to the latest testing branch. Any errors would be mailed to me. If others are interested I could sent this to a list address. Issues: - Using a self-signed ssl certificate with Selenium RC is a pain, using non-ssl for now. [4] - Somehow selenium does not like the language selection on the cookie login page, forced English in my config for now. - The current naming scheme for test cases seems to be a bit off, according to the phpunit defaults. When running through wui.php it works, but when running individual tests the underscores in the class/file names are interpreted as directory separator. I therefore propose a CamelCase format for the new selenium classes. - The wiki has no info about testing, I propose a Devel:UnitTesting page I hope to soon commit these changes to trunk, any feedback would be very welcome. References: 1. http://seleniumhq.org/ 2. https://addons.mozilla.org/en-US/firefox/addon/2079 2 .http://www.phpunit.de/manual/3.1/en/selenium.html 4. http://townx.org/blog/elliot/dealing-self-signed-ssl-certificates-when-runn… -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions

3 9

[Phpmyadmin-devel] current user
by Zeeshan Mughal 17 Jul '09

17 Jul '09

Hi, I am using the following code to extract currently logged user name from PMA_DBI_fetch_value('SELECT USER();') // $userAndHost = PMA_DBI_fetch_value('SELECT USER();'); // $userAndHost = str_split($userAndHost); // while ($i=0 < count($userAndHost)-1) { // $username += $userAndHost[$i]; // $i++; // if ($userAndHost[$i] == "@") { // break; // } It takes a lot of time to load up the web page mainly due to the code above. Is there any alternative to this? Thanks! P.S. follow my live progress update streams at zixan.info. I find it is much more effective way to communicate more frequently. -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

4 4

[Phpmyadmin-devel] Vacation + DebConf
by Michal Čihař 16 Jul '09

16 Jul '09

Hi all I'll be till 4th August on vacation in Spain being one week in the middle on the DebConf 09. This means that I will not read emails that often and replies to private emails can take long. So especially for GSoC students it means what I've told all the time - use the mailing list to ask questions. And please write status reports, it is again end of week and I did not see much of them! I will take lack of communication as more important thing in final evaluation, which can make you fail even if you will provide working code. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

1 0

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

15 Jul '09

Hi Derek Dne Wed, 15 Jul 2009 20:09:46 +0000 drummingds1(a)users.sourceforge.net napsal(a): > @@ -262,7 +262,7 @@ > /** > * Bookmark table > * - leave blank for no bookmark support > - * SUGGESTED: 'pma_bookmark' > + * DEFAULT: 'pma_bookmark' > * > * @global string $cfg['Servers'][$i]['bookmarktable'] > */ Please do not revert changes made in trunk (there is more such changes). -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

2 1

[Phpmyadmin-devel] private student branches
by Marc Delisle 15 Jul '09

15 Jul '09

Hi, maybe students can use this to keep their private branches in sync with the trunk: http://svnbook.red-bean.com/en/1.5/svn.branchmerge.basicmerging.html#svn.br… -- Marc Delisle http://infomarc.info

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers