CMS MADE SIMPLE FORGE

Khronos

 
Back Back to List

[#12678] Import from CGCalendar - stops add_event working 'event_status' field needs to be added

avatar
Created By: Chris Taylor (chrisbt)
Date Submitted: Thu Jan 04 14:27:41 -0500 2024

Assigned To: Fernando Morgado (JoMorg)
Version: 1.0.0
CMSMS Version: 2.2.18
Severity: Minor
Resolution: Awaiting Response
State: Open
Summary:
Import from CGCalendar - stops add_event working 'event_status' field needs to be added
Detailed Description:
After add_event sumbit
FATAL ERROR:
QUERY = INSERT INTO cms_module_khronos_events (event_id, event_title,
event_summary, event_details, event_date_start, event_date_end, event_parent_id,
event_recur_period, event_date_recur_end, event_created_by, event_recur_nevents,
event_recur_interval, event_recur_weekdays, event_recur_monthdays,
event_allows_overlap,event_all_day,event_status, event_create_date,
event_modified_date) VALUES (3723,'Just a TEST EVENT...','Chris just testing','
sdfasf g agar e hdyer yery  e ye yeywe we y we

','2024-01-10
12:00:00',NULL,-1,'none',NULL,-105,-1,-1,'','',1,0,'P',NOW(),NOW())
ERROR = Unknown column 'event_status' in 'field list'

Haven't looked at the code yet - might do tomorrow


History

Comments
avatar 
Date: 2024-01-05 04:40
Posted By: Chris Taylor (chrisbt)

After import from CGCalendar field 'event_status C(1)' needs to be added ... and
maybe set to published?
avatar 
Date: 2024-07-03 06:25
Posted By: Fernando Morgado (JoMorg)

Sorry cannot reproduce, a vanilla install of Khronos has the field created as
expected, and importing from CGCalendar should just copy from the original db...
need more on this, in particular any php errors on import if any. thanks
Updates

Updated: 2024-07-03 06:25
resolution_id: 5 => 10

Updated: 2024-01-05 04:40
description: FATAL ERROR: QUERY = INSERT INTO cms_module_khronos_events (event_id, event_title, event_summary, event_details, event_date_start, event_date_end, event_parent_id, event_recur_period, event_date_recur_end, event_created_by, event_recur_nevents, event_rec => After add_event sumbit FATAL ERROR: QUERY = INSERT INTO cms_module_khronos_events (event_id, event_title, event_summary, event_details, event_date_start, event_date_end, event_parent_id, event_recur_period, event_date_recur_end, event_created_by, event_
summary: Unknown column 'event_status' in 'field list' when adding a new entry => Import from CGCalendar - stops add_event working 'event_status' field needs to be added
resolution_id: => 5