Solved

Wordpress events calendar plug in does not generate mysql tables

Posted on 2008-06-19
11
484 Views
Last Modified: 2013-12-12
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

0
Comment
Question by:lisacowan
  • 6
  • 5
11 Comments
 
LVL 15

Expert Comment

by:dosth
Comment Utility
0
 
LVL 15

Expert Comment

by:dosth
Comment Utility
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
 

Author Comment

by:lisacowan
Comment Utility
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
 
LVL 15

Expert Comment

by:dosth
Comment Utility
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
 

Author Comment

by:lisacowan
Comment Utility
dosth,
did you intend that I remove something from you sql. Sorry, not following.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:lisacowan
Comment Utility
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
 
LVL 15

Expert Comment

by:dosth
Comment Utility
is this path right?

/home/httpd/vhosts/cowanservices.com/httpdocs/z3test/
0
 

Author Comment

by:lisacowan
Comment Utility
that is the correct path as far as the web server is concerned. In a browser it would be http://cowanservices.com/z3test/
0
 
LVL 15

Accepted Solution

by:
dosth earned 500 total points
Comment Utility
did you get any reply from the developer?
0
 

Author Closing Comment

by:lisacowan
Comment Utility
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
 
LVL 15

Expert Comment

by:dosth
Comment Utility
ok, sounds good

thanks for the points also
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

So you have coded your own WordPress plugin and now you want to allow users to upload images to a folder in the plugin folder rather than the default media location? Follow along and this article will show you how to do just that!
This article discusses four methods for overlaying images in a container on a web page
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now