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

Current User: Guest
Please consider registering

 
Search Forums:


 




Eeek! ‘ORDER BY post_id DESC’ at line 3

UserPost

4:53 am
17 Jun 2008


Airsoftica

Guest

 
1

Oh my,

I'm getting the following error at the top of my page:

Hopefully it isn't fatal-but what does it mean?  I really am not a database person!

http://www.airsoftica.com/?page_id=638

You can only see it if you're logged in as the administrator.

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' at line 3]
SELECT DISTINCT forum_id, topic_id FROM wp_sfposts WHERE ORDER BY post_id DESC;

Please Help!

5:19 am
17 Jun 2008


Mr Papa

Moderator

Arizona, USA

posts 1256

 
2

I dont believe its a big issue, but not sure why you are seeing it…  Its related to displaying the users new post list, but I dont see a new post list on your site because I am a guest…

Could you please tell me your settings on the spf manage options panel, the global tab, in the Quicklinks dropdown section?  do you have the display quicklinks dropdown checked? and what value do you have in the number of new posts to show?

And only the admin sees?  not members or moderators? all forum pages?  or just certain views?

5:33 am
17 Jun 2008


Airsoftica

Guest

 
3

Mr Papa said:

I dont believe its a big issue, but not sure why you are seeing it…  Its related to displaying the users new post list, but I dont see a new post list on your site because I am a guest…

Could you please tell me your settings on the spf manage options panel, the global tab, in the Quicklinks dropdown section?  do you have the display quicklinks dropdown checked? and what value do you have in the number of new posts to show?

And only the admin sees?  not members or moderators? all forum pages?  or just certain views?



Interesting. 


I've added a second administrator (initially to grant you access to the site) but the error doesn't show up as the second admin, only with the first one. 

This error occurs in Mozilla, IE, and Safari.

Forum Page Details

Forum Page ID:
Forum Page Slug:

Forum Administrator

Forum Administrator ID:
Forum Display Name:

Auto Update

:
How many seconds before refresh:

Lock Down Forum

:

New Posts and Tools

:
:
:
:
:
:
:

Breadcrumb Links

:
:
Home:

Display Forum Components

:
:

QuickLinks Dropdowns

:
Number of New Posts to show:

Avatars

:
:
Maximum Avatar Width/Height (pixels):

RSS Feeds

:
Number of Recent Posts to feed:
Limit to Number of Words (0=all):

Spam Detection

:

Post Editing

:


5:35 am
17 Jun 2008


Airsoftica

Guest

 
4

Aha,

We solved it.  The error is some sort of bug that has to do with the Quicklinks dropdown menu.  If you set it to 0, don't have it checked!

Good eyes, good call, thanks for your help.  You guys rock–this is a great program.

1:52 pm
17 Jun 2008


Mr Papa

Moderator

Arizona, USA

posts 1256

 
5

thats what I suspected…  still, we shouldnt throw an error for that condition…  I will log a ticket to prevent that from occurring…

2:01 pm
17 Jun 2008


Mr Papa

Moderator

Arizona, USA

posts 1256

 
6

btw, is that really how the forum admin page looks for you???  what browser is that?  pretty ugly…  it should look like:

2:59 am
18 Jun 2008


Airsoftica

Guest

 
7

Oh heavens no it doesn't look like that.  I copied and pasted rather than take a screenshot.  I just downloaded Firefox 3 today–beautiful app!  I'd highly recommend it.

3:11 am
18 Jun 2008


Mr Papa

Moderator

Arizona, USA

posts 1256

 
8

whew, thats a sigh of relief…  yup, already got it myself…

3:12 am
18 Jun 2008


Mr Papa

Moderator

Arizona, USA

posts 1256

 
9

btw, this issue is fixed for the next release…  you will be able to put 0 for your post count… this will allow you to get the forum link dropdown but not the latest posts dropdown…

10:22 pm
18 Jun 2008


Airsoftica

Guest

 
10

That's really great.  I can't believe how much work this project must have been for you gentlemen–bugs or not it looks and works wonderfully.  My forum is already filling up!



Reply to Topic: Eeek! ‘ORDER BY post_id DESC’ at line 3

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: 9 + 11        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

Yellow Swordfish

slimboyfatz33

15 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 15

Topics: 1775

Posts: 11970

Members:

There are 819 members

There are 749 guests


Yellow Swordfish has made 4627 posts

Top Posters:

Mr Papa - 1256

-Radio- - 481

ovizii - 93

jfv - 80

angelic007 - 66

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


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