#47387 [Opn]: Load stmt result bool false

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: Open Bug Type: MySQLi related Operating System: Linux mandriva 2009 PHP Version: 5.3CVS-2009-02-14 (snap) New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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 tooljn@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] johannes@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. ------------------------------------------------------------------------ [2009-02-15 08:25:30] lars dot a dot johansson at se dot atlascopco dot com Hi again, Im running mysql 5.1.30 CE. I run my queries one by one in mysqli->query(xxx). Running the script via mysql source stmt also works ok. I also run other load scripts under 5.3 that runs ok. Note using PHP 5.2.2 works as expected and differs from 5.3. It is not easy to ship this code, its in the middle of a rather complex multitasking job control system, so if further debugging is needed it is probably easier if someone give me instructions how to debug and what to look for. ------------------------------------------------------------------------ [2009-02-14 16:06:32] lars dot a dot johansson at se dot atlascopco dot com Description: ------------ Hi, I run three simple queries i mysqli->query 1 Exec use test; 2 CREATE TABLE...; 3 LOAD DATA LOCAL INFILE...; when I run this in 5.2.2 the result is true for all 3 queries. when I run this in 5.3 the result for the LOAD statement is false, but I can not find any problem with the LOAD, it loads as good as in 5.2.2. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47387&edit=1