Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
77 views
in Q2A Core by

When running http://myhost/q2a/index.php?qa=installI am getting the error:

Database query error 1146
Table 'q2a.qa_options' doesn't exist
SELECT title, content FROM qa_options

Here is what I have setup in qa-config.php

define('QA_MYSQL_HOSTNAME', 'localhost');
define('QA_MYSQL_USERNAME', 'qaroot');
define('QA_MYSQL_PASSWORD', '********');
define('QA_MYSQL_DATABASE', 'q2a');

Here are the commands to create database and user:

> create database q2a;
Query OK, 1 row affected (0.00 sec)

> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| q2a                |
| test               |
+--------------------+
5 rows in set (0.00 sec)

> create user 'qaroot'@localhost identified by '********';
Query OK, 0 rows affected (0.00 sec)

> grant all privileges on q2a.* to 'qaroot'@localhost;
Query OK, 0 rows affected (0.00 sec)

> show grants for 'qaroot'@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for qaroot@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'qaroot'@'localhost' IDENTIFIED BY PASSWORD '*7D2FEB9B85E0ABB3C14A02FFFF16317239E3A94D' |
| GRANT ALL PRIVILEGES ON `q2a`.* TO 'qaroot'@'localhost'                                                       |
+---------------------------------------------------------------------------------------------------------------+

Q2A version: 1.8

1 Answer

0 votes
by
You should install the latest version (1.8.3)
...