Smartsearch Index error: "an error has occured: Data too long for column 'description' at row 1"

Need help with the Administration of your Joomla! 4.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
djcaptpln880
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 217
Joined: Mon Jul 26, 2021 9:32 am

Smartsearch Index error: "an error has occured: Data too long for column 'description' at row 1"

Post by djcaptpln880 » Sun Jun 09, 2024 10:35 pm

Greetngs

Using J4 + Gantry 5

Tried to do this:

1. Run smart search index under components
3. Did some searching and didn't find this specific issue in the KB
3. It outputted this: Data too long for column 'description' at row 1

Any idea what is going on here and how to fix it?

starac012_1
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Jun 14, 2024 1:21 pm

Re: Smartsearch Index error: "an error has occured: Data too long for column 'description' at row 1"

Post by starac012_1 » Fri Jun 14, 2024 1:27 pm

I have same problem. By run smart search index. I check my title in table #__content, max have 235 lent!

I use next requare
SELECT by length(alias) as len,id FROM `prefix_content` ORDER by len DESC

djcaptpln880
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 217
Joined: Mon Jul 26, 2021 9:32 am

Re: Smartsearch Index error: "an error has occured: Data too long for column 'description' at row 1"

Post by djcaptpln880 » Fri Jun 14, 2024 2:10 pm

Thanks for reply

What is the solution here?

starac012_1
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Jun 14, 2024 1:21 pm

Re: Smartsearch Index error: "an error has occured: Data too long for column 'description' at row 1"

Post by starac012_1 » Mon Jun 17, 2024 1:04 pm

I hoped that developers of joomla help us)

gws
Joomla! Champion
Joomla! Champion
Posts: 6102
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Smartsearch Index error: "an error has occured: Data too long for column 'description' at row 1"

Post by gws » Mon Jun 17, 2024 1:48 pm



Post Reply

Return to “Administration Joomla! 4.x”