TOPIC:

Data too long for column 'ip' at row 1 week 3 days ago #279451

  • jooomlaa's Avatar Topic Author
  • jooomlaa
  • Offline
  • Junior Breezer
  • Junior Breezer
  • 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 1 week 3 days ago #279452

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 11753
  • Karma: 3
  • Thanks: 761
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 1 week 3 days ago #279454

  • jooomlaa's Avatar Topic Author
  • jooomlaa
  • Offline
  • Junior Breezer
  • Junior Breezer
  • 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 1 week 3 days ago #279456

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 11753
  • Karma: 3
  • Thanks: 761

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

Data too long for column 'ip' at row 1 week 3 days ago #279461

  • jooomlaa's Avatar Topic Author
  • jooomlaa
  • Offline
  • Junior Breezer
  • Junior Breezer
  • 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 1 week 3 days ago #279467

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 11753
  • Karma: 3
  • Thanks: 761
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
Moderators: ForumSupport
Time to create page: 0.050 seconds

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

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!