Calender

[Sharribee]

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



Thanks
xxx

[Kymmy]

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

[Kymmy]

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 8)

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

[Kymmy]

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 8)

[samwise]

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

[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

[billy]

Try replacing the apostrophes with double quotation marks.

example:

INSERT INTO tbl_tablename (fld_txtname) VALUES ( "use double quotation marks, when there are apostrophes or apostrophe in the string");
HTH

Billy :)

[DaveS]

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


Should now be sorted MOM if you could give it a go. :thumb: :thumb:

[DaveS]

Try replacing the apostrophes with double quotation marks.

example:

INSERT INTO tbl_tablename (fld_txtname) VALUES ( "use double quotation marks, when there are apostrophes or apostrophe in the string");
HTH

Billy :)

Ahhh Bill you've been hanging around MS stuff too long. :teeth:
string = addslashes(string) will do the trick in PHP.
The username had not been escaped properly, but is now sorted. :-)

[Mabels Old Man]

Give the man a coconut, cheers :thumb: :thumb: :thumb: :thumb: :thumb: :thumb: :thumb: :thumb:

[billy]

I know Dave...sad really :)

Regards

Bill