rsiegel827

Marcus-

Here are the potentially relevant tables (sent over from our host):

CREATE TABLE wp_52_comments (
comment_ID bigint(20) unsigned NOT NULL auto_increment,
comment_post_ID bigint(20) unsigned NOT NULL default ‘0’,
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL default ”,
comment_author_url varchar(200) NOT NULL default ”,
comment_author_IP varchar(100) NOT NULL default ”,
comment_date datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default ‘0’,
comment_approved varchar(20) NOT NULL default ‘1’,
comment_agent varchar(255) NOT NULL default ”,
comment_type varchar(20) NOT NULL default ”,
comment_parent bigint(20) unsigned NOT NULL default ‘0’,
user_id bigint(20) unsigned NOT NULL default ‘0’,
PRIMARY KEY (comment_ID),
KEY comment_approved (comment_approved),
KEY comment_post_ID (comment_post_ID),
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
KEY comment_date_gmt (comment_date_gmt),
KEY comment_parent (comment_parent)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_bookings (
booking_id bigint(20) unsigned NOT NULL auto_increment,
event_id bigint(20) unsigned NOT NULL,
person_id bigint(20) unsigned NOT NULL,
booking_spaces int(5) default NULL,
booking_comment text,
booking_date timestamp NOT NULL default CURRENT_TIMESTAMP,
booking_status tinyint(1) NOT NULL default ‘1’,
booking_price decimal(10,2) unsigned NOT NULL default ‘0.00’,
booking_meta longtext,
PRIMARY KEY (booking_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_categories (
category_id bigint(20) unsigned NOT NULL auto_increment,
category_owner bigint(20) unsigned NOT NULL default ‘0’,
category_name tinytext NOT NULL,
category_slug varchar(200) NOT NULL,
category_description text,
PRIMARY KEY (category_id),
KEY category_slug (category_slug)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_events (
event_id bigint(20) unsigned NOT NULL auto_increment,
event_owner bigint(20) unsigned default NULL,
event_name tinytext NOT NULL,
event_start_time time NOT NULL,
event_end_time time NOT NULL,
event_start_date date NOT NULL,
event_end_date date default NULL,
event_notes text,
event_rsvp tinyint(1) NOT NULL default ‘0’,
event_spaces int(5) default NULL,
event_contactperson_id bigint(20) unsigned default NULL,
location_id bigint(20) unsigned NOT NULL,
recurrence_id bigint(20) unsigned default NULL,
event_category_id bigint(20) unsigned default NULL,
event_attributes text,
event_date_created datetime default NULL,
event_date_modified datetime default NULL,
recurrence tinyint(1) NOT NULL default ‘0’,
recurrence_interval int(4) default NULL,
recurrence_freq tinytext,
recurrence_byday tinytext,
recurrence_byweekno int(4) default NULL,
event_slug varchar(200) NOT NULL,
event_status int(1) default NULL,
blog_id bigint(20) unsigned default NULL,
group_id bigint(20) unsigned default NULL,
PRIMARY KEY (event_id),
KEY event_status (event_status),
KEY blog_id (blog_id),
KEY event_slug (event_slug),
KEY group_id (group_id)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_locations (
location_id bigint(20) unsigned NOT NULL auto_increment,
location_name tinytext NOT NULL,
location_owner bigint(20) unsigned NOT NULL default ‘0’,
location_address tinytext NOT NULL,
location_town tinytext NOT NULL,
location_province tinytext,
location_latitude float default NULL,
location_longitude float default NULL,
location_description text,
location_slug varchar(200) NOT NULL,
location_state varchar(200) default NULL,
location_postcode varchar(10) default NULL,
location_region varchar(200) default NULL,
location_country char(2) NOT NULL,
PRIMARY KEY (location_id),
KEY location_state (location_state),
KEY location_region (location_region),
KEY location_country (location_country),
KEY location_slug (location_slug)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_meta (
meta_id bigint(20) unsigned NOT NULL auto_increment,
object_id bigint(20) unsigned NOT NULL,
meta_key varchar(255) default NULL,
meta_value longtext,
meta_date timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (meta_id),
KEY post_id (object_id),
KEY meta_key (meta_key),
KEY object_id (object_id)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
CREATE TABLE wp_52_em_people (
person_id bigint(20) unsigned NOT NULL auto_increment,
person_owner bigint(20) unsigned NOT NULL default ‘0’,
person_name tinytext NOT NULL,
person_email tinytext NOT NULL,
person_phone tinytext NOT NULL,
PRIMARY KEY (person_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_tickets (
ticket_id bigint(20) unsigned NOT NULL auto_increment,
event_id bigint(20) unsigned NOT NULL,
ticket_name tinytext NOT NULL,
ticket_description text,
ticket_price decimal(10,2) default NULL,
ticket_start datetime default NULL,
ticket_end datetime default NULL,
ticket_min int(10) default NULL,
ticket_max int(10) default NULL,
ticket_spaces int(11) default NULL,
PRIMARY KEY (ticket_id),
KEY event_id (event_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE wp_52_em_tickets_bookings (
ticket_booking_id bigint(20) unsigned NOT NULL auto_increment,
booking_id bigint(20) unsigned NOT NULL,
ticket_id bigint(20) unsigned NOT NULL,
ticket_booking_spaces int(6) NOT NULL,
ticket_booking_price decimal(10,2) NOT NULL,
PRIMARY KEY (ticket_booking_id),
KEY booking_id (booking_id),
KEY ticket_id (ticket_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Yes, it is events manager. Marcus, I will ask for access to the database. What would the database for em be called?

(It is now back at the 3.98 version because the events disappeared when I followed the upgrade instructions)

Don’t get any errors on the upgrade. A specific site in question is: https://college.oxy.edu/dwa/. I don’t have access to the database myself but is there a specific question I should as our hosting provider? I do have ftp access to the themes, plugins, etc. just not the databases.

Andrea- this is exactly what I did. Here is the site: https://wpdev.oxy.edu/31testing/ I have deactivated all plugins as well as temporarily removed all of the mu-plugins.

Thanks Andrea- I did that already. Tested with a few themes including the default twentyten theme.

I realized that if I change the window option from window to opaque the problem is solved.

Yeah… since that is the default setting at the computers at school, have to support it! Thanks! worked great!!

Just installed audit trail and having the same problem.

have any of you used re-captcha?

Andrea- looks like typepad and tantan haven’t been updated in a long time… are they still fully functional with wordpress 3.0.5 and 3.1?