I’m getting the following SQL error running Postgres on a new trunk
installation.
Can anyone shed some light on a potential fix?
Thanks,
Nathan
Database error
Invalid SQL: SELECT count() FROM egw_etemplate WHERE
et_name=’.calendar’ AND et_template=’’ AND et_lang=’##’ AND
et_group=’’ AND et_version=’’:
ERROR: invalid input syntax for integer: ""
LINE 1: … AND et_template=’’ AND et_lang=’##’ AND et_group=’’ AND et_…
^
(^ points to et_group=’’) #0 /var/www/egroupware/phpgwapi/inc/class.egw_db.inc.php(674):
egw_db->halt(‘Invalid SQL: SE…’, 840, ‘/var/www/egroup…’) #1 /var/www/egroupware/phpgwapi/inc/class.egw_db.inc.php(1949):
egw_db->query('SELECT count()…’, 840, ‘/var/www/egroup…’, false,
-1, false, 2) #2 /var/www/egroupware/phpgwapi/inc/class.egw_db.inc.php(1680):
egw_db->select(‘egw_etemplate’, ‘count(*)’, Array, 840,
’/var/www/egroup…’) #3 /var/www/egroupware/etemplate/inc/class.soetemplate.inc.php(840):
egw_db->insert(‘egw_etemplate’, Array, Array, 840,
’/var/www/egroup…’, ‘etemplate’) #4 /var/www/egroupware/etemplate/inc/class.boetemplate.inc.php(971):
soetemplate->save(’.calendar’, ‘’, ‘##’, 0, ‘.’) #5 /var/www/egroupware/etemplate/inc/class.boetemplate.inc.php(834):
boetemplate->save(’.calendar’, ‘’, ‘##’) #6 /var/www/egroupware/etemplate/inc/class.boetemplate.inc.php(887):
boetemplate::test_import(‘calendar.edit_s…’) #7 /var/www/egroupware/etemplate/inc/class.boetemplate.inc.php(940):
boetemplate->read_from_cache(‘calendar.edit_s…’, ‘’, ‘’, 0, ‘’) #8 /var/www/egroupware/etemplate/inc/class.boetemplate.inc.php(89):
boetemplate->read(‘calendar.edit_s…’, ‘’, ‘’, 0, ‘’, ‘’) #9 /var/www/egroupware/etemplate/inc/class.etemplate.inc.php(146):
boetemplate->__construct(‘calendar.edit_s…’, ‘’) #10 /var/www/egroupware/calendar/inc/class.calendar_uiviews.inc.php(631):
etemplate->__construct(‘calendar.edit_s…’) #11 /var/www/egroupware/calendar/inc/class.calendar_uiviews.inc.php(517):
calendar_uiviews->edit_series() #12 /var/www/egroupware/calendar/inc/class.calendar_uiviews.inc.php(228):
calendar_uiviews->week(0, true) #13 [internal function]: calendar_uiviews->home() #14 /var/www/egroupware/phpgwapi/inc/common_functions.inc.php(867):
call_user_func(Array) #15 /var/www/egroupware/calendar/inc/class.calendar_hooks.inc.php(67):
ExecMethod(‘calendar.calend…’) #16 [internal function]: calendar_hooks::home(Array) #17 /var/www/egroupware/phpgwapi/inc/common_functions.inc.php(867):
call_user_func(‘calendar_hooks:…’, Array) #18 /var/www/egroupware/phpgwapi/inc/class.hooks.inc.php(152):
ExecMethod(‘calendar_hooks:…’, Array) #19 /var/www/egroupware/home/index.php(247): hooks->single(‘home’, ‘calendar’) #20 {main}
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
