Hello,

I try to use an existing table (MySql/PHP) but no events are shown.

I tried to make a new table but get a connection error.

I use MySql 5.0.8-dev - 20102224 - $Revision: 310735 $, PHP 5.3.8 and DW-CS4

It even do not work when I remove the brackets (queries) in the calendar_get_events.php

Can you help please?

Hello,

Can you please tell me: what is the exact error message "I tried to make a new table but get a connection error." ?
Also - can you pelase provide a link to your page with the existing connection?

Hello Teodor,

The link to the calendar page is emmausharen.nl/calendar.php. At the bottom I putted a link to the calendar insert page. The link to the connection page is emmausharen.nl/calendar_ajax/calendar_get_events1.php

The message I get when I try to make a new table is:
MM_ERROR: MySql error#: 1064
You have an error in your SQL syntax; check your manual that corresponds to your SQL server version for the right syntax to use near '[c2]([event_id]bigintNOT NULL IDENTITY, [event_title] varchar(250) NOT NULL, ['at line1

I hope this will help.
Thank's in advance,
Frank

On your page i see the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[titel] AS title, [start], [stop] , [omschrijving] AS description, [type], [id] ' at line 1

It seems that you have not configured your columns in the calendar UI

I actually noticed that my problem was wrong database type selection and no rights to create. Changed MSSQL to MySQL and added create rights... anyway creation of a new table works for me now.

Hello Jukka,

You are so right. I didn't see that!

Thank you, everything works fine now.

Regards,
Frank