SugarCRM - 数据库故障 - 行大小太大? [英] SugarCRM - Database Failure - Row Size Too Large?

问题描述

我一直在为 SugarCRM 构建自定义模块，但遇到了一些问题，在安装该模块时遇到了数据库故障".详情请参阅 Sugarcrm.log.

I've been building a custom module for sugarCRM and i'm running into some issue's, when installing the module i'm met with 'Database failure. Please refer to sugarcrm.log for details.'

检查日志文件后，我发现错误是这样的:

Upon checking the log file, i can find the error is this:

MySQL 错误 1118:行大小太大.所用表类型的最大行大小(不包括 BLOB)为 65535.您必须将某些列更改为 TEXT 或 BLOB01/03/14"

"MySQL error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs 01/03/14"

虽然我的模块确实有很多字段，但我能解决这个问题吗?创建字段时，似乎糖没有为我提供 varchar/text 等选项.

Whilst my module does have alot of fields, is there anyway i could get around this? Seems like sugar doesn't give me options for varchar/text etc when creating fields.

谢谢！

推荐答案

我在将 SugarCRM 作为多租户解决方案实施时遇到了同样的问题.您有几个选择.

I ran in to this same problem when implementing SugarCRM as a multi-tenant solution. You have a couple of options.

1) 进入工作室并将字段的大小设置为较小的值.varchar 字段中的每个字符平均大小为几个字节.因此，如果您减少工作室中每个字段允许的字符数，您将允许在模块中使用更多字段.(参见 http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html).

1) Go in to studio and set the size of your fields to a smaller value. Each character in a varchar field is a few bytes in size on average. Therefore, if you reduce the amount of characters allowed for each of your fields in studio you will allow for more fields in your module. (see http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html).

2) 将这些字段分成几个与父模块相关的模块.这会将您的字段分散到 1 个以上的表中，防止您达到限制.

2) Divide up those fields into a couple of modules that relate to a parent module. This will spread out your fields over more than 1 table preventing you from hitting the limit.

如果您需要对任一解决方案进行更深入的解释，我很乐意为您提供进一步帮助.

I would be happy to assist further if you need a more in-depth explanation of either solution.

这篇关于SugarCRM - 数据库故障 - 行大小太大?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！