Page 1 of 1

Can`t create a new absence

Posted: 2015-10-21, 11:14
by Ellwood
Hello, i am using version 36019. I cannot create a new absence. I get this notice:

TeamCal Pro Database Error

Module: db_model.php

Class: Db_model

Function: db_query(), Line 125

Error:

Error: A problem was encountered while executing this query:

INSERT INTO `my_tc_absences` (
`name`,
`symbol`,
`icon`,
`color`,
`bgcolor`,
`bgtransparent`,
`factor`,
`allowance`,
`counts_as`,
`show_in_remainder`,
`show_totals`,
`approval_required`,
`counts_as_present`,
`manager_only`,
`hide_in_profile`,
`confidential`,
`admin_allowance`
) VALUES (
'Lehrgang',
'A',
'No',
'000000',
'FFFFFF',
'',
'1',
'0',
'0',
'1',
'1',
'0',
'0',
'0',
'0',
'0',
''
)

SQL Error:

Unknown column 'bgtransparent' in 'field list'

Execution halted


Please, can you help me?
Thank you very much!

Timo

Re: Can`t create a new absence

Posted: 2015-11-04, 18:43
by Ellwood
I fixed the problem. In the datatable my_tc_absences was the field bgtransparent missing.
I do not why. I changed the datatable with a new one from a new installation and it works fine! :D

Re: Can`t create a new absence

Posted: 2015-11-08, 19:52
by George
Glad it worked. You may have missed an update step along the way (or I may have forgotten to put it down in the upgrade text file :( )