編程中的出錯信息
返回
<![CDATA[
Argument "P0" isn't numeric in multiplication (*) at ./pro/mscenq1.pl line 761, <CONFIG> line 12., referer:
Argument "P2" isn't numeric in multiplication (*) at ./pro/mscenq1.pl line 762, <CONFIG> line 12., referer:
Use of uninitialized value in multiplication (*) at ./pro/mscenq1.pl line 761, <CONFIG> line 12., referer:
Use of uninitialized value in multiplication (*) at ./pro/mscenq1.pl line 762, <CONFIG> line 12., referer:
Use of uninitialized value in concatenation (.) or string at ./pro/mscenq1.pl line 765, <CONFIG> line 12.,
Use of uninitialized value in concatenation (.) or string at ./pro/mscenq1.pl line 769, <CONFIG> line 12.,
Use of uninitialized value in multiplication (*) at ./pro/mscenq1.pl line 761, <CONFIG> line 12., referer:
Use of uninitialized value in multiplication (*) at ./pro/mscenq1.pl line 762, <CONFIG> line 12., referer:
-----------------------------------------------------------------------------------
Subroutine copy_enq1_enq2 redefined at ./pro/mscqtn_input.pl line 398.\r, referer: http://127.0.0.1/
Subroutine copy_enq1_enq22 redefined at ./pro/mscqtn_input.pl line 424.\r, referer: http://127.0.0.1/
File does not exist: C:/www/htdocs/favicon.ico
File does not exist: C:/www/htdocs/favicon.ico
Subroutine copy_enq1_enq2 redefined at ./pro/mscqtn_input.pl line 398.\r, referer: http://localhost/cgi-bin/msc_start.cgi
Subroutine copy_enq1_enq22 redefined at ./pro/mscqtn_input.pl line 424.\r, referer: http://localhost/cgi-bin/msc_start.cgi
-----------------------------------------------------------------------------------
修改項目:
刪除mscenq2.pl的
copy_enq1_enq2和copy_enq1_enq22
msc.pm
#require "./pro/mscquo1_one.pl";
#require "./pro/mscorder2.pl";
#require "./pro/mscinv1.pl";
#require "./pro/mscpacking1.pl";
#require "./pro/mscinv2.pl";
-----------------------------------------------------------------------------------
malformed header from script. Bad header=\xef\xbb\xbf<html>: m_start.pl, referer: http://127.0.0.1/iis_cgi.htm
$t{template} = HTML::Template->new(filename => "m_start.htm");
$t{template}->param(LOOP => \@loop);
print $t{template}->output;
追加了如下一行解決了問題。
print "Content-type: text/html; charset=UTF-8\n\n";
$t{template} = HTML::Template->new(filename => "m_start.htm");
$t{template}->param(LOOP => \@loop);
print "Content-type: text/html; charset=UTF-8\n\n";
print $t{template}->output;
---------------------------------------------------------------
[Wed Mar 19 16:54:59 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
my %row = (
NO => $t{NO}
);
改為==>
%row = ();
%row = (
NO => $t{NO}
);
最后改為==>
$row_ref = (); # 這個初始化非常重要!
$$row_ref{id} = $rec[0];
$$row_ref{ourref} = $rec[1];
push(@loop, $row_ref);
[Wed Mar 19 16:54:59 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_start.pl line 31, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
$t{ourref} = $self->dbh->selectrow_array("SELECT ourref FROM enq1 where id = $rec[2]");
==>在做新表時,自動往enq2里填寫最新的ourref
[Wed Mar 19 16:54:59 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_start.pl line 31, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:02 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:02 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_header.pl line 26, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:02 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_header.pl line 26, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:02 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_header.pl line 54, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:02 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_header.pl line 54, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:08 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:08 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2.pl line 32, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:08 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2.pl line 32, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:08 2008] [error] [client 127.0.0.1] Use of uninitialized value in split at ./pro/mscenq2.pl line 67, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:08 2008] [error] [client 127.0.0.1] Use of uninitialized value in numeric eq (==) at ./pro/mscenq2.pl line 146, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:13 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:17 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:17 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_start.pl line 31, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:55:17 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_start.pl line 31, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
問題1:數(shù)字排列按數(shù)字,文字排列按文字
# @union = sort {$a<=>$b} keys %count;
@union = sort keys %count;
------------------------------------
[Mon Mar 03 12:21:46 2008] [error] [client 127.0.0.1] Argument "16A" isn't numeric in sort at ./pro/mscenq1_parts3.pl line 89, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Mon Mar 03 12:21:46 2008] [error] [client 127.0.0.1] Argument "16B" isn't numeric in sort at ./pro/mscenq1_parts3.pl line 89, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Mon Mar 03 12:21:46 2008] [error] [client 127.0.0.1] Argument "SB254511" isn't numeric in sort at ./pro/mscenq1_parts3.pl line 89, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
-------------------------------------------
[Mon Mar 03 13:46:56 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: Unknown column '16A' in 'where clause' at ./pro/mscenq1_parts3.pl line 152, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
mysql> select id from a000003 where code = 16A;
ERROR 1054 (42S22): Unknown column '16A' in 'where clause'
mysql> select id from a000003 where code = "16A";
+----+
| id |
+----+
| 12 |
+----+
[Wed Mar 19 16:48:24 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscenq2_select.pl line 162.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:24 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:24 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_start.pl line 31, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:24 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_start.pl line 31, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:27 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscenq2_select.pl line 162.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:27 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:27 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_header.pl line 26, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:27 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_header.pl line 26, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:27 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2_header.pl line 53, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:27 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2_header.pl line 53, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:38 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscenq2_select.pl line 162.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:38 2008] [error] [client 127.0.0.1] "my" variable %row masks earlier declaration in same scope at ./pro/mscshowparts30.pl line 40.\r, referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:38 2008] [error] [client 127.0.0.1] Use of uninitialized value in concatenation (.) or string at ./pro/mscenq2.pl line 32, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:38 2008] [error] [client 127.0.0.1] DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./pro/mscenq2.pl line 32, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:38 2008] [error] [client 127.0.0.1] Use of uninitialized value in split at ./pro/mscenq2.pl line 67, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
[Wed Mar 19 16:48:38 2008] [error] [client 127.0.0.1] Use of uninitialized value in numeric eq (==) at ./pro/mscenq2.pl line 146, <CONFIG> line 11., referer: http://localhost/cgi-bin/msc_start.cgi
]]>
返回
靖西县|
凌云县|
营山县|
阳新县|
固镇县|
顺昌县|
平安县|
衡水市|
拉萨市|
济南市|
商丘市|
嘉鱼县|
黎平县|
景洪市|
信宜市|
巫溪县|
凯里市|
昭通市|
体育|
丹东市|
客服|
时尚|
定州市|
扬州市|
青冈县|
衡水市|
延川县|
信宜市|
榆社县|
天峨县|
山阴县|
芦溪县|
彭阳县|
弋阳县|
维西|
塔河县|
东兴市|
西青区|
五莲县|
台湾省|
清流县|