
Keystone Frequently Asked Questions
$Id: FAQ,v 1.10 2000/07/07 18:49:02 kiranp Exp $
$Name: keystone-0_74_00 $
---------------------------------------------------------------------
Q: In PTS, there were projects and tasks.  Now there are just slips.
	What gives?

A: Correct.  Keystone makes no distinction between a task with 
	subtasks, and a project.  The seperation of them in PTS was a 
	limitation, since tasks couldn't have children, etc.

	Any slip can have child slips, that can be dependent on the 
	closing of another task, or have child tasks of their own.  Rules
	for how child tasks react to what happens to their parents are
	still in the works.

---------------------------------------------------------------------
Q: What is a Filter?

A: A filter is a certain rule applied to a table that can limit the 
	number of rows you see from that table.  For instance, you can set a
	filter to only show you open slips, or ones you opened, or ones opened
	by a certain technician between two dates. 

	Filters can be set up by the system adminstrator, so any user can 
	select one of tyhe publically defined filters, or users can generate
	their own.  Filters may be turned on and off by just clicking on the 
	'ON' or 'OFF' graphic next to the 'Filters are...' pick on the menu.

	To view/add/edit filters, select 'Filters' under the 'Other' menu.

---------------------------------------------------------------------
Q: I added in a new user, but they can't log in?  What gives?

A: The tool used to add users is a generic table browser, and knows 
	nothing about encrypted passwords.  It stored the password away for
	the user without encrypting it.  Go to the Maintenance functions,
	and click on 'Change Password'.  Change the username to the name
	of the user just added, and type in their new password.  This will
	encrypt their password and store it in the table.

---------------------------------------------------------------------
Q: When I'm installing Keystone for the first time, I'm able to see the
	login screen, but anything after that either comes up with a 'not
	logged in' screen, or a 'mysql' error, or the like.

A: There are many reasons this can happen.  The first is that PHP is
	not configured properly, or MySQL hasn't been configured right.  RUn
	down this checklist to confirm your installation:
	1) create a file called 'test.php3', and put <? phpinfo() ?> in it.
		Point your web browser at it, and make sure you have the database
		support you need in it.
	2) Make sure you have the 'keystone' database created in your system,
		and that your server has all the tables required from the 'struct'
		directory.
	3) Keystone 0.10.07 has more robust error messages in it.  Run that,
		and see if you're getting database errors.

---------------------------------------------------------------------
Q: I've installed MySQL, but I keep getting "you have no permission to
	access this table" or some similar security issue.  How do I 
	get it working?

A: MySQL is very touchy about access configurations in its 'grant' tables,
	and they can be very difficult to get right.  If your security
	model allows it, try running 'mysqld' with '--skip-grant-tables'.
	If that works, then everything but your grant tables is configured
	properly.

	Another issue that comes up is that the MIT pthreads library 
	frequently doesn't allow 'localhost' as a target host for the connect
	function.  Put in a FQDN, and try again.

---------------------------------------------------------------------
Q: I'm still getting "You have no permission to access this table" but I 
	don't want to run using '--skip-grant-tables'.  Is there any hope?

A: Yup.  Matt Barnson (matt_barnson@singletrac.com) wrote a good blurb on
	how to set up the grant tables correctly.  It's in 'grant_tables.txt'
	in your 'docs' directory where you installed Keystone.

---------------------------------------------------------------------
Q: When I select Slips->Properties (or Contacts->Properties), the
	instructions under "Main Slips View" says "Check the columns
	you want to appear in the normal slips view." but there is
	nothing to check.  I'm using Postgres as the database engine.

A: The current Postgres query in properties.php3 will not list
	anything under the "Main Slips View" column the first time a
	user attempts to edit their properties.  This is because (1)
	Postgres version < 6.5 does not support outer joins and (2)
	the query being used by Postgres does an inner join only
	finding previous user settings.

	Fortunately, there is a bug in the properties update that
	inserts rows into propdisp even if the user does not
	change/set anything.  So, if the user selects
	Slips->Properties then hits the "Post Changes" button they can
	Slips->select Slips->Properties a second time and see the full
	Slips->list.

	Once Postgres 6.5 is released (it will probably go beta in
	February 1999), outer joins will supposedly be supported
	(maybe, the programmer working on that isn't as far along as
	he would like).  Once outer joins are part of Postgres, an
	upgrade to 6.5 will be mandatory....

	I am reluctant to "fix" this with an elaborate set of queries
	since the real fix will be when Postgres supports outer joins
	and that is already on the radar screen....

---------------------------------------------------------------------
Q: I've just installed Keystone, and I hit my first page.  I get 
	the following error:

	Fatal error: Call to unsupported or undefined function 
	mysql_pconnect() in mysql.php3 on line 16

A: You're either running an older version of PHP (you should be running
	3.0.6 or later), or you do not have MySQL support compiled
	into your PHP.  Recompile --with-mysql, and try again.

---------------------------------------------------------------------
Q: I can't seem to get more than one person to appear as a member of
	the 'Tech' or 'Admin' groups.  What gives?

A: Certain browsers don't handle the Maintenance->Group lists functions
	correctly.  You need to highlight -all- the members of the group
	and then click "Post Listing".  You may need to hold down the Control 
	key when selecting more than one person, depending on the browser.

---------------------------------------------------------------------
Q: I'm running IE, and get the following error when working with
	slips: MySQL error #1064 in function db_query parse error 
	near  'xpent=' at line 1

A: This is a problem that comes up in international versions of Internet
	Explorer, where '&time;' is a keyword.  The current CVS version of
	Keystone has this fixed, or yoiu can manually edit 'slips.php3', looking
	for 'timespent', and changing it to read &amp;timespent.  Should be around
	line 201.

