Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+11 votes
1.3k views
in Q2A Core by
closed by

Hi, I'm new to this site. I want to install this site in my local server. But I'm unable to do so.

I'm following https://docs.question2answer.org/install/ but getting following database error.

Fatal error: Uncaught mysqli_sql_exception: Table 'qa_tuts.qa_options' doesn't exist in C:\xampp\htdocs\qa\qa-include\qa-db.php:227 Stack trace: #0 C:\xampp\htdocs\qa\qa-include\qa-db.php(227): mysqli->query('SELECT title, c...') #1 C:\xampp\htdocs\qa\qa-include\qa-db.php(202): qa_db_query_execute('SELECT title, c...') #2 C:\xampp\htdocs\qa\qa-include\qa-db.php(557): qa_db_query_raw('SELECT title, c...') #3 C:\xampp\htdocs\qa\qa-include\qa-db.php(590): qa_db_single_select(Array) #4 C:\xampp\htdocs\qa\qa-include\app\options.php(135): qa_db_multi_select(Array) #5 C:\xampp\htdocs\qa\qa-include\qa-base.php(403): qa_preload_options() #6 C:\xampp\htdocs\qa\qa-include\qa-page.php(36): qa_initialize_postdb_plugins() #7 C:\xampp\htdocs\qa\qa-include\qa-index.php(188): require('C:\\xampp\\htdocs...') #8 C:\xampp\htdocs\qa\index.php(27): require('C:\\xampp\\htdocs...') #9 {main} thrown in C:\xampp\htdocs\qa\qa-include\qa-db.php on line 227

Can anyone help me ?

Q2A version: latest version
by
I used xampp server ( Apache + MariaDB + PHP + Perl ) from the link https://www.apachefriends.org/index.html, later i come to know that Mysql is required rather than MariaDB.

So I installed Mysql from the site https://dev.mysql.com/downloads/mysql/

Still same problem, So i remove xampp, and install Apache,Php and Mysql from the guidlines in the link https://freelancedev.tech/how-to-setup-apache-php-and-mysql-on-windows-10/

after that i installed phpmyadmin too for my convinience, then try to install q2a, but still the same error i'm getting.

I'm only renaming, changing user credentials and database in qa-config.php file, nothing else i'm doing.

I also checked whether the given user able to create tables or not in the database by using phpmyadmin - Yes, it's creating new tables.

Finally, I'm moving into Linux instead of windows in coming days.
by
So, it's a clean Q2A installation. Which windows is it? 7,8,10 or 11?

But yes, moving to Linux is way easier for setting up websites
by
sir, it's windows 8.
by
Same configuration working in ubuntu. Not able to trace the problem with windows

Welcome to the Q&A site for Question2Answer.

If you have a question about Q2A, please ask here, in English.

To report a bug, please create a new issue on Github or ask a question here with the bug tag.

If you just want to try Q2A, please use the demo site.

Categories

...