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

Upgrade Database Error

+1 vote
496 views
in Q2A Core by

1 upgrade step/s remaining...

Running query: ALTER TABLE qa_posts DROP FOREIGN KEY qa_posts_ibfk_3 ...


Warning: Cannot modify header information - headers already sent by (output started at /xxx/xxx/public_html/qa-include/qa-db-install.php:1019) in /xxx/xxx/public_html/qa-include/qa-install.php on line 60
Question2Answer was unable to perform the installation query below. Please check the user in the config file has CREATE and ALTER permissions:

ALTER TABLE qa_posts DROP FOREIGN KEY qa_posts_ibfk_3

Error 1025: Error on rename of './aumnik_vio/qa_posts' to './aumnik_vio/#sql2-6fc-1019423' (errno: 152)

1 Answer

+3 votes
by

I think this is because the foreign key constraint has a different name to what's expected, perhaps due to some manual database changes that were performed. You'd need to examine your qa_posts table to see what name is used for the constraint that refers to the qa_categories table, and then modify the line after case 30: in qa-db-install.php accordingly.

Snow Theme by Q2A Market
Powered by Question2Answer
...