install step 3 - SQLSTATE[42S02]: Base table

[per mogster]

hI
Trying to install pgv on one.com but i ret an error creating tables in step 3. anyone that have a clue?

SQLSTATE: Base table or view not found: 1146 Table 'moegster_info.pgv_site_setting' doesn't exist

[Gerry Kroll]

Did you create the database before you launched PhpGedView?  PGV can't create the database, but it WILL create or update the tables in an existing database.

[per mogster]

Hi
i copied the instalation files to a subfolder on my website. Hosted by one.com
Moved to that location and the setup started. However stoped at level 3.

i have no gedcom file installed.

[Stephen Arnold]

per
Gerry's question was not GEDCOM, but rather whether you have a database with username/password access already created on One.com?
-Stephen

[per mogster]

Hi
step 2 is seting up the database conections. I use the names etc i got from one.com.
it seems to be ok, and if i change one of them, i get different errors with no access etc…

[per mogster]

If i force the setup to continue, i get:

exception 'PDOException' with message 'SQLSTATE: Base table or view not found: 1146 Table 'moegster_info.pgv_site_setting' doesn't exist' in /customers/moegster.info/moegster.info/httpd.www/phpgedview/includes/classes/class_pgv_db.php:830 Stack trace: #0 : PDOStatement->execute(Array) #1 /customers/moegster.info/moegster.info/httpd.www/phpgedview/includes/classes/class_pgv_db.php(830): call_user_func_array(Array, Array) #2 : PGV_DBStatement->__call('execute', Array) #3 /customers/moegster.info/moegster.info/httpd.www/phpgedview/includes/functions/functions_db.php(2387): PGV_DBStatement->execute(Array) #4 /customers/moegster.info/moegster.info/httpd.www/phpgedview/includes/classes/class_pgv_db.php(779): get_site_setting('PGV_SCHEMA_VERS…') #5 /customers/moegster.info/moegster.info/httpd.www/phpgedview/includes/session.php(279): PGV_DB::updateSchema('/customers/moeg…', 'PGV_SCHEMA_VERS…', 10) #6 /customers/moegster.info/moegster.info/httpd.www/phpgedview/config.php(75): require_once('/customers/moeg…') #7 /customers/moegster.info/moegster.info/httpd.www/phpgedview/install.php(42): require_once('/customers/moeg…') #8 {main}

[Gerry Kroll]

Just because one.com provided you with a database userid and password does NOT mean that you also have a database.

Normally, you'd establish your database with a tool such as phpmyadmin.  After this has been done, PGV will be able to connect that empty database and build the tables.  Afterwards, the tables are populated with your genealogical data.

If you don't know how to set up a database, you should ask one.com to do it for you. 

[per mogster]

hi..
yes i have a database,,,running bbphp there….

[Stephen Arnold]

something wrong with your access URL as you have the base site listed twice, then some kind of link to the public directory, www
/customers/moegster.info/moegster.info/httpd.www/

copied the instalation files to a subfolder on my website.
typically, you would have a directory, named phpgedview or tree or family or roots, etc, located off your main url, just ass you have on on BLOG   http:///moegster.info/phpgedview  and then you'd type http:///moegster.info/phpgedview/install.php (or it should auto start if you've not set the config.php to true).
Stephen

[Greg Roach]

There is almost certainly an error in your database connection settings.

Suggestion: Ignore the installation/setup routine.  Instead, edit the config.php file, and insert the settings there.  In the same file change $CONFIGURED from false to true.  Then visit the index.php page.  Tell us what happens.