CharlesMx
Missing DB column after update
After updating to 1.1.10 we now get an SQL error due to missing column 'content' prohibiting events from being saved. I verified the column is not in the database. It appears the updater didn't add the column. I added the column with the type of text to get rid of the error but it doesn't add content into it when updating.
[2014-03-12 15:57:53](ERROR @ /assets/components/mxcalendars/connector.php) Error 42S22 executing statement:
INSERT INTO modx_mxcalendars_events (title, description, content, categoryid, link, linkrel, linktarget, location_name, location_address, map, allday, startdate, enddate, repeating, repeattype, repeaton, repeatfrequency, source, feeds_id, feeds_uid, context, calendar_id, form_chunk, createdon, createdby, editedby, active) VALUES ('Test Event', 'test', '', '4', '', '', '', '', '', 0, 1, 1394629200, 1394661600, 0, 0, '', 0, 'local', 0, '', '', 1, '', 1394657873, 1, 0, 1)
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'content' in 'field list'
)
I had the same problem, the content column was missing, i also added it manualy and it saves just fine.
Stumbled across this problem today too - added content column and now all working fine. Needs a fix though really - I'm sure Charles is on it ;)
I realy hope so because MxCalendar is quite unstable now.
Met vriendelijke groet,
Ralph de Groot Lefthandmedia
On 30 jun. 2014, at 19:32, crimsonpixel [email protected] wrote:
Stumbled across this problem today too - added content column and now all working fine. Needs a fix though really - I'm sure Charles is on it ;)
— Reply to this email directly or view it on GitHub.
I had the same problem with 1.1.10 - thankfully fixed with adding the 'content' field to the db table.
However it then started complaining that the 'allday' column was missing, So I added that one as well, as type boolean.
With the extra columns added I can now save events!
