Date index for Jul 2003

Hi,

I'm running on Rehhat 8.0, php 4.2.2, and mysql   Ver 11.18 Distrib 
3.23.52 .  I couldn't get any login to work, then I installed the 0.9.4 
version and that worked and then the 0.8.4 started working too.  Now 
after I login on either version as administrator (they are pointed to 
the same db in the config.ini.php file) I get some screen display but I 
also get a lot of errors listed below.  achievo is the name of the 
database.  I can't do anything, add employees for instance.  I can get 
to the database with phpMyAdmin and it all looks good.  What should I do 
to get this working?

BTW, the 0.9.4 distro doesn't include a mysql script to create the tables.

Logging in on 0.8.4 as administrator gives:

error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: Invalid SQL: SELECT theme from employee where userid='administrator'


error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: Invalid SQL: SELECT theme from employee where userid='administrator'
error: No Database Selected (errno: 1046)
error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: Invalid SQL: SELECT week, userid FROM hours_lock WHERE (userid = 
'administrator' OR userid = '*') AND week = '200331'
error: No Database Selected (errno: 1046)
error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: Invalid SQL: SELECT phase.id, phase.name, project.name as 
projectname FROM project,phase,hours WHERE phase.id=hours.phaseid AND 
userid='administrator' AND phase.status='active' AND 
project.status='active' AND phase.projectid=project.id ORDER BY 
hours.entrydate DESC LIMIT 0, 100
error: No Database Selected (errno: 1046)
error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: Invalid SQL: SELECT hours.id,hours.phaseid,B.name AS al_A,A.name 
AS al_B,C.name AS al_C,hours.activityid,hours.remark,hours.time FROM 
hours JOIN activity C LEFT JOIN phase A ON A.id=hours.phaseid LEFT JOIN 
project B ON B.id=A.projectid WHERE userid='administrator' AND 
activitydate='2003-07-30' AND C.id=hours.activityid LIMIT 0, 25
error: No Database Selected (errno: 1046)
error: cannot use database achievo.
error: No Database Selected (errno: 1046)
error: Invalid SQL: SELECT COUNT(*) as count FROM hours JOIN activity C 
LEFT JOIN phase A ON A.id=hours.phaseid LEFT JOIN project B ON 
B.id=A.projectid WHERE userid='administrator' AND 
activitydate='2003-07-30' AND C.id=hours.activityid

And logging in as administrator on 0.9.4 gives:

error: [+00.04501s] cannot use database achievo.

error: [+00.48491s] cannot use database achievo.
error: [+00.59788s] Access denied for user: 'achievo dot 
database 'achievo' (errno: 1044)
error: [+00.59793s] cannot use database achievo.
error: [+00.61587s] Access denied for user: 'achievo dot 
database 'achievo' (errno: 1044)
error: [+00.61592s] cannot use database achievo.
error: [+00.71187s] Access denied for user: 'achievo dot 
database 'achievo' (errno: 1044)
error: [+00.71193s] cannot use database achievo.
error: [+00.71619s] Access denied for user: 'achievo dot 
database 'achievo' (errno: 1044)
error: [+00.71625s] cannot use database achievo.