Can't login to admin

Question

I can't login to my admin account, this error occurs (log from apache). Thanks for help!

 PHP Question2Answer MySQL query error 1411: Incorrect string value: '::1' for function inet_aton - Query: INSERT INTO qa_iplimits (ip, action, period, count) VALUES (COALESCE(INET_ATON('::1'), 0), 'L', 406099, 1) ON DUPLICATE KEY UPDATE count=IF(period=406099, count+1, 1), period=406099, referer: http://localhost/

Comments

Is this on localhost? What operating system?

---

yes. It's localhost, running on my Mac OS 10.11

Answer 1

I've had this problem too. It's due to Mac using IPv6 by default. The easiest way to fix it is:

1. Open the file /etc/apache2/httpd.conf
2. Change the line
   Listen 80
   to
   Listen 127.0.0.1:80
3. Save and restart Apache.

The next version of Q2A (1.8) has full support for IPv6 so the issue will be fully resolved.