The error output when I ask questions without selecting a category

Question

Question2Answer query failed:

INSERT INTO qa_posts (categoryid, type, parentid, userid, cookieid, createip, title, content, format, tags, notify, created) VALUES (_utf8 '', _utf8 'Q', NULL, _utf8 '1', NULL, INET_ATON(_utf8 '2.134.150.245'), _utf8 'fse fsef esfsefsefesfesfse', _utf8 '', _utf8 '', _utf8 '', _utf8 '@', NOW())

Error 1452: Cannot add or update a child row: a foreign key constraint fails (`surakz5_surak/qa_posts`, CONSTRAINT `qa_posts_ibfk_3` FOREIGN KEY (`categoryid`) REFERENCES `qa_categories` (`categoryid`) ON DELETE SET NULL)

Comments

What version are you using?

---

1,4- beta 1. This is a mistake, too, you have to go on this site.

---

http://pics.kz/s2/99/27/a6/9927a6f6e777423c2c9512e73b273533.png

Answer 1

OK, got it. This happens when you ask a question via the ask box widget, rather than via the 'Ask a Question' navigation link.

The solution is to add these lines in qa-page-ask.php, before the comment "Check for permission error":

if (!isset($categories[$incategoryid]))

$incategoryid=null;

 

This will of course be fixed in the next release.