Calender

[Sharribee]

Hi guys, MOM is having problems posting in the calender, any ideas????



Thanks
xxx

[Lumiya]

Hi guys, MOM is having problems posting in the calender, any ideas????

No problems posting and then deleting a test event. Does he get any error messages?

Kymmy

[Sharribee]

I have had no problems either, he does get an error message but he can't remember what. (must be his age)

He is going to try again and then post here the message he gets


Thanks Kymmy

[Mabels Old Man]

OK tried again and I get the following


Arse! Query failed:
errorno=1064
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 's Old Man', 'I\'ll be there ')' at line 9
clean_query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'I\'ll be there ')
query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'I\'ll be there ')


Hope this means something to somebody

[Lumiya]

OK tried again and I get the following


Arse! Query failed:
errorno=1064
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 's Old Man', 'I\'ll be there ')' at line 9
clean_query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'I\'ll be there ')
query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'I\'ll be there ')


Hope this means something to somebody

By the look of it the words I'll be there is throwing up the error. Try altering that line to something else especially without the apostraphy

Kymmy

[Mabels Old Man]

Okey dokey Tried something simple with no punctuation

Arse! Query failed:
errorno=1064
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 's Old Man', 'My calendar is clear')' at line 9
clean_query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'My calendar is clear')
query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'My calendar is clear')

See told you it doesn't like BMW riders.

[Lumiya]

Okey dokey Tried something simple with no punctuation

Arse! Query failed:
errorno=1064
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 's Old Man', 'My calendar is clear')' at line 9
clean_query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'My calendar is clear')
query=INSERT INTO tbl_event_participant (fld_event_id, fld_participant_user_id, fld_participant_username, fld_participant_comment) VALUES (128, 1141, 'Mabel's Old Man', 'My calendar is clear')

See told you it doesn't like BMW riders.

Nope, only thing I can think of is that it's the apostraphy in your username

The code is trying to seperate inputed text and code by the use of apostraphies, you having one in your username is getting it confused. Try going into your profile and changing the username then retrying the entry...just remember you might have to login again using the new username and password

ThanX Kymmy

[samwise]

I'd agree with that - apostrophes cause merry hell in MS SQL anyway, if not doubled-up

[DaveS]

This can be sorted in the php code..... it is the apostrophe that's causing the problems.

Leave it with me a bit to sort.

[Mabels Old Man]

This can be sorted in the php code..... it is the apostrophe that's causing the problems.

Leave it with me a bit to sort.

OK boss