10-11-2003 23:47									#1
	Read on: ATTACHMENTS BACK-END SYSTEM CHANGED Get a bigger avatar today!

After work and efforts of months(ok so it wasnt that long) we've switched the system behind forum attachments. The change occured yesterday and today and took several hours as there were over 49000 files of a total size of 4.8GB to process.

The difference is that now attachments are not stored in the mysql database but separately. E.g. there is still a table for the various necessary information(the post that it is attached on, the owner, etc) but the actual file is placed outside the database.

The user processes of viewing, adding, editing, removing attachments have not changed at all.

This should easen the load on the mysql server and lead to less server busy messages for both registered users and guests. Already (and in that have helped some other configuration changes that we have done on mysql lately) the first results seem positive.

Now we want you to check if your (most important as plenty of you have lots of them ) attachments have been transfered succesfully. E.g. if they are images if they show up correctly or if they are zip files if they can be downloaded in a correct form, etc.

Please report back any problems on this thread. Thank you!

	10-11-2003 23:57									#2
	Support Apolyton, buy Civilization 2

Nice work.

Btw I'm taking bets on how long it will be before the first back-end attachment joke.

	11-11-2003 00:20									#3
	Support Apolyton, buy Civilization 2

The latest SMAX Democracy Team Game turn is working fine.

	11-11-2003 00:59									#4
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

Files uploaded after the progressbar started yesterday should be no pronlems with at all...

	11-11-2003 01:33									#5
	Support Apolyton buy from Amazon

quote: Originally posted by DrSpike Nice work. Btw I'm taking bets on how long it will be before the first back-end attachment joke.

ER Brown Card for for but well done Admins for doing this. I'm sure it wasn't straightforward

	11-11-2003 14:32									#6
	Remove this text

to the admins for this one. No problems so far. All attachments work like a charm.

Would someone get a back-end attachment for Spikey to play with

Asmodean

	11-11-2003 15:09									#7
	Support Apolyton, buy Civilization: The Boardgame

He can have a spoiler that was attached to the back-end of my old Escort.

-Jam

	11-11-2003 15:12									#8
	Help yourself to an AD-FREE life

You guys..........you're so considerate.

	11-11-2003 16:58									#9
	Increase the size of your Attachments

We do our best.

Nice work Markos, seems a problem-free change.

	11-11-2003 19:14									#10
	Support Apolyton, buy GURPS/ Alpha Centauri

I just got my first "Server Busy" message since the back-end upgrade.

Just to let you know, Mark.

Asmodean

	11-11-2003 20:43									#11
	Get a bigger avatar today!

Did pages 'jump' to white between posting before this upgrade?
Not a big thing, but I'm using the MOO style which is darkblue and each time that white pops-up, well, it is a big difference.

PS: it's not an actual pop-up, I guess it just resets the color from blue to white.

	11-11-2003 20:56									#12
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

when you click on a attachment link or on all pages?

	11-11-2003 21:45									#13
	Support Apolyton, pre-order Civilization IV

Could that have anything to do with the fact that I get an error in line 3 whenever I load a page at Apolyton?

Asmodean

	11-11-2003 22:06									#14
	Avatar Enlargement: We've got the solution

I do not get that...

	11-11-2003 23:11									#15
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

All the images and attachment works perfect over here

	12-11-2003 01:46									#16
	Support Apolyton, buy Civilization: The Boardgame

quote: Originally posted by Asmodean Could that have anything to do with the fact that I get an error in line 3 whenever I load a page at Apolyton?

hmmm could i have a screenshot?

	12-11-2003 01:58									#17
	Support Apolyton, buy Alpha Centauri

Here you go Mark.

Sorry it's in Danish, but the dialoguebox means something like:

"There was an error loading this page
Do you want to search for the error?

Line: 3
Error: The string constant is left unfinished"

Excuse my bad translation, but I know next to nothing about programming, so I don't know how this error would look in English

Asmodean

	12-11-2003 02:00									#18
	Got spare money?

Grrrrr...forgot to post the screenshot

Attachment: errorline3.jpg
This has been downloaded 67 time(s).

	12-11-2003 02:10									#19
	Support Apolyton

Yup, that's one of those errors I've been getting a lot lately.

Attachment: debug.jpg
This has been downloaded 65 time(s).

	12-11-2003 02:51									#20
	Support Apolyton buy from Amazon

quote: Originally posted by vovan Yup, that's one of those errors I've been getting a lot lately.

For me it has just started today.

But it is kinda annoying to have to click no every time I load a page. Is there no way to turn this errormessage off?

Asmodean

	12-11-2003 03:12									#21
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

The javascript error can't be relsted to the attachment update.

There should be an option to not show erros on scriopts, I don't know where it is...

	12-11-2003 04:16									#22
	Support Apolyton, pre-order Civilization IV

hi ,

so thats how you made it possible Mark , well thanks

have a nice day

	12-11-2003 09:57									#23
	Got spare money?

Tools -> Internet Options -> Advanced -> Disable script debugging

	12-11-2003 10:11									#24
	Get a bigger avatar today!

the javascript error should be fixed now

	12-11-2003 13:32									#25
	Browse Apolyton AD-FREE

Indeed it is. Thanks, Mark

Asmodean

	12-11-2003 16:51									#26
	Increase Your PM Length

Good job, Markos!

	13-11-2003 01:14									#27
	Support Apolyton or Terrorists Win

My eyes thank you very much

	13-11-2003 21:08									#28
	Lose 30 kilos (of popups)

attachment file data have now been removed from the database. attachments table went from 4697439068 bytes to 3354724

	17-11-2003 03:45									#29
	Support Apolyton, buy Alpha Centauri

I can't attach files any longer...

I only get document contains no data errors.

	17-11-2003 03:58									#30
	Support Apolyton, pre-order Civilization IV

It workes now.. I'm not sure if it was that I was using windows or a temporary server glitch...