PEAR Bug Search Results

MDB2_Driver_mysqli: Bug 23776 [Open] extensions not installed

cashfromhome at usa dot com — 2018-11-18T07:08:48+00:00

MDB2_Driver_mysqli Bug
Reported by cdobay65
2018-11-18T07:08:48+00:00
PHP: 5.6.11 OS: windows10 Package Version: Unknown

Description:
------------
Missing extensions mygsqli and gd, but when I look they are checked in the version that I am running. So what would cause me not to be able to install a program from the c-panel?

MDB2_Driver_mysqli: Feature/Change Request 21122 [Open] SSL connections using mysqlnd as client require server auth.

radams at circlepix dot com — 2016-10-05T22:26:27+00:00

MDB2_Driver_mysqli Feature/Change Request
Reported by smada
2016-10-05T22:26:27+00:00
PHP: Irrelevant OS: Ubuntu Package Version: 1.5.0b4

Description:
------------
According to the documentation here 
(http://us3.php.net/manual/en/mysqli.options.php), MySQLi allows a flag 
for not verifying the server certificate 
(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT).  However, I don't think that 
flag is being used by the mysqlnd client.  Instead, according to the 
documentation (http://us3.php.net/manual/en/mysqli.real-connect.php), 
there is a new flag required to connect using SSL and to not verify the 
server certificate.  The flag is passed as a parameter to 
mysqli_real_connect, which means the code in MDB2_Driver_mysqli 
needs to be changed, since it currently doesn't use that parameter at all.

Test script:
---------------
    $dsn = 'mysqli://user:password@server/db?key=client-key.pem&cert=client-cert.pem';
    $options = array('ssl' => true, 'dont_verify_cert' => true);
    $db = MDB2::connect($dsn, $options);


Expected result:
----------------
Should connect using ssl.

Actual result:
--------------
Fails to connect.

MDB2_Driver_mysqli: Bug 20441 [Open] System update

medjomeman at hotmail dot fr — 2014-11-17T23:11:42+00:00

MDB2_Driver_mysqli Bug
Reported by mbiama
2014-11-17T23:11:42+00:00
PHP: 5.6.3 OS: Linux Package Version: 1.4.1

Description:
------------
DataObject not working better
Warning: in_array() expects parameter 2 to be array, boolean given in 10.php on line 707
PHP Warning:  in_array() expects parameter 2 to be array, boolean given in /usr/local/lib/php/PEAR/REST/10.php on line 707



Test script:
---------------
Updating âMDB2_Driver_mysqliâ â¦ PHP Extensions and Applications Package

Expected result:
----------------
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/curl.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/curl.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/bz2.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/bz2.so: open shared object file: Such file or directory in Apache2 on line 707
PHP Warning:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/zip.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/zip.so: open shared object file: Such file or directory in Apache2 on line 707
PHP Warning:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/mbstring.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/mbstring.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/Core.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/Core.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/dbase.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/dbase.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/ereg.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/ereg.so: open shared object file: Such file or directory in Unknown on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/exif.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/exif.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/gettext.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/gettext.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/imap.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/imap.so: open shared object file: No such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/intl.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/intl.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/ionCube.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/ionCube.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/Loader.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/Loader.so: open shared object file: Such file or directory in Apache2 on line 707
PHP Warning:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/mysqli.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/mysqli.so: open shared object file: Such file or directory in Apache2 on line 7Â°7
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/openssl.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/openssl.so: open shared object file: Such file or directory in Apache on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/pspell.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/pspell.so: open shared object file: No such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/sqlite3.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/sqlite3.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/tidy.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/tidy.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/wddx.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/wddx.so: open shared object file: Such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/xmlrpc.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/xmlrpc.so: open shared object file: such file or directory in Apache2 on line 707
PHP ini_get("include_path")  );:  PHP Startup: Unable to load dynamic library '/home/angosson/lib/php/extensions/debug-zts-20100525/soap.so' - /home/angosson/lib/php/extensions/debug-zts-20100525/soap.so: open shared object file: such file or directory in Apache2 on line 707



Actual result:
--------------
Notice: unserialize(): Error at offset 1923 of 13660 bytes in Registry.php on line 1145

Notice: unserialize(): Error at offset 1923 of 13660 bytes in Registry.php on line 1145

MDB2_Driver_mysqli: Bug 19965 [Open] Double escaping id escaping_wildcards

opi at gmx dot at — 2013-05-30T19:51:10+00:00

MDB2_Driver_mysqli Bug
Reported by alex_le
2013-05-30T19:51:10+00:00
PHP: 5.4.15 OS: Linux Package Version: 1.5.0b4

Description:
------------
in function escape/quote, if you set $escape_wildcards to true, then the escape will be double escaped.

Test script:
---------------
var_dump($mdb2->escape('Test_1', true));
var_dump($mdb2->quote('Test_1', 'text', true, true));

Expected result:
----------------
Test\_1
'Test\_1'

Actual result:
--------------
Test\\_1
'Test\\_1'

MDB2_Driver_mysqli: Feature/Change Request 19888 [Open] It would be useful if getTableFieldDefinition returns comments that may be set

ken at linux dot ie — 2013-04-09T02:32:03+00:00

MDB2_Driver_mysqli Feature/Change Request
Reported by kguest
2013-04-08T23:23:16+00:00
PHP: 5.4.6 OS: n/a Package Version: 

Description:
------------
It would be useful if the tableInfo method also returned the comments that might be set against the fields in whichever table is being investigated.

MDB2_Driver_mysqli: Bug 19729 [Open] URLs are forcely converted to the content of URL

ikeda at mrfusion dot co dot jp — 2012-11-30T08:02:57+00:00

MDB2_Driver_mysqli Bug
Reported by pear_ikd
2012-11-30T08:02:57+00:00
PHP: 5.3.3 OS: CentOS release 5.8 Package Version: 1.5.0b4

Description:
------------
The version 1.5.0b4 beta of this driver forcely converts a clob 
/ blob field value to the content exressed by the value ,
when the value is matched to URL pattern and so on.
For example, you cannnot insert the value 
'https://pear.php.net/' to clob field.

This feature is implemented by the code below.

line: 1612
 if (is_resource($value) || $type == 'clob' || $type == 'blob' 
&& $this->db->options['lob_allow_url_include']) 

This code seems to include incidental mistake about 
precedence of logical operater.?The corrent code is bellow.

line: 1612
 if (is_resource($value) || (($type == 'clob' || $type == 
'blob') && $this->db->options['lob_allow_url_include']))

MDB2_Driver_mysqli: Bug 19586 [Assigned] rev 327099 introduced "Undefined index: charset"

danielc at analysisandsolutions dot com — 2012-08-27T21:23:00+00:00

MDB2_Driver_mysqli Bug
Reported by danielc
2012-08-27T21:22:42+00:00
PHP: 5.4.6 OS:  Package Version: SVN

Description:
------------
When running the unit tests the following notice came up:

Notice: Undefined index: charset in MDB2/Driver/mysqli.php on line 1003

This was introduced in rev 327099 by afz.  I reverted the change for now until a more complete fix can be created.

Right now all of the unit tests pass.

What is trying to be fixed here?  Please open a ticket for it.  This helps when creating the change log.  Please include unit tests demonstrating the problem and the fix.

MDB2_Driver_mysqli: Bug 18531 [Open] Multibyte characters not handled in prepare

sdanzig at gmail dot com — 2011-05-12T21:40:57+00:00

MDB2_Driver_mysqli Bug
Reported by sdanzig
2011-05-12T21:40:57+00:00
PHP: 5.3.0 OS: Windows XP SP 3 Package Version: 1.4.1

Description:
------------
When preparing a query with foreign characters, prepare fails.  
The prepare statement uses strpos to find the position of 
placeholders (in my case, question marks)..then uses simple 
array indexing to try to access this character.  However, the 
memory representation is different from the string representation 
in the instance where some multibyte characters are used.  I 
fixed this using mb_substr() in the 3 places where array indexing 
on the query is used in prepare().

MDB2_Driver_mysqli: Bug 17207 [Open] prepare()d statement with MDB2_PREPARE_MANIP fails to execute

szbeam at gmail dot com — 2010-03-09T05:24:45+00:00

MDB2_Driver_mysqli Bug
Reported by szbeamaroo
2010-03-09T05:24:45+00:00
PHP: 5.3.0 OS: OS X - Snow Leopard Package Version: 1.4.1

Description:
------------
When specifying MDB2_PREPARE_MANIP when preparing an INSERT 
statement, the subsequent execute() fails, with mysqli_stmt_execute() 
returning 0 instead of 1.

Leaving the 3rd parameter to prepare() out, the statement will execute. 
However this results in the return value from execute() being an 
MDB2_Result_Common object instead of an integer, which breaks 
expectations.

This may be an underlying driver problem, as the same code below 
works as expected on Linux.

$ mysql -V
mysql  Ver 14.14 Distrib 5.1.44, for apple-darwin10.2.0 (i386) using 
readline 5.1


Test script:
---------------
$mdb2 =& MDB2::connect(DB_DSN);
$mdb2->setOption('debug',2);
$sth = $mdb2->prepare('INSERT INTO numbers (number) VALUES (?)', array('integer'), MDB2_PREPARE_MANIP);
$sth->execute(1);
$sth->execute(8);

var_dump($mdb2->getDebugOutput());


Expected result:
----------------
successful insert of numbers to the numbers table, and output from the 
debug line.

Actual result:
--------------
here is a backtrace of the error caught via my PEAR_ERROR_CALLBACK 
handler -

pear_error_handler)) called at [/usr/lib/php/PEAR.php:955]
#2  PEAR_Error->PEAR_Error(MDB2 Error: unknown error, -1, 16, 
pear_error_handler, _execute: [Error message: Unable to execute 
statement]
[Last executed query: INSERT INTO numbers (number) VALUES (?)]
[Native code: 0]
) called at [/usr/lib/php/MDB2.php:973]
#3  MDB2_Error->MDB2_Error(, 16, pear_error_handler, _execute: 
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO numbers (number) VALUES (?)]
[Native code: 0]
) called at [/usr/lib/php/PEAR.php:564]
#4  PEAR->raiseError(, , , , _execute: [Error message: Unable to 
execute statement]
[Last executed query: INSERT INTO numbers (number) VALUES (?)]
[Native code: 0]
, MDB2_Error, 1) called at [/usr/lib/php/MDB2.php:1442]
#5  MDB2_Driver_Common->raiseError(, , , Unable to execute 
statement, _execute) called at 
[/usr/lib/php/MDB2/Driver/mysqli.php:1574]
#6  MDB2_Statement_mysqli->_execute(1, ) called at 
[/usr/lib/php/MDB2.php:4065]
#7  MDB2_Statement_Common->execute(1) called at 
[/Users/sbeam/Sites/dnl/util/test.php:10

MDB2_Driver_mysqli: Bug 17091 [Open] result_buffering is working only with multi_query (?)

alec at alec dot pl — 2010-02-12T18:56:49+00:00

MDB2_Driver_mysqli Bug
Reported by alec
2010-02-12T18:56:49+00:00
PHP: Irrelevant OS:  Package Version: CVS

Description:
------------
I'm not sure about this but something's wrong in these code snippet from _doQuery()

if ($this->options['multi_query']) {
            $result = mysqli_multi_query($connection, $query);
        } else {
            $resultmode = $this->options['result_buffering'] ? MYSQLI_USE_RESULT : MYSQLI_USE_RESULT;
            $result = mysqli_query($connection, $query);
        }

if ($this->options['multi_query']) {
            if ($this->options['result_buffering']) {
                if (!($result = @mysqli_store_result($connection))) {
                    $err =& $this->raiseError(null, null, null,
                        'Could not get the first result from a multi query', __FUNCTION__);
                    return $err;
                }
            } elseif (!($result = @mysqli_use_result($connection))) {
                $err =& $this->raiseError(null, null, null,
                        'Could not get the first result from a multi query', __FUNCTION__);
                return $err;
            }
        }

MDB2_Driver_mysqli: Feature/Change Request 16238 [Open] BIT data type reports as unsupported

rob at tdd dot org dot uk — 2009-05-21T19:31:09+00:00

MDB2_Driver_mysqli Feature/Change Request
Reported by mightymephisto
2009-05-19T02:46:12+00:00
PHP: 5.2.5 OS: Debian Package Version: 1.5.0b2

Description:
------------
Since MySQL 5.0.3 the BIT data type is no longer treat as TINYINT(1)

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

Please add this data type to the _mapNativeDatatype function, and to the mysql driver too.

MDB2_Driver_mysqli: Bug 12311 [Open] can't createTable() with infos from tableInfo(), if I have TIMESTAMP columns

carsten_sttgt at gmx dot de — 2007-10-23T14:39:57+00:00

MDB2_Driver_mysqli Bug
Reported by cwiedmann
2007-10-23T14:39:57+00:00
PHP: Irrelevant OS: Irrelevant Package Version: 1.4.1

Description:
------------
Hello,

in addition to Bug #10488, I think there is another problem: If you have a TIMESTAMP column in MySQL you can't recreate this column with the manager module as it was, with the information from the reverse module.

Because a DEFAULT CURRENT_TIMESTAMP is illegal for a DATETIME column in MySQL, which the manager create instead of a TIMESTAMP. And yes: it's really a difference between a DATETIME and a TIMESTAMP. And if there was a TIMESTAMP, I want to have a TIMESTAMP ;-) In the constructor I told MDB2 that I want use MySQL, and so I should be able to use all basic features from this DB (without using e.g. custom types).

Another thing I'm missing:
If I create the original column with an additional "ON UPDATE CURRENT_TIMESTAMP", I don't get this info from the reverse module tableInfo(). (For this I can make a patch.)

BTW:
On this manual page [1] you can read, that MDB is creating a TIMESTAMP in MySQL, and not a DATETIME.

Regards,
Carsten

[1] http://pear.php.net/manual/en/package.database.mdb2.datatypes.php#AEN38081


Test script:
---------------
getDebugInfo());
}
PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'printError');

$dsn      = 'mysqli://root@localhost/test';
$dbTable = 'mdb2test';

$mdb2 = MDB2::connect($dsn);
$mdb2->loadModule('Manager');
$mdb2->loadModule('Reverse', null, true);

echo 'Created table with e.g. phpMyAdmin:'.PHP_EOL;
$sql = <<exec($sql);

/* Use this for a negative test */
$sql = <<exec($sql);

echo 'Get tableInfo() from the original table:'.PHP_EOL;
$oldDefinition = $mdb2->tableInfo($dbTable);
var_dump($oldDefinition);
echo PHP_EOL;

echo 'dropTable()'.PHP_EOL.PHP_EOL;
$mdb2->dropTable($dbTable);

echo 'Show MDB2 FieldDeclaration:'.PHP_EOL;
$definition = array ();
foreach ($oldDefinition as $value) {
    $definition[$value['name']] = array(
        'type'    => $value['mdb2type'],
        'notnull' => $value['notnull'],
        'default' => $value['default'],
    );
}
echo "CREATE TABLE $dbTable (".PHP_EOL;
echo "    ".$mdb2->getFieldDeclarationList($definition).PHP_EOL;
echo ")".PHP_EOL.PHP_EOL;

echo 'createTable()'.PHP_EOL.PHP_EOL;
$mdb2->createTable($dbTable, $definition);


echo 'Get tableInfo() from the new table:'.PHP_EOL;
$newDefinition = $mdb2->tableInfo($dbTable);
var_dump($newDefinition);
echo PHP_EOL;

echo 'Are old and new tableInfo() the same?'.PHP_EOL;
var_dump($oldDefinition == $newDefinition);
echo PHP_EOL;
?>


Expected result:
----------------
No error message and the arrays $old_definition and $new_definition should be equal.


Actual result:
--------------
Created table with e.g. phpMyAdmin:
CREATE TABLE mdb2test (
    updatetime TIMESTAMP NOT NULL
    DEFAULT CURRENT_TIMESTAMP
);

Get tableInfo() from the original table:
array(1) {
  [0]=>
  array(8) {
    ["notnull"]=>
    bool(true)
    ["nativetype"]=>
    string(9) "timestamp"
    ["default"]=>
    string(17) "CURRENT_TIMESTAMP"
    ["type"]=>
    string(9) "timestamp"
    ["mdb2type"]=>
    string(9) "timestamp"
    ["name"]=>
    string(10) "updatetime"
    ["table"]=>
    string(8) "mdb2test"
    ["flags"]=>
    string(35) " not_null default_CURRENT_TIMESTAMP"
  }
}

dropTable()

Show MDB2 FieldDeclaration:
CREATE TABLE mdb2test (
    updatetime DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
)

createTable()

_doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE  TABLE mdb2test (updatetime DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL)]
[Native code: 1067]
[Native message: Fehlerhafter Vorgabewert (DEFAULT) fÃ¼r 'updatetime']