Ok - so I followed the instructions on how to create an AJAX based calendar - created the table in MySQL with the appropiate fields and manually put in a test event. I created the calendar page and added the AJAX feed and uploaded the calendar_ajax & ScriptLibrary folders and the calendar page to the website and nothing appears - what am I missing here? Is there something else I should do?

Edited by - Mike Hicks on 19 Feb 2010  01:26:32

Hello Mike,

Could you please provide a link to your page?

on its way

I am having the same issue.

The calendar works perfectly in Dreamweaver, and also on my localhost testing server no issues at all, but when I put the page live, it does not retrieve any events at all. just an empty grid.

You can view the page here:
www.gddvn.com/alps/events.php

I'm really getting frustrated.

Hello Jeff,

What i see as a problem on your page is:

Table 'alpsdb.calEvents' doesn't exist

But I checked the database and the table calEvents does exist. it is there and all the events are present in the table.

I'm slightly confused here...

I will check my connection script to see if the problem is there...

I found the problem. It is a definite bug in the extension.

When I first inserted the calendar, I used the extension to create the tables in my database. it created a table called 'calevents' which seemed to work fine on my development machine in both Dreamweaver and my localhost testing server, but the live server on my hosting companies servers it stopped working.

So I had a closer look and found in the file called 'calendar_get_events1.php' the extension was looking for 'calEvents' table which could not be found because on the live server, MySQL table names are case sensitive, so by inserting the capital 'E' in the table name in the calendar_get_events1.php file, the code was broken.

I think DMX Zone should release an immediate update to correct this bug.

I renamed the table on the live server to 'calEvents' and now it's working perfectly.

Thanks for pointing me in the right direction.

Hello,

We are going to check this issue and notify you as soon as we find the problem.

I have created a new page with the calendar 98.130.211.215/~dan/test.php

It does not display and of the existing events. the line at the bottom is from the table so I think the connection is OK.

Hello Nick Jewett.

Seems like you are missing arguments in "calendar_get_events2.php" on line 46 of your code.