Sebastian,
it's a phpMyAdmin bug. In PMA_DBI_try_query() we should check for the number of affected rows and store it, before issuing the SHOW WARNINGS.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=326580
Originator: NO
cannot confirm
please provide code/steps to reproduce
and/or try on http://pma.cihar.com/STABLE/ (root, no pw)
Logged In: YES
user_id=30264
Originator: YES
Output (dutch):
Ingevoegde rijen: 3
Ingevoegde rij id: 7
Warning (1364): Field 'info_hash' doesn't have a default value
Input:
SQL-query:
INSERT INTO `testdb`.`xbt_files` (
`fid` ,
`leechers` ,
`seeders` ,
`completed` ,
`flags` ,
`mtime` ,
`ctime`
)
VALUES (
NULL , '0', '0', '0', '0', '', ''
);
Logged In: YES
user_id=326580
Originator: NO
please add
- MySQL server version
- php-mysql library version
- table structure
Logged In: YES
user_id=30264
Originator: YES
Don't you know what http://pma.cihar.com/STABLE/ is running?
Logged In: YES
user_id=326580
Originator: NO
you did not said and i did not noticed that you created a test environment there ... i take a look ...
Logged In: YES
user_id=326580
Originator: NO
seems to be a php mysqli bug - reported
http://bugs.php.net/41325
Logged In: YES
user_id=210714
Originator: NO
Sebastian,
on http://bugs.php.net/41325 there is a quote error in your code. You need something like:
$sql = "INSERT INTO `test` (`int`, `int2`) VALUES ('', '')";
I can reproduce the problem in phpMyAdmin, but your test script produces 1 on the same system (PHP 5.2.2, MySQL 5.0.37).
Logged In: YES
user_id=210714
Originator: NO
Sebastian,
it's a phpMyAdmin bug. In PMA_DBI_try_query() we should check for the number of affected rows and store it, before issuing the SHOW WARNINGS.
Logged In: YES
user_id=326580
Originator: NO
yes, i know - now
see php bug report
Logged In: YES
user_id=210714
Originator: NO
However I still don't see how your test script could say 2.
Logged In: YES
user_id=326580
Originator: NO
it does not ...
Logged In: YES
user_id=326580
Originator: NO
fixed in trunk and QA_2_10