[Building Sakai] SQL Exception

[Steve Swinsburg]

Hi Cristiano,

use the NEW- ... ddl script, which is just an SQL command to generate the table with the correct column type.

Are you using MySQL 5.5?

cheers,
Steve





On 25/05/2012, at 7:05 AM, Cristiano Borges Cardoso wrote:

> Steve Swinsburg <steve.swinsburg <at> gmail.com> writes:
> 
>> 
>> What version Sakai are you using? 
>> 
>> The issue with SAKAI_PERSON_T was fixed in 2.8.1 and up:
>> https://jira.sakaiproject.org/browse/SAK-20598
>> 
>> It's a simple fix, and there is info in that ticket if you need to do it 
> manually.
>> 
>> cheers,
>> Steve
>> 
>> On 24/05/2012, at 6:35 AM, Cristiano wrote:
>> 
> 
> Thanks Steve!
> 
> I downloaded version 2.8.1, but it's the same error:
> 
>      Unsuccessful schema statement: create table SAKAI_PERSON_T
>      ...
>      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>      Row size too large. The maximum row size for the used table type, not 
> counting BLOBs, is65535. You have to change some columns to TEXT or BLOBs
> 
> I had seen this fix, but do not know which file to change.
> Can you help me?
> 
> cheers,
> 
> Cristiano
> 
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"