Image Comments not working ?
0
After trying to comment a picture, if got the following error Message:
General Error
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 'tasty ^^')' at line 2
INSERT INTO phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_time, comment_text) VALUES ('220', '16414', '294', '15076', 'Lord_Helmchen', '1198263669', Hmm tasty ^^')
Line : 1310
File : album_showpage.php
General Error
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 'tasty ^^')' at line 2
INSERT INTO phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_time, comment_text) VALUES ('220', '16414', '294', '15076', 'Lord_Helmchen', '1198263669', Hmm tasty ^^')
Line : 1310
File : album_showpage.php
0
Lord_Helmchen wrote...
After trying to comment a picture, if got the following error Message:General Error
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 'tasty ^^')' at line 2
INSERT INTO phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_time, comment_text) VALUES ('220', '16414', '294', '15076', 'Lord_Helmchen', '1198263669', Hmm tasty ^^')
Line : 1310
File : album_showpage.php
When commenting, you should try not to use any special characters (' ; : ^ ! etc) as the MySQL server interprets these symbols as commands. If that still doesn't work, I guess there are still problems with the PHP.
0
Nope doesn`t helped, error still existing.
This time i just inserted test in the comment bracket.
General Error
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 '')' at line 2
INSERT INTO phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_time, comment_text) VALUES ('220', '16414', '294', '15076', 'Lord_Helmchen', '1198405797', test')
Line : 1310
File : album_showpage.php
Could somebody else comment a picture an see what happens ? Before i forget it, if tryed to comment the following picture
Image --> Code Geass --> CC --> C2 - 007 (ID: 16414)
This time i just inserted test in the comment bracket.
General Error
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 '')' at line 2
INSERT INTO phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_time, comment_text) VALUES ('220', '16414', '294', '15076', 'Lord_Helmchen', '1198405797', test')
Line : 1310
File : album_showpage.php
Could somebody else comment a picture an see what happens ? Before i forget it, if tryed to comment the following picture
Image --> Code Geass --> CC --> C2 - 007 (ID: 16414)