Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] failed with SQL error: Row size too large

  • paintek
  • paintek
  • OFFLINE
  • Posts: 72
  • Thanks: 1
  • Karma: 2
11 years 3 months ago #231373 by paintek
Replied by paintek on topic Re: failed with SQL error: Row size too large
this solution make the edit in the backend possible??? it's the .xml file ok for CB 1.9??? this change will be default in future relese?

why everything seems so obvious, after someone told it to you?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 3 months ago #231391 by krileon
Replied by krileon on topic Re: failed with SQL error: Row size too large

this solution make the edit in the backend possible???

No.

it's the .xml file ok for CB 1.9???

No, it's CB 1.8 XML file.

this change will be default in future relese?

Possibly, I've a bug ticket for 1.9.1 regarding this but it needs to be discussed internally as there are drawbacks to the change.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: paintek

Please Log in or Create an account to join the conversation.

  • paintek
  • paintek
  • OFFLINE
  • Posts: 72
  • Thanks: 1
  • Karma: 2
11 years 3 months ago #231434 by paintek
Replied by paintek on topic Re: failed with SQL error: Row size too large
Ok, now i've the same problem (CB 1.9), what's the best way to solve it? wait for next relese?

why everything seems so obvious, after someone told it to you?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 3 months ago #231439 by krileon
Replied by krileon on topic Re: failed with SQL error: Row size too large
Quickfix is to edit the database columns within _comprofiler and change the varchar types for cb_ columns to text or edit the XML file, change their types, and run CB Tools as shown on page 1 of this topic. Aside from that yes wait for next release, we've plans to discuss internally the best approach to fix for 1.9.1.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum