[SOLVED]Invoice | No activities shown...

Ola,

Sorry for my quostion, i am a newbee to TRACKTIME.

I haveve added a customer, project and a activity. I ignored the hourstack for now.

After clciking "add an activity entry" I don't see any activity in the list. I know that track time hide activities that have been billed or that are linked to a billed hour stack.

anybody?

Robbert

hi,

1. can you check if your #__tracktime_trackers table has the column tr_id_hours?
YES --> Value is 0

2. can you enable the joomla debug and see if there is an sql error?
see error below...

JDatabaseMySQL::query: 1054 - Unknown column 'ho_billed' in 'where clause' SQL=SELECT tracker.*, cu_name, pr_name, name FROM #_tracktime_trackers tracker INNER JOIN slb12_users ON tr_assigned_to = id INNER JOIN #_tracktime_projects ON tr_id_projects = id_projects INNER JOIN slb12_tracktime_customers ON pr_id_customers = id_customers LEFT JOIN #_tracktime_hours ON tr_id_hours = id_hours WHERE tr_billed = 0 AND (ho_billed = 0 OR ho_billed IS NULL) ORDER BY tr_start DESC LIMIT 0, 20

thanks!

Yes! that query did the trick! Solved for me.
Thank you!