Error 1117 (hy000): too many columns - Error 1117 (hy000) - Error 1117 (hy000) at line 1: too many columns - Error: 1117 – SQLSTATE: HY000 ER_TOO_MANY_FIELDS | idError.com-The largest database with errors and solutions!

Home > MySql-Server

Error: 1117 - SQLSTATE: HY000 ER_TOO_MANY_FIELDS

March 11th, 2009

Goto solutions Leave a solution

Description:
Message: Too many columns

MySql-Server #1117 - too many columns sql, error 1117 (hy000), error 1117 (hy000) at line 1: too many columns, error 1117 (hy000) at line 2: too many columns, error 1117 (hy000) at line 3: too many columns, error 1117 (hy000) at line 5862: too many columns, error 1117 (hy000): too many columns, error 1117 (hy000): too many columns in mysql, error 1117 mysql, error 1117 sqlstate: hy000 (er_too_many_fields), error 1117-too many columns, error: 1117 sqlstate: hy000 (er_too_many_fields)message: too many columns, er_too_many_fields, lrm-00118: syntax error at '=' at the end of input, message:too many columns sqlstate: hy000, mysql error code 1117 (er_too_many_fields): too many columns, sql error (1117): too many columns

Solutions (1) Trackbacks (0) Leave a solution Trackback

srinivas panguluri
March 18th, 2009 at 15:26 | #1
Reply | Quote
It turns out the column limits set by MySQL is 4096 and each time you add a custom filed in EE it adds 2x fields to the exp_weblog_data table. Whilst this might not be an issue on a single site, this is a major issue on MSM.
Well, this code explains why < max row size and min_record_length(table_options),reclength);
if (info_length+(ulong) create_fields.elements*FCOMP+288+
n_length+int_length+com_length > 65535L || int_count > 255)
{
my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0));
DBUG_RETURN(1);
}

No trackbacks yet.

Permission denied Error: 1103 – SQLSTATE: 42000 ER_WRONG_TABLE_NAME