TOPIC:

Data too long for column 'ip' at row 4 months 5 days ago #279451

  • jooomlaa's Avatar Topic Author
  • jooomlaa
  • Offline
  • Junior Member
  • Junior Member
  • Registered
  • Posts: 51
  • Thanks: 1
When I have enabled the "Save IP address" feature, I get this error message:

Data too long for column 'ip' at row

I think this is trying to store an IP6 address, but the IP field only has varchar(30) and is too small for that. The DB field should be adapted to today's standards

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

Data too long for column 'ip' at row 4 months 5 days ago #279452

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Registered
  • Posts: 12079
  • Thanks: 780
Hi,

please go to database and replace varchar with other type, e.g. long

Let me know the result

Regards,
Tihana

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

Data too long for column 'ip' at row 4 months 5 days ago #279454

  • jooomlaa's Avatar Topic Author
  • jooomlaa
  • Offline
  • Junior Member
  • Junior Member
  • Registered
  • Posts: 51
  • Thanks: 1
yes, if changed to 255 chr it works

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

Data too long for column 'ip' at row 4 months 5 days ago #279456

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Registered
  • Posts: 12079
  • Thanks: 780

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

Data too long for column 'ip' at row 4 months 5 days ago #279461

  • jooomlaa's Avatar Topic Author
  • jooomlaa
  • Offline
  • Junior Member
  • Junior Member
  • Registered
  • Posts: 51
  • Thanks: 1
I can also fix the error by disabling IP storage in the BF configuration. That would have been easier. But I wanted to suggest that this error is also corrected in a clean patch.

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

Data too long for column 'ip' at row 4 months 5 days ago #279467

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Registered
  • Posts: 12079
  • Thanks: 780
Hi,

ok, I put this to "to do" list, and thanks for info

Regards,
Tihana

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

  • Page:
  • 1
  • 2
Moderators: ForumSupport
Time to create page: 0.058 seconds

Support Chat

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

After joining, please enter the Crosstec Area and use the #crosstec-support or #crosstec-general channels.

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!