[SPTUsers] installComplete.php

[Michael McFadden]

Thank you for the help that seems to have fixed the problem.  How long
should it take for the localhost/SPT/SPT--Install.php to run its course.  It
has been 30 minutes already any reason I should be concerned at this point.
Also I am trying to find the documentation for The Scout Portal Toolkit. 
>  -----Original Message-----
> From: 	Cornejo, Luis [mailto:lcornejo at dep.anl.gov] 
> Sent:	Wednesday, March 12, 2003 2:11 PM
> To:	'Michael McFadden'
> Subject:	RE: [SPTUsers] installComplete.php
> 
> I believe I encountered that problem before, and it was a very persistent
> one. I believe if you go ahead and drop the entire database and recreate
> it, it will solve the problem.
> 
> -luis- 
> 
> 		-----Original Message-----
> 		From: Michael McFadden [mailto:mmcfadden at mtc-inc.com] 
> 		Sent: Wednesday, March 12, 2003 3:19 PM
> 		To: Scout Portal Users Group
> 		Subject: RE: [SPTUsers] installComplete.php
> 
> 			I was able to download a program called control
> center from the mysql site.  This allowed me to look at my database that I
> had created through a GUI and delete all of the tables.  With this
> software I was able to figure out my previous question.  However I am
> still getting the same error even though it doesn't appear I have any
> tables in my database.
> 
> 			The following problems were detected during
> installation:
> 
> 				Could not successfully execute SQL command:
> 
> 
> 				CREATE TABLE APSessions (
> 				SessionId INT NOT NULL,
> 				LastActiveDate DATETIME NOT NULL,
> 				INDEX (SessionId)
> 				);
> 
> 				(SQL error message: Table'APSessions'
> already exists)
> 
> 			If anyone has any idea why I might still be getting
> this error message it sure would save my week.
> 			Thanks again for the help.  Michael 
> 
> 			I am having another problem with the
> SPT--InstallComplete.php
> 			Here is what is listed on the page after I enter the
> relevant info into Install.php and hit continue.
> 
> 			The following problems were detected during
> installation:
> 
> 				Could not successfully execute SQL command:
> 
> 
> 				CREATE TABLE APSessions (
> 				SessionId INT NOT NULL,
> 				LastActiveDate DATETIME NOT NULL,
> 				INDEX (SessionId)
> 				);
> 
> 				(SQL error message: Table'APSessions'
> already exists)
> 
> 			I am using RedHat 8.0 w/ apache or httpd ver.
> 2.0.40-8, php ver. 4.2.2-8.0.5, mysql ver. 3.23.52-3
> 
> 			I created a Database called SPT and didn't create
> any tables that I know of.  I used the command:     mysqladmin create spt
> 			Next I used the mysqladmin command to create a user
> and password.  I am not sure how to get back into mysql to even verify
> that the Table APSessions exists.
> 			After I create the username and password I seem to
> be locked out.  If I try to enter a command for example:  mysqladmin
> create whatever       I get an error of:  mysqladmin:  connect to server
> at 'localhost' failed 
> 			error:  'Access denied for user:  'root at localhost'
> (Using password: NO)'
> 
> 			Any help would be great like what command would I
> use to remove tables within the SPT database or how now do I login to
> mysqladmin.  Or is there something else I am missing.  I did install the
> mysql-php rpm so I am pretty sure that php and mysql are talking to each
> other.
> 
> 			Michael McFadden
> 			Meeting the Challenge
> 			719-444-0252
> 
> 			 << File: ATT00526.txt >>  << File: ATT40287.txt >> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4831 bytes
Desc: not available
Url : http://scout.wisc.edu/pipermail/sptusers/attachments/20030312/e9840fdc/winmail.bin