ihsn / nada

National Data Archive (NADA) is an open source data cataloging system that serves as a portal for researchers to browse, search, compare, apply for access, and download relevant census or survey information. It was originally developed to support the establishment of national survey data archives.
http://nada.ihsn.org
MIT License
38 stars 10 forks source link

Issues running the installer #73

Open jareddewitt opened 1 year ago

jareddewitt commented 1 year ago

Discussed in https://github.com/ihsn/nada/discussions/72

Originally posted by **jareddewitt** February 24, 2023 I'm having issues running the installer after setup. When I browse to **http://your-domain/nada-folder-name**, i get redirected to **http://your-domain/nada-folder-name/index.php/install** and only a blank pages is displayed. This seems to happen in docker as well as a fresh install on nginx, php7.3, mysql.
BioLionMM commented 1 year ago

I have the same problem.

mah0001 commented 1 year ago

@BioLionMM, try these:

  1. Create an empty database to use with NADA
  2. Update the application/config/database.php to make sure the database name and database user/name are correct
  3. Edit the index.php file in the root folder and on line 66 change the environment to "development" from "production". This will show all PHP errors on the page.

Please post any error messages you get here so we can further debug what's happening.

BioLionMM commented 1 year ago

@mah0001 I did as you said, and have this error:


An uncaught Exception was encountered

Type: mysqli_sql_exception

Message: Table 'nada.configurations' doesn't exist

Filename: C:\Apache24\htdocs\nada-5.2.1\system\database\drivers\mysqli\mysqli_driver.php

Line Number: 305

Backtrace:

File: C:\Apache24\htdocs\nada-5.2.1\application\models\Configurations_model.php
Line: 47
Function: get

File: C:\Apache24\htdocs\nada-5.2.1\application\models\Configurations_model.php
Line: 140
Function: check_key_exists

File: C:\Apache24\htdocs\nada-5.2.1\application\libraries\Template.php
Line: 104
Function: add

File: C:\Apache24\htdocs\nada-5.2.1\application\core\MY_Controller.php
Line: 28
Function: __construct

File: C:\Apache24\htdocs\nada-5.2.1\application\controllers\Page.php
Line: 6
Function: __construct

File: C:\Apache24\htdocs\nada-5.2.1\index.php
Line: 343
Function: require_once

But I am not supposed to create this table, right? My nada database is empty.

mah0001 commented 1 year ago

Are you on PHP8? The NADA 5.2.1 only supports PHP 7. For PHP8, you can use the branch nada-5.3 (https://github.com/ihsn/nada/tree/nada-5.3).

If this is on PHP 7, edit the database.php file and look for the setting db_debug and make sure db_debug is set to FALSE.

BioLionMM commented 1 year ago

I used nada-5.3 and it worked! I'm seeing the page with the install database button. Thanks a lot!