TbsSQL 3.2 fails -- no error message

I'm using PHP 5.4.4 and MySQLi 5.5.25a.  Executing attempt 1 below, "@new MySQLi($db_params...,", I am successful.  Executing attempt 2 "    $db = new clsTbsSQL();", I am not successful.  The code from the class appears to hang up on line 882 of tbssql_mysqli.php, the "@new MySQLi..." statement of "_Dbs_Connect()".
My copy of config.php contains the value of $db_params as a global value.  My copy of tbssql_mysqli.php has not been changed except to add a few (?) echos and var_dumps to confirm that I have the values that I think I do at different points.  I do.
Help is appreciated.

Hi,

Don't you have any error message ?

Hi.
No error message.  The last output was the echo  beginning "attempt 2...".  I suspect that the code hung or went into a loop rather than failed.

I erred in noting line 882 was where the code hung up.  My diagnostic echos distorted the actual location.  The rest of the statement still stands.

If your snippet is copy/past of your original code then I can say it cannot work.
If class_exists('clsTbsSql') is true, then the snippet does not try to connect.

This snippet is not a part of my original code.
If the class did exist, I'd get the message that it existed, but I don't.  I get the message that "clsTbsSql" doesn't exist".  The code hangs on the statement "$db = new cslTbsSQL()".  More accurately, it hangs on the statement in tbssql_mysqli.php, function _Dbs_Connect() , at the "@new MySQLi..." statement.

>If the class did exist, I'd get the message that it existed, but I don't.

Maybe because of the case clsTbsSql vs clsTbsSQL.


I cannot try your configuration with PHP 5.4.4 for now.

But I suggest that you track the problem by changing :
with :
in the source code of TbsSQL.

This should display the full error message of MySQLi.
You can also take the opportunity to check variables  $srv, $uid, $pwd and $db, and see of the values are what you're expecting.

Writing clsTbsSQL instead of clsTbsSql was a big oversight on my part, but unfortunately fixing it didn't solve the problem.

I changed the source code of the @new MySQLi statement, removing the "@" sign, but I got no error message.  This is why I suspect that there is a loop or something to make the code hang within "new MySQLi".  If this is true, then the problem is not mine or TBS', but something with php-mysql.  I am just wondering if you'd heard of it.

I have an echo statement to check the connection variables.  They are what I expect.

In my snippit, "attempt 1", where MySQLi is executed outside of a class, the connection is successful.  It fails when I attempt to connect from within a class, such as clsTbsSql.

I added a class that doesn't use clsTbsSql to my test which connects to mysqli.  It works.  But when I try to connect with clsTbsSql, it still doesn't work. (My software,is PHP 5.4.4 and MySQLi 5.5.25a)  Here is my latest test program followed by the results.  Notice that the Id in the first two tests is populated and that there are no errors.

Results:
Executed outside of any class
object(mysqli)#1 (19) { ["affected_rows"]=> int(0) ["client_info"]=> string(75) "mysqlnd 5.0.10 - 20111026 - $Id: b0b3b15c693b7f6aeb3aa66b646fee339f175e39 $" ["client_version"]=> int(50010) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(0) ["host_info"]=> string(15) "erie via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "5.5.27" ["server_version"]=> int(50527) ["stat"]=> string(132) "Uptime: 5122 Threads: 1 Questions: 30 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.005" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(17) ["warning_count"]=> int(0) }

Executed within TestMysqli class that I wrote
$obj = TestMysqli Object ( [Id] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.10 - 20111026 - $Id: b0b3b15c693b7f6aeb3aa66b646fee339f175e39 $ [client_version] => 50010 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => erie via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.27 [server_version] => 50527 [stat] => Uptime: 5122 Threads: 2 Questions: 30 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.005 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 18 [warning_count] => 0 ) )

Executing clsTbsSql
clsTbsSql::_Dbs_Prepare()"
$db: object(clsTbsSql)#4 (15) { ["Version"]=> string(47) "3.2 for MySQL with Improved Extrension (mysqli)" ["Id"]=> bool(false) ["SqlNull"]=> string(4) "NULL" ["DefaultRowType"]=> string(5) "array" ["CacheDir"]=> string(1) "." ["CacheTimeout"]=> bool(false) ["TempCacheTimeout"]=> bool(false) ["CacheAutoClear"]=> int(10080) ["CacheSuffix"]=> string(0) "" ["InitMsg"]=> bool(true) ["InitCsl"]=> bool(true) ["_CacheCurrSql"]=> bool(false) ["Mode"]=> int(1) ["TbsKey"]=> string(6) "tbssql" ["_Tbs_FetchFct"]=> &string(20) "_Tbs_RsFetch_Default" }
clsTbsSql::Connect
clsTbsSql::Connect:before $this_Dbs_Connect
clsTbsSql::_Dbs_Connect:$this->Mode = "1"
clsTbsSql::_Dbs_Connect:before calling new MySQLi
function_exists('mysqli_connect') = bool(true)
---
It looks as though clsTbsSql hangs.

Hi Alan,

I've tested your test code and it worked for me on PHP 5.4.3 + MySQLi 5.5.24-log.


I need more time to test on PHP 5.4.4.

Here's a workaround from the __construct function of my own Database class:
You had mentioned doing something like this in the TbsSql manual, but I had overlooked it.
Thanks for working on this, Skrol.