#50021 [Fbk->Csd]: Predefined Statements doesn't allow Strings with more than 256 letters.

ID: 50021 User updated by: novitools dot novi at web dot de Reported By: novitools dot novi at web dot de -Status: Feedback +Status: Closed Bug Type: MySQLi related Operating System: Windows Vista PHP Version: 5.3.0 New Comment: I was ill for the last few day. Thats why it took me so long to answer. I tried to use the latest snapshot, but I had problems with a connection to a MySQL-Server. The installation of an apache and PHP itself worked fine, but every access to the MySQL-Server end in an Internal Server Error. However a new version of XAMPP has been offered since yesterday. The new Version inculdes PHP 5.3.1 . And now it runs. The problem I have described doesn't exists anymore in PHP Version 5.3.1 . Previous Comments: ------------------------------------------------------------------------ [2009-12-22 10:01:12] jani@php.net Please try using this snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2009-11-03 21:32:25] uw@php.net Thanks for the feedback! I feared that meta data would indicate the correct length. To be honest, I have no idea so far what may be causing it. ------------------------------------------------------------------------ [2009-11-03 14:33:21] novitools dot novi at web dot de Here is the result: Field 1: `You can only read the first 256 words of this text. That is why I must write such a long text, because I must reach the limit of 256 words. The same error occours, when you try to select a text column from the database. But I didn't had this error before ` Catalog: def Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 284 Max_length: 284 Decimals: 31 Flags: NOT_NULL +------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------------------------------------------+ | You can only read the first 256 words of this text. That is why I must write such a long text, because I must reach the limit of 256 words. The same error occours, when you try to select a text column from the database. But I didn't had this error before | +------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------------------------------------------+ | You can only read the first 256 words of this text. That is why I must write such a long text, because I must reach the limit of 256 words. The same error occours, when you try to select a text column from the database. But I didn't had this error before in a previous version of php. | +------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------------------------------------------+ 1 row in set (0.00 sec) ------------------------------------------------------------------------ [2009-11-03 09:54:50] uw@php.net Please run you query in the MySQL prompt and show the meta data that is returned from MySQL. Start the MySQL prompt with "mysql --column-type-info" followed by your usual "-u", "-p", "-h" etc. options. For example: nixnutz@ulflinux:~> /usr/local/mysql/bin/mysql --column-type-info -uroot -proot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 Server version: 5.1.39-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select 1; Field 1: 1 Catalog: def Database: `` Table: `` Org_table: `` Type: LONGLONG Collation: binary (63) Length: 1 Max_length: 1 Decimals: 0 Flags: NOT_NULL BINARY NUM +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.00 sec) But, of course, run your failing query and run mysql prompt on your system. Thanks, Ulf ------------------------------------------------------------------------ [2009-10-30 15:12:35] novitools dot novi at web dot de So the problem only occurs on specific versions: No Problem with this Versions: client_version 50005 server_version 50132 Big Problem with this Versions: client_version 50137 server_version 50137 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/50021 -- Edit this bug report at http://bugs.php.net/?id=50021&edit=1