Date index for Jul 2003
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Database creation script error
After running the creating script provided in versin 0.9.4, logging in with
administrator the errors below appear. The script does not create the table
PERSON.
How is the correct script for creating achievo database from scratch?
error: [+00.07598s] Table 'achievo_0_9.person' doesn't exist (errno: 1146)
error: [+00.07606s] Invalid SQL: SELECT
hours.id,hours.activitydate,userid.lastname AS al_a,userid.firstname AS
al_b,userid.id AS al_c,userid.cellular AS al_d,userid.fax AS
al_e,hours.phaseid,B.name AS al_f,A.name AS al_g,C.name AS
al_h,hours.activityid,hours.remark,hours.time,hours.entrydate FROM hours
LEFT JOIN person userid ON hours.userid=userid.id JOIN activity C LEFT JOIN
phase A ON A.id=hours.phaseid LEFT JOIN project B ON B.id=A.projectid WHERE
activitydate='2003-07-04' AND hours.userid AND C.id=hours.activityid ORDER
BY hours.id
error: [+00.12651s] Table 'achievo_0_9.schedule_attendee' doesn't exist
(errno: 1146)
error: [+00.12712s] Invalid SQL: SELECT DISTINCT
schedule.id,schedule.startdate,schedule.enddate,schedule.starttime,schedule.
endtime,schedule.title,schedule.description,schedule.location,schedule.allda
y,schedule.publicitem,schedule.owner,schedule.status,schedule.scheduletype
FROM schedule LEFT JOIN schedule_attendee ON
schedule_attendee.schedule_id=schedule.id LEFT JOIN person ON
person.id=schedule_attendee.person_id WHERE schedule.startdate
<='2003-07-04' AND schedule.enddate >= '2003-07-04' AND (schedule.owner=''
OR person.id='' OR schedule.all_users = 1) ORDER BY starttime
error: [+00.12958s] Table 'achievo_0_9.person' doesn't exist (errno: 1146)
error: [+00.12965s] Invalid SQL: SELECT id FROM person WHERE userid =
'administrator' AND role='employee'
error: [+00.23242s] Table 'achievo_0_9.person' doesn't exist (errno: 1146)
error: [+00.23249s] Invalid SQL: SELECT todo.id,owner.lastname AS
al_a,owner.firstname AS al_b,owner.id AS al_c,owner.cellular AS
al_d,owner.fax AS al_e,projectid.name AS al_f,projectid.id AS
al_g,todo.title,assigned_to.lastname AS al_h,assigned_to.firstname AS
al_i,assigned_to.id AS al_j,assigned_to.cellular AS al_k,assigned_to.fax AS
al_l,todo.entrydate,todo.duedate,todo.updated,todo.priority,todo.description
,todo.status FROM todo LEFT JOIN person owner ON todo.owner=owner.id LEFT
JOIN project projectid ON todo.projectid=projectid.id LEFT JOIN person
assigned_to ON todo.assigned_to=assigned_to.id WHERE
assigned_to='administrator' AND assigned_to <> 0 AND todo.status NOT IN
(5,2) ORDER BY duedate, priority
error: [+00.23626s] Table 'achievo_0_9.person' doesn't exist (errno: 1146)
error: [+00.23634s] Invalid SQL: SELECT todo.id,owner.lastname AS
al_a,owner.firstname AS al_b,owner.id AS al_c,owner.cellular AS
al_d,owner.fax AS al_e,projectid.name AS al_f,projectid.id AS
al_g,todo.title,assigned_to.lastname AS al_h,assigned_to.firstname AS
al_i,assigned_to.id AS al_j,assigned_to.cellular AS al_k,assigned_to.fax AS
al_l,todo.entrydate,todo.duedate,todo.updated,todo.priority,todo.description
,todo.status FROM todo LEFT JOIN person owner ON todo.owner=owner.id LEFT
JOIN project projectid ON todo.projectid=projectid.id LEFT JOIN person
assigned_to ON todo.assigned_to=assigned_to.id WHERE
todo.owner='administrator' AND assigned_to<>'administrator' AND todo.status
NOT IN (5,2) ORDER BY duedate, priority