I just upgraded the site http://socialpollination.biz/answers/
to v1.2beta to address the WordPress AJAX issue. However, after a few errors with the upgrade, I decided to start with a clean database. I've reinstalled the tables with a new prefix, and integrated the WP users. However, when attempting to ask a question, I get the following error.
Here is the specific code:
Question2Answer query failed:
INSERT INTO qa2_posts (categoryid, type, parentid, userid, cookieid, createip, title, content, tags, notify, created) VALUES (NULL, _utf8 'Q', NULL, _utf8 '7', NULL, INET_ATON(_utf8 '188.8.131.52'), _utf8 'Please work today', _utf8 'Please please please work this time.', _utf8 'please,work,this,time', _utf8 '@', NOW())
Error 1452: Cannot add or update a child row: a foreign key constraint fails (`thescra4_socialpol`.`qa2_posts`, CONSTRAINT `qa2_posts_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `qa2_users` (`userid`) ON DELETE SET NULL)
It appears to be tied to the WordPress user tables integration, since I am able to ask a question when disabling that functionality.