CiviCRM Community Forums (archive)

This might need to go somewhere else, but it seems like a couple of the database tables aren't created until you actually enter the first extended care entry.

I received a DB error, no table, on this page: /civicrm/sfschool/extendedCareSummary?reset=1
until I added an extended care entry, then the table was obviously there

Still get the error on this page: /civicrm/sfschool/extended/class?reset=1
Database Error Code: Table 'CiviCRM.sfschool_extended_care_source' doesn't exist, 1146
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT     count(entity_id) as current, s.max_participants as max, s.term, s.day_of_week, s.session, s.name
FROM       civicrm_value_extended_care e
INNER JOIN sfschool_extended_care_source s ON ( s.term = e.term AND s.day_of_week = e.day_of_week AND s.session = e.session AND s.name = e.name )
WHERE      e.has_cancelled = 0
AND        s.term = 'Spring 2011'
 GROUP BY term, day_of_week, session, name [nativecode=1146 ** Table 'CiviCRM.sfschool_extended_care_source' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT     count(entity_id) as current, s.max_participants as max, s.term, s.day_of_week, s.session, s.name
FROM       civicrm_value_extended_care e
INNER JOIN sfschool_extended_care_source s ON ( s.term = e.term AND s.day_of_week = e.day_of_week AND s.session = e.session AND s.name = e.name )
WHERE      e.has_cancelled = 0
AND        s.term = 'Spring 2011'
 GROUP BY term, day_of_week, session, name [nativecode=1146 ** Table 'CiviCRM.sfschool_extended_care_source' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT     count(entity_id) as current, s.max_participants as max, s.term, s.day_of_week, s.session, s.name
FROM       civicrm_value_extended_care e
INNER JOIN sfschool_extended_care_source s ON ( s.term = e.term AND s.day_of_week = e.day_of_week AND s.session = e.session AND s.name = e.name )
WHERE      e.has_cancelled = 0
AND        s.term = 'Spring 2011'
 GROUP BY term, day_of_week, session, name [nativecode=1146 ** Table 'CiviCRM.sfschool_extended_care_source' doesn't exist]"]
)
Again, all of this may belong in another thread

Sadly I don't think I'll be able to devote much time to beta testing this as I was hoping to use it for attendance at my weekly class meetings. Doesn't seem like it is meant or setup for that.

Thanks,
Matt