- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Re: phpMyAdmin new patch files
by Olivier M. 09 Aug '01

09 Aug '01

On Thu, Aug 09, 2001 at 01:39:24PM -0700, Dan Allen wrote: > I hope that you don't mind that I am e-mailing you. I had posted some no problem. the best for your patches would be that you upload them on the sourceforge feature or bugs tracker, and post a short note to the devel-ml. > patches yesterday and they were from the old version...I didn't even > think about cvs, but since the new version rc4 just came out, I reedited > the files and created patches from that version. In addition to the > patches I listed about socket and permission I also have a NULL patch, > which, when an number cell has a value of empty string, it shouldn't > show empty string but NULL, since it is impossible for a number cell to > just be blank (try it in mysql terminal client). Also, when you entered > the editor, the fields that were numbers and NULL showed up as blank and > when you inserted the data, the blanks would fill in as the default > (either 0 or the value set)...so, if the field is empty when going into > the editor (when you click on Edit) it auto fills in NULL where the > number cell is blank. I was also thinking about adding this for new > cells...so when you go to insert new data, number fields start out as > either NULL (if the parameter is NULL) or 0 (if the parameter is > NOT_NULL). If you reply, I will send you those diffs and you can throw > out what you don't like and keep what you like. > > Dan Allen -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

1 0

[Phpmyadmin-devel] out_buffer_pre($ob_mode);
by Dan Allen 09 Aug '01

09 Aug '01

This post is simply a request for clarification. What does the function out_buffer_pre($ob_mode) do? I am a bit confused, and all I know is that if I use galeon the main.php is not rendered at all (and the source is empty). Now, I realize that this is not a phpMyAdmin bug, but perhaps if I knew what it did, I could go over to the guys and gals at galeon and let them know what is cause the browser to break. Thanks for the time! Dan Allen

1 0

[Phpmyadmin-devel] PHPMyAdmin errors
by Dmitry Kashlev 09 Aug '01

09 Aug '01

I have a phpMyAdmin installed on the web server. When I try to delete any row (entry) in the database, I click on delete link to the right of the entry. Then I click on yes. The following string appears: Warning: Cannot add header information - headers already sent by (output started at config.inc.php3:118) in /usr/local/web/data/sql/sql.php3 on line 94 Here's part of sql.php3: if (!$result) { $error = mysql_error(); include("header.inc.php3"); mysql_die($error); } $num_rows = @mysql_num_rows($result); if ($num_rows < 1) { // PATCH ADDITION BEGINS // if (file_exists($goto)) if(file_exists("./$goto")) // PATCH ADDITION ENDS { include("header.inc.php3"); if (isset($zero_rows) && !empty($zero_rows)) $message = $zero_rows; else $message = $strEmptyResultSet; // PATCH ADDITION BEGINS // include($goto); include(preg_replace('/\.\.*/', '.', $goto)); // PATCH ADDITION ENDS } else { $message = $zero_rows; Header("Location: $goto"); } exit; } else { include("header.inc.php3"); display_table($result); if (!eregi("SHOW VARIABLES|SHOW PROCESSLIST|SHOW STATUS", $sql_query)) echo "<p><a href=\"tbl_change.php3?server=$server&db=$db&table=$tab le&goto=sql.php3?".urlencode($GLOBALS['QUERY_STRING'])."\"> $strInsertNewRow</a> </p>"; } } require ("footer.inc.php3"); ?> What does this mean, and how to prevent that error from ocurring? __________________ Dmitry Kashlev Webmaster Bronx Science Computing

1 0

[Phpmyadmin-devel] [announce] phpMyAdmin 2.2.0rc4 released
by Olivier M. 09 Aug '01

09 Aug '01

Good morning, Salut! The 4th Release Candidate for phpMyAdmin version 2.2.0 is available from: http://phpmyadmin.sourceforge.net/ As usual, too many fixes to all be listed here, so please simply have look at the ChangeLog (huge!): http://phpmyadmin.sourceforge.net/ChangeLog.txt Regards, Olivier/swix, for the devel team. -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

1 0

Re: [Phpmyadmin-devel] putting a @, or if (function_exists)) ?
by Loïc 09 Aug '01

09 Aug '01

Hi Marc & all! >Should we check if the function extension_loaded exists before calling >it? Or is the @ enough? '@' is not enough, you have to use "if (@function_exists('extension_loaded'))" to do the work. >And should we do this for every PHP4-specific function we find in the >code? Well, this could be a good idea but in the case of the bug report we're talking about, the problem is a bit more annoying: lots of the functions that exists in php3.0.10+ and php4.0.0 are not implemented in php4.0 beta releases. It means that you have to test each function (even php3 ones) before to use them.... Really painfull. Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

1 0

[Phpmyadmin-devel] ok for 2.2.0-rc4 release tomorrow ? (9Aug, 12h)
by Olivier M. 08 Aug '01

08 Aug '01

Marc voted yes, and I also think it would soon be time to release something again. So, Loic & other developpers, you have 10 hours to answer :) If I don't get a negative answer, it will prepare everything tomorrow morning. Regards, Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

3 3

[Phpmyadmin-devel] create-release.sh / rc4
by Olivier M. 08 Aug '01

08 Aug '01

Hello everybody, As promised, the create-release.sh is ready, and located in the scripts/ subdirectory, where I moved the other two scripts. And speaking about releases, what about getting rc4 out ? It must simply be at least as good as the rc3... :) Just a small thing : where is now the "Users" link ? (was in main.php3 in rc3). (which calls user_details.php3). Regards, Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

3 11

[Phpmyadmin-devel] database permission patch
by Dan Allen 08 Aug '01

08 Aug '01

I was using phpmyadmin with different user account and discovered that while phpmyadmin doesn't list the tables on the left frame for restricted databases (which is good) when you click on the database, it gives a confusing error that no tables are found...which is not really correct (also giving a mysql error output) it should say that the user is restricted to use the database...This might be more of an idea, but here is a patch to correct this. Build on it. Dan Allen --- phpMyAdmin2.2.0rc3/db_details.php Sat Jul 21 22:02:58 2001 +++ phpMyAdmin/db_details.php Tue Aug 7 23:59:11 2001 @@ -10,7 +10,20 @@ } else { show_message($message); } - +/* We first need to check if we can actually do anything with this database, because if not, no point in + showing any of the stuff on the page + If you can't see the tables, then you can't do anything, so here we go +*/ +$query = "show open tables from $db"; +$result = mysql_query($query); +if($result == "") { + if($AUTH) + $denied_user = $cfgServer['stduser']; + else + $denied_user = $cfgServer['user']; + echo "The user <span style=\"font-weight: bold;\">$denied_user</span> does not have the proper permissions to access this database."; +} +else { /** * Displays an html table with all the tables contained into the current * database @@ -464,6 +477,7 @@ <?php +} // End the if...else loop for permission to access the database from all the way up top /** * Displays the footer */ __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

2 2

[Phpmyadmin-devel] 'socket' patch
by Dan Allen 08 Aug '01

08 Aug '01

Recently I installed mysql in my /home directory and began to setup phpMyAdmin when I realized that it was missing support for an alternative 'socket' connect, which is necessary to point to any other mysql server than the main mysql server on the machine. I have added a patch to version 2.2.0-rc3 that I downloaded just yesterday. I am not an expert at using diff, but I did run diff -Nuar and here are the results for lib.inc.php and config.inc.php. I would really like this to be added to the main tree, so if anyone likes the idea but hates the way I send it, please e-mail me at: bigredlinux at yahoo dot com to get me on the right track because I have lots of these patches. --- phpMyAdmin2.2.0rc3/lib.inc.php Sat Jul 21 22:02:59 2001 +++ phpMyAdmin/lib.inc.php Tue Aug 7 23:27:27 2001 @@ -222,9 +222,19 @@ auth(); } else { if(empty($cfgServer['port'])) { - $dbh = $connect_func($cfgServer['host'],$cfgServer['stduser'],$cfgServer['stdpass']) or mysql_die(); + // Check for socket + if(empty($cfgServer['socket'])) { + $dbh = $connect_func($cfgServer['host'],$cfgServer['stduser'],$cfgServer['stdpass']) or mysql_die(); + } else { + $dbh = $connect_func($cfgServer['host'] . ':' . $cfgServer['socket'],$cfgServer['stduser'],$cfgServer['stdpass']) or mysql_die(); + } } else { - $dbh = $connect_func($cfgServer['host'].":".$cfgServer['port'],$cfgServer['stduser'],$cfgServer['stdpass']) or mysql_die(); + // Check for socket + if(empty($cfgServer['socket'])) { + $dbh = $connect_func($cfgServer['host'].":".$cfgServer['port'],$cfgServer['stduser'],$cfgServer['stdpass']) or mysql_die(); + } else { + $dbh = $connect_func($cfgServer['host'].":".$cfgServer['port'].':'.$cfgServer['socket'],$cfgServer['stduser'],$cfgServer['stdpass']) or mysql_die(); + } } $PHP_AUTH_USER = addslashes($PHP_AUTH_USER); $PHP_AUTH_PW = addslashes($PHP_AUTH_PW); @@ -303,12 +313,23 @@ $cfgServer['user']=$PHP_AUTH_USER; $cfgServer['password']=$PHP_AUTH_PW; } - - if (empty($cfgServer['port'])) { - $link = $connect_func($cfgServer['host'], $cfgServer['user'], $cfgServer['password']) or mysql_die(); + + if(empty($cfgServer['port'])) { + // Check for socket + if(empty($cfgServer['socket'])) { + $link = $connect_func($cfgServer['host'],$cfgServer['user'],$cfgServer['password']) or mysql_die(); + } else { + $link = $connect_func($cfgServer['host'] . ':' . $cfgServer['socket'],$cfgServer['user'],$cfgServer['password']) or mysql_die(); + } } else { - $link = $connect_func($cfgServer['host'].":".$cfgServer['port'], $cfgServer['user'], $cfgServer['password']) or mysql_die(); + // Check for socket + if(empty($cfgServer['socket'])) { + $link = $connect_func($cfgServer['host'].":".$cfgServer['port'],$cfgServer['user'],$cfgServer['password']) or mysql_die(); + } else { + $link = $connect_func($cfgServer['host'].":".$cfgServer['port'].':'.$cfgServer['socket'],$cfgServer['user'],$cfgServer['password']) or mysql_die(); + } } + } else{ echo $strHostEmpty; --- phpMyAdmin2.2.0rc3/config.inc.php Sat Jul 21 22:02:58 2001 +++ phpMyAdmin/config.inc.php Tue Aug 7 23:37:16 2001 @@ -23,6 +23,7 @@ // You can disable a server config entry by setting host to ''. $cfgServers[1]['host'] = 'localhost'; // MySQL hostname $cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port +$cfgServers[1]['socket'] = ''; // MySQL socket - leave blank for default socket $cfgServers[1]['adv_auth'] = false; // Use advanced authentication? $cfgServers[1]['stduser'] = ''; // MySQL standard user (only needed with advanced auth) $cfgServers[1]['stdpass'] = ''; // MySQL standard password (only needed with advanced auth) @@ -33,8 +34,9 @@ $cfgServers[1]['bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support $cfgServers[1]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support -$cfgServers[2]['host'] = ''; +$cfgServers[2]['host'] = 'localhost'; $cfgServers[2]['port'] = ''; +$cfgServers[3]['socket'] = ''; $cfgServers[2]['adv_auth'] = false; $cfgServers[2]['stduser'] = ''; $cfgServers[2]['stdpass'] = ''; @@ -62,7 +64,7 @@ // or set it to 0 to be given a list of servers without logging in // If you have only one server configured, $cfgServerDefault *MUST* be // set to that server. -$cfgServerDefault = 1; // Default server (0 = no default server) +$cfgServerDefault = 0; // Default server (0 = no default server) $cfgServer = ''; unset($cfgServers[0]); __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

2 1

[Phpmyadmin-devel] strange " bug
by Alain Brissaud 08 Aug '01

08 Aug '01

Hello, Step 1 : CREATE TABLE `test` (`id` VARCHAR(50) not null, `txt` VARCHAR(50) not null , PRIMARY KEY (`id`), INDEX (`id`)); INSERT INTO `test` (`id`, `txt`) VALUES ('1', 'test "test" test'); Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save. <phpmyadmin> SELECT `id`,`txt` FROM `test` WHERE 1 AND `id` LIKE \"1\" LIMIT 0, 30 MySQL said: You have an error in your SQL syntax near '\"1\" LIMIT 0, 30' at line 1 </phpmyadmin> No problem if you key is an int. Yuk. Regards, Alain. P.S : php 4.0.5, phpmyadmin cvs, mysql 3.23.39

2 5