Ticket #384 (closed Bug report: fixed)

Opened 1 year ago

Last modified 8 months ago

Can't create an admin login during install.php setup.

Reported by: wifidog@b0x.net Assigned to:
Priority: normal Milestone: Not yet assigned to a Milestone
Component: Auth server, Install script Keywords:
Cc:

Description

Administration account

Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "server_stakeholders" does not exist in /home/stewart/www/Portal/install.php on line 1060

Warning: pg_fetch_all() expects parameter 1 to be resource, boolean given in /home/stewart/www/Portal/install.php on line 1061

I'm getting this above the admin Username, Password, Email form. When I fill out the form and click next it goes on, but will not finish the install. I continue to get more errors.

I've used this program for sometime and was doing a little upgrade maintenance. Which of course caused me all kinds of issues. I ended up dumping my database and making a new one basically installing the entire program from scratch. I guess it might not have been me, but something the install script didn't like.

Sincerely,

Not much hair left

Attachments

Change History

09/20/07 04:00:39 changed by wifidog@b0x.net

Here is what I get after entering my admin info and clicking next:

Administration account

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT virtual_host_id FROM virtual_hosts WHERE hostname='hotspot.94stewart.com'

Error message : ERROR: relation "virtual_hosts" does not exist

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT default_virtual_host FROM server ORDER BY creation_date LIMIT 1

Error message : ERROR: relation "server" does not exist

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT virtual_host_id FROM virtual_hosts WHERE hostname='hotspot.94stewart.com'

Error message : ERROR: relation "virtual_hosts" does not exist

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT default_virtual_host FROM server ORDER BY creation_date LIMIT 1

Error message : ERROR: relation "server" does not exist

Fatal error: Uncaught exception 'Exception' with message 'Server::getDefaultVirtualHost: Fatal error: Unable to find the default virtual host!' in /home/stewart/www/Portal/classes/VirtualHost.php:194 Stack trace: #0 /home/stewart/www/Portal/classes/Network.php(133): VirtualHost::getDefaultVirtualHost() #1 /home/stewart/www/Portal/install.php(1049): Network::getDefaultNetwork() #2 {main} thrown in /home/stewart/www/Portal/classes/VirtualHost.php on line 194

09/20/07 13:35:01 changed by benoitg

  • status changed from new to closed.
  • resolution set to fixed.

Darn, you probably just ran into a UI flaw in the install script that caused you not to update your database schema. I really wish the install script had a maintainer. I tried fixing the flaw in [1296], try going through the install script again, and tell us if it works

09/20/07 22:30:12 changed by wifidog@b0x.net

  • status changed from closed to reopened.
  • resolution deleted.

I've tried reinstalling it several times, I get further when I create a fresh database. If I try to reinstall after getting stuck I usually don't get as far. Let me try it one more time right now.

Database initialisation

On localhost, Database wifidog exists and is up to date (shema version 57).

I get to this and it won't let me click next. If I delete the db and start over I can get further to the admin setup part. Is there a way I can just manually create an admin account? Looks like that would solve my issues to at least let me get this working properly again.

09/20/07 22:50:52 changed by wifidog@b0x.net

ok, I grabbed the latest svn as I notice there was an update concerning my issues. I'll give it a whirl.

Thanks

09/20/07 22:52:38 changed by wifidog@b0x.net

good to go, thanks!

09/21/07 14:03:15 changed by benoitg

  • status changed from reopened to closed.
  • resolution set to fixed.

Add/Change #384 (Can't create an admin login during install.php setup.)




Action