Installed and created a database calendar. No events are showing event though I have added multiple events into the database.

www.gfactorgaming.com/event_calendar.asp

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.

Regards:Vulcho.

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.

www.gfactorgaming.com/calendar_test.asp

If I use this URL I get incorrect table error.

www.gfactorgaming.com/calendar_ajax/calendar_get_events1.asp?start=10&stop=12

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

Hello Jake,

Can you please make sure you selected the proper database type in the Calendar Options ?

I have tried them all. My database is MySQL and this is what I have it set to now.

Please send me a screenshot of your Calendar configuration to

Sending screen shots now.

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 &";"
Else
Response.Write rsJson.jsString
End If
END IF

Resolved???? This is still an OPEN issue????

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` >= ?))"

to

"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.

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".

www.gfactorgaming.com/event_calendar.asp


BTW any new entries I make will not show until I change the datatype!

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.

Thanks,

Jake

THIS IS NOT RESOLVED!!!! WHY DO YOU GUYS KEEP SETTING TO RESOLVED????

Is there an update on this? I have not been able to use this since I purchased.