PDA

View Full Version : Accessing reports


dem28
13-01-06, 02:17 AM
Is there anything I have to do to access reports in 2.0.1? I have the 'Administrator' role and the 'All Modules' allow permissions. However, when I access 'reports' from the Projects module or the Help Desk module I get 'Access Denied'. I've went through the permissions course but I didn't see anything related to setting up reports. What am I doing wrong?

Thanks for you help.

pedroa
13-01-06, 02:30 AM
Do you have a mix of CVS code?
About helpdesk you have to go to the System Admin. Modules Helpdesk configure and change the minimin user type for reporting option and save it.

Try again,

Pedro A.

dem28
20-01-06, 12:22 AM
Thank you!

lediz
22-08-07, 07:11 PM
hello

i have de similar error

I have an error if I click to visualize the list of the elemenst (bug/....) I ' indicated anything in the part configures HELPDESK.A what be useful-you it? should it obligatorily be configured?

- my error : if i click on "list/bug/not specified/....)


Welcome Admin Person Help | My Info | Todo | Today | Logout

ERROR: C:\Program Files\EasyPHP 2.0b1\www\dotproject\includes\db_adodb.php(65): Error executing: SELECT hi.*,
CONCAT(co.contact_first_name,' ',co.contact_last_name) assigned_fullname,
co.contact_email as assigned_email,
p.project_id,
p.project_name,
p.project_color_identifier
FROM helpdesk_items hi
LEFT JOIN users u2 ON u2.user_id = hi.item_assigned_to
LEFT JOIN contacts co ON u2.user_contact = co.contact_id
LEFT JOIN projects p ON p.project_id = hi.item_project_id
WHERE ((item_company_id in (4,5,1,2) OR item_created_by=1)
OR item_assigned_to=1
OR (item_requestor_type=1 AND item_requestor_id=1) ) AND item_project_id in (0,1, 3, 4, 2, 5)
ORDER BY hi.item_id LIMIT 0,
Backtrace:
0 C:\Program Files\EasyPHP 2.0b1\www\dotproject\includes\db_adodb.php:65 dprint('C:\\Program Files\\EasyPHP 2.0b1\\www\\dotproject\\includes\\db_adodb.php',65 ,0,'Error executing: SELECT hi.*,
CONCAT(co.contact_first_name,\' \',co.contact_last_name) assigned_fullname,
co.contact_email as assigned_email,
p.project_id,
p.project_name,
p.project_color_identifier
FROM helpdesk_items hi
LEFT JOIN users u2 ON u2.user_id = hi.item_assigned_to
LEFT JOIN contacts co ON u2.user_contact = co.contact_id
LEFT JOIN projects p ON p.project_id = hi.item_project_id
WHERE ((item_company_id in (4,5,1,2) OR item_created_by=1)
OR item_assigned_to=1
OR (item_requestor_type=1 AND item_requestor_id=1) ) AND item_project_id in (0,1, 3, 4, 2, 5)
ORDER BY hi.item_id LIMIT 0,')
1 C:\Program Files\EasyPHP 2.0b1\www\dotproject\includes\db_connect.php:134 db_exec('SELECT hi.*,
CONCAT(co.contact_first_name,\' \',co.contact_last_name) assigned_fullname,
co.contact_email as assigned_email,
p.project_id,
p.project_name,
p.project_color_identifier
FROM helpdesk_items hi
LEFT JOIN users u2 ON u2.user_id = hi.item_assigned_to
LEFT JOIN contacts co ON u2.user_contact = co.contact_id
LEFT JOIN projects p ON p.project_id = hi.item_project_id
WHERE ((item_company_id in (4,5,1,2) OR item_created_by=1)
OR item_assigned_to=1
OR (item_requestor_type=1 AND item_requestor_id=1) ) AND item_project_id in (0,1, 3, 4, 2, 5)
ORDER BY hi.item_id LIMIT 0,')
2 C:\Program Files\EasyPHP 2.0b1\www\dotproject\modules\helpdesk\list.php:424 db_loadList('SELECT hi.*,
CONCAT(co.contact_first_name,\' \',co.contact_last_name) assigned_fullname,
co.contact_email as assigned_email,
p.project_id,
p.project_name,
p.project_color_identifier
FROM helpdesk_items hi
LEFT JOIN users u2 ON u2.user_id = hi.item_assigned_to
LEFT JOIN contacts co ON u2.user_contact = co.contact_id
LEFT JOIN projects p ON p.project_id = hi.item_project_id
WHERE ((item_company_id in (4,5,1,2) OR item_created_by=1)
OR item_assigned_to=1
OR (item_requestor_type=1 AND item_requestor_id=1) ) AND item_project_id in (0,1, 3, 4, 2, 5)
ORDER BY hi.item_id LIMIT 0,')
3 C:\Program Files\EasyPHP 2.0b1\www\dotproject\index.php:322 require('C:\\Program Files\\EasyPHP 2.0b1\\www\\dotproject\\modules\\helpdesk\\list.ph p')

....



Warning: Invalid argument supplied for foreach() in C:\Program Files\EasyPHP 2.0b1\www\dotproject\modules\helpdesk\list.php on line 492


Warning: Division by zero in C:\Program Files\EasyPHP 2.0b1\www\dotproject\modules\helpdesk\list.php on line 616

Erreur de syntaxe pr�s de '' � la ligne 14



Thanks