View Single Post
  #6  
Old 09-08-12, 11:18 AM
lmessino lmessino is offline
Valued Users
Frequent Visitor
dotProject Version: 2.1.2
php Version: 4.x
MySQL Version: 5.0
Operating System Version: Linux
Browser: Firefox
 
Join Date: 03-08-12
Posts: 18
Default Re: Priority Support

I have a issue when i am update from 2.1.2 ver to 2.1.5
List the next issues :

1.- I don't see in my tab from project all my projects , actually i can't see anything.
2.- When i used the option my info crased my table task_sum and i can drop the table for worked again. Show the code error .

__________________________________________________ ____
ERROR: /services9/webpages/k/a/karismaresorts.net/public/dp2009/includes/db_adodb.php(67): Error executing:

INSERT INTO `tasks_sum`
SELECT task_project, COUNT(distinct tasks.task_id) AS total_tasks,
SUM(task_duration * task_percent_complete * IF(task_duration_type = 24, 8, task_duration_type))/
SUM(task_duration * IF(task_duration_type = 24, 8, task_duration_type)) AS project_percent_complete, SUM(task_duration * IF(task_duration_type = 24, 8, task_duration_type)) AS project_duration
FROM `tasks`
GROUP BY `task_project`

(Column count doesn't match value count at row 1)
Backtrace:
0 /services9/webpages/k/a/karismaresorts.net/public/dp2009/includes/db_adodb.php:67 dprint('/services9/webpages/k/a/karismaresorts.net/public/dp2009/includes/db_adodb.php',67,0,'Error executing:

INSERT INTO `tasks_sum`
SELECT task_project, COUNT(distinct tasks.task_id) AS total_tasks,
SUM(task_duration * task_percent_complete * IF(task_duration_type = 24, 8, task_duration_type))/
SUM(task_duration * IF(task_duration_type = 24, 8, task_duration_type)) AS project_percent_complete, SUM(task_duration * IF(task_duration_type = 24, 8, task_duration_type)) AS project_duration
FROM `tasks`
GROUP BY `task_project`

(Column count doesn\'t match value count at row 1)')
1 /services9/webpages/k/a/karismaresorts.net/public/dp2009/modules/projects/index.php:161 db_exec('INSERT INTO `tasks_sum`
SELECT task_project, COUNT(distinct tasks.task_id) AS total_tasks,
SUM(task_duration * task_percent_complete * IF(task_duration_type = 24, 8, task_duration_type))/
SUM(task_duration * IF(task_duration_type = 24, 8, task_duration_type)) AS project_percent_complete, SUM(task_duration * IF(task_duration_type = 24, 8, task_duration_type)) AS project_duration
FROM `tasks`
GROUP BY `task_project`')
2 /services9/webpages/k/a/karismaresorts.net/public/dp2009/index.php:299 require('/services9/webpages/k/a/karismaresorts.net/public/dp2009/modules/projects/index.php')
<\pre>

ERROR: /services9/webpages/k/a/karismaresorts.net/public/dp2009/classes/query.class.php(628): query failed(SELECT projects.project_id, project_status, project_color_identifier, project_name, project_description, project_duration,
project_start_date, project_end_date, project_color_identifier, project_company, company_name, company_description, project_status,
project_priority, tc.critical_task, tc.project_actual_end_date, tp.task_log_problem, ts.total_tasks, tsy.my_tasks,
ts.project_percent_complete, user_username FROM (`projects`) LEFT JOIN `companies` AS com ON projects.project_company = company_id LEFT JOIN `users` AS u ON projects.project_owner = u.user_id LEFT JOIN `tasks_critical` AS tc ON projects.project_id = tc.task_project LEFT JOIN `tasks_problems` AS tp ON projects.project_id = tp.task_project LEFT JOIN `tasks_sum` AS ts ON projects.project_id = ts.task_project LEFT JOIN `tasks_summy` AS tsy ON projects.project_id = tsy.task_project WHERE projects.project_company = '1' GROUP BY projects.project_id ORDER BY project_end_date asc) - error was: Unknown column 'ts.total_tasks' in 'field list'
Backtrace:
0 /services9/webpages/k/a/karismaresorts.net/public/dp2009/classes/query.class.php:628 dprint('/services9/webpages/k/a/karismaresorts.net/public/dp2009/classes/query.class.php',628,0,'query failed(SELECT projects.project_id, project_status, project_color_identifier, project_name, project_description, project_duration,
project_start_date, project_end_date, project_color_identifier, project_company, company_name, company_description, project_status,
project_priority, tc.critical_task, tc.project_actual_end_date, tp.task_log_problem, ts.total_tasks, tsy.my_tasks,
ts.project_percent_complete, user_username FROM (`projects`) LEFT JOIN `companies` AS com ON projects.project_company = company_id LEFT JOIN `users` AS u ON projects.project_owner = u.user_id LEFT JOIN `tasks_critical` AS tc ON projects.project_id = tc.task_project LEFT JOIN `tasks_problems` AS tp ON projects.project_id = tp.task_project LEFT JOIN `tasks_sum` AS ts ON projects.project_id = ts.task_project LEFT JOIN `tasks_summy` AS tsy ON projects.project_id = tsy.task_project WHERE projects.project_company = \'1\' GROUP BY projects.project_id ORDER BY project_end_date asc) - error was: Unknown column \'ts.total_tasks\' in \'field list\'')
1 /services9/webpages/k/a/karismaresorts.net/public/dp2009/classes/query.class.php:650 exec(2)
2 /services9/webpages/k/a/karismaresorts.net/public/dp2009/modules/projects/index.php:259 loadList()
3 /services9/webpages/k/a/karismaresorts.net/public/dp2009/index.php:299 require('/services9/webpages/k/a/karismaresorts.net/public/dp2009/modules/projects/index.php')
<\pre>
__________________________________________________ _______

3.- When i want to see the tickets section only see the firts 50 but a donīt have the next button or something help me view the others tickets ,and i can see only the firts tickets. And i want order by field don't working too.

4.- When i want active my opportunities module show me the next error
_____________________________________________
Warning
Help
Missing file. Possible Module "opportunities" missing!
______________________________________________

5.- When i go to main section for project i can see the company but i canīt switch for other companies.

I hope you assitant bucause i can see i have a lot problems.

TYSM for u time .

LM

Reply With Quote