Wordpress events calendar plug in does not generate mysql tables

I have a Wordpress 2.2.3 blog with a custom theme that i am attempting to use the  Events Calendar plugin v. 6.3.2. The plugin activates properly but when displayed either on a page or in the Wordpress admin area Events Calendar tab returns an error message, "WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]", When I check in phpmyadmin on the site, sure enough the table is nonexistent. Any help would be appreciated.
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-01' AND `eventEndDate` >= '2008-06-01' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-02' AND `eventEndDate` >= '2008-06-02' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-03' AND `eventEndDate` >= '2008-06-03' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-04' AND `eventEndDate` >= '2008-06-04' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-05' AND `eventEndDate` >= '2008-06-05' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-06' AND `eventEndDate` >= '2008-06-06' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-07' AND `eventEndDate` >= '2008-06-07' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-08' AND `eventEndDate` >= '2008-06-08' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-09' AND `eventEndDate` >= '2008-06-09' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-10' AND `eventEndDate` >= '2008-06-10' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-11' AND `eventEndDate` >= '2008-06-11' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-12' AND `eventEndDate` >= '2008-06-12' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]
SELECT * FROM `wp_eventscalendar_main` WHERE `eventStartDate` <= '2008-06-13' AND `eventEndDate` >= '2008-06-13' ORDER BY `eventStartTime`, `eventEndTime`;
 
WordPress database error: [Table 'jzente_wordpress.wp_eventscalendar_main' doesn't exist]

Open in new window

lisacowanAsked:
Who is Participating?
 
dosthCommented:
did you get any reply from the developer?
0
 
dosthCommented:
try to create table manually

jzente_wordpress is your database name?

CREATE TABLE  . wp_eventscalendar_main .  (
id mediumint(9) NOT NULL AUTO_INCREMENT,
eventTitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
eventDescription text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
eventLocation varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
eventStartDate date NOT NULL,
eventStartTime time default NULL,
eventEndDate date NOT NULL,
eventEndTime time default NULL,
accessLevel varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default public,
postID mediumint(9) NULL DEFAULT NULL,
PRIMARY KEY id (id)
);
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
lisacowanAuthor Commented:
I have tried creating a table but including with your sql, dosth, but so far have not been able to get it work in phpmyadmin.
ERROR: C1 C2 LEN: 13 14 602
STR: 
 
SVN: $Id: sqlparser.lib.php 10247 2007-04-03 10:23:49Z lem9 $
MySQL: 4.0.27-standard-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.10.1
PHP VER,OS: 4.4.6 Linux
LANG: en-utf-8
SQL: CREATE TABLE  . wp_eventscalendar_main .  (
id mediumint(9) NOT NULL AUTO_INCREMENT,
eventTitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
eventDescription text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
eventLocation varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
eventStartDate date NOT NULL,
eventStartTime time default NULL,
eventEndDate date NOT NULL,
eventEndTime time default NULL,
accessLevel varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default public,
postID mediumint(9) NULL DEFAULT NULL,
PRIMARY KEY id (id)
)
 
----END RAW----
 
SQL query:
 
CREATE TABLE  . wp_eventscalendar_main .  ( id mediumint(9) NOT NULL AUTO_INCREMENT, eventTitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, eventDescription text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, eventLocation varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL, eventStartDate date NOT NULL, eventStartTime time default NULL, eventEndDate date NOT NULL, eventEndTime time default NULL, accessLevel varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default public, postID mediumint(9) NULL DEFAULT NULL, PRIMARY KEY id (id) )
 
MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '.  (
id mediumint(9) NOT NULL AUTO_INCREMENT,
eventTitle var

Open in new window

0
 
dosthCommented:
remove .

CREATE TABLE  wp_eventscalendar_main   (
id mediumint(9) NOT NULL AUTO_INCREMENT,
eventTitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
eventDescription text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
eventLocation varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
eventStartDate date NOT NULL,
eventStartTime time default NULL,
eventEndDate date NOT NULL,
eventEndTime time default NULL,
accessLevel varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default public,
postID mediumint(9) NULL DEFAULT NULL,
PRIMARY KEY id (id)
);
0
 
lisacowanAuthor Commented:
dosth,
did you intend that I remove something from you sql. Sorry, not following.
0
 
lisacowanAuthor Commented:
I just just installed a fresh copy of wordpress 2.5.1 and installed events calendar 6.3.2 and got back the following errors (see code snippet). I checked the code and it refers to an include of another page, eb_db.class.php. This page has the sql to create the tables, which is about the same as yours. I then tried installing version 5.8.4 of the events calendar and it activated and created tables just fine. It seems to work just fine too, but of course lacks a feature I need. I am conluding the problem is a bug with 6.3.2 but I don't see any mention of it on http://www.lukehowell.com/2008/04/27/events-calendar-60/ so I am going to post it and see if the developer has an answer.

Warning: main(/home/httpd/vhosts/cowanservices.com/httpdocs/z3test/blog/wp-content/plugins/events-calendar/ec_day.class.php) [function.main]: failed to open stream: No such file or directory in /home/httpd/vhosts/cowanservices.com/httpdocs/z3test/blog/wp-content/plugins/events-calendar01/events-calendar.php on line 31
 
Fatal error: main() [function.require]: Failed opening required '/home/httpd/vhosts/cowanservices.com/httpdocs/z3test/blog/wp-content/plugins/events-calendar/ec_day.class.php' (include_path='.:/usr/share/pear') in /home/httpd/vhosts/cowanservices.com/httpdocs/z3test/blog/wp-content/plugins/events-calendar01/events-calendar.php on line 31

Open in new window

0
 
dosthCommented:
is this path right?

/home/httpd/vhosts/cowanservices.com/httpdocs/z3test/
0
 
lisacowanAuthor Commented:
that is the correct path as far as the web server is concerned. In a browser it would be http://cowanservices.com/z3test/
0
 
lisacowanAuthor Commented:
We decided to use another standalone calendar for now and I have found another developer who is supposed to be developing a wordprees plugin that is exactly what we want and when and if that becomes available, we will switch to that. In the case of this calendar, I believe it was a versioning problem.
0
 
dosthCommented:
ok, sounds good

thanks for the points also
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.