ID: 47387
User updated by: lars dot a dot johansson at se dot atlascopco dot com
Reported By: lars dot a dot johansson at se dot atlascopco dot com
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: Linux mandriva 2009
PHP Version: 5.3CVS-2009-02-14 (snap)
New Comment:
Hi,
I compiled with --enable-debug, but, I use SAPRFC in this scenario, it
does not compile with debug. And it seems PHP debug does not play with
dynamic modules compiled without debug. I see if I can force this bug?
some other way.
Previous Comments:
------------------------------------------------------------------------
[2009-02-17 19:06:36] johan...@php.net
Would be great if you can narrow it down a bit more, Setting to
"Feedback" for tracking this better. Thank you.
------------------------------------------------------------------------
[2009-02-17 18:50:05] lars dot a dot johansson at se dot atlascopco dot
com
hi again,
the logon was a red herring. I used the wrong userid.
I cannot reproduce the error with my abrevaited test program.
It works as it should.
Still my original program do not work the same in 5.3 as it did in 5.2.
I do not think I have time work on this util the weekend.
------------------------------------------------------------------------
[2009-02-17 17:42:02] lars dot a dot johansson at se dot atlascopco dot
com
Hi again,
I created a smaller program
#!/home/tooljn/PHP5.3/local/bin/php
<?php
// #!/home/tooljn/PHP/php-5.2.6/sapi/cli/php
// #!/usr/local/bin/php
// #!/home/tooljn/PHP5.3/local/bin/php
// #!/home/tooljn/PHP/php5.3-200802231330/sapi/cli/php
mysqli_report(MYSQLI_REPORT_ERROR);
$sqlhost='192.168.1.9';
$sqluser='uuuuu';
$sqlpw='pppppp';
$sqldb='test';
$port='3306';
$mysqli = new mysqli("$sqlhost", "$sqluser", "$sqlpw",
"$sqldb",$port);
$result = $mysqli->query('use test;');
var_dump($result);
$result = $mysqli->query('CREATE TABLE IF NOT EXISTS PROJECT_DETAIL
(`PROJECT_DEFINITION` CHAR(24),`DESCRIPTION` CHAR(40),`MASK_ID`
CHAR(24),`RESPONSIBLE_NO` DECIMAL(8,0),`APPLICANT_NO`
DECIMAL(8,0),`COMP_CODE` CHAR(4),`BUS_AREA` CHAR(4),`CONTROLLING_AREA`
CHAR(4),`PROFIT_CTR` CHAR(10),`PROJECT_CURRENCY`
CHAR(5),`PROJECT_CURRENCY_ISO` CHAR(3),`NETWORK_ASSIGNMENT`
DECIMAL(1,0),`START` DATE,`FINISH` DATE,`PLANT` CHAR(4),`CALENDAR`
CHAR(2),`PLAN_BASIC` DECIMAL(1,0),`PLAN_FCST` DECIMAL(1,0),`TIME_UNIT`
CHAR(3),`TIME_UNIT_ISO` CHAR(3),`NETWORK_PROFILE`
CHAR(7),`PROJECT_PROFILE` CHAR(7),`BUDGET_PROFILE`
CHAR(6),`PROJECT_STOCK` CHAR(1),`OBJECTCLASS` CHAR(2),`STATISTICAL`
CHAR(1),`TAXJURCODE` CHAR(15),`INT_PROFILE` CHAR(7),`WBS_SCHED_PROFILE`
CHAR(12),`CSH_BDGT_PROFILE` CHAR(6),`PLAN_PROFILE`
CHAR(6),`JOINT_VENTURE` CHAR(6),`RECOVERY_IND` CHAR(2),`EQUITY_TYPE`
CHAR(3),`JV_OBJECT_TYPE` CHAR(4),`JV_JIB_CLASS`
CHAR(3),`JV_JIB_SUB_CLASS_A` CHAR(5),`DELETION_FLAG`
CHAR(1),`OBJECTCLASS_EXT` CHAR(5),`FUNC_AREA` CHAR(4),`FUNC_AREA_LONG`
CHAR(16)
,PRIMARY KEY (`PROJECT_DEFINITION`));');
var_dump($result);
$result = $mysqli->query("LOAD DATA LOCAL INFILE
'PROJECT_DEFINITION_STRU.CSV' replace INTO TABLE PROJECT_DETAIL FIELDS
TERMINATED BY ';' IGNORE 0
LINES(`PROJECT_DEFINITION`,`DESCRIPTION`,`MASK_ID`,`RESPONSIBLE_NO`,`APPLICANT_NO`,`COMP_CODE`,`BUS_AREA`,`CONTROLLING_AREA`,`PROFIT_CTR`,`PROJECT_CURRENCY`,`PROJECT_CURRENCY_ISO`,`NETWORK_ASSIGNMENT`,`START`,`FINISH`,`PLANT`,`CALENDAR`,`PLAN_BASIC`,`PLAN_FCST`,`TIME_UNIT`,`TIME_UNIT_ISO`,`NETWORK_PROFILE`,`PROJECT_PROFILE`,`BUDGET_PROFILE`,`PROJECT_STOCK`,`OBJECTCLASS`,`STATISTICAL`,`TAXJURCODE`,`INT_PROFILE`,`WBS_SCHED_PROFILE`,`CSH_BDGT_PROFILE`,`PLAN_PROFILE`,`JOINT_VENTURE`,`RECOVERY_IND`,`EQUITY_TYPE`,`JV_OBJECT_TYPE`,`JV_JIB_CLASS`,`JV_JIB_SUB_CLASS_A`,`DELETION_FLAG`,`OBJECTCLASS_EXT`,`FUNC_AREA`,`FUNC_AREA_LONG`);");
var_dump($result);
that gives me this output
too...@tooseww14 projectDetails0]$ ./err53.php
PHP Warning: mysqli::mysqli(): OK packet 6 bytes shorter than expected
in /home/tooljn/dw/data/090217173424_chopsap01/projectDetails0/err53.php
on line 13
PHP Warning: mysqli::mysqli(): (HY000/2000): mysqlnd cannot connect to
MySQL 4.1+ using old authentication in
/home/tooljn/dw/data/090217173424_chopsap01/projectDetails0/err53.php on
line 13
PHP Warning: mysqli::query(): Couldn't fetch mysqli in
/home/tooljn/dw/data/090217173424_chopsap01/projectDetails0/err53.php on
line 14
NULL
PHP Warning: mysqli::query(): Couldn't fetch mysqli in
/home/tooljn/dw/data/090217173424_chopsap01/projectDetails0/err53.php on
line 18
NULL
PHP Warning: mysqli::query(): Couldn't fetch mysqli in
/home/tooljn/dw/data/090217173424_chopsap01/projectDetails0/err53.php on
line 20
NULL
I have to find out why I can logon in my original program and not here.
I hope I can fix this in the next comming hour.
------------------------------------------------------------------------
[2009-02-17 17:01:48] lars dot a dot johansson at se dot atlascopco dot
com
Hi
I cut down the infile to one row:
F-1490;Honeywell - Crowfoot C340 et roue de
sor;;31150004;0;GREA;;3000;0033012001;EUR;EUR;2;20060214;20060315;3115;ZN;4;1;TAG;DAY;ZFRN002;ZFRN001;ZFRN01;X;PR;;;;ZFRN00000001;000001;ZFN002;;;;;;;;;2061;2061
php 5.3 also gives this err msg:
PHP Warning: mysqli::query(): (00000/0): in
/home/tooljn/dw/pgm/include/scriptEx.php on line 262
my 3 queries are generated by my PHP code and look like this:
use test;
CREATE TABLE IF NOT EXISTS PROJECT_DETAIL (`PROJECT_DEFINITION`
CHAR(24),`DESCRIPTION` CHAR(40),`MASK_ID` CHAR(24),`RESPONSIBLE_NO`
DECIMAL(8,0),`APPLICANT_NO` DECIMAL(8,0),`COMP_CODE` CHAR(4),`BUS_AREA`
CHAR(4),`CONTROLLING_AREA` CHAR(4),`PROFIT_CTR`
CHAR(10),`PROJECT_CURRENCY` CHAR(5),`PROJECT_CURRENCY_ISO`
CHAR(3),`NETWORK_ASSIGNMENT` DECIMAL(1,0),`START` DATE,`FINISH`
DATE,`PLANT` CHAR(4),`CALENDAR` CHAR(2),`PLAN_BASIC`
DECIMAL(1,0),`PLAN_FCST` DECIMAL(1,0),`TIME_UNIT`
CHAR(3),`TIME_UNIT_ISO` CHAR(3),`NETWORK_PROFILE`
CHAR(7),`PROJECT_PROFILE` CHAR(7),`BUDGET_PROFILE`
CHAR(6),`PROJECT_STOCK` CHAR(1),`OBJECTCLASS` CHAR(2),`STATISTICAL`
CHAR(1),`TAXJURCODE` CHAR(15),`INT_PROFILE` CHAR(7),`WBS_SCHED_PROFILE`
CHAR(12),`CSH_BDGT_PROFILE` CHAR(6),`PLAN_PROFILE`
CHAR(6),`JOINT_VENTURE` CHAR(6),`RECOVERY_IND` CHAR(2),`EQUITY_TYPE`
CHAR(3),`JV_OBJECT_TYPE` CHAR(4),`JV_JIB_CLASS`
CHAR(3),`JV_JIB_SUB_CLASS_A` CHAR(5),`DELETION_FLAG`
CHAR(1),`OBJECTCLASS_EXT` CHAR(5),`FUNC_AREA` CHAR(4),`FUNC_AREA_LONG`
CHAR(16)
,PRIMARY KEY (`PROJECT_DEFINITION`));
LOAD DATA LOCAL INFILE 'PROJECT_DEFINITION_STRU.CSV' replace INTO
TABLE PROJECT_DETAIL FIELDS TERMINATED BY ';' IGNORE 0
LINES(`PROJECT_DEFINITION`,`DESCRIPTION`,`MASK_ID`,`RESPONSIBLE_NO`,`APPLICANT_NO`,`COMP_CODE`,`BUS_AREA`,`CONTROLLING_AREA`,`PROFIT_CTR`,`PROJECT_CURRENCY`,`PROJECT_CURRENCY_ISO`,`NETWORK_ASSIGNMENT`,`START`,`FINISH`,`PLANT`,`CALENDAR`,`PLAN_BASIC`,`PLAN_FCST`,`TIME_UNIT`,`TIME_UNIT_ISO`,`NETWORK_PROFILE`,`PROJECT_PROFILE`,`BUDGET_PROFILE`,`PROJECT_STOCK`,`OBJECTCLASS`,`STATISTICAL`,`TAXJURCODE`,`INT_PROFILE`,`WBS_SCHED_PROFILE`,`CSH_BDGT_PROFILE`,`PLAN_PROFILE`,`JOINT_VENTURE`,`RECOVERY_IND`,`EQUITY_TYPE`,`JV_OBJECT_TYPE`,`JV_JIB_CLASS`,`JV_JIB_SUB_CLASS_A`,`DELETION_FLAG`,`OBJECTCLASS_EXT`,`FUNC_AREA`,`FUNC_AREA_LONG`);
------------------------------------------------------------------------
[2009-02-17 16:21:48] johan...@php.net
Can you please give the configure line and check whether the file
you're trying to read is properly formatted. How big is the file?
For getting more debug data you could try to compile using
--with-mysqli=mysqlnd and --enable-debug and then set
mysqlnd.debug=t:o,/tmp/mysqlnd.trace
in your php.ini. This generates a file /tmp/mysqlnd.trace please
provide that for further investigation.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/47387
--
Edit this bug report at http://bugs.php.net/?id=47387&edit=1
