#34623 [Opn->Fbk]: Segfault when selecting 'longtext' field with pdo/mysql

From: Date: Wed, 28 Sep 2005 21:36:57 +0000
Subject: #34623 [Opn->Fbk]: Segfault when selecting 'longtext' field with pdo/mysql
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-85739@lists.php.net to get a copy of this message
 ID:               34623
 Updated by:       tony2001@php.net
 Reported By:      stewey at ambitious dot ca
-Status:           Open
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: Mac OS X 10.4.2
 PHP Version:      5CVS-2005-09-27 (snap)
 New Comment:

Still no luck in reproducing it.
Please do the following in gdb (when you got the backtrace):
gdb> p *stmt
gdb> p *stmt->methods
and paste results here.


Previous Comments:
------------------------------------------------------------------------

[2005-09-28 23:13:47] stewey at ambitious dot ca

Changing summary to read 'longtext'.

------------------------------------------------------------------------

[2005-09-28 23:11:46] stewey at ambitious dot ca

It's actually a 'longtext'. I'm very sorry for the 
misinformation. To the obvious question: yes, this makes the 
difference. If it's 'text', no problem, longtext = segfault. 
Again, I'm sorry.

Yes, I can repro via the CLI. Would you like a backtrace of 
that?


CREATE TABLE article (
  articleId int(10) unsigned NOT NULL auto_increment,
  parentId int(10) unsigned NOT NULL default '0',
  templateId int(10) unsigned NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  subTitle varchar(255) default NULL,
  text longtext NOT NULL,
  creationTime timestamp NULL default NULL,
  modificationTime timestamp NULL default 
CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  state enum('Online','Offline') NOT NULL default 
'Online',
  audience enum('Private','Public') NOT NULL default 
'Private',
  childSortOrder enum
('Title','Date','Popularity','Arbitrary') NOT NULL default 
'Title',
  sortWeight int(11) NOT NULL default '0',
  PRIMARY KEY  (articleId),
  KEY parentId (parentId,templateId),
  FULLTEXT KEY title (title,subTitle,text)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

------------------------------------------------------------------------

[2005-09-28 22:03:52] tony2001@php.net

Can't reproduce.
Please show your CREATE TABLE command.
Also, are you able to replicate it using PHP CLI ?

------------------------------------------------------------------------

[2005-09-28 17:20:35] stewey at ambitious dot ca

$ ./configure --with-apxs2=/usr/local/apache2/bin/apxs --
with-mysql=/usr/local/mysql --enable-pdo --prefix=/usr/
local/php5 --with-xmlrpc --with-pdo-mysql --enable-debug

$ make

$ make install

Hope that helps!

------------------------------------------------------------------------

[2005-09-28 13:03:04] sniper@php.net

How did you compile/configure PHP?


------------------------------------------------------------------------

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/34623

-- 
Edit this bug report at http://bugs.php.net/?id=34623&edit=1


Thread (21 messages)

« previous php.bugs (#85739) next »