Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Getting an error on my website "A Question2Answer database query failed when generating this page."

+2 votes
4,081 views
asked Aug 3, 2013 in Q2A Core by suresh1983
retagged Aug 3, 2013 by suresh1983

I am getting the above mentioned error when I tried to install a plugin "who is online".

I am getting the error "A Question2Answer database query failed when generating this page."

I check out my error log page, but there is no error updated there.

www.yourgoal.in

commented Aug 3, 2013 by suresh1983
I got this error in the error log

"[Sat Aug 03 02:44:25 2013] [11326133] [dir:error] [client 220.227.201.129:12249] Inside mod_dir, setting document_root to PARENT_DOCUMENT_ROOT : /var/chroot/home/content/33/11326133/html, referer http://www.yourgoal.in/index.php?qa=ask

[Sat Aug 03 02:44:26 2013] [11326133] [fcgid:warn] [client 220.227.201.129:12249] mod_fcgid: stderr: PHP Question2Answer MySQL query error 1062: Duplicate entry '0' for key 2 - Query: INSERT INTO qa_who_is_online (ip,city,country,country_code) VALUES(-589051519,'(Unknown city)','INDIA','IN'), referer http://www.yourgoal.in/index.php?qa=ask

[Sat Aug 03 02:48:21 2013] [11326133] [dir:error] [client 220.227.201.129:28436] Inside mod_dir, setting document_root to PARENT_DOCUMENT_ROOT : /var/chroot/home/content/33/11326133/html, referer http://www.yourgoal.in/index.php?qa=ask

[Sat Aug 03 02:48:21 2013] [11326133] [fcgid:warn] [client 220.227.201.129:28436] mod_fcgid: stderr: PHP Question2Answer MySQL query error 1062: Duplicate entry '0' for key 2 - Query: INSERT INTO qa_who_is_online (ip,city,country,country_code) VALUES(-589051519,'(Unknown city)','INDIA','IN'), referer http://www.yourgoal.in/index.php?qa=ask

1 Answer

+1 vote
answered Aug 5, 2013 by gidgreen

It looks like the problem is in whichever plugin is responsible for managing the qa_who_is_online table.

commented Aug 6, 2013 by suresh1983
Yes, I know that....and I am searching on how to delete or uninstall the plugin

Can any one please help me with this as my site is completely down due to this reason.
...