Support Forum

Error log report-unsure on a description

DA Darthmonk
Darthmonk
Member
Member since Jun 2011
31 posts
Dec 19, 2012 · 6:33 pm · Edited

Hi,just a quick check on report in error log-is it important or not-forum seems to be working ok

ile: /problem-with-post-edit-buttonome/mysites/public_html/syma107.com/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php

line: 394

function: insert

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 ‘t charge’, ‘A user has edited the post’, 1356560441)’ at line 1

INSERT INTO wp_sfnotices (user_id, guest_email, post_id, link, link_text, message, expires) VALUES (827, ”, 5627, ‘http://syma107.com/forum/general-syma-s107-information/new-battery-still-wont-charge/#p5627’, ‘New battery…still won’t charge’, ‘A user has edited the post’, 1356560441)
December 20, 2012

9:20 am

 database file: /problem-with-post-edit-buttonome/mysites/public_html/syma107.com/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php

line: 394

function: insert

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 ‘t charge’, ‘A user has edited the post’, 1356560441)’ at line 1

INSERT INTO wp_sfnotices (user_id, guest_email, post_id, link, link_text, message, expires) VALUES (262, ”, 5627, ‘http://syma107.com/forum/general-syma-s107-information/new-battery-still-wont-charge/#p5627’, ‘New battery…still won’t charge’, ‘A user has edited the post’, 1356560441)

8 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Dec 19, 2012 · 6:48 pm

yeah, we have already fixed this one in the next version… only comes into play if the topic title has a quote in it… and then the topic or a post in it is edited and a notice generated for admins/user…  thanks…

DA Darthmonk
Darthmonk
Member
Member since Jun 2011
31 posts
Dec 19, 2012 · 11:06 pm

I guessed that was not a problem, I have to say having your forum up for nearly two years all updates have been great,I am very impressed how a topic can hit Google so fast, the seo the forum gives my site is amazing.I use the flex theme and make the forum page without any sidebars,no distractions, we are over 5000 posts now and pumping.If anyone thinks paying $99 a year is expensive to be a Gold member all I can say is the forum has changed my hits from 1000 a month to now near Christmas hitting 20,000 views,I am wrapped in the Simple press and the fantastic quick replies to any questions-Thanks guys,have a great 2012 Christmas-From a happy camper http://syma107.com/forumlaughOh just one thing see you have a few great smileys more than my forum,where is the best place to get them from?

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Dec 19, 2012 · 11:29 pm

thanks for the kind words!  great to hear now and then!  Merry Christmas to you! glad to hear your site is prospering!

as to smileys, just google them…  any and all smileys can be used – no matter size…

here is one big resource:  http://www.smileygenerator.us/downloads2/pafiledb.php?action=category&id=6

or for color variations

http://www.smileygenerator.us/downloads2/pafiledb.php?action=category&id=7

of course, if you like ours, you can just download the image file and upload to yours…  but seriously, just google for smiley and find ones you like…

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Dec 19, 2012 · 11:49 pm

okay, couldnt resist… some other good resources…

http://www.bbsmiley.com/forums/smiley-packs.17/

http://www.en.kolobok.us/

http://www.big-boards.com/smileys.php

DA Darthmonk
Darthmonk
Member
Member since Jun 2011
31 posts
Mar 29, 2013 · 7:25 pm

Is this error report anything to worry about?

file: sites/public_html/syma107.com/wp-content/sp-resources/forum-plugins/ban/library/sp-ban-components.php
line: 24
function: gethostbyaddr
Warning | gethostbyaddr() [function.gethostbyaddr]: Address is not a valid IPv4 or IPv6 address

BR Brandon
Brandon
Member
Member since May 2010
864 posts
Mar 30, 2013 · 12:07 am

That is a warning as opposed to an actual error but it does mention the ban plugin. It would probably be a good idea to check the IP addresses you have entered and make sure they are in a valid format.