gamonoid / icehrm

Manage your employees easily with a robust and efficient Human Resource Management System
http://icehrm.com
Other
567 stars 368 forks source link

Error when saving attendance / using time punch because of IPv6 #297

Open AnAxNu opened 2 years ago

AnAxNu commented 2 years ago
Screenshot 2022-03-15 at 4 55 25 PM

On a freshly installed 31.0.0.0 I get the error above: Error Occured while Time Punch Error occured while saving attendance. The error is caused by the user using an IPv6-address and the database can handle a maximum of 25 characters for the ip. IPv6-addresses can be around 45 characters. The 2 fields in the Attendance-table are: in_ip and out_ip. Changing them from VARCHAR(25) to VARCHAR(50) fixes the problem.