We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Started getting error Data too long for column 'site_pages' at row 1

Development and Programming

energycell's avatar
energycell
18 posts
5 years ago
energycell's avatar energycell

When trying to add a new entry we are now getting the following error:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘site_pages’ at row 1: UPDATE exp_sites SET site_pages = ‘Y….’

This is a multi-site install, the error is occurring on the original base site.

We also have structure installed, new entries are being added as EE entries, but they are not being added to the Structure Listings table.

I’m not sure what information the ‘site_pages’ column actually holds.

Any advice very welcome!

       
Yuri's avatar
Yuri
273 posts
5 years ago
Yuri's avatar Yuri

The site_pages column holds the information about page URIs created using Pages module. If you change column type to MEDIUMTEXT or LONGTEXT that should give you enough space

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.