Hi, I followed all the guide steps at ‘Database Structure’, but when I add any events on the scheduler, I cannot see that event has been added to the database. I think probably I have set up the database wrong way.
Can anyone tell me how to set up the database correctly at the beginning?
Can you please specify how exactly did you set it up?
Sql dump of the table would be very helpfull
Hi, I just followed the instruction where it says that -
To be correctly processed, your database table must contain at least 3 fields:
start_date - (DateTime) the date when a task is scheduled to begin. The default format - ”%m/%d/%Y %H:%i”.
end_date - (DateTime) the date when a task is scheduled to be completed. The default format - ”%m/%d/%Y %H:%i”.
text - (string) the text of a task.
I did create a table in the database with those fields, but the scheduler didn’t load the data. So, I think I didn’t quite get the idea, how to set up the database with the right type of table in it.
If you can tell me about an example table which should work with the scheduler, I will be thankful to you.
Hi,
here is basic table schema for MySqlCREATE TABLE `events` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`start_date` datetime NOT NULL,
`end_date` datetime NOT NULL
PRIMARY KEY (`id`)
);Although data loading is possible without ‘id’ column, it is necessary for updating/deleting events.
It would be great if you provide your current table structure(sql dump), so we could figure out how to make that article clearer