Time Report Error
Page: 1
Recent posts in this topic
Pro
Peter Schmitt
on May 29. 2008. 1:52 pm
Hi Ilija and All,
Just to share some errors I found after the upgrade.
When creating new time report:
First I got an error that the query failed because the is_default does not have default value, I fixed it by setting it to 0.
And then when choosing anybody:
Query failed with message 'Data truncated for column 'user_filter' at row 1'
UPDATE sac_time_reports SET user_filter = 'anybody', user_filter_data = 'N;', date_filter = 'selected_range', date_from = '2008-04-01', date_to = '2008-04-30' WHERE id = '5'
I'm guessing it's because 'anybody' does not exist in the enum:
`user_filter` enum('anyone','logged_user','company','selected')
Not sure the best approach for this, changing the enum or the dropdown value. Any idea? Anybody else had the same problem?
Just to share some errors I found after the upgrade.
When creating new time report:
First I got an error that the query failed because the is_default does not have default value, I fixed it by setting it to 0.
And then when choosing anybody:
Query failed with message 'Data truncated for column 'user_filter' at row 1'
UPDATE sac_time_reports SET user_filter = 'anybody', user_filter_data = 'N;', date_filter = 'selected_range', date_from = '2008-04-01', date_to = '2008-04-30' WHERE id = '5'
I'm guessing it's because 'anybody' does not exist in the enum:
`user_filter` enum('anyone','logged_user','company','selected')
Not sure the best approach for this, changing the enum or the dropdown value. Any idea? Anybody else had the same problem?
Staff
Ilija Studen
on May 29. 2008. 1:55 pm
Hi Peter,
Thanks for the detailed report. I'll have this checked first thing in the morning (it's 10PM here) and report back with a fix.
Thanks for the detailed report. I'll have this checked first thing in the morning (it's 10PM here) and report back with a fix.
activeCollab Team Member
Pro
Peter Schmitt
on May 30. 2008. 11:04 am
Hi Ilija,
The upgrade that I was referring was v1.1
Is this fixed by release 1.1.1? Cause I didn't see it on the list.
Thanks for the quick feedback.
The upgrade that I was referring was v1.1
Is this fixed by release 1.1.1? Cause I didn't see it on the list.
Thanks for the quick feedback.
Staff
Ilija Studen
on May 30. 2008. 1:45 pm
Hi Peter,
This problem is still present in v1.1.1. You should execute following query to alter acx_time_reports table:
We'll have this covered in the next release.
This problem is still present in v1.1.1. You should execute following query to alter acx_time_reports table:
ALTER TABLE `acx_time_reports` CHANGE `user_filter` `user_filter` ENUM( 'anybody', 'logged_user', 'company', 'selected' ) NOT NULL DEFAULT 'anybody'
We'll have this covered in the next release.
activeCollab Team Member
