November 10, 2003, 14:47
|
#1
|
|
Apolyton CS Co-Founder
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
Read on: ATTACHMENTS BACK-END SYSTEM CHANGED
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!
|
|
|
|
|
November 10, 2003, 14:57
|
#2
|
|
Deity
Local Time: 13:14
Local Date: November 2, 2010
Join Date: Sep 2001
Location: Enthusiastic member of Apolyton
Posts: 30,342
|
Nice work.
Btw I'm taking bets on how long it will be before the first back-end attachment joke. 
|
|
|
|
|
|
November 10, 2003, 15:20
|
#3
|
|
Emperor
Local Time: 06:14
Local Date: November 2, 2010
Join Date: Dec 2001
Location: Minnesota, USA
Posts: 6,454
|
The latest SMAX Democracy Team Game turn is working fine.
__________________
I'm not conceited, conceit is a fault and I have no faults...
As always, will play after work. I wonder if I'll ever be able to turn that the other way...
|
|
|
|
|
|
November 10, 2003, 15:59
|
#4
|
|
Technical Director
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Apr 2001
Location: Chalmers, Sweden
Posts: 9,294
|
Files uploaded after the progressbar started yesterday should be no pronlems with at all...
__________________
ACS - Technical Director
|
|
|
|
|
|
November 10, 2003, 16:33
|
#5
|
|
King
Local Time: 12:14
Local Date: November 2, 2010
Join Date: Dec 2000
Posts: 1,195
|
|
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
__________________
(+1)
|
|
|
|
|
|
November 11, 2003, 05:32
|
#6
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
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
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 11, 2003, 06:09
|
#7
|
|
Deity
Local Time: 12:14
Local Date: November 2, 2010
Join Date: May 2002
Location: lol ED&D is officially full PvP LOL
Posts: 13,229
|
He can have a spoiler that was attached to the back-end of my old Escort.
-Jam
|
|
|
|
|
|
November 11, 2003, 06:12
|
#8
|
|
Deity
Local Time: 13:14
Local Date: November 2, 2010
Join Date: Sep 2001
Location: Enthusiastic member of Apolyton
Posts: 30,342
|
You guys..........you're so considerate.
|
|
|
|
|
|
November 11, 2003, 07:58
|
#9
|
Local Time: 23:14
Local Date: November 2, 2010
Join Date: Aug 2001
Location: Skanky Father
Posts: 16,530
|
We do our best.
Nice work Markos, seems a problem-free change. 
__________________
I'm building a wagon! On some other part of the internets, obviously (but not that other site).
|
|
|
|
|
|
November 11, 2003, 10:14
|
#10
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
I just got my first "Server Busy" message since the back-end upgrade.
Just to let you know, Mark.
Asmodean
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 11, 2003, 11:43
|
#11
|
|
Deity
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Sep 2001
Location: Republic of Flanders
Posts: 10,747
|
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.
__________________
#There’s a city in my mind
Come along and take that ride
And it’s all right, baby, it’s all right #
|
|
|
|
|
|
November 11, 2003, 11:56
|
#12
|
|
Apolyton CS Co-Founder
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
when you click on a attachment link or on all pages?
|
|
|
|
|
|
November 11, 2003, 12:45
|
#13
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
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
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 11, 2003, 13:06
|
#14
|
|
Deity
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Oct 2000
Location: Bergen, Norway
Posts: 13,800
|
I do not get that... 
__________________
Do not fear, for I am with you; Do not anxiously look about you, for I am your God. -Isaiah 41:10
The LORD your God is with you, he is mighty to save. He will take great delight in you, he will quiet you with his love, he will rejoice over you with singing. - Zephaniah 3:17
Get The List for cIV here!
|
|
|
|
|
|
November 11, 2003, 14:11
|
#15
|
|
Emperor
Local Time: 07:14
Local Date: November 2, 2010
Join Date: Jun 2003
Location: Lima, Peru
Posts: 4,828
|
All the images and attachment works perfect over here
__________________
Fortune and Glory, here I come!!!.
Indy Jones
I'm not afraid of an army of lions lead by a lamb, i'm afraid of an army of sheep lead by a lion
Alexander the Great
|
|
|
|
|
|
November 11, 2003, 16:46
|
#16
|
|
Apolyton CS Co-Founder
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
|
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?
|
|
|
|
|
|
November 11, 2003, 16:58
|
#17
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
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
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 11, 2003, 17:00
|
#18
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
Grrrrr...forgot to post the screenshot
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 11, 2003, 17:10
|
#19
|
|
Emperor
Local Time: 06:14
Local Date: November 2, 2010
Join Date: Oct 2001
Posts: 5,725
|
Yup, that's one of those errors I've been getting a lot lately.
|
|
|
|
|
|
November 11, 2003, 17:51
|
#20
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
|
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
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 11, 2003, 18:12
|
#21
|
|
Technical Director
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Apr 2001
Location: Chalmers, Sweden
Posts: 9,294
|
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...
__________________
ACS - Technical Director
|
|
|
|
|
|
November 11, 2003, 19:16
|
#22
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Oct 2000
Location: MY WORDS ARE BACKED WITH BIO-CHEMICAL WEAPONS
Posts: 8,117
|
hi ,
so thats how you made it possible Mark , well thanks 
have a nice day
|
|
|
|
|
|
November 12, 2003, 00:57
|
#23
|
|
Apolyton CS Co-Founder
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
Tools -> Internet Options -> Advanced -> Disable script debugging
|
|
|
|
|
|
November 12, 2003, 01:11
|
#24
|
|
Apolyton CS Co-Founder
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
the javascript error should be fixed now
|
|
|
|
|
|
November 12, 2003, 04:32
|
#25
|
|
Emperor
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Aarhus, Denmark
Posts: 3,618
|
Indeed it is. Thanks, Mark
Asmodean
__________________
Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark
|
|
|
|
|
|
November 12, 2003, 07:51
|
#26
|
|
Emperor
Local Time: 07:14
Local Date: November 2, 2010
Join Date: Mar 2000
Location: Flyover Country
Posts: 4,659
|
Good job, Markos!
__________________
"We have tried spending money. We are spending more than we have ever spent before and it does not work...After eight years of this Administration, we have just as much unemployment as when we started... And an enormous debt to boot!" — Henry Morgenthau, Franklin Delano Roosevelt's Treasury secretary, 1941.
|
|
|
|
|
|
November 12, 2003, 16:14
|
#27
|
|
Deity
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Sep 2001
Location: Republic of Flanders
Posts: 10,747
|
My eyes thank you very much
__________________
#There’s a city in my mind
Come along and take that ride
And it’s all right, baby, it’s all right #
|
|
|
|
|
|
November 13, 2003, 12:08
|
#28
|
|
Apolyton CS Co-Founder
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
attachment file data have now been removed from the database. attachments table went from 4697439068 bytes to 3354724
|
|
|
|
|
|
November 16, 2003, 18:45
|
#29
|
|
Technical Director
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Apr 2001
Location: Chalmers, Sweden
Posts: 9,294
|
I can't attach files any longer...
I only get document contains no data errors. 
__________________
ACS - Technical Director
|
|
|
|
|
|
November 16, 2003, 18:58
|
#30
|
|
Technical Director
Local Time: 14:14
Local Date: November 2, 2010
Join Date: Apr 2001
Location: Chalmers, Sweden
Posts: 9,294
|
It workes now.. I'm not sure if it was that I was using windows or a temporary server glitch...
__________________
ACS - Technical Director
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
All times are GMT -4. The time now is 08:14.
|
|
