#2 Cannot write data with phpMyAdmin

[Niels Ulrik Andersen]

I’ve noticed that phpmyadmin does not function when
used through the proxy. When I go to insert a record
via the phpmyadmin interface, no matter what I put in
the blanks it inserts a blank record into the DB. I
cant edit the record to change it either. When I do it
remains blank after saving.

(Reported by a user)

[Nobody/Anonymous]

Logged In: NO

I've noticed the same problem.

You can still use direct SQL queries to update or insert rows, but only if magic quotes is turned off.

If magic quotes is on you can get around it by putting this code after //// End of config

set_magic_quotes_runtime(FALSE);

if (get_magic_quotes_gpc()) {
/*
All these global variables are slash-encoded by default,
because magic_quotes_gpc is set by default!
(And magic_quotes_gpc affects more than just $_GET, $_POST, and $_COOKIE)
*/
$_SERVER = stripslashes_array($_SERVER);
$_GET = stripslashes_array($_GET);
$_POST = stripslashes_array($_POST);
$_COOKIE = stripslashes_array($_COOKIE);
}

function stripslashes_array($data) {
if (is_array($data)){
foreach ($data as $key => $value){
$data[$key] = stripslashes_array($value);
}
return $data;
}else{
return stripslashes($data);
}
}

[adisurya]

Logged In: YES
user_id=1748015
Originator: NO

Is it same with this?

Warning: Invalid argument supplied for foreach() in /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php on line 155

Warning: Invalid argument supplied for foreach() in /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php on line 155

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php:155) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ob.lib.php on line 61

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php:155) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 13

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php:155) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php:155) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 15

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php:155) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 16

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_replace.php:155) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 19
Server: localhost
Error

SQL query: Edit

INSERT INTO (
)
VALUES (
), (
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() VALUES (), ()' at line 1

My configuration in php.ini (public_html/cpanel/)
magic_quotes_gpc = Off
magic_quotes_runtime = Off

[Nobody/Anonymous]

Years later, bug remains (imagine that!) The software has not changed, but it still doesn't work!