@teylyn: please don't yell, now you crushed it again![]()
@teylyn: please don't yell, now you crushed it again![]()
Never use Merged Cells in Excel
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I guess the technical team is working to resolve things at the backend. So in the meantime, the server is not able to handle the load and dbase and other errors could be popping up. I guess we should just give them a lil time to handle it all and we should have a fine-flowing forum.
I know it can be very irritating to keep getting the errors and to lose text you have typed....but right now all the tech team need from us is a lil patience....things should be fine sooner or later....
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Arlette,
Compared to some I'm a relative newbie here but since I joined every change that has been made to the forum has been a complete and utter screw up of one form or another. Once you've been around a bit longer you get as frustrated and pessimistic as the rest of us.
Dom
Arlette,
Is two years long enough to fix the forum.. ?
Last edited by pike; 01-05-2012 at 06:32 AM.
Arlette, excuse me, but I think you have no idea what you are talking about. This forum has a history of success, but ever since Vai took it over three years ago, it has been going steadily downhill with regards to user experience, management, people skills and communications. You've been a member for less than 6 months and I find that in your posts so far you always strongly lean towards Vai's position. Maybe it's a regional thing. Maybe a cultural one. To me, you sound very much like a claqueur. But this is an international forum and Vai is riding it into the ground.
< I need to take a walk around the block, otherwise, I won't be allowed to post here anymore ..... >
Last edited by teylyn; 01-05-2012 at 06:38 AM.
Hi guys when you have a mo check this out http://www.excelforum.com/showthread...=1#post2675451 and the last 4 - 5 posts of that thread![]()
Not all forums are the same - seek and you shall find
@Jaslake, i'd be interested to hear how you go on over the next day or two as Vai has taken my advice and is working towards doing this right![]()
I would be remiss if I did not admit I developed the habit a year ago of COPYING the text of my posts before hitting the SUBMIT button, I'm so used to having to retrieve them and try again....![]()
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Where are my recent posts?
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
I think the search is finally functional however there are certain things which i am not able to follow such as the Order of the Searched THreads..
Now THey dont seeem to follow any order or is there something that I am missing as I remember very clearly what was my first thread but its not coming up at all..
Fair play to you for continuing to try. If I've understood correctly Vai has accepted his team are out of their depth and is getting a bit of help from Simon so hopefully things will improve soon. As it's just taken me over 5 minutes to log on and post this I won't be trying to answer anything for a bit yet.
Dom
Hey guys,
Thanks for your support all through this rough times we have had with the server spikes. As posted on the forum, the spikes in the server load were posing problems for everyone and creating dbase errors.
However, i am happy to say that we have resolved this problem. We have been checking each and every minute aspect of the forum to find out the root cause of the spikes in the server load. The skylight view was one of the main contributors to the high load and we have de-activated it.
Also, you would have observed that a few things here and there have been de-activated as well, such as Users viewing the thread, list of birthdays on the main page, etc. All these will be put back one by one after carefully monitoring its effect on the server load. Even these small features could cause potential problems to the server.
For the past few hours, the forum has been performing well and we are constantly monitoring it to ensure it continues to do so.
Teylyn - We had huge server issues yesterday and i guess everyone faced a problem with the various errors popping up. Now, everything has been resolved and you should not be facing any of these issues.
Sorry for the inconvenience caused to you Teylyn. Since the server is back and functioning again, i dont think you will be facing this problem.
The reason of not getting convinced about the complete working of the functionality is leaving some room of doubt as there can be some threads missing or maybe not as I joined the forum on 3-Nov-2008 and I am sure and I am sure I would have started with some thread on the same day however as the Threads are not sorted and theres no way of searching for some threads more than a year back its difficult to say..
Maybe it working but not neat in terms of the order...
Hope this helps in realizing ths issue..
Is everything fixed now then? Haven't seen an update for a few days.
Dom
I've not had any major problems so far this week
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I had DB errors yesterday.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I just hope that this was last updateAnd when one day I would be really old and have 50 and my son ask me: "Dad, why excel forum hasn't be updated for ages and move into 3D" I'll say: "At least it work this way"
Things being what they are ( instead of what they should be), I'll stay away a bit longer.
wrong icon
EF_skype.GIF
I had DB errors briefly this morning at about 09:45-10:00, give or take.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe I am missing something, but before when you performed a search you could narrow the search to a particular section of the forum. I do not see this as an option anymore or have I overlooked something?
HTH
Regards, Jeff
Hi Jeff,
In the Advanced Search screen, it defaults to the "Search Multiple Content Types" tab. (Can't say I find a use for it..) If you click the "Search Single Content Type" tab, you'll see a listbox where you can select one or more sub-forums.
Too be sung when forum members meet.Nobody knows the trouble I've seen
Nobody knows my sorrow
Nobody knows the trouble I've seen
Glory hallelujah!
Alf
I think the upgrade is magical
I solved this one within 9 minutes without even looking!!! ...![]()
@Marcol: wouldn't have expected any less. What would be good, and is becoming increasingly necessary, is the ability to address and resolve the posts without having to log into the forum.
Regards, TMS
@Marcol: wouldn't have expected any less. What would be good, and is becoming increasingly necessary, is the ability to address and resolve the posts without having to log into the forum.
Regards, TMS
who said we have no readers minds?! ))
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
I am getting so sick of seeing this ...
Leave the Page.jpg
When this happens, I have to confirm that I want to leave the page, close that tab, again confirm that I want to leave the page and then close down any other tabs connected to the forum ... sometimes even having to close Internet Explorerer (IE9). Then after opening up IE9 again, checking in to the forum and opening up my CP, I generally find that the post was accepted. It's so easy to end up with duplicate posts, it's ridiculous.
As I've been using the forum for about 18 months, I'm familiar with should and shouldn't happen. GH any new users who don't know what's going on. Oddly enough, my ipad seems to cope better so maybe it's IE9 that's contributing to the problem
TMS
Good grief: it actually happened when I was posting the last message.![]()
![]()
![]()
No, it's not IE9, I am using Firefox 6 and getting the exact same issues.....
.... let's see how long this one takes to post!
I am really getting sick and tired of this... it's been over a month!!!! WTF does it take to get it right!
I'm on FireFox and getting that exact same thing, taking multiple multiple multiple (did I say multiple?) attempts to get the page to refresh... the site is stalling for up to five minutes at a time when this happens....
....which gives me time to go work on other Excel forums, guess that's a good thing.![]()
And that thread has two posts but no views???????
It's to do with the way the forum runs it's HTML/Javascript with the current version of PHP, there's some subtle changes that need making to make this go away!
It will happen in all browsers unfortunately!
@Vai, i'm still not getting notifications when i should, sometimes i get double notification and then others i get nothing.
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:33 PM.
Same issues on Chrome.
I'm starting to wonder if Vai just thinks there's enough previously answered questions in the history that a forum that works isn't important and he can just rake in the advertising profits from the non-members. Let's face it if you knew how cr@p things were you certainly wouldn't join with the intention of helping out around here now.
Dom
I wonder if the people who post the most take longer? My MO has been to attach a file, as an example, to show my answer. I'm concerned that any new attached file needs to be extracted from the message and put somewhere else, that takes extra time.
I to have waited more than 10 seconds with the spinning hourglass, waiting to get to another place in the forum. It seems that closing my browser and starting it again is the only way to check to see if my post/answer was accepted. I've started to copy and paste my post into notepad, just in case the post wasn't accepted and I need to submit it again.
All this makes me go elsewhere to help others.
I also have noticed that Rep points aren't being accumulated correctly. It seems I had a number that didn't increase after a few positive reps and comments were submitted.
I'd like to know how long I may need to wait after attaching a file, using Advanced formatting and having multiple tabs from my browser looking at the same post. What is taking so long???![]()
Edit - this post was recognized and came back in less than 2 seconds..![]()
Now can they all be like this one?
![]()
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I suppose we need to rename this subforum into the 'water boiler'
This is nothing! If you want to see some proper moaning head over to a Leeds United forum
Dom
PS Bates Out!!!
@MarvinP:
Do the rep points have a green box or a grey box. Seems a grey box indicates an OP doesn't have "rep power". Strange that I've been posting for over 18 months and never experienced this before. Doesn't seem quite right that if I fix something for someone who is very new to the forum, they can't reward me with rep points.I also have noticed that Rep points aren't being accumulated correctly. It seems I had a number that didn't increase after a few positive reps and comments were submitted.
Regards, TMS
In case Vai is interested here's the fix for the annoying pop up, in clientscript/vbulletin_textedit.js file change it this:
{YAHOO.util.Event.addListener(window,"beforeunload",this.exit_prompt,this,true)}
to:
{YAHOO.util.Event.addListener(window,"beforeunload",this.exit_prompt,this,false)}
And all should be well!
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:33 PM.
Seem like an easy enough fix that this "magic" team of Vai's should know how to fix, isn't it?
Also, I am getting "grey" reputations too... so probably another programming screw up by the "team"
Andrew opened a thread for the magic grey rep!
http://www.excelforum.com/the-water-...s-of-grey.html
To whom it may concern:
OK, I give in ... I really enjoy answering questions and get a great sense of satisfaction from helping people. It keeps my brain active ... there's only so many sudoku puzzles you can do ... and I learn as I go.
However, the frustration caused by all the problems, in particular the "Leave This Page" debacle leaves me speechless ... almost.
Anyway, I'm going to take a week or two out and see if things improve. My wife will think it's because she keeps telling me to "get a life" but I can live with that; no reason for her to think anything elseAnd, who knows, it might break the habit and I can find something else to occupy my time
Shame, because I've enjoyed the atmosphere here. But it seems a lot of the people who "make the forum" are voting with their keyboards, so I think I will follow their lead.
Regards, TMS
TMS, before you bow out how about a small experiment?, unless the "Team" have changed other code this should give you a small release, turn off javascript in your browser (or install another browser and turn off that JS if you dont want to chnage the settings of your current one), the vBulletin family of software were always built to cater for those that dont have JS turned on, naturally some nice things may not be available to you but back in days of old you could hardly tell the difference if JS was on or not.
Give it a go before you go elsewhere or have a break
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:33 PM.
That seems to temporarily fix it, Simon. Thanks.
I will have to remember to re-instate it or decide if it is worth it to keep it off after browsing elsewhere....
As you can see it doesn't affect too much in the way of operation here and i'm glad it worked for you, but as you say it is only temporary, and yes it may affect your browsing pleasure elsewhere. If the fix i posted gets done then everyone can be happier
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:34 PM.
Hi Simon.
Thanks for encouraging me to stay but I think I'm going to pass for the moment.
Currently, I have Safari running with JavaScript switched off. I tried to update a post with some example data embedded in HTML tags. When I saved it, it thought about it for a long time before apearing not to do anything. I tried again and thought it had been successful only to find my nicely aligned example is now all on one line. Not quite what I intended.
You have my email address, or the means to get it, so, if you want to talk to me offline at some point, let's do that.
I commend you on you remarkable patience which doesn't seem to be appreciated.
Regards, TMS
Whats' great about Simon, is that he never gives up ! I wish I had that stamina !
But... in the last five minutes, the system threw me out three times ( responding too slowly), then it took something like 2 minutes ( yes, 120 secs) to load a page, and the same to post an answer.
So, I do understand TM, and will stay on vacation a little longer. Sorry for letting you down, but this is really looking like a joke, worse than Belgian politics.
Arthurbr, thanks for the accolade, funny enough it just took around 90 secs for the forum to load for me!
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:34 PM.
......and 30 secs to make that last post!
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:34 PM.
Vai time to make Simon head of your team .. you need to .. arr.. i'm wasting my breath .. Vai will do what he wants when he wants .. stuff what any one else thinks or how the forum performs!
A post worth reading from one of our users....
http://www.excelforum.com/excel-prog...book-2.html#16
I don't think thats issues with the forum, my corporate firewall is just as strict, some JS driven items it won't allow and then some HTML it wont allow!
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:32 PM.
Is this an upgrade issue or is it me. For me this Thread will only appear in Printable View...http://www.excelforum.com/excel-prog...int-print.html
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
I can see that in standard format (not using your link) so it must be an issue local to you.
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:32 PM.
@Simon: early days but Firefox with the NoScript addon does seem to help. Better than Safari with scripts blocked, anyway. I'm not getting my hopes up though.
I'll see how it goes for the moment ... but next DB error or general crash, I'll be taking some R&R time.
Regards
The most remarkable thing is the complete absence of any comment from the owner of the forum over the last few days.
I'm sure he'll eventually come around and assure us that his team is working hard and that all issues are now fixed.
For me, this forum has degraded to banana software. And I think this should be its theme song:
http://youtu.be/Sdn3O6aaMNc
cheers,
@ Simon
Seems Paul has fixed my issue@ PaulIt is because the thread title ends in "print". I've adjusted the title so it will now appear correctly
I'm now able to access the Thread and download the attachment...thank you.
@ On ErrorGoTo0
Yes, you appear to have been correct...thanks
Hey guys,
We got the irritating popup (more of an eyesore wasnt it?) sorted out and you should not be seeing any of those soon. I apologize for the inconvenience that has caused all of you.
Also, i have verified the existence of grey reps and they surely do exist.
You should not be receiving any dbase errors on the forum, however if you do, feel free to get back to us and we will sort it out immediately.
The forum was slow yesterday and was posing problems due to a defrag that was being run on the server. You should not be facing any more problems today.
Happy posting !!!![]()
Vai,
TRY TESTING SOME OF THESE CHANGES YOU ARE MAKING RATHER THAN IRRITATING PEOPLE MORE AND MAKING THIS JOKE OF AN UPGRADE EVEN MORE TIRESOME AND EMBARASSING!!!
Dom
To be honest, no it wasn't more of an eyesore, and it wasn't just irritating. It was frustrating and, I would have thought, a cause for concern for you. It damaged any confidence that might have been growing, was/is keeping away some of your best contributors and is wasting resources in duplicated and triplicated posts ... amongst other things.We got the irritating popup (more of an eyesore wasnt it?)
How you can just gloss over it is beyond me.
And the grey reps isn't something to be ignored either. It's recognition, a tick in the box for effort. You need to sort it out, and quickly.
Let's hope the negative rep's work correctly; I just send Vai a neg rep because of his disregarding member's comments.
Vai i'm glad you employed the Yahoo JS fix i posted, now if you'll take a look at the settings you should be able to clear up any further issues with the rep system (as long as the template coding hasn't been compromised).
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:33 PM.
Simon, I wonder: If you do all the work sorting out their problems, why don't you get the credit?
I sincerely hope that Vai will compensate you in real value for your contributions to fixing the forum issues.
At the very least, he should void forum rule #13, which has never been agreed by any moderator, and you should be allowed to link to http://www.thecodecage.com in your signature.
Posts per user don't display correctly.
A user has 2 posts on the forum. Clicking on the user name to display the forum posts lists only one post; the most recent one is missing. This is useless. It used to show ALL posts by the user, even the most recent one.
Vai, whatever indexing you are using right now does not work.
I've posted this before. It has been deleted. I'll keep posting it.
production.jpg
I don't know how many times I have posted a response with a file uploaded only to get a database error and have to do it all over again. Are the database errors being sorted out?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
@ Alf
I believe I lost 10 points.
I think it is because the title ends with 'print'.
It is because the thread title ends in "print". I've adjusted the title so it will now appear correctly.
http://www.excelforum.com/excel-prog...-the-list.html
@Vai: please fix the grey rep count problem. It shouldn't be that difficult and shouldn't have any major impact on other key functionality.
I enjoy the challenge of resolving problems and the gratitude of the people I help ... but I also enjoy the recognition.
I have continued to persevere through your difficult times but I'm going to stop posting in this forum until this is resolved.
I'm lost with where to post this ...
The message about navigating away from the page seems to have gone to some extent.
However it has been replaced with
If anybody can post twice within 30secs on this forum I'd be very surprised.This forum requires that you wait 30 seconds between posts. Please try again in 15 seconds.
Why does the Forum want to post twice, it's certainly not me?
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hey Val,
I don't know what TMShucks means by grey rep but I just got two "thanks" on my rep settings page and the total went down. Did you try to fix the Reputation totals and put a negative sign in front of new entries? For your info, I went from 1691 (or so) to 1683 (or so) after the last two positive reps.
Do I get negative rep for looking at the settings page to see what my rep is? It does seem a little punative to get rep points subtracted for people saying thanks. I wonder if TMS has posted since his last one above? Please fix this reputation summation problem!!
Another question. I'm an awful speller. Does the spell check icon work above the message boxes?
Mine have been reinstated.
@MarvinP: actually, I have ... I felt guilty about leaving an OP in limbo, so I answered the question. My rep has also gone down from around 2096 to 2087.
I guess this is a case of "be careful for what you wish for"
@Vai ... WTF???????????????
@MarvinP: actually, I have ... I felt guilty about leaving an OP in limbo, so I answered the question. My rep has also gone down from around 2096 to 2087.
I guess this is a case of "be careful for what you wish for"
@Vai ... WTF???????????????
I think they have perhaps incorporated a randomiser so the rep system is now a lucky (or unlucky) dip. they probably need to adapt the tag lines too - "MarvinP is unsure where he stands now" and so on.
I cannot wait to see the status when I return from dealing with my clients next week. Iwonder if the forum will still be here.
Last edited by OnErrorGoto0; 01-26-2012 at 01:01 PM.
Given that the search option doesn't apply anymore, I thought I would keep track of one of the threads that I responded to by subscribing to it. I was not notified when there were more posts added to it. Seriously, wtf?
Just a note, you only get notification of new posts once you revisit the thread, until then you only get one, so scenario is:
You post and leave>Op posts (notification sent)>New Helper posts>Op posts>New Helper posts>You visit after reading notification, go "WTF?" (notification sending reset)>Op posts (as long as you're not currently viewing thread new notification sent)
You can code a solution whereby folk are notified every time as i have one but to be honest if you are a busy poster your inbox would fill up quick
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:31 PM.
Quite interesting, my reputation points went from 301 to 294 a reduction of 2,3 %.
TMShucks lost 9 points going from 2096 to 2087 a reduction of 0,4 %.
This is probably not a “Robin Hood” kind of robbery i.e. taking from the rich and giving it to the poor. Nor does it seem to be a general down sizing as we all should loose about the same %.
Would be nice to know more cases of “lost point” so one could do an analyze to see if there is a pattern. A “Monte Carlo” simulation or “Drunkards Walk” mathematics perhaps.
Alf
well, someone has taken 9 points from me!
I'm wondering if the tech team knows something about'em....hi guys, I want'em back!
I lost 9 points..![]()
Guess what, i got my reps back.....i just checked...
No pattern detected yet. So far we got:
THShucks number of posts 5303 points lost 9
Jaslake number of posts 3418 points lost 10
Arlu1201 number of posts 1776 points lost 9
John55 number of posts 503 points lost 9
Alf number of posts 441 points lost 7
Perhaps there is no pattern? Just plain stupidety from those who are fixing the forum!
Alf
Oh sh** so have I. I humbly apologize to the ones fix the forum.
Alf
wow!
yeap, I rcvd them back too! Merlin is in action!)
I have a possible reason for grey rep squares.....
If the reputation dialog is brought up and no radio button is clicked then Val doesn't know if it is green or red. It then comes out as grey. If a user clicks on the radio button then it goes to green.???
I think it is a problem with the initial state of the rep radio buttons and not being captured by the program. ???
I also got my rep back in my settings screen. Now I wonder if it is really correct?
let's test it...
My rep count is mended ... I did think about a happy smiley but, you know what, I can't be ar$ed
Hey all,
The negative rep came in due to a slight change in one of the settings. This has been restored. All the reps have been reversed to their original value.
Also, the grey reps have always been a part of the rep system. Its due to rep power.
Last edited by Vaibhav; 01-26-2012 at 03:15 PM.
Vai, have you ever wondered why all mods and staff details (underneath your username) appear bold and blue? the html is poorly formed, take a look at the forum home you'll see that any user that appears after a mod or admin appears bold...etc!
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 01-26-2012 at 09:32 PM.
HEY - I just did about 6 answers and NO PROBLEMS!!!![]()
![]()
Could it be adding more memory was the answer?
Good Job VAL!!!!
Let's not get nervous yet...being an Old Codger, I been through and managed many of these System Upgrades...all of which resulted in success. This one has been and is being a bit difficult. The Powers That Be may well have identified their most limiting problem...we can hope. Not sure why it wasn't identified early on...don't know, don't care...hopefully this'll get it fixed. If not...
Our last attempt to increase the ram on the server was un-successful as we already had the maximum possible RAM which the server could have. We performed a lot of optimization on the server to decrease the load but still in high traffic times the current server is unable to bear the traffic so we have decided to move to a new and much better server with double the RAM and much better processor. The server has been ordered and being prepared now and the process of moving the site to the new server will start in around 3 hours from now. Once the site has been moved we will change the DNS to point to the new server and it will take between 2-24 hours for DNS to propagate all across the globe. There will be minimal downtime during the process but once we change the DNS we will have to close the creation of new threads and posts on the old server so that there are no posts which are lost during the transition. All updates regarding the server move will be available on our twitter account as well : http://twitter.com/exceltipsnforum
The Forum Attachment "facility" doesn't seem to want .xls files (i.e. pre 2007 files), looks like they have to be zipped.
I have tried with 372, 135, and 137KB files, surely they are not above the size limit?
Hi Vaibhav
I appreciate you giving notice such as this and others in the recent pastIt would be nice if you could time stamp these notices so we users can get a relative sense of time when all of this is going to happen.Our last attempt to increase the ram on the server was un-successful as we already had the maximum possible RAM which the server could have. We performed a lot of optimization on the server to decrease the load but still in high traffic times the current server is unable to bear the traffic so we have decided to move to a new and much better server with double the RAM and much better processor. The server has been ordered and being prepared now and the process of moving the site to the new server will start in around 3 hours from now. Once the site has been moved we will change the DNS to point to the new server and it will take between 2-24 hours for DNS to propagate all across the globe. There will be minimal downtime during the process but once we change the DNS we will have to close the creation of new threads and posts on the old server so that there are no posts which are lost during the transition. All updates regarding the server move will be available on our twitter account as well : http://twitter.com/exceltipsnforum
I have had problems with all workbooks of any size over (I guess) 100KB. Testing a small xls attachment.
Last edited by OnErrorGoto0; 01-28-2012 at 06:27 AM.
test attachment
No problem attaching .xls for me
Testing over 100KB.
And over 200KB?
Internal server error (that could just be coincidence of course!)
Testing huge attachment....not happening...i get the attached error...
Hi Simon
Just tried to upload a file to this Thread
http://www.excelforum.com/editpost.p...postid=2694773
Hitas you suggested...no error message...just no file upload.when you come back to excel forum always hit Ctrl+F5
Looks like the limit for .xls files is c120KB.
The size that you are allowed to upload for each file is attached, i suspect that during the "RAM upgrade" the sizes if post upload and mysql packest have been reduced (ptobably to 1mb) so when you are trying to upload the file along with everything else with the post (including space taken by auto save) the packet or post size are larger than that set in myconf.ini (or set at cpanel level on the server).
sizes.jpg
Most recent posts seem to be not updating the dashboard. For example, I posted to this Thread
http://www.excelforum.com/excel-prog...el-2011-a.htmlat 10:38PM...it does not appear on the dashboard.
There's been at least one additional post...also not recorded.
I'm happy to announce that the wizkids from India managed to screw up a new thing in the forum:
In this post it's indicated 16 posts have been posted, 2 pages in total.
Clicking on the '2' button of the pages, or 'last' button of the pages only shows page 1.
Last edited by snb; 01-28-2012 at 10:13 AM.
@ Simon
I'm talking 120KB not MB
Just tried a 200KB .xlsm with only a couple of dozen characters in the message text. The file won't upload.
Surely this can't be correct ...![]()
I just tried to upload a file of 144kb and get an ioerror.
What a bag of utter tosh this website has become. I'm surprised anyone can be bothered trying any longer.
Dom
Its definitely a settings issue but not in the vbulletin software, it's at server level!
Testing attachment....successful...800kb...
The last update on Twitter was 23rd Jan. Very informative, not!All updates regarding the server move will be available on our twitter account as well : http://twitter.com/exceltipsnforum
Last edited by Domski; 01-29-2012 at 05:40 AM.
There was one 21 minutes ago...
"The website transfer from old server to the new one is still underway, hopefully it gets complete in the next 3-4 hours."
The emphasis is presumably on the word 'hopefully'.
Now there's a coincidence![]()
From where the need to change the server, while before the downgrade it all worked smoothly ?
It's a typical example of running backwards because of incompetency (we have no idea what went wrong so we change something not based on a thorough analysis but based on a wild guess: 'well you never know'; and by doing so creating new problems you are not able to solve (that will be so 'solved' based on a new wild guess, creating... etc.))
Whoever is watching this thread for updates on the event when they do change the nameservers (DNS) when you come back to excel forum always hit Ctrl+F5 this will ensure that your cached page isn't used to load the site and you are sure that you are seeing the current site at that time![]()
When trying to mark a post as solved I have received the following error
I will post the link in the mark as solved threadThe website encountered an error while retrieving http://www.excelforum.com/editpost.p...post&p=2694820. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this web page later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfil the request.
Edit: Managed to get it to accept the solved now after giving it 10mins
Last edited by WasWodge; 01-29-2012 at 08:25 PM. Reason: update
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
This thread says there are 321 posts. However,you can't see post #321 because it's on page 9. No matter how I try, I can't get onto that page ... Maybe this will work?
Edit: yes, that works and it confirms the problem jaslake is reporting.
In my UserCP, the Joke thread shows arlu1201 as the last poster at
"Today, 08:02 PM " NZ time. Opening the thread, there is a later post by pike.
The "What's new" view also does not show the actual poster and date/time stamp of the latest post.
So, now we cannot trust these views anymore? Now the core functionality of alerting us to new posts in subscribed threads is broken, too?
Last edited by teylyn; 01-30-2012 at 07:27 AM.
Duplicate posts are still happening. See
http://www.excelforum.com/excel-prog...05#post2694805
I don't really see how the move to a new server with more RAM has changed what's fundamentally wrong with this forum. Ok, I did not have any time-outs or database errors, but I still don't see the functionality we had before the upgrade.
Call this a complete failure.
I did actually manage to submit a post without a database error, page freeze, duplicate post or it vanishing altogether so I'm guessing something has worked. I have noticed problems as mentioned with the last poster not showing correctly and don't know if the other errors that have been coming up have been fixed.
Vai - is there any chance of that list of resolved and outstanding issues that you have promised????
Dom
@ Vai
I have to assume your scrambling around like a chicken with it's head cut off (ever see that...my Grandfather used to raise them for his 12 Grandchildren back in the mid 40's until the mid 50's...we all lived in the same 3 bedroom home on Spring Avenue), fascinating stuff.
Communication is your best tool. I believe you'll be well served using it. Perhaps you're having issues posting as we are???
Please keep us informed!
I have repeatedly asked for a forum to list/manage/report/update issues, instead of spreading them across a dozen threads in three different forums.
But, hey, I'm just a moderator, so who would listen to me?
Just a note and i have mentioned this about 5 or 6 times, but i'm either NOT getting notifications or they're very sporadic, look how many posts in here that have taken place since my last post and i've not had a notification!
Whatever benefit the new server has brought load speed isn't one of them. It's taken 3-4 minutes to get to this point from clicking in Chrome to load the homepage up.
Dom
And 5 more minutes to register that post.
Dom
it's working very slow, and to post a reply I need to try for several times, the wheel is roating and rotating and finally I rcv an error
"The following errors occurred with your submission
This forum requires that you wait 30 seconds between posts. Please try again in 24 seconds."
if I refresh the page teh replay is there!!!!
I with Dom and John on this s l o w issue. Painfully slow.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I thought doubling RAM was supposed to make things faster, not slow it down to a damned crawl!
This is really eating at me now!!!!!
Is it just me or is this forum is pretty screwed up in term of functionality. Quick post is not quick anymore.
Hope they don't speed this site up anymore
I've just tried getting on here for the last 10 minutes and keep getting this
header('HTTP/1.1 503 Service Temporarily Unavailable'); header('Status: 503 Service Temporarily Unavailable'); header('Retry-After: 17200'); // in seconds print "TEST123"; Retry after 17200 seconds???? (286.5 minutes?)
Hope they don't speed this site up anymore
I've just tried getting on here for the last 10 minutes and keep getting this
header('HTTP/1.1 503 Service Temporarily Unavailable'); header('Status: 503 Service Temporarily Unavailable'); header('Retry-After: 17200'); // in seconds print "TEST123"; Retry after 17200 seconds???? (286.5 minutes?)
And now this This forum requires that you wait 30 seconds between posts. Please try again in 26 seconds. when i hadn't previously posted. wtf????
And then bumped out?
Need some help Vai?
And then bumped out?
Need some help Vai?
Time for posting warning again!
Is there an echo in here?
The popularity of this froum,
Going...
Going...
Going...
Going...
Going...
Going...
Gone!!!
hi,
what kind of day we have ...today?! the beginning is a good one!
JapanDAve...
here...
here...
here...
here...
By the way that post was instant....
John, I hope so, b/c this is such a great site, so much knowledge here and I own a lot to those who have helped me in the past. I would hate to see some of those people go else where.![]()
So far the forum is fine, just some sporadic errors. I guess there was some server prob last nite....but seems like everything is fine now....
only problem 10% of the errors close the forum for 90% of the time
I also get the Server Error in trying to up;oad a file (170 KB) excel forum.jpg
Perhaps we have different definitions of "working fine". No site with recurring errors is fine to my mind.
Is there any order in these times ?
![]()
Last edited by snb; 01-31-2012 at 04:33 AM.
I am seeing an order. Maybe try refreshing the page. See my screeshot below -
Fortunately I have a German great grand parent and my German gene tells me that this is not "working fine" . Working fine is 99.99%
@snb,
Those times are in order (though 12:44am should be displayed as 00:44 in my opinion).
@onerrorthough 12:44am should be displayed as 00:44 in my opinion
That's exactly the point why in the present representation 09.12 is 'later' then 12.44 AM.
So my it's about a wrong representation.
Someseem to forget we live in different timezones..
![]()
Well 12.44am has to be before 9.12 because it is not 12.44pm
At any rate that too is cosmetic - I will be happy if they rectify the db errors first!
incorrect replies number
it seems that the last reply is from Peter, but it's not truth! I responded yesterday at 0132.
Upgrading this forum has been like peeling an onion.
Vai's helpers strip of one layer after the other but the result only makes me cry.
Alf
As you can see in the header today, we have posted this msg - We had a few hours downtime on the site yesterday because of a corrupted table and we were required to repair the tables. Sorry for the inconvenience caused.
So far the server load has been normal and no dbase errors reported in the past 3-4 hrs.
We have fixed the post count issue as well, so you should not be seeing that again.
A separate forum for issues is on the way. Feel free to report any bugs and we will solve it for you.
For what it's worth. I just tried to upload a 156 KB xlsm file and no go. Error message "Internal Server Error"
Alf
Some are punished by God immediately, others have to wait until the upgrade!
I got the same error even with a.xls.
I received a PM with someone having same problem.
We started off pretty promising this morning... but now we are back to a deadly crawl in forum response time.....![]()
Testing upload of .xls and .xlsm.....seems like it went through...no error this time...
@Arlu 1201
Please read the title of this thread and act accordingly...
There's a special subforum for 'testers' of the 'technichal team'.
Please do your testing over there.
@SNB, i wasnt just testing for my sake. It was just to assist others to know that it works and save them the trouble of testing it again.....
@arlu1201
I'd been trying to upload a file for most of the morning. Thanks for the "heads up".i wasnt just testing for my sake. It was just to assist others to know that it works and save them the trouble of testing it again.....
Please read what I wrote carefully (if necessary twice or more) before you post a reaction.
While we're creating new sub forums can we get rid of some of the, frankly useless, other ones?
Dom
Still no email notifications coming through???????????
Vai, i've been recieving emails from this forum for the last 8 years, i have changed nothing, it's the forum that has changed and now i don't get notifications, i have checked my settings here and i am subscribed to the forums i always was, my subscription is set to automatic....etc, in short nothing different than it ever has been, the only thing that has changed is the forum software and the server!
I'm glad you finally replied to me reporting this
You can of course use the maintainance tools in vbulletin>admincp>maintainance>diagnostics and test email sending to a @msn.com addresss and see if it arrives, infact send the test to me, notify me on skype and i'll check after you have sent it!, could be a server sending issue.
Last edited by Simon Lloyd; 02-01-2012 at 11:32 AM.
I have created a new sub-forum for issues - http://www.excelforum.com/suggestions-for-improvement/
If any of the issues posted in this entire thread still persist, please feel free to post them to the new sub-forum as a new thread.
Please create 1 thread per issue. To standardize it, kindly use Issue if you are reporting an issue or Improvement for any suggestion for improvement.
Am closing this thread.
Appreciate your co-operation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks