LuxCal Forum

The place for questions, suggestions and news about the LuxCal Event Calendar

User:   Password:   Remember Me?   
LuxCal Forum / General / Problems / CSV import error
Posted:  03 Jan 2014 09:17   Last Edited By: Roel B.
Hi All
Fantastic piece of software I must say. Using version 3.2
The only problem I have is trying to import a csv file. I get no errors when I upload the file but when I try and and add the events to the database I get an error in the logs.
Script name: /calendar/index.php
MySQL error: Column count doesn't match value count at row 1
Query string: INSERT INTO [db]events VALUES (NULL,DEFAULT,'Committee Meeting','Committee Meeting',1,'Patcham Community Centre Room2',DEFAULT,DEFAULT,DEFAULT,DEFAULT,2,DEFAULT,DEFAULT,DEFAULT,DEFAULT,'2014-01-06','9999-00-00',DEFAULT,'19:15','23:00',1,1,4,0,DEFAULT,DEFAULT,DEFAULT,'2014-01-03', '2014-01-03',DEFAULT)

I have tried with default test scripts and all sorts.
Any ideas?
Paul M
Posted:  03 Jan 2014 20:34
Hi Paul,
Sorry, there is a bug in the importCSV.php file.
Send me your email address (via the Contact Us page), so that I can send you the updated file.

Thanks for reporting this problem.