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 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`);
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[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
