11
ghia
Re: No Users can access to ZenTrack module
  • 2008/9/13 21:25

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Did you create (somewhere in admin) some departments?

12
atisolution
Re: No Users can access to ZenTrack module

Sure, I have some of departments before modify it in department's email.

13
ghia
Re: No Users can access to ZenTrack module
  • 2008/9/14 8:20

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Could you list the 8 queries used in your last image?

14
atisolution
Re: No Users can access to ZenTrack module

hi

Here it is

Quote:

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '91fe3bbe258ef06a3eb34b379bd50a35'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xhelp'
SELECT * FROM xoops_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_xhelp_status ORDER BY description ASC
SELECT COUNT(*) FROM xoops_xhelp_tickets WHERE status = '3'
SELECT COUNT(*) FROM xoops_xhelp_tickets WHERE status = '2'
SELECT COUNT(*) FROM xoops_xhelp_tickets WHERE status = '1'
SELECT u.uid, u.uname, u.name, (s.responseTime / s.ticketsResponded) as AvgResponseTime FROM xoops_users u INNER JOIN xoops_xhelp_staff s ON u.uid = s.uid WHERE ticketsResponded > 0 ORDER BY AvgResponseTime LIMIT 0, 5
SELECT SUM(callsClosed) FROM xoops_xhelp_staff
SELECT t.*, (UNIX_TIMESTAMP() - t.posted) as elapsed, (UNIX_TIMESTAMP() - t.lastUpdated) as lastUpdate FROM xoops_xhelp_tickets t INNER JOIN xoops_xhelp_status s ON t.status = s.id WHERE s.state <> '2' ORDER BY priority ASC LIMIT 0, 10



Could you help me to fix it?

Thanks in advance

15
ghia
Re: No Users can access to ZenTrack module
  • 2008/9/15 7:41

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


I think that the listed queries are not the queries from your last image.
You have to copy them from where it says 'Could not find Department ID. Aborting'.

Thus, after submitting the email box.

16
atisolution
Re: No Users can access to ZenTrack module

hi

Yes, Here it is

Quote:

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '806e1ae26fe00d760da27eba33d31688'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xhelp'
SELECT * FROM xoops_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner


17
ghia
Re: No Users can access to ZenTrack module
  • 2008/9/15 12:57

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Is it?
It has to be from that error page (which says 7 and I count 8 queries), not from the next.

18
atisolution
Re: No Users can access to ZenTrack module

hi

Yes, it is

19
ghia
Re: No Users can access to ZenTrack module
  • 2008/9/16 20:01

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


It appears that ZenTrack has a own connection for mySQL. To see the debug output of ZenTrack, you have to set $debug=3; in header.php .

20
atisolution
Re: No Users can access to ZenTrack module

ok - already set $debug=3 - what information do you need for your debug?

My error for xHelp is:

Quote:

Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '18fcd3e8f17b1e327428f71162caeec6'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xhelp'
SELECT * FROM xoops_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner


Login

Who's Online

303 user(s) are online (250 user(s) are browsing Support Forums)


Members: 0


Guests: 303


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits