Finding the Root Cause of Registration Problem and Fix it!

This problem is not new - I got the same report weeks ago, but I was not able to find the cause and I suspected it was a client-side problem e.g. due to google translate.

Today, I got a report again for the same problem when trying to register a steem account via https://steemyy.com/reg.php

Dear Justyy !
I try to creat account but error: Data too long for column 'addr' at row 1 - **Please contact [email protected] if this problem still occurs.
Please help me!

I then suddently realise that this is a Server problem when data isn't inserted into the MySQL database correctly. Looking at the field of 'addr' which is a VARCHAR(15) to store the IP address, I then realised this will be a problem for IPv6 address which will be longer than 15 chars.

Thus, the fix is easy - changing the size of the field to VARCHAR(255) to accomodate for IPv6 addresses.

Problem solved, and the user is happy!

Verifying that now the IPv6 is written to database:

and account created successfully!

PS: the IP addresses are stored temporarily to avoid service abuse from the same IP address.

@steemcurator01
@steemcurator02
@steemcurator03
@steemcurator04
@steemcurator05
@steemcurator06
@steemcurator07
@steemcurator08

---

Follow me for topics of Algorithms, Blockchain and Cloud.
I am @justyy - a Steem Witness
https://steemyy.com

My contributions

• Steem Blockchain Tools
• Computing & Technology
• Download Youtube Video
• Find Cheap & Bargin VPS: VPS Database
• Online Software and Tools

Support me

If you like my work, please:

• Buy Me a Coffee, Thanks!
• Become my Sponsor, Thanks!
• Voting for me:
  https://steemit.com/~witnesses type in justyy and click VOTE
  
  Alternatively, you could proxy to me if you are too lazy to vote! and you can also vote me at the tool I made: https://steemyy.com/witness-voting/?witness=justyy