No events are showing on calendar or list view

[Cappiels]

Hi there,

Something weird is going on. All of my events have stopped showing on the calendar and in list view.

The MySQL database seems fine. I can log into it with PHPMyAdmin no problem, browse the data, etc. The connection from the calendar setup page seems fine also.

I'm using version 6.3.10 and tried updating to the most recent version of the calendar, but that didn't fix it, so I reverted back to 6.3.10 for the time being.

Sorry, I can't include a link to the web pages because I'm behind a company firewall. By the way, another thing I noticed is that the event admin page in the calendar ***WILL*** allow a user to log in and add an event, but the event does not then show up on the calendar. It goes into oblivion and is not written to the MySQL database.

Any advice you can offer would be greatly appreciated. The MySQL database has plenty of events in it and I really hope I can get them to show up again on the calendars and list views.

thanks,
Steven

[ve9gra]

Is only the mySQL database enabled? Has the permissions on the database changed - does the user entered in the Setup Manager still have full permissions on the table? Has anything at all changed in your setup (web, database, firewall, etc...)?

[Cappiels]

Is only the mySQL database enabled?

YES


Has the permissions on the database changed - does the user entered in the Setup Manager still have full permissions on the table?

I DIDN'T CHANGE ANYTHING NOR DID ANY OTHER PERSON..

Has anything at all changed in your setup (web, database, firewall, etc...)?

I *WAS* PLAYING AROUND WITH TRYING TO REMOVE SUNDAY AND SATURDAY FROM THE TOC VIEW... BUT I RECALL THAT BEFORE AND AFTER ENTERING THE CODE TO REMOVE THOSE COLUMNS FROM TOC, I *DID* SEE EVENTS ON THE CALENDAR, SO I DON'T THINK THAT'S CAUSING THIS... (??)

ANYYYY ADVICE YOU CAN OFFER FOR HOW TO DEBUG OR FIX THIS WOULD BE GREATLY APPRECIATED AS THIS IS AN ACTIVE CALENDAR THANK YOU

[Cappiels]

I thought there might be something wonky going on with my installation of mySQL, so I uninstalled it and reinstalled it, reimported the mySQL database and am still having the same problem... I've attached a screenshot of phpMyAdmin looking at the database..

[Cappiels]

strangely.. it says that the database is 0 bytes

is it possible the database has gotten corrupted ??

[Cappiels]

this is the SQL I used to recreate the table:

#
# Table structure for table `epc_calendar`
#

CREATE TABLE `epc_calendar` (
  `id` int(7) NOT NULL auto_increment,
  `startDate` int(11) NOT NULL default '0',
  `endDate` int(11) NOT NULL default '0',
  `startTime` time NOT NULL default '00:00:00',
  `endTime` time NOT NULL default '00:00:00',
  `eventType` text NOT NULL,
  `repeatx` int(7) NOT NULL default '0',
  `title` text NOT NULL,
  `descr` text NOT NULL,
  `days` int(7) NOT NULL default '0',
  `stop` int(7) NOT NULL default '0',
  `month` tinyint(2) NOT NULL default '0',
  `weekDay` tinyint(1) NOT NULL default '0',
  `weekNumber` tinyint(1) NOT NULL default '0',
  `category` text NOT NULL,
  `eventKey` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1044 ;

#
# Dumping data for table `epc_calendar`
#

[Cappiels]

also... I am using php 5.2.2 and just upgraded MySQL to 4.1

does it matter that the original database was in mySQL 4.0.15:

# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 25, 2007 at 11:39 AM
# Server version: 4.0.15
# PHP Version: 5.2.2
# 
# Database : `testescal6`
#

[ve9gra]

You can clearly see that there are no entries in your table (I'm looking at the screenshot you posted). If you've just recreated it without re-importing your events, you'll have an empty table.

[Cappiels]

No, there are entries in the table.. I just didn't click the "browse" button to display the records.

I can browse the data.. there are over 1000 records in the table.

Do you have any suggestions for things I can try ?

the calendar Events admin panel thinks that it adds the record to the database, and nothing.. no record is added..

the connection in the Setup manager says the database connection is valid...

any ideas ??

[Brian]

Can you post a screenshot of the structure screen for the database in phpMyAdmin?

[Cappiels]

Thanks Brian. Here is a screenshot of the structure.

[Brian]

The database structure is for the most recent release of the calendar. If you've reverted to a previous version of the calendar, it won't work with an updated database structure as you're using now.

[Cappiels]

Hi Brian,

Did the database structure change from version 6.3.1 to the current version? (I don't think so, did it?).
I only reverted to 6.3.1 because it wasn't working with the most recent version.

I just went back to the most current version of the calendar and it's not working there either.

Something is not working, and I need a gameplan.

Could you please tell me what steps you would take? I really would like to get it back in working order asap if possible.


thanks,
Steven

[Brian]

Yes, that database structure changed to allow for changes in PHP 5 and mySQL.

Please open a support ticket with the URL and login to your Setup Manager so I can take a look.

[Cappiels]

I'm sorry, but I'm behind a company firewall.

I don't understand.. If I have the most recent database structure, shouldn't the most recent calendar be working with the database? It isn't.


I'm happy to reinstall the calendar or the database.. as long as I can hopefully reimport the event information, as there are over 1000 events in the database.

I'm all ears and am willing to do whatever you suggest.

Thanks for the help.

[Brian]

This is not normal or a problem I've seen. Something had to have changed on the server to cause this to occur, but I don't know what that is.

Can you dump your database and attach it in a support ticket so I can test is locally?