TOPIC:

Data too long for column 'title' at row 1 3 weeks 3 days ago #280847

  • Topic Author
  • jdwires
  • Offline
  • Junior Member
  • Junior Member
  • Registered
  • Posts: 41
  • Thanks: 0
I recently upgraded to J!4 and am running the latest version and BF Pro v. 1.9.1 Stable (943). Most forms seem to be working fine, but one is throwing an error on the front end of the website: "Save Subrecord Failed: Data too long for column 'title' at row 1". When I look at the form records, all the items are blank and only the first question has any data.


I also noticed that after the first record item, all of the other record items have null values showing for the element ID and type.

I haven't made any changes to the form other than if I shorten the length of the second form question label to only a couple of words, I will get the same error, but more of the form record is populated down to about the halfway mark.

Any thoughts?
Attachments:

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

Last edit: Post by jdwires.

Data too long for column 'title' at row 1 3 weeks 2 days ago #280867

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Administrator
  • Administrator
  • Super Users
  • Posts: 10331
  • Thanks: 827
Can you please export the form in BF Configuration => Create Package, zip it and attach to your next reply? I will try to debug this on my end.

When you export, please make sure to only select that particular form, not additional assets like scripts and pieces et. al.

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

Data too long for column 'title' at row 1 3 weeks 2 days ago #280876

  • Topic Author
  • jdwires
  • Offline
  • Junior Member
  • Junior Member
  • Registered
  • Posts: 41
  • Thanks: 0
I've noticed it on a few other forms now, but here is the one you requested.

Thanks in advance for your help.

P.S. I saw another post with a similar problem and changing the length of the table column fixed it. Would that be worth trying in this instance?
Attachments:

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

Data too long for column 'title' at row 1 3 weeks 2 days ago #280888

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Administrator
  • Administrator
  • Super Users
  • Posts: 10331
  • Thanks: 827

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

Data too long for column 'title' at row 1 3 weeks 2 days ago #280893

  • Topic Author
  • jdwires
  • Offline
  • Junior Member
  • Junior Member
  • Registered
  • Posts: 41
  • Thanks: 0
I'm glad I tried that in a test environment. I tried changing it from varchar(50) to varchar(255) like in the other post. Now the forms submit but the page just sits and spins and eventually returns a server 500 error timeout after a few minutes. :(I changed the value back to varchar(50) but it still timesout. :(:(

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

Data too long for column 'title' at row 1 3 weeks 1 day ago #280911

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Administrator
  • Administrator
  • Super Users
  • Posts: 10331
  • Thanks: 827
Error 500 usually means a PHP error in that context.
Are you able to look into the php_error.log of your websever? (not access log but the actual php error log).
Your hosting provider should be able to tell in his docs where you can find it for your site.

Once we figured the error, it should be easy to find a solution.

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

Moderators: ForumSupport
Time to create page: 0.060 seconds

Support Discord

Join our Discord and enter the Crosstec channels for live-support, chat forums and directly interacting with the community!

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Subscribe to news and updates!

Special Offer

Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Live Support Chat Opened!

Join our Discord chat here and enter the Crosstec channels to receive live support and talk directly to the team!