Date index for Jan 2005

If there is a place to report bugs please let me know.

Today nightly build install gives me a ToDo error when I login with a 
regular user with full security privs.

On install it said all tables were good except the calendar beacause it 
was missing the calendar mod. Not sure if its related.



error: [+00.41009s] Table 'JRBTECH.todo' doesn't exist (errno: 1146)
error: [+00.41026s] Invalid SQL: SELECT DISTINCT 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,owner.status AS al_f,projectid.name AS 
al_g,projectid.id AS al_h,todo.title,assigned_to.lastname AS 
al_i,assigned_to.firstname AS al_j,assigned_to.id AS 
al_k,assigned_to.cellular AS al_l,assigned_to.fax AS 
al_m,assigned_to.status AS 
al_n,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='1' AND 
assigned_to <> 0 AND todo.status NOT IN (5,2) ORDER BY duedate, priority
error: [+00.41878s] Table 'JRBTECH.todo' doesn't exist (errno: 1146)
error: [+00.41889s] Invalid SQL: SELECT DISTINCT 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,owner.status AS al_f,projectid.name AS 
al_g,projectid.id AS al_h,todo.title,assigned_to.lastname AS 
al_i,assigned_to.firstname AS al_j,assigned_to.id AS 
al_k,assigned_to.cellular AS al_l,assigned_to.fax AS 
al_m,assigned_to.status AS 
al_n,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='1' AND 
assigned_to<>'1' AND todo.status NOT IN (5,2) ORDER BY duedate, priority



Ivo Jansch wrote: