Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Databas errors
Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Oct 15, 2013 - 2:37 pm

Hi guys,

I get following databas errors from time to time. Is it something i should worry about?

file: /problem-with-post-edit-buttonome/friskytt/public_html/wp-content/plugins/simple-press/admin/panel-forums/support/spa-forums-prepare.php

line: 155

function: spdb_table

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 ') ORDER BY forum_seq' at line 1

SELECT * FROM wp_sfforums WHERE forum_id IN () ORDER BY forum_seq

.............................................................................................................................................

file: /problem-with-post-edit-buttonome/friskytt/public_html/wp-content/plugins/simple-press/forum/content/ahah/sp-ahah-admintoollinks.php

line: 41

function: spdb_table

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 '' at line 1

SELECT * FROM wp_sftopics WHERE topic_id=

.............................................................................................................................................

file: /problem-with-post-edit-buttonome/friskytt/public_html/wp-content/plugins/simple-press/forum/content/ahah/sp-ahah-admintoollinks.php

line: 40

function: spdb_table

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 '' at line 1

SELECT * FROM wp_sfforums WHERE forum_id=

.............................................................................................................................................

file: /problem-with-post-edit-buttonome/friskytt/public_html/wp-content/sp-resources/forum-plugins/report-post/library/sp-report-post-components.php

line: 73

function: spdb_table

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 '' at line 1

SELECT post_content FROM wp_sfposts WHERE post_id=

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 15, 2013 - 7:21 pm

I doubt there is any real problem but they are true errors so would like to understand - especially the two regarding the forum tools...  they indicate you are using the forum tools on a post, yet the post doesnt have a valid topic or forum... which of course does not make any sense...

same for the last... someone is reporting a post, but the post doesnt exist...

can you make the errors happen or do they just randomly appear?  if the former, can you tell me the steps?

I suspect it might just be a bot following some link and since the bot wont have the necessary permissions and data, it would fail, but still odd...

Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Oct 16, 2013 - 8:52 am

Mr Papa said

can you make the errors happen or do they just randomly appear?  if the former, can you tell me the steps?

I suspect it might just be a bot following some link and since the bot wont have the necessary permissions and data, it would fail, but still odd...

I dont know Steve.

Will check the error log more frequently and see if something i do triggers the errors.

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2013 - 10:23 am

cool...  continuing to work through on my side too...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626