The "my threads" feature isn't working

Alexander's Horse · June 26, 2003, 20:25

Has been out for at least 2 or 3 days.

Can we get it restored please? Its a very useful feature.

Here is the error message:

Quote:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

We apologise for the inconvenience.

Database error in vBulletin: Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=2445 ORDER BY dateline DESC LIMIT 1
mysql error: Can't open file: 'search.MYI'. (errno: 145)
mysql error number: 1016
Date: Thursday 26th of June 2003 08:24:18 PM
Script: /forums/search.php?s=&searchuser=Alexander\'s%20Horse&exactname=yes&forumchoice=-1&titleonly=&showposts=&searchdate=30&beforeafter=after&sortby=lastpost&sortorder=descending&action=simplesearch&query=&showot=1
Referer: http://apolyton.net/forums/index.php

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

We apologise for the inconvenience.

Database error in vBulletin: Invalid SQL: DELETE FROM search WHERE dateline<1056068659
mysql error: Can't open file: 'search.MYI'. (errno: 145)
mysql error number: 1016
Date: Thursday 26th of June 2003 08:24:19 PM
Script: /forums/search.php?s=&searchuser=Alexander\'s%20Horse&exactname=yes&forumchoice=-1&titleonly=&showposts=&searchdate=30&beforeafter=after&sortby=lastpost&sortorder=descending&action=simplesearch&query=&showot=1
Referer: http://apolyton.net/forums/index.php

Phew!

Alexander's Horse · June 26, 2003, 20:27

The "new posts" feature isn't working either:

Quote:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

We apologise for the inconvenience.

Database error in vBulletin: Invalid SQL: SELECT searchid FROM search WHERE query='1=1 AND NOT (thread.forumid=\'179\' OR thread.forumid=\'207\' OR thread.forumid=\'178\' OR thread.forumid=\'165\' OR thread.forumid=\'166\' OR thread.forumid=\'167\' OR thread.forumid=\'168\' OR thread.forumid=\'169\' OR thread.forumid=\'170\' OR thread.forumid=\'200\' OR thread.forumid=\'201\' OR thread.forumid=\'202\' OR thread.forumid=\'203\' OR thread.forumid=\'204\' OR thread.forumid=\'205\' OR thread.forumid=\'206\' OR thread.forumid=\'155\' OR thread.forumid=\'156\' OR thread.forumid=\'15\' OR thread.forumid=\'190\' OR thread.forumid=\'191\' OR thread.forumid=\'192\' OR thread.forumid=\'193\' OR thread.forumid=\'194\' OR thread.forumid=\'112\' OR thread.forumid=\'159\' OR thread.forumid=\'152\' OR thread.forumid=\'128\' OR thread.forumid=\'123\' OR thread.forumid=\'125\' OR thread.forumid=\'116\') AND thread.lastpost>=1056666574 AND thread.open<>10 AND forumid!=147 '
mysql error: Can't open file: 'search.MYI'. (errno: 145)
mysql error number: 1016
Date: Thursday 26th of June 2003 08:26:20 PM
Script: /forums/search.php?s=&action=getnew
Referer: http://apolyton.net/forums/showthrea...threadid=90537

Immortal Wombat · June 26, 2003, 20:29

I imagine it is because they run on the same thing as the forum Search, which is also non-functional.

alva · June 26, 2003, 20:29

Third similar thread on this issue AH

Alexander's Horse · June 26, 2003, 21:12

Really? I wasn't aware. But it shows I'm not alone.

Skanky Burns · June 26, 2003, 23:00

Actually you are. Everyone's "My Threads" feature is fixed. Except yours.

DrSpike · June 27, 2003, 06:25

Quote:

Originally posted by alva
Third similar thread on this issue AH

That's the way to get Deity.

Hydey · June 27, 2003, 07:19

it seems to be working for me

Thirgaral · June 27, 2003, 07:36

Go to apolyton.net (not the forums-site) and click on "your threads". That still works

Heresson · June 27, 2003, 07:42

Quote:

Originally posted by Hydey
it seems to be working for me

I'll try it out.

Heresson · June 27, 2003, 07:45

I'll have have a feeling of guilt on the other side...

DanQ · June 27, 2003, 22:59

Hi folks.

Yes, I am aware of the error messages in question -- they are currently being investigated. Thank you for the heads-up, nonetheless, and for your patience.

---------
Dan; Apolyton CS

Hydey · June 27, 2003, 23:33

see Dan is on the ball and things will be fixed soon enough

MarkG · June 28, 2003, 04:12

should be ok

please report any similar errors

mrmitchell · June 28, 2003, 12:27

I must say, 4 threads!? Does this mean people actually did use the search???

Snowflake · June 28, 2003, 23:01

No! This means that people don't search. In fact they don't even look! My "my thread" thread is still on the first page. Doesn't look to me like they do search before they start asking questions...

Heresson · June 29, 2003, 07:41

Of course. Why should they? It's easier, and You get +1

The Mad Monk · June 29, 2003, 09:09

They searched for threads on the search function not working, but the search function wasn't working, so they so made a thread.

Alexander's Horse · June 29, 2003, 20:05

Quote:

Originally posted by MarkG
should be ok

please report any similar errors

Thanks Mark - working fine now

Snowflake · June 29, 2003, 23:39

Quote:

Originally posted by The Mad Monk
They searched for threads on the search function not working, but the search function wasn't working, so they so made a thread.

Sirotnikov · June 30, 2003, 09:17

Woohooo

It works.

arty:

Only when it was broken did I realise how much it is dear.

to Mark for coming up with this in the first place.