[Plugin: Ajax Event Calendar] Cannot add events or categories

Strange that I haven’t heard complaints about this before…
in ajax-event-calendar.php, add this line:
global $wpdb;

immediately after this line:
if ($result === false){

When you check your logs again, let me know if you see further errors.
Eran

Thanks for the quick response. Same issue with events and categories not posting. I also noticed that it didn’t create the Calendar Contributor role. Errors from the logs are even less specific now:

[Thu Aug 25 17:15:17 2011] [error] [client IP removed] , referer: [site path]/test/wp-admin/admin.php?page=event_categories
[Thu Aug 25 17:15:28 2011] [error] [client IP removed] , referer: [site path]/test/wp-admin/admin.php?page=ajax-event-calendar.php

No JS errors appearing in the console either. The only other plugin activated is Akismet.

Check the WordPress error logs, located in the wp-content folder – the file is named debug.log – if you don’t see it, edit the wp-config.php in the root folder and activate debugging. Then try using the calendar again and see if the file appears, and contains any new information.

[26-Aug-2011 00:34:26] PHP Notice: Undefined property: stdClass::$category_id in [server path]\wp-content\plugins\ajax-event-calendar\ajax-event-calendar.php on line 927

[26-Aug-2011 00:34:26] WordPress database error Table ‘clubs.wp_3_aec_event’ doesn’t exist for query INSERT INTO wp_3_aec_event (user_id,title,start,end,allDay,category_id,description,link,venue,address,city,state,zip,contact,contact_info,access,rsvp) VALUES (‘2′,’jhj’,’2011-08-27 00:00:00′,’2011-08-27 00:00:00′,’1′,’0′,’kjh’,’kjh’,”,’kjhkjh’,’jkh’,’kjh’,’kjh’,’kjh’,’kjh’,’0′,’0′) made by do_action, call_user_func_array, ajax_event_calendar->add_event, ajax_event_calendar->insert_event

[26-Aug-2011 00:34:26] WordPress database error Table ‘clubs.wp_3_aec_event’ doesn’t exist for query INSERT INTO wp_3_aec_event (user_id,title,start,end,allDay,category_id,description,link,venue,address,city,state,zip,contact,contact_info,access,rsvp) VALUES (‘2′,’jhj’,’2011-08-27 00:00:00′,’2011-08-27 00:00:00′,’1′,’0′,’kjh’,’kjh’,”,’kjhkjh’,’jkh’,’kjh’,’kjh’,’kjh’,’kjh’,’0′,’0′) made by do_action, call_user_func_array, ajax_event_calendar->add_event, ajax_event_calendar->insert_event, ajax_event_calendar->return_result

[26-Aug-2011 00:34:26]

Looks like the plugin didn’t install properly.
Try reinstalling, and watch your PHP and WordPress logs for errors.

[26-Aug-2011 10:50:20] PHP Warning: mysql_connect(): [2002] No connection could be made because the target machine actively refused it.

(trying to connect via tcp://localhost:3306) in [server path]\wp-includes\wp-db.php on line 1017

[26-Aug-2011 10:50:20] PHP Warning: mysql_connect(): No connection could be made because the target machine actively refused it.

in [server path]\wp-includes\wp-db.php on line 1017

Aha, I think I figured out the issue. We’re using multisite to manage multiple blogs. If I activate the plugin at the network admin level it doesn’t work. However, if I activate it on the individual blog everything works great.

Yes, this plugin does not automate multiple site blogs installation.
I’m pleased we were able to resolve the matter to successful outcome.

I am having the same problem.

loywpuser said he resolved the problem by changing a file permission, but provided no other details.

I have tried to add an event using a Macintosh and two different PCs. In all three cases, the ADD button was greyed out and I was unable to add any information to the calendar.

Please let me know if there is a solution to this.
Thanks

Mike

I’m also having the same problem. On the Events add page, the Update button is disabled. Oddly, it is enabled on the ‘Calendar installed’ event that automatically creates itself during installation. I can add events by hand through inserts to the database, and I was able to delete the ‘Calendar installed’ event so my d/b connection must be okay. ???

Please note the plugin does NOT support WordPress MU installations. If you are having issues because you are using WordPress MU, I cannot be of assistance. That said, I suggest you follow the troubleshooting tips in the FAQ for identifying the cause of the issue. It is most likely another plugin or a custom theme javascript conflict.

I am not using MU.

I am using the standard wordpress theme Twenty Eleven 1.3

There are only a few other plugins for the site. I turned off all plugins except the Calendar, and the problem was still there.

This problem began when I upgraded to WordPress 3.3.

At this point I don’t have a solution to the problem and the plugin is unusable because I cannot add an new event.

Eran I sent you a login for this site in your email. You are an admin. If you could, please try to add an event for January 7 called “Latin Jazz Night”. https://bigislandjazz.com/wp-admin/admin.php?page=ajax-event-calendar.php You have my permission to temporarily turn off other plugins to see for yourself there is no conflict.

I am unable to replicate this issue on my test site (innermonolog.com/demo) , which uses the latest version of the plugin and the latest version of WordPress 3.3 – my only suggestions is to employ the troubleshooting tips listed (especially the PHP logs and javascript console) in the FAQ and identify the cause of your issue.

Problem solved. I had a couple of fields still set to require and I wasn’t filling them in, so it wouldn’t let me save. Easily fixed, but that behavior might be more prominently mentioned or even have an alert box to say why it won’t save. Otherwise, the plugin is pretty good and easy to use.

I’m glad you figured it out.