27-06-2003 05:25									#1
	The "my threads" feature isn't working Support Apolyton, buy Call to Power 2

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!

	27-06-2003 05:27									#2
	Support Apolyton, buy GURPS/ Alpha Centauri

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/showthre...&threadid=90537

	27-06-2003 05:29									#3
	Support Apolyton, buy GURPS/ Alpha Centauri

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

	27-06-2003 05:29									#4
	Avatar Enlargement: We've got the solution

Third similar thread on this issue AH

	27-06-2003 06:12									#5
	Got spare money?

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

	27-06-2003 08:00									#6
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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

	27-06-2003 15:25									#7
	Increase Your PM Length

quote: Originally posted by alva Third similar thread on this issue AH

That's the way to get Deity.

	27-06-2003 16:19									#8
	Inflate your Upload Space

it seems to be working for me

	27-06-2003 16:36									#9
	Enter the AD-FREE zone

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

	27-06-2003 16:42									#10
	Put an end to popups!

quote: Originally posted by Hydey it seems to be working for me

I'll try it out.

	27-06-2003 16:45									#11
	Support Apolyton, pre-order Civilization IV

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

	28-06-2003 07:59									#12
	Support Apolyton, buy Galactic Civilizations

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

	28-06-2003 08:33									#13
	Enter the AD-FREE zone

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

	28-06-2003 13:12									#14
	Support Apolyton, pre-order Civilization IV

should be ok

please report any similar errors

	28-06-2003 21:27									#15
	Increase Your PM Length

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

	29-06-2003 08:01									#16
	Get a bigger avatar today!

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...

	29-06-2003 16:41									#17
	Support Apolyton

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

	29-06-2003 18:09									#18
	Lose 30 kilos (of popups)

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

	30-06-2003 05:05									#19
	Avatar Enlargement: We've got the solution

quote: Originally posted by MarkG should be ok please report any similar errors

Thanks Mark - working fine now

	30-06-2003 08:39									#20
	Got spare money?

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.

	30-06-2003 18:17									#21
	Browse Apolyton AD-FREE

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.