Entering an event on calender?

[chalky4]

I would like to enter the following details on the calender incase anyone not doing TLD can help out but when I try it comes up with a load of goggledygoop

Saturday 20th June 13:00 hrs
Gwyddon Forest, Abercarn --- Trail Rides for Children with Learning Difficulties
Sunday 21st June 10:30 hrs
Gwyddon Forest, Abercarn --- Trailbike/sidecar Charity Trial
Contact Mike Rees (mikerees65@hotmail.com)for more details.
This man has been helping the kids for 25years and needs our help

[DaveS]

I would like to enter the following details on the calender incase anyone not doing TLD can help out but when I try it comes up with a load of goggledygoop

Can you be more specific please?
Any chance of a screen shot or a cut and paste of the error message.
It should just work, so if it isn't I need to fix it for you.

[chalky4]

Dave this is a copy of what comes up!!!!! hence the term gobledegoop cos I ain't got a clue
Thanks
Chalky


Arse! Query failed:
errorno=1048
error=Column 'fld_event_startdate' cannot be null
clean_query=INSERT INTO tbl_event (fld_event_startdate, fld_event_enddate, fld_event_name, fld_event_desc, fld_event_owner_user_id, fld_event_owner_username, fld_event_location, fld_event_postcode, fld_event_latitude, fld_event_longitude, fld_event_country, fld_event_instructions, fld_event_url) VALUES (STR_TO_DATE('20/6/2009 13.00','%d/%m/%Y %H:%i'), STR_TO_DATE('21/6/2009 00:00','%d/%m/%Y %H:%i'), 'Trail Rides for kids with Learning Problems', 'Trail Rides for Children with Learning Difficulties‏ Saturday 20th June 13:00 hrs Gwyddon Forest, Abercarn', 7195, 'chalky4', 'Gwyddon Forest, Abercarn', '', '0', '0', 'United Kingdom', 'Contact mikerees65@hotmail.com for more info. This man and the children need your help, assuming your not on TLD of course', '')
query=INSERT INTO tbl_event (fld_event_startdate, fld_event_enddate, fld_event_name, fld_event_desc, fld_event_owner_user_id, fld_event_owner_username, fld_event_location, fld_event_postcode, fld_event_latitude, fld_event_longitude, fld_event_country, fld_event_instructions, fld_event_url) VALUES (STR_TO_DATE('20/6/2009 13.00','%d/%m/%Y %H:%i'), STR_TO_DATE('21/6/2009 00:00','%d/%m/%Y %H:%i'), 'Trail Rides for kids with Learning Problems', 'Trail Rides for Children with Learning Difficulties‏ Saturday 20th June 13:00 hrs Gwyddon Forest, Abercarn', 7195, 'chalky4', 'Gwyddon Forest, Abercarn', '', '0', '0', 'United Kingdom', 'Contact mikerees65@hotmail.com for more info. This man and the children need your help, assuming your not on TLD of course', '')

[DaveS]

There's something it doesn't like in the text you've entered.
It will probably be a comma or apostrophe or something like that.
Take out those characters and try again.
You can always edit your calendar entry anyway.

[Lumiya]

Even better he could try a colon in the start time instead of the decimal point he used

'20/6/2009 13.00'

[DaveS]

yes that could be it...

Chalky by the way this isn't you, the application should cope with whatever you throw at it.

[chalky4]

Even better he could try a colon in the start time instead of the decimal point he used

You wouldn't think that a little dot could cause so many problems, all sorted thank you.
What really p*ssed me off was that error message called me an A*se, don't mind mortal beings calling me that but a bloo*y computer, it nearly ended up out the window

[Lumiya]

yes that could be it...

Dave the code is set to parse the time with a colon delimiter "%H:%i"

Is it perhaps worth while changing the form to accept Hour and Minutes as two seperate items (perhaps dropdowns) so this won't be an issue in the future???

[Lumiya]

You wouldn't think that a little dot could cause so many problems, all sorted thank you.
What really p*ssed me off was that error message called me an A*se, don't mind mortal beings calling me that but a bloo*y computer, it nearly ended up out the window

You think that's bad...You should see what the mod system calls us if we make a mistake .......

(Though I think it might be Dave in disguise typing in the obscenities!!! )

[chalky4]

Dave the code is set to parse the time with a colon delimiter "%H:%i"

OMG your multi lingual