Posted 1 year ago #
Hi,
I'm trying to get this plugin to work and am really excited about it.
It seems to install OK, and activates fine, but when I go to add an event, it seems to just vanish into thin air.
Looking through the code, it looks like the plugin wants to create a table, but I don't see one being created in phpmyadmin.
Any thoughts? Could there be a setting I need to flip somewhere?
Posted 1 year ago #
I'm having the same problem and talked to the plugin creator. He is currently trying to figure out the problem.
Posted 1 year ago #
Is there a manual workaround I can use in the interim? I'd like to show the concept to a client of mine.
Posted 1 year ago #
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.
Posted 1 year ago #
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?
Posted 1 year ago #
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.
Posted 1 year ago #
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.
Posted 1 year ago #
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.
Posted 1 year ago #
@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?
Posted 1 year ago #
@ronbme: The readme is incorrect, then. I copy/pasted. :)
It's working now. Thanks a ton.
Posted 1 year ago #
@tvallier,
Great! Glad it's working for you. Thanks for the heads up on the readme file. I'll change it.
Ron
Posted 1 year ago #
@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?
Posted 1 year ago #
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.
Posted 1 year ago #
@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
Posted 1 year ago #
@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.
Posted 1 year ago #
@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
Posted 1 year ago #
@ronbme,
Yes, I did just remove "character set utf8". Will that affect anything?
Beautiful. Thanks so much. By adding that simple piece of code into my options page, it then showed up properly in my large event calendar.
Thanks again, I'm so happy that it works now!
I hope I'm not pushing my luck here, but is there a way to force the calendar to display the start time without having to hover?
Posted 1 year ago #
@isignjc,
Great! I'm glad you've got it working.
You might want to have your host upgrade your PHP and MySql. You could have problems with other plugins in the future.
Be sure to check back for new versions with more options.
Ron
Posted 1 year ago #
Uh-oh...I just realized that my large calendar won't go to the previous or next month. Any ideas?
Posted 1 year ago #
@isign4jc,
Have you tried switching themes? That has worked for others.
Posted 1 year ago #
@ronbme,
I'm creating a website for a client using this calendar, so I must use my own theme. Is there an alternative fix?
Posted 1 year ago #
@isign4jc,
I'll see if there is an alternate you can use. You are not getting any errors when you try to go to the next or previous month, are you?
As for your question about seeing the start time without hovering, no, there's no way to do it right now. What you see in the large calendar are the titles.
Posted 1 year ago #
Make sure in the theme header that the following line appears.
<?php wp_head();?>
and make sure the footer contains
<?php wp_footer();?>
Posted 1 year ago #
@ronbme,
I'm not getting any errors when I click on the previous or next month. Nothing happens at all when I do so.
@snumb130,
I already had the <?php wp_head();?> properly in place, but did not have the <?php wp_footer();?> . Is it important where exactly the <?php wp_footer();?> goes? I don't have an official footer on my own created theme, so I was just trying it out with adding that line at the end of my script. It did not fix anything.
Posted 1 year ago #
I am not sure if the wp_footer has to be in a particular part. Probably not. It should be fine as long as it happens late in the page.
Posted 1 year ago #
Ok, I made sure that wp_footer was right before my closing body tag since that's how it is in the default template. I'm still not able to switch the calendar to the next or previous month. Any other ideas?
Posted 1 year ago #
isign4jc,
This sounds like a javascript problem, although the previous and next months would not be showing at all if that were the case.
Have you tried clearing your browser cache and made sure that javascript is turned on?
Posted 1 year ago #
hm...I'm stumped as to the problem. I made sure that javascript was turned on and I also cleared my browser cache. Additionally, I uninstalled the events calendar plugin from my site, downloaded it again, then uploaded it again to my site (without removing the current database). This also did not affect anything.
This wouldn't have anything to do with the fact that I was unable to add the line CHARACTER SET utf8 to my database, would it?
Posted 1 year ago #
I also compared the source code in my page to the source code on the plugin's homepage and mine looks different. For some reason mine is adding all these spaces. Here is what it is showing:
<div id="calendar_wrapLarge"><h2 style="text-align:center;"><span id="EC_previousMonthLarge"></span> May 2008 <span id="EC_nextMonthLarge"></span></h2><br /><table id="wp-calendarLarge">
Posted 1 year ago #
If I update my database to 5.0 will I have to reinstall WP and everything else?
This topic has been closed to new replies.
