On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

Support Forum : Database Issue

In preparation for the release of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site and to get details of version 4.0, click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Home Forums Simple:Press Forum Version 3.0 to 3.1.4 Database Issue

Database Issue
Page: 1
UserPost

8:33 pm
11 Jul 2008


Mr Papa

Moderator

Arizona, USA

posts 1602
1

Originally Dortrich's topic, but accidentally deleted it…  his post…

On my forum when a modarator delete a Topic he get this message. But the Topic is cleared.
With admin permissions deleting is errorless.

WordPress database 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 COUNT(topic_id) FROM wp_sftopics WHERE forum_id=

WordPress database 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 post_id DESC LIMIT 1' at line 1]
SELECT post_id FROM wp_sfposts WHERE forum_id = ORDER BY post_id DESC LIMIT 1

WordPress database 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]
UPDATE wp_sfforums SET post_id=NULL, topic_count=0 WHERE forum_id=

8:35 pm
11 Jul 2008


Mr Papa

Moderator

Arizona, USA

posts 1602
2

Our replies and questions…

What - every time? Or was this just once?


yes, more info please… I just tried on a couple of different sites and did not have this issue…

1:07 pm
12 Jul 2008


Dortich

Member

Germany

posts 13
3

It seems that was a one-time issue. We are unable to reproduce it.

1:15 pm
12 Jul 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
4

Well that is sort of good. Thanks for letting us know.

If it happens again it would be very useful to have a detailed step by step list of what led up to it….
Page: 1


Reply to Topic: Database Issue

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 6 + 3        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

11 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)