Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
722 views
in Q2A Core by

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/

by
Is this on localhost? What operating system?
by
yes. It's localhost, running on my Mac OS 10.11

1 Answer

+2 votes
by

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. 

...