[Plugin: Events Calendar] Events Disappearing/No Tables Created?

I’m having the same problem and talked to the plugin creator. He is currently trying to figure out the problem.

Is there a manual workaround I can use in the interim? I’d like to show the concept to a client of mine.

Try downloading the latest version 6.3.1 and install that. One of the problems fixed was that the database was not being created for those using older versions of MySql. There have also been fixes for those using older versions of PHP.

Those using PHP 5 and MySQL 5 have not been experiencing these problems.

Just tried 6.3.1 and din’t see a table created.

I’m on PHP 4.4.1 and MySQL 4.0.27-standard. Want me to manually create the table (I see the CREATE command in the source) and see if everything else works?

The MySQL 4.0 is your problem.

It is choking on the CHARACTER SET and COLLATE statements. There are only four of them. The COLLATE statments were taken out of the 6.3.1 version. You could take the CHARACTER SET part out also and it should create the table. Or you could create a script, if you know how to do that.

You might want to check with your host and have them update your PHP and MySql. They are both out of date.

So – manually creating the table seems to have done the trick. Sortof.

I can now enter events, and they appear in the admin UI -but I’m trying to use EventCalendarLarge and all I see in my page is the text.

Seems closer, though.

Even though I just downloaded the latest version yesterday, I removed it and re-downloaded it from the site today and added it. I’m still not getting any events to show up after I add them either.

@tvallier,

It is “EventsCalendarLarge”. (You left out the ‘s’ in Event.)
And that needs to be surrounded by double brackets on a page.

Let me know if that doesn’t work.

@isign4jc,
Are events not showing up in the widget calendar, the large calendar, or both? Do you have javascript turned on?

What version of PHP and MySql are you using? What browser and version?

@ronbme: The readme is incorrect, then. I copy/pasted. ??

It’s working now. Thanks a ton.

@tvallier,

Great! Glad it’s working for you. Thanks for the heads up on the readme file. I’ll change it.

Ron

@ronbme,

I’m only using the large calendar and it’s not showing up there. Javascript is turned on.

I’m guessing I’m having the same problem as tvallier because my host has PHP 4.4.4 and MySQL 4.0.26. I am on IE 6.

If I were too duplicate what worked for tvallier, what should I name the table in the database? Or do you have different advice for me?

I just looked in my db code and added this manually to my MySQL database:

CREATE TABLEwp_eventscalendar_main` (

id mediumint(9) NOT NULL AUTO_INCREMENT,
eventTitle varchar(255) CHARACTER SET utf8 NOT NULL,
eventDescription text CHARACTER SET utf8 NOT NULL,
eventLocation varchar(255) CHARACTER SET utf8 default NULL,
eventStartDate date NOT NULL,
eventStartTime time default NULL,
eventEndDate date NOT NULL,
eventEndTime time default NULL,
accessLevel varchar(255) CHARACTER SET utf8 NOT NULL default ‘public’,
postID mediumint(9) NULL DEFAULT NULL,
PRIMARY KEY id (id)
);`

For some reason it would not allow me to put “CHARACTER SET utf8” into the MySQL, so I had to remove each time it said that. Will that affect anything importantly? I then tried adding an event and it showed up perfectly on my admin screen, but was merely missing the start and end time on my EventsCalendarLarge page.

@isign4jc,

If you are only using the large calendar, try this first.

Put EventsCalendarLarge on a page by itself. (The readme file is wrong. You must have the ‘s’ after ‘Event’ for it to work.)

If that doesn’t work, that means that you probably don’t have a table created, which is what I suspect.

Do you know how to manually create a table? If not, do you know how to run a script?

Ron

@ronbme,

I’m guessing our posts crossed paths because I actually posted the answers to your questions in my above post. Let me know if you need any further information to diagnose my problem. Thanks so much for your speedy responses!

Just an additional note: My start and end times are present in the database, but just not showing up in the large calendar page. Everything else about the event is showing up, though.

@isign4jc,

Ok. It looks like you have the table created. Just make sure all the fields are there. I assume you mean that you just removed the “character set utf8” part, right?

The start and end time will only show up if you have entered them. If you did enter a time and it didn’t show up, go to “options” and enter
“h:i:s a” (without the quotes) in the “Large Calendar Times”. You can also enter the same thing in “Widget Calendar Times”.

Ron