https://www.icyphoenix.com/viewtopic.php?f=26&t=2632
-----------------------------------
tearyied
Tue 14 Aug, 2007 10:33

FAP SUPPORT - SQL Error : 1064
-----------------------------------
I've installed Mighty Gorgon Full Album Pack 1.4.1 © 2006 and I'm getting an error when commenting and uploading...  I'm assuming it has to do with the apostrophe in the comment/description because when I delete the apostrophe, there is no error.  

The error reads:

Could not insert new entry

DEBUG MODE

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 awesome!!')' 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 ('561', '225', '2', '3', 'cindee317', '437f6071', '1187080335', 'it's awesome!!')

Line : 1438
File : album_showpage.php

Please help?!


-----------------------------------
lefty74
Tue 14 Aug, 2007 11:41

Re: SQL Error : 1064
-----------------------------------
http://www.icyphoenix.com/viewtopic.php?p=8060#p8060

that should help for the title and description.


-----------------------------------
Mighty Gorgon
Tue 21 Aug, 2007 15:27

Re: SQL Error : 1064
-----------------------------------
What is strange is that it should be fixed in FAP 1.4.1... :roll:

Can you provide me a link to test this please?