Solved

Wordpress events calendar plug in does not generate mysql tables

Posted on 2008-06-19
11
497 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 15

Expert Comment

by:dosth
ID: 21823737
0
 
LVL 15

Expert Comment

by:dosth
ID: 21823794
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
ID: 21824005
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 15

Expert Comment

by:dosth
ID: 21824182
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
ID: 21824397
dosth,
did you intend that I remove something from you sql. Sorry, not following.
0
 

Author Comment

by:lisacowan
ID: 21826143
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
ID: 21830034
is this path right?

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

Author Comment

by:lisacowan
ID: 21831576
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
ID: 21872539
did you get any reply from the developer?
0
 

Author Closing Comment

by:lisacowan
ID: 31468830
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
ID: 21874726
ok, sounds good

thanks for the points also
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Building a glossary into your website 9 60
SQL Function 4 38
Echo'd value as selected in dropdown 20 44
Php variable to be sent back 3 35
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

710 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