Ajax Event Calendar Support Product Page

Under investigation

I can't get anything to display in my calendar

Reported 06 Nov 2012 19:41:17
have this problem
06 Nov 2012 19:41:17 Jake Guerin posted:
Installed and created a database calendar. No events are showing event though I have added multiple events into the database.



Replied 07 Nov 2012 16:14:01
07 Nov 2012 16:14:01 Vulcho Vulev replied:
Hello Jake.

Can you please contact your server administrator. I think there is some problems with the read permisions on your server. The error that i am receiving is Network error 500 which is serverside related.


Replied 07 Nov 2012 18:15:02
07 Nov 2012 18:15:02 Jake Guerin replied:
I just check the permission with the system admin and everything is correct. I have tried to redirect this to other tables and it still errors.

I can query the table just fine using a normal record set.

Replied 07 Nov 2012 18:16:35
07 Nov 2012 18:16:35 Jake Guerin replied:
If I use this URL I get incorrect table error.


Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.54-log]Incorrect table name 'gfactorgaming.gf_events'

D:\INETPUB\GFACTORGAMING\CALENDAR_AJAX\../Scriptlibrary/JSON_UTIL_latest.asp, line 4
Replied 08 Nov 2012 10:44:25
08 Nov 2012 10:44:25 Teodor Kuduschiev replied:
Hello Jake,

Can you please make sure you selected the proper database type in the Calendar Options ?
Replied 08 Nov 2012 15:35:02
08 Nov 2012 15:35:02 Jake Guerin replied:
I have tried them all. My database is MySQL and this is what I have it set to now.
Replied 08 Nov 2012 15:56:45
08 Nov 2012 15:56:45 Teodor Kuduschiev replied:
Please send me a screenshot of your Calendar configuration to
Replied 08 Nov 2012 17:13:12
08 Nov 2012 17:13:12 Jake Guerin replied:
Sending screen shots now.
Replied 08 Nov 2012 22:31:27
08 Nov 2012 22:31:27 Jake Guerin replied:
Here is the source query code:

Set dmxEventsRs_cmd = Server.CreateObject ("ADODB.Command"
dmxEventsRs_cmd.ActiveConnection = MM_DNGFACTOR_STRING
dmxEventsRs_cmd.CommandText = "SELECT `event_title` AS title, `start`, `stop` , `description`, `event_id` FROM `gfactorgaming.gf_events` WHERE `start` <= ? AND (`stop` >= ? OR (`stop` IS NULL AND `start` >= ?))"
dmxEventsRs_cmd.Parameters.Append dmxEventsRs_cmd.CreateParameter("@stop", 3, 1, , request_Stop)
dmxEventsRs_cmd.Parameters.Append dmxEventsRs_cmd.CreateParameter("@start", 3, 1, , request_Start)
dmxEventsRs_cmd.Parameters.Append dmxEventsRs_cmd.CreateParameter("@start2", 3, 1, , request_Start)
dmxEventsRs_cmd.Prepared = true
dim rsJson, cb
set rsJson = QueryToJSON(dmxEventsRs_cmd, ""
cb = Request.QueryString("callback"
If cb <> "" Then
Response.Write cb & "("& rsJson.jsString &";"
Response.Write rsJson.jsString
End If
Replied 09 Nov 2012 16:49:59
09 Nov 2012 16:49:59 Jake Guerin replied:
Resolved???? This is still an OPEN issue????
Replied 09 Nov 2012 20:42:30
09 Nov 2012 20:42:30 Jake Guerin replied:
I was finally able to get something to display on my calendar but it wasn't easy and I'm not sure where to go from here.

First thing I did was change the SQL statement in the code from "SELECT `event_title` AS title, `start`, `stop` , `description`, `type`, `event_id` FROM `gfactorgaming.gf_events` WHERE `start` <= ? AND (`stop` >= ? OR (`stop` IS NULL AND `start` >= ?))"


"SELECT `event_title` AS title, `start`, `stop` , `description`, `type`, `event_id` FROM `gf_events` WHERE `start` <= ? AND (`stop` >= ? OR (`stop` IS NULL AND `start` >= ?))"

At the database level the only way I was able to get something to display was to change the "start" data type to "text" from "datetime". It's very GOOFY!!!! So the "start" data type is "text" and the "stop" data type is "datetime". Any reason for this??

Why does the "start" data type have to be "text" in order for this to work?

I'm not sure if this extention is really going to work out for what I need it to do.
Replied 09 Nov 2012 22:23:33
09 Nov 2012 22:23:33 Jake Guerin replied:
You can see by the calendar URL that Im gettin results but the only way this is showing is because I had to manually change the "start" datatype to "text" from "datetime".


BTW any new entries I make will not show until I change the datatype!
Replied 16 Nov 2012 16:17:51
16 Nov 2012 16:17:51 Jake Guerin replied:
I would like to request a refund on this extention. I have sent several emails with all the details of the issue I'm having to support and its been over two weeks and I'm still unable to use this extention correctly. This was purchased for my business. I will have to find others means. Can someone please email me or contact me directly.


Replied 19 Nov 2012 16:54:45
19 Nov 2012 16:54:45 Jake Guerin replied:

Replied 17 Dec 2012 18:42:12
17 Dec 2012 18:42:12 Jake Guerin replied:
Is there an update on this? I have not been able to use this since I purchased.

Reply to this topic