查询MySql服务器时出错，Windows2008 R2
查询MySql服务器时出错，Windows2008 R2
提问于 2015-05-07 02:29:51
我有一个由web表单和Mysql服务器组成的系统，运行在2008年的R2上。我已经安装了MySql和pma没有任何问题，并验证了他们的工作和访问。我已经在开发机器上创建了这个系统，一切都运行得很好。现在，我将文件移动到实时服务器上，收到以下错误消息“localhost via TCP/IP string(61)”，第1行的'desiccant_1‘列的十进制值不正确。
有没有人有解决这个错误的办法？谢谢您抽时间见我。我已经包括了所有的文件，如果需要更多的信息，请让我知道。
数据库名称为comms。
Web表单：
<body>
<p>Complete form and submit:</p>
<form class="form" method="post" action="ealwReport.php">
<label for="desiccant_1">desiccant_1</label>
<input type="number"step="0.01" name="desiccant_1" min="0" max="16.5" /><br />
<label for="desiccant_2">desiccant_2</label>
<input type="number"step="0.01" name="desiccant_2" min="0" max="16.5" /><br />
<label for="desiccant_3">desiccant_3</label>
<input type="number"step="0.01" name="desiccant_3" min="0" max="16.5" /><br />
<label for="desiccant_4">desiccant_4</label>
<input type="number"step="0.01" name="desiccant_4" min="0" max="16.5" /><br />
<label for="desiccant_5">desiccant_5</label>
<input type="number"step="0.01" name="desiccant_5" min="0" max="16.5" /><br />
<label for="desiccant_6">desiccant_6</label>
<input type="number"step="0.01" name="desiccant_6" min="0" max="16.5" /><br />
<br />
<label for="laser_1">laser_1</label>
<input type="number"step="0.01" name="laser_1" min="0" max="16.5" /><br />
<label for="laser_2">laser_2</label>
<input type="number"step="0.01" name="laser_2" min="0" max="16.5" /><br />
<label for="laser_3">laser_3</label>
<input type="number"step="0.01" name="laser_3" min="0" max="16.5" /><br />
<label for="laser_4">laser_4</label>
<input type="number"step="0.01" name="laser_4" min="0" max="16.5" /><br />
<label for="laser_5">laser_5</label>
<input type="number"step="0.01" name="laser_5" min="0" max="16.5" /><br />
<label for="laser_6">laser_6</label>
<input type="number"step="0.01" name="laser_6" min="0" max="16.5" /><br />
<br />
<label for="table_top_1">table_top_1</label>
<input type="number"step="0.01" name="table_top_1" min="0" max="16.5" /><br />
<label for="table_top_2">table_top_2</label>
<input type="number"step="0.01" name="table_top_2" min="0" max="16.5" /><br />
<br />
<label for="RMI">RMI</label>
<input type="number"step="0.01" name="RMI" min="0" max="16.5" /><br />
<label for="Miscellaneous">Miscellaneous</label>
<input type="number"step="0.01" name="Miscellaneous" /><br />
<br />
<label for="User">User</label>
<input type="text" name="User" /><br />
<label for="Date">Date</label>
<input input type="text" name="Date" value="<?php echo date('F j, Y, G:i');?>" readonly/><br />
<label for="comments">Comments?</label>
<textarea class="text" name="comments"></textarea><br />
<br />
<input type="submit" class="submit" value="submit" name="submit" />
</form>
<p id="demo"></p>
<script>
document.getElementById("demo").innerHTML = Date();
</script>
</body>发布到以下脚本“ealwReport.php”的网页表单：
<?php
$desiccant_1 = $_POST['desiccant_1'];
$desiccant_2 = $_POST['desiccant_2'];
$desiccant_3 = $_POST['desiccant_3'];
$desiccant_4 = $_POST['desiccant_4'];
$desiccant_5 = $_POST['desiccant_5'];
$desiccant_6 = $_POST['desiccant_6'];
$laser_1 = $_POST['laser_1'];
$laser_2 = $_POST['laser_2'];
$laser_3 = $_POST['laser_3'];
$laser_4 = $_POST['laser_4'];
$laser_5 = $_POST['laser_5'];
$laser_6 = $_POST['laser_6'];
$table_top_1 = $_POST['table_top_1'];
$table_top_2 = $_POST['table_top_2'];
$RMI = $_POST['RMI'];
$Miscellaneous = $_POST['Miscellaneous'];
$User = $_POST['User'];
$Date = $_POST['Date'];
$comments = $_POST['comments'];
$dbc = mysqli_connect('localhost', 'root', 'xxxxx', 'comms')
or die('Error connecting to MySQL server.');
echo mysqli_get_host_info($dbc) . "\n";将数据插入数据库：
$query = "INSERT INTO ealw (desiccant_1, desiccant_2, desiccant_3, desiccant_4, " .
"desiccant_5, desiccant_6, laser_1, laser_2, laser_3, laser_4, laser_5, " .
"laser_6, table_top_1, table_top_2, RMI, Miscellaneous, User, Date, comments) " .
"VALUES ('$desiccant_1', '$desiccant_2', '$desiccant_3', '$desiccant_4', '$desiccant_5', " .
"'$desiccant_6', '$laser_1', '$laser_2', '$laser_3', '$laser_4','$laser_5', " .
"'$laser_6', '$table_top_1','$table_top_2', '$RMI', " .
"'$Miscellaneous', '$User', '$Date', '$comments')";
$result = mysqli_query($dbc, $query)
or die (var_dump(mysqli_error($dbc)));ERROR RECEIVED = localhost via TCP/IP string(61)“第1行'desiccant_1‘列的十进制值'’不正确”
从数据库返回最新记录：
$sql2 = "SELECT desiccant_1, desiccant_2, desiccant_3, desiccant_4, desiccant_5
, desiccant_6, laser_1, laser_2, laser_3, laser_4, laser_5, laser_6
, table_top_1, table_top_2, RMI, Miscellaneous FROM ealw ORDER BY id DESC LIMIT 1";
$result2 = mysqli_query($dbc, $sql2);
?>表结构：
CREATE TABLE IF NOT EXISTS `ealw` (
`id` int(11) NOT NULL,
`desiccant_1` decimal(4,2) NOT NULL DEFAULT '0.00',
`desiccant_2` decimal(4,2) NOT NULL DEFAULT '0.00',
`desiccant_3` decimal(4,2) NOT NULL DEFAULT '0.00',
`desiccant_4` decimal(4,2) NOT NULL DEFAULT '0.00',
`desiccant_5` decimal(4,2) NOT NULL DEFAULT '0.00',
`desiccant_6` decimal(4,2) NOT NULL DEFAULT '0.00',
`laser_1` decimal(4,2) NOT NULL DEFAULT '0.00',
`laser_2` decimal(4,2) NOT NULL DEFAULT '0.00',
`laser_3` decimal(4,2) NOT NULL DEFAULT '0.00',
`laser_4` decimal(4,2) NOT NULL DEFAULT '0.00',
`laser_5` decimal(4,2) NOT NULL DEFAULT '0.00',
`laser_6` decimal(4,2) NOT NULL DEFAULT '0.00',
`table_top_1` decimal(4,2) NOT NULL DEFAULT '0.00',
`table_top_2` decimal(4,2) NOT NULL DEFAULT '0.00',
`RMI` decimal(4,2) NOT NULL DEFAULT '0.00',
`Miscellaneous` decimal(4,2) NOT NULL DEFAULT '0.00',
`User` text NOT NULL,
`Date` text NOT NULL,
`comments` text
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;回答 1
Stack Overflow用户
发布于 2015-05-08 03:06:07
感谢每个人的投入。按照肯尼的建议，我的问题通过禁用Mysql数据库中的“严格”模式得到了解决。我使用了PMA & entered SET @@global.sql_mode= ''；来关闭严格的mode.The系统现在可以正常工作了。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/30084802
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号