2008-12-01, 07:45 PM
Ok, so I tried inserting the first event into my calendar:
I've checked the timestamp column type. It's integer. And digging into the code, I found it treated it as a string. The solution which worked for me is down here.
Suggested change to inc/datahandlers/event.php:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
22P02 - ERROR: invalid input syntax for integer: ""
Query:
INSERT INTO mybb_events (cid,uid,name,description,visible,private,dateline,starttime,endtime,timezone,ignoretimezone,usingtime,repeats) VALUES ('1','1','Klasówka z Mickiewicza','Klasówka z jęzka polskiego z życia i twórczości Adama Mickiewicza.','1','0','1228158352','1228867200','0','','0','0','N;')
I've checked the timestamp column type. It's integer. And digging into the code, I found it treated it as a string. The solution which worked for me is down here.
Suggested change to inc/datahandlers/event.php:
464c464
< 'timezone' => $db->escape_string($event['timezone']),
---
> 'timezone' => intval($event['timezone']),