[SOLVED]Invoice | No activities shown...

More
06 Jan 2013 12:40 - 07 Jan 2013 17:23 #533 by studiolabrame
studiolabrame created the topic: [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
Last Edit: 07 Jan 2013 17:23 by admin.

Please Log in or Create an account to join the conversation.

More
06 Jan 2013 16:21 #534 by admin
admin replied the topic: Re: Invoice | No activities shown...
thanks for the report.
I'll investigate and publish a new version ASAP

Please Log in or Create an account to join the conversation.

More
06 Jan 2013 18:24 #535 by admin
admin replied the topic: Re: Invoice | No activities shown...
please, can you check if your #__tracktime_trackers table has the column tr_id_hours?
can you enable the joomla debug and see if there is an sql error?

Please Log in or Create an account to join the conversation.

More
06 Jan 2013 20:40 #538 by studiolabrame
studiolabrame replied the topic: Re: Invoice | No activities shown...
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!

Please Log in or Create an account to join the conversation.

More
07 Jan 2013 16:58 - 07 Jan 2013 16:58 #542 by admin
admin replied the topic: Re: Invoice | No activities shown...
mhm... this is really weird, since the column ho_billed has been added quite ago...
however, do you know how to run queries into phpmyadmin?
if so, run this alter table:

ALTER TABLE `#__tracktime_hours` ADD `ho_billed` TINYINT NOT NULL AFTER `ho_total`;

(remember to replace #_ with your database prefix)
Last Edit: 07 Jan 2013 16:58 by admin.
The following user(s) said Thank You: studiolabrame

Please Log in or Create an account to join the conversation.

More
07 Jan 2013 17:14 #543 by studiolabrame
studiolabrame replied the topic: Re: Invoice | No activities shown...
Yes! that query did the trick! Solved for me.
Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.236 seconds