I have a problem with reading data from database. Everything displays correctly except the 'Message' row which doesn't show up at all.
Problem is in the longtext data type. If I change it to mediumtext (or text) it works. Below is a table conf and a query.
ID mediumint(8)
Type tinyint(1)
Title varchar(100)
DateCreated datetime
DateModified datetime
Sender char(10)
Recipients varchar(800)
ReadBy varchar(800)
Message longtext
I'm using the newest MAMP if it helps, and I have already changed php.ini memory limit to 64M, 128M, 256M and even 512M and nothing helps.
Problem is in the longtext data type. If I change it to mediumtext (or text) it works. Below is a table conf and a query.
ID mediumint(8)
Type tinyint(1)
Title varchar(100)
DateCreated datetime
DateModified datetime
Sender char(10)
Recipients varchar(800)
ReadBy varchar(800)
Message longtext
Code:
SELECT ID, Type, Title, DateCreated, DateModified, Sender, Recipients, ReadBy, Message FROM G1_Messages WHERE ID=?
Comment