php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #35337 prepare update into longtext column broken
Submitted: 2005-11-22 19:43 UTC Modified: 2005-12-03 01:03 UTC
From: bill dot finn at sellingsource dot com Assigned:
Status: Closed Package: MySQLi related
PHP Version: 6CVS-2005-11-19 (snap) OS: Gentoo 2.6.9
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bill dot finn at sellingsource dot com
New email:
PHP Version: OS:

 

 [2005-11-22 19:43 UTC] bill dot finn at sellingsource dot com
Description:
------------
Performing an update into a non-null longtext column using prepare syntax.  Example code works in php 5.0.x.  Upgraded to 5.1.x and it started entering variations of empty strings, 0, or 0000-00-00 depending on how much data I was trying to enter.  In a test that allows null values, it enters null.


(mysql 5.0.13 && mysql 5.0.15)

Reproduce code:
---------------
CREATE TABLE test (col1 longtext not null);
<?php
$data = "whatever, some string";
$mysqli = new mysqli( HOST, USER, PASS, DB, PORT );
$query = "INSERT INTO test SET col1 = ?";
$prepared = $mysqli->prepare( $query );
$prepared->bind_param('s', $data );
$prepared->execute();
$prepared->close();
?>

Expected result:
----------------
contents of $data inserted into col1 of table.

Actual result:
--------------
SELECT col1 FROM test
shows one of three things:
0000-00-00
0
empty string

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-11-22 22:31 UTC] tony2001@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip


 [2005-11-30 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2005-12-03 01:03 UTC] bill dot finn at sellingsource dot com
tested with 2005-11-29, works.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Sun Jul 06 17:01:33 2025 UTC