[mysql5] problem z polem Opcje

[dyktek]

[SQL] pobierz, plaintext 
SELECT 
DISTINCT tasks.task_id,
task_parent,
task_name, 
task_start_date, 
task_end_date, 
task_dynamic, 
task_pinned, 
pin.user_id AS pin_user,
task_priority, 
task_percent_complete, 
task_duration, 
task_duration_type, 
task_project,
task_description, 
task_owner, 
task_status, 
usernames.user_username,
usernames.user_id, 
task_milestone,
assignees.user_username AS assignee_username, 
count(DISTINCT assignees.user_id) AS assignee_count, 
co.contact_first_name, 
co.contact_last_name,
count(DISTINCT files.file_task) AS file_count, tlog.task_log_problem 
FROM tasks, user_tasks 
LEFT JOIN projects p ON p.project_id = tasks.task_project 
LEFT JOIN users AS usernames ON task_owner = usernames.user_id 
LEFT JOIN user_tasks AS ut ON ut.task_id = tasks.task_id 
LEFT JOIN users AS assignees ON assignees.user_id = ut.user_id 
LEFT JOIN contacts AS co ON co.contact_id = usernames.user_contact 
LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > 0
LEFT JOIN files ON tasks.task_id = files.file_task 
LEFT JOIN user_task_pin AS pin ON tasks.task_id = pin.task_id AND pin.user_id = 12 
WHERE project_active <> 0 AND task_project             = p.project_id AND user_tasks.user_id       = 12 AND user_tasks.task_id       = tasks.task_id AND (task_percent_complete    < 100 OR task_end_date = '') AND p.project_active  = 1 AND p.project_status <> 4 AND p.project_status <> 5 AND task_status = 0
GROUP BY task_id
ORDER BY project_id, task_start_date
[SQL] pobierz, plaintext 

mam takie zapytanie do bazy, ono działa prawidłowo w mysql 4.x problem pojawia przy wykonaniu tego na mysql 5.x chodzi o tą część

[SQL] pobierz, plaintext 
LEFT JOIN projects p ON p.project_id = tasks.task_project
[SQL] pobierz, plaintext 

zwracany jest błąd #1054 - Nieznana kolumna 'tasks.task_project' w on clause, dodaj że taka kolumna istnieje w tej tabeli no i jak pisalem to zapytanie działa w mysql4

[Sh4dow]

problem zaczyna sie od wesji bodajze 5.0.13 gdzie zaladowali standard SQL 2003 (chyba) i sa wlasnie takie problemy, sproboj zamienic

[SQL] pobierz, plaintext 
FROM tasks, user_tasks
[SQL] pobierz, plaintext 

na

[SQL] pobierz, plaintext 
FROM user_tasks, tasks
[SQL] pobierz, plaintext 

nie daje gwarancji ale sproboj poukladac zapytanie odpowienio, bo to prawdpodobnie o to chodzi.

Ten post edytował Sh4dow 13.11.2006, 12:02:49

[dyktek]

pomogło dzięki