• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

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

0
lisacowan
Asked:
lisacowan
  • 6
  • 5
1 Solution
 
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
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
 
dosthCommented:
did you get any reply from the developer?
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now