Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set homepage for a member throws exception #1358

Closed
robsonsobral opened this issue Sep 24, 2021 · 0 comments · Fixed by #1972
Closed

Set homepage for a member throws exception #1358

robsonsobral opened this issue Sep 24, 2021 · 0 comments · Fixed by #1972

Comments

@robsonsobral
Copy link
Contributor

As I have many websites on MSM, I'm getting an error.

image

Exception Caught
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'cp_homepage_channel' at row 1:
UPDATE `exp_members` SET `cp_homepage` = 'entries_edit', `cp_homepage_channel` = '{\"1\":\"1\",\"2\":\"9\",\"3\":\"21\",\"4\":\"22\",\"5\":\"31\",\"6\":\"32\",\"7\":\"67\",\"8\":\"76\",\"9\":\"49\",\"10\":\"57\",\"13\":\"109\",\"14\":\"120\",\"15\":\"131\",\"16\":\"142\",\"17\":\"153\",\"18\":\"164\",\"19\":\"175\",\"20\":\"186\",\"21\":\"197\",\"22\":\"208\",\"23\":\"219\",\"24\":\"230\",\"25\":\"241\",\"26\":\"252\",\"27\":\"263\",\"28\":\"274\",\"29\":\"285\",\"30\":\"296\",\"31\":\"307\",\"32\":\"318\",\"33\":\"329\",\"34\":\"340\",\"35\":\"351\",\"36\":\"362\",\"37\":\"373\",\"38\":\"384\",\"39\":\"395\",\"40\":\"406\",\"41\":\"417\",\"42\":\"428\",\"43\":\"439\",\"44\":\"450\",\"45\":\"461\",\"46\":\"472\",\"47\":\"483\",\"48\":\"494\",\"49\":\"505\",\"50\":\"516\",\"51\":\"527\",\"52\":\"547\",\"53\":\"550\",\"54\":\"553\",\"55\":\"564\",\"56\":\"575\",\"57\":\"586\",\"58\":\"597\",\"59\":\"608\",\"60\":\"619\",\"61\":\"630\"}', `cp_homepage_custom` = '' WHERE `member_id` = 14

ee/legacy/database/drivers/mysqli/mysqli_connection.php:114

image

intoeetive added a commit that referenced this issue Apr 6, 2022
to keep more data on large MSM sites

EECORE-1783

fixes #1358
intoeetive added a commit that referenced this issue Aug 16, 2022
bryannielsen added a commit that referenced this issue Oct 24, 2022
…page-column-type

Resolved #1358 where setting CP Homepage for member could cause PHP error on large sites using MSM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant