Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
in Q2A Core by
I downloaded 1.8.0 fresh yesterday, uploaded to a new folder on our website. Associated with a blank mysql database. I am getting the error:

error 1146: Table 'cwqadb.qa_options' doesn't exist - Query: SELECT title, content FROM qa_options

Please help.

Actually, I have been using 1.7.0. I followed the upgrade instructions to upgrade to 1.8.0. But I am getting blank screen. So I tried fresh installation in new folder with new db as described above.

Please help.
Q2A version: 1.8.0
Is this a plain Q2A installation or one with Wordpress or SSO integration? Where did you download the zip file from (Q2A website or Github)? What PHP version?
It is plain installation. Downloaded from Q2A website. PHP version is 5.2. Have tried 5.4 also. Same results. Note that this is IIS server.

1 Answer

0 votes
edited by

Problem solved after several days!

I had configured FastCGI application on my IIS server to run PHP. So it was not working.

I switched to ISAPI Extension PHP version 5.2.17 and it started working.

The funny part is I already had QA website running successfully on FastCGI.

Setting up a new QA website on new database doesn't work on FastCGI. So switched to ISAPI Extension.

Update: The database (tables) was created after switching to ISAPI. But then installation showed blank page when creating Super Administrator. So I again switched back to FastCGI. This time it succeeded. 

Summary: On IIS we need to switch to ISAPI to create tables and switch back to FastCGI to proceed further with whole setup.

To me that sounds like it could be a problem with the PHP extensions installed on each of the PHP versions. Make sure you have the mysqli extension installed and working correctly.
Well. I directly configured it using Plesk admin UI that my host provides. I am using shared hosting. Not sure how to do it directly from IIS.