[Needing help with filesort]

Sorry to be annoying, I HATE bumping support threads, but I tried googling around for help on what you mean but nothing...

[Needing help with filesort]

Hi,

 

What do you mean by ascending? Are you saying it's indexed for an ASC query, but not a DESC query?

[Needing help with filesort]

Hi,

 

SQL version: 4.1.21

 

This query:

 

SELECT t.tid, t.title, t.starter_name, t.starter_id, p.post_date, p.post, p.pid

                                              FROM freeto_topics t

                                      LEFT JOIN freeto_posts p ON (p.new_topic = 1 AND p.topic_id = t.tid)

                                                      WHERE t.forum_id IN (7,3,26)

                                                              AND t.approved=1

                                                      ORDER BY t.tid DESC

                                                      LIMIT 0, 15

 

is used on a forum. it seems to be doing a filesort. here is the EXPLAIN for this query:

 

id  select_type  table  type  possible_keys  key  key_len  ref  rows  Extra

1 SIMPLE t range forum_id forum_id 4 NULL 23 Using where; Using filesort

1 SIMPLE p ref topic_id topic_id 4 freeto.t.tid 49

 

How can I get rid of this...? forum_id has an index on tid so I dont understand why it's doing a file sort. More info can be posted if needed, I'm confused with this index stuff and I've read the manuals, but I need some help.

 

Thanks in advance.

[sys_tem(); ... a difficult problem]

hmm thanks, but Nope, not working. I tried those \ns in the sys_tem(); command too, not working.

[sys_tem(); ... a difficult problem]

Hi,

I currently have an issue with the sys_tem(); command.

My problem is that I need system to be able to "reply" to the response of this command:
sys_tem("pure-pw useradd username -u ftpuser -g ftpgroup -d /var/www/s/host/username -N 200");

What this is, exactly, is a Pure-FTPd command line that adds a user in. The issue that when you do it, it then asks for password to be typed twice before adding.

"Passwrd: " is outputted on the page. I don't know of a way to reply to that. I tried after that:

sys_tem("testpassword");
sys_tem("testpassword");

The next two sys_tems seem to just open up brand new windows, doing nothing. Is there any way to continue the sys_tem(); if you get what I mean?

Thanks in advance,
jcink

edit: I know it isn't called sys_tem but if you try to post with that word in your post you get blocked!!!! >=(

[Targeting the parent window]

Hi I'm having some trouble with windows.

Lets say i have on page 1:

<a href='test.html' target='_blank'>

And on the test.html page, i want to target the window that launched it.

<a href='javascrip:document.blahblaha' target='_parent'>
edit: i know its supposed to say J A V A S C R I P T but every time i type the full word i get 406 not acceptable error O_o

but this does not seem to work. is there a way to do this?

Thanks,
Jcink