https://www.icyphoenix.com/viewtopic.php?f=26&t=5326
-----------------------------------
tearyied
Mon 19 Jan, 2009 23:47

FAP SUPPORT - Problem With Apostrophe In The Comment Section
-----------------------------------
Whenever there's a apostrophe used in the comment section, I'm getting this error.

SQL Error : 1064 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 so vute')' at line 2

INSERT INTO phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_user_ip, comment_time, comment_text) VALUES ('3019', '1159', '1', '3', 'cindee317', '437f67d5', '1232403831', 'this is great, she's adorable!')

Line : 1438
File : album_showpage.php

Can anyone help me?
I've already updated my version to the latest Mighty Gorgon Full Album Pack 1.4.1 © 2006.


-----------------------------------
sharkattaq
Thu 01 Apr, 2010 23:18

Re: Problem With Apostrophe In The Comment Section
-----------------------------------
You need to add an addslashes:

http://php.net/manual/en/function.addslashes.php

This will solve it.


