Solved

Wordpress events calendar plug in does not generate mysql tables

Posted on 2008-06-19
11
488 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
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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

910 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

24 Experts available now in Live!

Get 1:1 Help Now