"Table 'dbname.qa_options' doesn't exist"

Post date: 2022-05-13 18:18:48
Views: 58

I've installed question2answer on a server from these instructions on an Ubuntu 22.04 server in AWS with Apache/2.4.52 and MariaDB Ver 15.1 Distrib 10.6.7-MariaDB.  There are no plugins being used.

Whenever I get to step 9, I get a 500 error, and when I look at the logs, I see that I'm getting this error--

Uncaught mysqli_sql_exception: Table 'dbname.qa_options' doesn't exist in /var/www/html/qa-include/qa-db.php:227

I've double- and triple-checked the database credentials.  And it also looks like qa_db_create_table_sql is not being called at all.

I see there are similar questions asked here through the years, but I'm finding no answers relevant to my setup.

I'm going to try to continue debugging this on my end to try to find out why this function isn't being called, but if anyone knows how to resolve this, please let me know.

Update: As a workaround, I put this at the beginning of qa_index_set_request() in qa-include/qa-index.php.

     // MANUAL CORRECTION.
     // install if request_uri is "install-0462"

     if ($_SERVER'REQUEST_URI'] == '/install-0462') {
             $msg = 'Starting manual fix for broken installation process.';
             error_log($msg);

             require QA_INCLUDE_DIR . '/db/install.php';

             qa_db_install_tables();
             qa_db_upgrade_tables();

             $msg = "Completed installing.";
             error_log($msg);

             exit();
     }

     // END MANUAL CORRECTION.

Then I just went to /install-0462 and it installed correctly.

That doesn't fix the problem, I guess, but it's working correctly otherwise, so far.  I also had to manually change the user permissions to get an admin user.

Please click Here to read the full story.
 
Other Top and Latest Questions:
A pullback in this biotech stock has created a buying opportunity, according to the charts
Emirates CEO issues apology after Dubai flood chaos; says airline has 30,000 suitcases to return
The highest-paying in-demand jobs that don't require a degree, according to new research
Crypto prices gain to start the week following first Bitcoin halving since 2020
EU threatens to suspend TikTok Lite’s money-for-views program over addiction fears
Any good articles about homelessness and "authority" in the US?
How can i solve the problem?
Verizon reports fewer quarterly subscriber losses on flexible plan demand
How to start a high-paying side hustle: 'It has to be something that you're actually passionate about,' says expert
Baby Reindeer: Season 1