in the "single calendar" event if i uncheck the "runs at check box" it throws the following error
MySource Error
File: [SYSTEM_ROOT]/core/include/assertions.inc Line: 504
Message: [ASSERT EXCEPTION] DB Error: unknown error
UPDATE sq_cal_date_val SET start_date_seconds = null,start_date_minutes = null,start_date_hours = null,start_date_mday = 18,start_date_mon = 1,start_date_year = 2006,start_date_ts = 1137502800,start_date_ds = 13166,start_date_wday = 3,start_date_yday = 18,start_date_ms = 24073,start_date_ryday = 348,start_date_rmday = 14,start_date_wdom = 3,start_date_rwdom = 2,end_date_seconds = null,end_date_minutes = null,end_date_hours = null,end_date_mday = null,end_date_mon = null,end_date_year = null,end_date_wday = null,end_date_yday = null,end_date_ts = null,end_date_ds = null,end_date_ms = null,end_date_ryday = null,end_date_rmday = null,end_date_wdom = null,end_date_rwdom = null,frequency = '' WHERE assetid = '1199' [nativecode=ERROR: relation "sq_rollback_timestamp" does not exist CONTEXT: PL/pgSQL function "sq_get_rollback_timestamp" line 4 at select into variables PL/pgSQL function "sq_cal_date_val_rb_trg_fn" line 1 at SQL statement] (LINE 740 IN
Backtrace: Show
This looks like a much more general error you are getting with rollback. We sometimes see this error when PostgreSQL seems to get confused about a temporary table we are using.
Can you try running install/step_02.php again to see if Matrix can recreate it for you.
Also, what version of Postgres are you using?
we are on pilot stage, i suppose the version of postgres that you provided.
could you pls let me know the steps involved in running the install/step_02.php
$ cd /path/to/matrix
$ php install/step_02.php .
by default the calendar is setup to view by "Month"
At the runtime mode, when i try to view by year the following error displays
Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 42 bytes) in /var/www/matrix/packages/calendar/lib/calendar_common.inc on line 861
You need to beef up the amount of memory available to Matrix by editing mysource_matrix/core/web/index.php and increasing the memory limit in that file.