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
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
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
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
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
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/
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/
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
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.
Ok my subject is for fun, but seriously, I received an email
with an attached file:
phpMyAdmin-2.2.0rc3-php3.zip.bat
asking to take a look at the file.
I guess that depending on my email client, I could have seen
phpMyAdmin-2.2.0rc3-php3.zip and be tempted to double-click it.
Well I didn't because this contains a virus.
Bye
Marc