Hello,
the forum software has been upgraded to vBulletin 4.1.8. In the course of that upgrade, some customisations of the forum have been reset to default and need to be re-applied manually. Please use this thread to list functionality that has been dropped.
Making a start:
Excel version no longer showing in user info on top right of post
search only finds posts since upgrade
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
When viewing a thread the forum rules link has moved to the quick navigation drop down. Not an issue as such, more an observation.
Dom
"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'd like to see the old "Child of....." Skin available.
...also "Quick Links" - should always be available - If you use "New posts" it isn't there......
Audere est facere
Hi,
when trying excel programming threads this page is displayed
"Invalid Forum specified. If you followed a valid link, please notify the administrator".
john
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-
The icon for Excel attachments is broken. The linked image http://www.excelforum.com/images/attach/xls.gif does not seem to exist. This happened before the upgrade, too, at least in the "child of ..." skin.
Same icons for WATER COLLER and other posts?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Where are my recent posts?
Used IE7 sometimes receive error:
Fatal error: Call to undefined function prepare_blog_category_permissions() in /home/eforum/public_html/includes/blog_init.php on line 32
Still getting the Database Error when trying to connect... And also really need access to the old posts and started threads. It would be a big blow to the site if these were lost.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
hi abousetta,
I can not manage with this "new skin" at all!
it seems to be mixed...
I know what you mean John. It's really difficult to work with compared to the last version and I'm entirely sure what the new features are. I just want my old posts
it's easier to have an icon/button "old version" and "new version" as yahoo mail has!
well, it's really difficult to navigate through.
an experiment...
do we need videos here?????
Last edited by vlady; 12-05-2011 at 03:14 AM.
According to Twitter the old (new) skin will be back soon I think.
Dom
Domski,
very good news!
I would like to post an issue. I recieved an infraction in this thread ,I was told I ignored a moderators request. Well, I posted my reply about 5mins after the OP replied and keep getting "Database error" and "please wait while you are being connected", so I left it at that went back to work and what do you know I finally able to get back online I have an infraction. I am trying to give back to this forum after all the help I received here and I get this, am I too penalized b/c of this site database failure?
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
Hey JapanDave,
It has happened to all of us. I know exactly what you did, having done it many times. If I post after a moderator has told to read the rules, I immediately edit my post and either delete it or add comments to tell the poster to follow the rules.
We love to have you help and learn but timing does happen. Don't get too mad at negative rep. We all have some. It will go away after a while.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I post this formula in a question
=FIXED(2.999)&"-"&FIXED(4.354)
when I copy and paste it it looks like this
1. =FIXED(2.999)&"-"&FIXED(4.354)
why's that?
Domski,
very good news!
When I can find in this new version the list of users who gave me the so call reputation? In previous version it was in CPU icon.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
@tom1977
Only way I can find at the moment is to right click on Notifications at the top and select Open or Open In New Tab and it takes you to that screen.
Dom
It's also under settings at the top of the page
Thanks a lot
I'm getting a lot of DB errors
Hey Spax, can you explain or copy the error over here? So we can understand what error you are getting?
The image below is representative of the screen I've been getting, this is an example from Google as I've not printscreened the error. It's a forum Database issue that usually throws these errors up :s
See also problem here with attached workbook which doesn't seem to exist
http://www.excelforum.com/showthread...=1#post2657334
I'm seeing the 'Page not found' message
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I always just used the "Go Advanced" version of the reply, which I could get to by clicking "Post Reply" at the bottom of a thread. Now that button just goes to the Quick Reply box, and I need to click the "Go Advanced" down there. Not really an issue, it just confused me for a bit. As a side note, I had to turn off the new way to do attachments. I can understand the idea behind it, but its not something I would use.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
JapanDave's Infractions aren't showing up!
I also miss the User Control Panel view... They had a nice breakdown of all of the rep I wasn't gaining per post and such. (Disregard this... it is under "Settings" now.)
I don't know when the new forums went live, but this is the first I've been able to connect all day due to database and Line 32 errors.
Also... what's this auto-save that keeps flashing?
Last edited by Miraun; 12-05-2011 at 04:33 PM.
Going for Guru! Click the Star to the bottom left of this post if I helped!
Good News Everyone: The Blogs appear to be working... We can now Blog about our excel experiences.... But could I get some validation that the world can see my written word in Blog form over on the blogs tab?
Not sure if anyone mentioned this yet, but I can't see any of the Quick Reply buttons (such as Link, Email, Italic, etc.) when using Skylight skin.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Aye, quick reply button images are all missing in Chrome using Skylight.
Dom
It worked fine for me... using Firefox 6.0
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.
OK, perhaps it's the browser....I'm using Google Chrome, it's not just formulas, when I cut and paste your comment I get the same thingOriginally Posted by NBVC
1. It worked fine for me... using Firefox 6.0
I am really not getting used to this new forum style... I have had no real ambition to post much!
I guess we'll get used to it......but I agree with you - I'm finding it difficult to read (in either skin).
It was same with previous skin... I think this is better... Just need some time to adopt...
Never use Merged Cells in Excel
Is there and where the information which version of excel user use?
everyone should probably clear cache/cookies and stuff.
@ dlllook the same to me unless its the 1. that's not supposed to be thereI post this formula in a question
=FIXED(2.999)&"-"&FIXED(4.354)
when I copy and paste it it looks like this
1. =FIXED(2.999)&"-"&FIXED(4.354)
why's that?
I dunno if people actually read my signature, but signature sizes for members appear to have been altered from the user defined values of the previous forum version. I think I only had about 50 characters before. Now I have a nice, flowing 500 character limit. This means I can finally put in the scales icon!
Ohh wait, it's a little star now...
@daddylonglegs , I am getting the same thing as you and I use Chrome.
I also can't get through to this web page by using [www.excelforum.com]
I have to use [www.excelforum.com/index/php]
Cleared cache in Chrome and still no quick reply buttons.
Edit they're also missing in the advanced window.
Dom
Last edited by Domski; 12-05-2011 at 06:34 PM.
Is there any chance to change it to old form...?
I have noticed that a lot of the regular posters are no longer posting... This message is directed to the owner/admin of the site
Danger!!!
Danger!!!
Warning!!!
Warning!!!
We need a working site... the bells and whistles don't do much if we can't even navigate the site correctly. Many of the links are not working, old posts are not available, etc. etc. etc.
abousetta
hi abouseta,
yes, it's true!
if you want to see your old posts you should go to yr profile and then "find latest posts" (if you are lucky!). well, it's not my case ))...but anyway, it's annoying.
and what is that "auto-saved"?
Canned replies don't seem to be working when giving an infraction
i cant find earlier posts ...........i went to my profile and did latest post but it does not show my earlier posts..............any ideas?
There are so many things... that I don't even know if this one was mentioned... but I don't see any notification of percentage of Inbox taken. I was told in another forum that my inbox was full, otherwise I wouldn't know unless I checked my email.. which I shouldn't have to, I don't think.
More DB errors, got a screenie this time please see attached;
I'm not thrilled by this silverlight view
In the skylight no reputation at all....
Agreed, it feels very cluttered; that's more of an aesthetic complaint than functionality.
No, before the content of the post was only being shown hovering over the link, but now it's 1 mess of indiscriminately cluttered text. Readability is functionality.Agreed, it feels very cluttered; that's more of an aesthetic complaint than functionality.
Besides, most of the screen is now being occupied by useless information.
Post contents hovers satisfactorily on FF8
Seems a shame this upgrade wasn't tested properly in advance. Doesn't help confidence any.
Dom
Hey, Dom! You win the understatement of the year award, 2011
welchs,
(you must have good eyes) try: bottom right-> archive ->excel programming...and go to last page
http://www.excelforum.com/archive/index.php/f-7.html
John55, not sure what your asking me to do. i followed the link.........but it doesnt list just my posts.....it lists everyone's post.......i think. this is NOT what i was hoping for. Is there a way, like in the past, that i can search for the posts that i have created?
Can anyone on this site answer this question?
I don't know if it's already been mentioned but the currently active user list (at the bottom of the forum's index page) does not wrap when the window is narrowed. In IE8, at least.
Not available: http://www.excelforum.com/images/attach/xlsm.gif
Last edited by snb; 12-06-2011 at 01:08 PM.
I usually use Advanced Search and search on Posts by my user name to keep track of replies and such but I'm getting "no matches found" Am I doing something wrong?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It works if you go in the Search Single Content Type tab to do the search
I wonder if anyone actually monitors this thread and is making updates to the forum based on the bugs that were are identifying... or it is just a place for us b**** about the endless problems with the upgrade. I haven't seen any real progress on resolving the problems. Maybe it would be best to go back to old version that was working until all (or at least the major bugs) in this version are hammered out (not debuggeed... hammered).
A very frustrated abousetta
@arthurbr
I fear you didn't look at the picture I added in post #50
I am talking about the non default forum 'skylight' skin
Last edited by snb; 12-06-2011 at 05:03 PM.
for once i'd like to be serious!!!!!!!! could someone moderate this thread or just start another one where all the issues are collated?
ok banter about stuff is fine but if i was trying to resolve this i'd probably disregard most posts as chat and hence miss the real issues
I agree with Martin that there should be some civilized way to communicate with the web developers the problems we have identified and at the same time they can update us on the progess they are making in resolving these issues. A simple table with two columns would suffice: Column A: identified issue; Column B: status of resolving it. This would at least demonstrate that there is a 'real' effort to move forward because from where I am standing, I don't see any improvements on the identified issues.
Thanks for collating the issues faced. We are monitoring this thread and we have noted each and every grievance given here. The team is working on it and by all means will get all the issues resolved.
Please tell me do you have problems with forum (all the time errors occur) or only I have?
Yes, you really are the only one...
Can somebody please tell me what 'Multi-Quote this message' Attachment 131725means ?
If you use 'Reply with Quote' the icons in the edit box will magically become visible.
the old attachments are not available at all, are they?
Hi snb
Thx for replies
I have asked because all day yesterday I was not able to open website with forum but in the evening at home I had any problems (it was worked ok). And unfortunately today in the morning (at work) problems started again… so..
So I am waiting patiently…. Good lack
welchs101,
- On the top right of the page, click on "My Profile"
- Click on tab "About Me"
- Click on link "Find all threads started by username"
Screenshot attached to show placement of links.
Hi tigeravatar
I try to do this, but what i get back, is: Sorry no matces...
Any advice?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
see the first post in this page, NBVC said
"It works if you go in the Search Single Content Type tab to do the search "
Hi John
It"s works for me now.
Thank you
Regards
I do wonder where my uploaded files went. Obviously I do something wrong or?
Is there a “manual” somewhere on how to do things under the new system?
Yes it’s frustrating, this could be a good time for me to join another forum and stay there for some months while things get sorted out in the “Excel help forum”.
I do wonder what was wrong with the old system (asides from it being old). As a user I never had any problem.
Alf
Alf's is the most telling question I've seen and one to which I'd like to see a response.
Vai, it's an old canard, but no less true for that: if it ain't broke don't fix it.
Why did you feel the need to upgrade (sic) the system at all when I suspect 99% of your users would have been quite happy with the status quo had you bothered to ask them?
I can only assume it was essentially a financial decision of yours but did you factor in the potential downside costs (like user drift through disatisfaction)?
Regards
Hello Alf,
I feel your pain. The changes were made by the owner without testing and without consulting with the community. Again. We are all struggling to find our way around, currently, moderators included.
cheers,
Hi teylyn,
Thanks for feedback and sympathy! If I feel frustrated I guess a moderator must be so much more upset on account of all the time and effort they do spend in this forum. Perhaps now is the time to sample the Yuletide glogg? At a bucket at a time!
A merry Christmas and a happy (working) database to you.
Alf
A quick update - the technical team is working on restoring some backend tables that have crashed. Should be up and running by end of day today. Also, the skylight skin will be functional within the next 2 days. The team is working hard to ensure its done at the earliest.
Vai, i can't view any attachments either, clicking them just gives me an invalid link message!, also shouldn't this thread http://www.excelforum.com/showthread.php?t=804519 be merged with this as they are both about the same topic
Not all forums are the same - seek and you shall find
Simon, The technical team is working on resolving the attachment issue. The table has got corrupted and they are rigorously working on reviving it.Vai, i can't view any attachments either, clicking them just gives me an invalid link message!, also shouldn't this thread http://www.excelforum.com/showthread.php?t=804519 be merged with this as they are both about the same topic
Alf, The uploaded files should start showing up soon. The table with the attachments has been corrupted and we are loading that table from the backup of the site.
Most of the bugs / issues have been resolved, the main issue which still remains is the attachments being displayed and advanced search function not working properly which we are working on and we will make sure that its corrected ASAP.
Look at the formatting on Post #7 of this Thread http://www.excelforum.com/the-water-...-workbook.html
I've been surfing the Forum today and find MANY Threads that indicate file attached but there is no attachment to be found. Others indicate an attachment such as Attachment 131792 but it won't open (invalid file extension or file corrupted)
Attachements are missing from my older (prior to upgrade) subscribed Threads.
Last edited by jaslake; 12-10-2011 at 07:20 PM.
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.
Normally you can download the table in any format you like then then via ssh search the database for attachment.TMD and delete it, then re-upload you should then be able to optimise it
Last edited by Simon Lloyd; 12-09-2011 at 03:10 AM.
Is it possible to add shortcut link to posts where I (we) write?
So I can access without Advance Search -> my name...
Can someone tell me is my idea foolish so I can drop it and stop pushing it
Beside the thing that Forum Search doesn't work when searching by exact name (trying for my own) I think it would be really nice (and I guess very easy to add), next to New Posts also a My Posts button.
It would be usefull for:
- New members to easier find their topics (and in some cases stop opening duplicated threads)
- Old members to check all unanswered posts from last few days
Now I find very difficult to see is there some more questions in the posts I've answered...
Also getting 2 or 3 emails for every notification, zbor's post above sent me 3 notifications all exactly the same and times exactly the same!
I notice all the attachments that existed prior to the upgrade have disappeared.
Also, this may be a silly question, but how do I get an attachment to display like in this thread, post#2?
http://www.excelforum.com/showthread.php?t=804582
With the pretty picture, views details etc.
In terms of bugs:
If you only use the attachment option at the bottom of the advanced editor and use insert inline, it will display the attachment as a link, but clicking it will result in an error.
If you upload it using the above method but don't insert inline, but use the attachment manager in the main toolbar at the top of the ediot (which uses attachconfig instead of attach), the link works.
Thread icons - opened/unopened envelopes appear mixed up.
i.e. An unopened envelope displays next to a thread that has already been opened (and vice-versa).
Using Firefox 8.0
- Edit - - - - - - - - - -
This error seems to be inconsistent, but I have noticed it on two separate computers (as well as IE & Firefox).
Last edited by ConneXionLost; 12-09-2011 at 03:05 AM.
Viewing the page that houses all the forums there is a 5 page scroll needed to get to see the who's online!
The issue with the scroll for 5 pages is a malformed html tag AND you have TWO wgo_birthday divs, so you are trying to display whats going on and birthdays twice!
I don't know who your "technical team" is Vai but you should fire them, these are schoolboy errors!
Nothing.. Just sending notifications to Lloyd
Simon, looks like the technical expertise of the "team" tasked with running this forum into the ground matches the management expertise of their boss.
Hmmm, you sound disgruntled teylyn, personally i think the solution would be to create a brand new test site, import ALL of the database as it stands, check for bugs (although it should pretty much work "out of the box") and then simply export the working style from the test site to this, the style contains ALL the css and template edits - job done!
Surely it's standard practise to fully test a system upgrade in a dev version and fix all the bugs before rolling it out live or is that just where I work
Dom
Vai, as an added, the postbit would look neater if the user info on the top right of each post was <smallfont> and not bold, this way it should all line up better.
Finding markup errors in this web site using W3C Markup Validator.
@abousetta
These two issues are EXTREMELY importantI'm an old guy...I don't remember from yesterday. In the past, I could go to the Forum to see how I resolved issues...can't do that today...YET...hopefully that'll be restored.(the old attachments and the search
I'm still getting hugeeeee blank spaces before getting to view the WOL...etc
Vai, this is because your team do not know what they are doing, they've made a schoolboy error when editing the html for the templates, that's why you see two footer statements
See th attached (if you can!)
@CXL, vBulletin has always shown markup errors unfortunately, it's the way templates are called and loaded in to each other, if you could take the seperate templates and vaildate them you will find there are very very few errors, some of the errors you see there have to be taken with a pinch of salt as quick closing tags i.e <img src="thispic.png" /> so the quick close is /> because it really should look like this <img src="thispic.png"></img> but the quick close is perfectly legal and we ll used, tahts just an example but there will be loads of them
@Simon, thanks for the info!
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
received this error just now.
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/eforum/public_html/includes/class_core.php(4596) : eval()'d code on line 1
That looks like a template edit gone wrong or some php has a rogue ' or a missing one
Hello jaslake
Click on the link but "Page not found".
I get this also from other posts.
Im afraid thats because the actual posted link is wrong, how you see it there with the ... in between is how the link actually is, so either it was posted wrong or the forum is shortening links wrongly.
I can still see the error above.
This happens when I click a visitor on my main profile. But just some.
Try it.
Smaller size for (INSERT IMAGE / Movies) like youtube -------as in a thumbnail view first....
Most bulletin software I'm familiar with contains the user option to choose how dates are being shown: ISO (dd-mm-yyyy) or USA (mm-dd-yyyy).
I very much like to view all dates in ISO-format.
The current forum is an inconsistent mix of both (dates posts are being delivered: mm-dd-yyyy; join date of members: dd mmm yyyy).
Dear ExcelForum,
I have beed trying to serach for my old threads but in vain..
From the time the Forum has been re-designed, i have been unable to view my old exisiting threads..
CAn someone please help me on this as I was trying to search for something on which I have been already received help..
I presume that this is already been worked upon but can someone please confirm the same..
Warm Regards
e4excel
Hi Simon Lloyd
That's nice stuff...don't want to work that hard...Forum Tools did that "stuff" before...would like it back. Perhaps I screwed up.
I'm getting double notifications again!!
Looking at this old thread I do get strange results when I try to download the added files. The original OP file seems to be replaced with something else.
The file I uploaded is replaced by another file i.e. not mine and my last upload in this thread has disappeared.
http://www.excelforum.com/excel-gene...html?p=2658843
Doing a search for "Solver" in the forum I get only 5 results, before the upgrade I used to get more than 20 pages with threads containing the key word "Solver"
Anybody knows what is going on? Will things get fixed or is the past gone and we start from scratch?
Alf
@Alf,
I suspect what you're experiencing is the result of the database corruption (the attachment table was damaged) and subsequent repair. Whether these current conditions will continue, or further "repair" is forthcoming, is yet to be seen.
Stay tuned!
Still no word on fixing the biggest two problems with the upgrade (the old attachments and the search). Are these on top of the list for fixing (e.g. more important than the font on the User Control Panel or making snowflakes appear across the screen on Christmas Day)... There is a wealth of knowledge (and attachemnts lost until now (and I need them back).
abousetta
I get the blank space, I also getting an annoying list view that resolves into the Forum view.
I've also reported that either the New Posts feature isn't working or else post numbers are falling rapidly.
Vai get someone who can do a proper job before the Forum is a memory
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hey Abousetta, The technical team is working on both these issues - Attachments from yrs 2005 n 2006 have been recovered. The rest is in progress.
Regarding the search option, the team is working on that as well.
Yes Jaslake.
This has been resolved Simon. Please check it again at your end in IE.
Roy, the post numbers are fine. As i posted in the mods forum too, here are the statistics since 28th Nov -
Date Thread Post
November*28,*2011 167 839
November*29,*2011 188 940
November*30,*2011 193 932
December*01,*2011 185 885
December*02,*2011 167 825
December*03,*2011 46 231
December*04,*2011 36 159
December*05,*2011 108 485
December*06,*2011 155 772
December*07,*2011 98 421
December*08,*2011 197 789
December*09,*2011 180 704
December*10,*2011 86 378
December*11,*2011 59 432
December*12,*2011 169 754
December*13,*2011 188 874
A more detailed update coming soon.
Yes Vai, thats fixed, as i said just basic html!
The newpost and or counts and scheduled tasks may not happen because your "technical team" have edited out an important part of the footer!!!
I really shouldn't be fault finding for you as your "team" are being paid not to cause these issues but i can't stand by and watch this forum get destroyed systematically!
I concur, Simon.
Thanks for your good work
+1
.
.
.
.
.
Formatting in Code appears to not work. When I post an update to code that involves only a single line or so I'll usually BOLD and UNDERLINE that line of code so as to not have to post a new attachment or post the entire code. This no longer appears to work since the upgrade. See post #18 of this Thread http://www.excelforum.com/excel-prog...ell-value.html
Simon, can you please explain further. Considering your experience with forums, your thoughts will surely expedite the solution.The newpost and or counts and scheduled tasks may not happen because your "technical team" have edited out an important part of the footer!!!
Vai, you have a technical team dealing with this so it shouldn't be too difficult, if you want to hire me feel free to offer your tender for my services. I have given direct pointers on what has been wrong with this upgrade and via other means, i have even commented in a thread of yours answering you directly.
One thing you need to remember about the vbulletin software is that it works straight out of the box, the database didn't need transporting or changing (other than any "extra" coulmns the software creates) and with hardly any other setting changes would have worked for everyone, so, if you want my free advice:If you do want the current style issues looking at by me then pm me
- export problematic tables, delete any .TMD tables that may exist for them via ssh, re-import each one by one and optomise
- upload with overwrite brand new vbulletin core files via ftp with the exception of install/install.php and images if you want to keep the current images
- create a brand new style with no parent, this will give you default vbulletin templates, set NOT to be available for selection by users
- prove default works as needed
- edit one template at a time to get functionality required always remembering to check the "history" checkbox so you can go back through any changes
- copy proven edited template to current style template of the same name, ask your members to give it the thumbs up because you HAVE already proven it works
- do the same for the rest that need editing (not many need editing at all, except the stylevars (css files))
- any edits you are unsure about, rather than let your technical team hack about in stuff they clearly aren't competent to do ask someone who knows!
Links to attachments on some threads point to the wrong file. For one example see my last post in this thread
http://www.excelforum.com/excel-gene...ent-month.html
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hi Paul
It's been a while...appreciate your input...you were one of my original mentors (my words) on the Forum.
In the instance of this Thread I didn't enter the codes for Bold or Underline manually...I used the Icons...Underline didn't take.
Thank you for thisGreat stuff...keep up the good communication.Wouldn't it be nice if SOME kind of message was received that the Forum will be down for (insert here what ever is your best estimate)...
Hi e4excel,
I have found that you can do a Google search (e.g. threads started by e4excel) you might be able to find the thread. The attachments are more likely not be there yet because we have been told that they are still being re-linked to the posts.
Hope this helps.
abousetta
Hey 6SJ, The technical team is working on recovering the attachments. As of yesterday, they had completed upto year 2006. Till now, they have completed 2008 (it takes time considering the huge volume of attachments we have). You should get the correct attachments in your posts shortly.
Actually, we will get the negative rep reversed for JapanDave because he got penalized when it was not his fault.
Just as Abousetta said, the team will be working on re-indexing the pre-upgrade posts this saturday evening (when the load on the server is less) and you should be able to view all your old threads and posts after that.
Hi teylyn
Did that (I believe...perhaps not). I'll try again the next time. Seemed to work pretty well...before the "Upgrade". Perhaps I pushed the wrong buttons.
The template for attaching files is all but user-friendly, to say the least
In your general settings you can choose either to use the new 'up'graded attachment window or the old one.
So...what's going on...give me a clue. Could not log on to the Forum all day today. Logging on yesterday was hit and miss. Wouldn't it be nice if SOME kind of message was received that the Forum will be down for (insert here what ever is your best estimate)...or...did we simply CRASH.
Thanks for that find, snb.
Step by step (using the Skylight skin)
- Click "Settings" in the upper right top nav. This will get you to what you may remember as your User Control Panel (User CP)
- In the right hand panels, track down "My Settings > My Account > General Settings" and click "General Settings"
- Scroll all the way down
- in the section for "Enhanced Attachment Uploading" select "Enhanced Attachment Uploading off"
- click "Save Changes"
- From then on, the "manage attachments" dialog will look like it used to before the upgrade.
cheers,
Wow...must be me...have I been shut down?
Simon, I wish you hadn't been booted out!
Anyone interested in a Q&A forum that discusses MS Office products, VBA to die for, and has a great user interface? PM me.
Have to defend Vai there a little teylyn, i wasn't booted we had a disagreement and i felt i could no longer admin under the particular terms.
How can we rectify this?
Explorer could not connect to the domain or some such thing. Had no issues with other sites I visited. The same happened during the weekend the Forum did the "Upgrade" so I assumed the powers that be were installing "fixes" for identified issues...apparently not...
As far as PMing Vai...I'd be happy to do that except, when it happens, I can't get on the Forum.
@NBVC, unfortunately it isn't something that could or would be resolved to me being Admin here again, you have Roy, excellent admin (for his limited scope given to him) and i've always found him to be a level and just fellow (which i why i chose him and a lot of you
Hi John,
In IE9 it seems to be working. The bold is a bit tough to see, but there. The underline tags you had weren't surrounding the line of code, only before it.
e.g.
[U][/U][B]your code[/B]
You can always format inside the code (IE7 tested) like this
[code][FONT=Arial]With ActiveSheet.ListObjects("Rewatching").DataBodyRange.Resize(ColumnSize:=1)
.Sort Key1:=.Cells(1, 1), Order1:=xlAscending, Header:=xlGuess, _
MatchCase:=False, Orientation:=xlTopToBottom
End With
With [FONT=Arial Black][B]ActiveSheet.ListObjects[/B][/FONT]("Rewatched").[COLOR="#0000CD"]DataBodyRange.Resize(ColumnSize:=1)[/COLOR] .Sort Key1:=.Cells(1, 1), Order1:=xlAscending, Header:=xlGuess, _
MatchCase:=False, Orientation:=xlTopToBottom
End With[/FONT][/CODE]
Result:
With ActiveSheet.ListObjects("Rewatching").DataBodyRange.Resize(ColumnSize:=1) .Sort Key1:=.Cells(1, 1), Order1:=xlAscending, Header:=xlGuess, _ MatchCase:=False, Orientation:=xlTopToBottom End With With ActiveSheet.ListObjects("Rewatched").DataBodyRange.Resize(ColumnSize:=1) .Sort Key1:=.Cells(1, 1), Order1:=xlAscending, Header:=xlGuess, _ MatchCase:=False, Orientation:=xlTopToBottom End With
That was my test in Chrome. Seems to work.you need to make sure that the text is selected before you click the icons.
I haven't had any problems logging in today or yesterday.
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---
LoL, I doubt it but hopefully Vai looks at this thread and sees your problem. Perhaps you should send him a message if this persists.
Hey Jaslake,
I too didnt face any probs yesterday. I was logged in the entire time. Were you receiving any error msg?
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]
I had a friend request that I have tried to deny but am unable to do so. The notification is still there and the friend request will not go away.
Fine, I'll stop sending you friend requests. My feelings aren't hurt.
(just kidding - i won't stop.)
LoL, well since I don't have you on my friends list I am going to send you because, well, my pointer/clicker is just heading that way now.
zbor, try the top nav drop-down "Quick Links > Subscribed Threads" or as a link for the URL: http://www.excelforum.com/subscription.php
If your user profile is set to automatically subscribe to threads that you post in, which is the default, I believe, then you will see all the threads you participated in or manually subscribed to.
Posted by zebor:
I for one found that quite usful but as zebor says it's not working anymore. Is this function going to be restored or is it gone forever?Beside the thing that Forum Search doesn't work when searching by exact name
Alf
There are serious errors on this Forum.
Attachments are extremely prone to failure and replies are not always being recognised on the "Todays' Posts" page. (Note the correct apostrophe position.)
It has also been running like a tractor with a sump full of chip fat and sawdust.
Default skin and IE9
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.
@ zbor
If you click on your handle in any reply you have made, there is a shortcut ("View Forum Posts") to your posts.
It was working the last time I tried.
Vai, any word on the issues we have noted. The thread that you created has not been updated for almost 2 weeks now. Attachments are still not back to normal nor is the search engine.
First All attachments have been restored please have a look and let us know if you still find any issue.
Secondly we are starting with the Reindex required to start the advance search option and most probably it will start by the evening.
Marcol, please don't post the same comment into three different threads. Vai is monitoring all three, so one post will suffice.
Thanks for the update Vai. I did a google search for some of my old posts and I did find attachments there now. If I find specific cases where the attachments are missing then I will let you know.
Attachment missing and the two shown are not the right one.First All attachments have been restored please have a look and let us know if you still find any issue
http://www.excelforum.com/excel-gene...html?p=2658843
Alf
I am no longer able to attach a file. About an hour ago and about 10 hours ago, attaching a sample .xlsm failed. I just got the spinning hourglass for about 3 minutes without completion.
Am I doing something wrong? Do I need some java script upgrade? Should I delete all my past attachments so I have more room?
It is a little discouraging to build some VBA answer and then not be able to attach it as an example.
Testing the search fuction this morning looking for solver threads I got this result:
Oh well, at least it did not complain about the font nor the font color.The following words are either very common, too long, or too short and were not included in your search:
solver
Alf
The standard search for vBulletin boards is less than satisfactory. You'll get much better results with a site specific Google search, like
solver site:excelforum.com
cheers,
Thanks teylyn
I've already started using Google but about a week ago I got at least 9 result doing the same i.e. searching for solver using the forum search so it has not improved over the week.
Why is downgrading the word that springs to my mind?
Alf
PS Your search string "solver site:excelforum" was superior to my way of seaching. Now I just need to get Google to sort the results according to date. Any hints?
Last edited by Alf; 12-28-2011 at 05:52 AM.
Google search offers advanced search and you can also click "More Search Tools" in the left hand nav to narrow down search results by time frame.
The Google interface changes constantly, with even less documentation than we get on this site (but at least it works). A Google search shows that there may have been tools to sort results by date in the past, but currently these options don't present in my interface. But then again, Google is known to serve different interfaces to different countries, so my current NZ experience may differ from what you see on your screen.
cheers,
Last edited by teylyn; 12-28-2011 at 06:23 AM.
Thanks teylyn
Will set up Goole to sort by date as well.
Tsk, tsk and you a moderator!with even less documentation than we get on this site (but at least it works).
Regards
Alf
This thread seems to have a problem
Autocalculate Age from Identity Card Number
I tried to post a reply with an attachment - the preview looked fine, but when I submitted the reply there was a database error.
When I opened the thread again the text of the message appeared but no attachment.
I edited the post and added the attachment again and all seemed okay, however the post is not showing in "Today's Posts" ...
See these screen shots
Does anybody know: Is there a way to show 00-24 hrs time format instead of AM/PM?
Zbor, dont mind me asking...but i guess your question is in the wrong thread. It doesnt have any relevance to the subject of this thread.
Maybe I remember wrong how old skin looked like, but I think it was like first example. So I thought this as after the update. Again, I might be wrong.
@zbor
Several users asked to introduce like most forums have as a standard the option to choose the dateformat. This forum has the option to choose the first day of the week (that has barely any relevance in this forum).
@arlu
Have you joined the 'technical' team ?
@zbor the timings on posts should be different for every user according to their location. Is there a reason to not want am/pm as it's self explanatory to folk and less confusing to some than if they had to decipher the 24hr format if their not used to it, but in answer to your question - yes the format can be changed by admin and it's one change affects all.
can someone inform me why we need :
- similar threads (see the informative 'related' ? results)
- tags for this thread
- view tags cloud
- bookmarks
- contact us
- Excletip.com
- Archive
- forum ruls for the umpth time in a window in the subwindow 'posting permissions'
and why we can't
- minimize 'similar threads'
- minimize 'tags for this thread'
- minimize 'bookmarks'
Last edited by snb; 01-04-2012 at 06:40 PM.
Simon, the AM/PM is very confusing for me, even after 10 years in a country that uses it.
Vai: I'd like to see an option for members to select whether they want to see AM/PM or 24hr format. Just like I'd like to see an option for members to change the date format to their preference. Currently the forum forces AM/PM and MDY on everybody.
For me this is a constant irritation, because I always have to consciously think about the dates and times I see in order to work out what they mean. If it were presented in my preferred format, reading date and time would be as effortless as breathing.
Arlu, please note that zbor's comment is absolutely in the right thread.
As an added here's the setting that should be used in vbulletin software:
Expanded European Format (e.g., 25th April 1998): jS F Y
This way everyone will see a comprehensible date
For the 24hr clock the time format in the vbulletin software should be set like this:
24-Hour Format Time (eg, 23:15): H:i
Teylyn, can you check to see what date/time zone you have chosen in your usercp settings, if you have chosen your time zone you should see adjusted times...etc
@Simon
This is producing the correct time, but not the desired time formatcan you check to see what date/time zone you have chosen in your usercp settings, if you have chosen your time zone you should see adjusted times...etc
sorry snb that was aimed at Teylyn for the date format!
Simon, yes I've set the time zone correctly. As snb has said, this shows the correct date and the correct time, but not the format I would like to see it in.
Is that an individual user setting? If so, where can I go to set it?For the 24hr clock the time format in the vbulletin software should be set like this:
24-Hour Format Time (eg, 23:15): H:i
When submitting a post, more often than not the system will have a loooong think until it comes back with the refreshed screen. I use a multi tab browser, so I click on another tab instead of watching paint dry. But for the last few days, I get a message box come up with the question whether or not I want to leave the page and lose my edits. The cancel button takes me back to the page. I click submit again and the message comes back straight away, even though I have not clicked away from the page. If I click the button to leave the page, it takes forever to actually do something. In most cases, it will hang indefinitely.
Closing the tab and opening a new one for the forum, sometimes the posted comment is visible in the thread, at other times it isn't.
not impressed.
No, unfortunately it's a "one change affects all" scenario, this applies to the date and time, i simply provided the settings that Vai needs to change to facilitate this
Vai:
the view "Today's Posts" does not show the correct data. I've replied to a thread at 12:56 PM NZ time. If I now open the view "Today's posts", the latest post for that thread is shown as 12:25 PM NZ time and is by the OP. If I click to go to the latest post, I end up at that OP's post, but my own post shows clearly underneath that one in the thread.
In how many more ways can this forum be made unworkable?
For the past few days the forum has dropped to a crawl responding to my initial visit to pull up my User CP. I can click on the UserCP link and it takes anywhere from 1-4 minutes to appear. If I immediately start opening threads it seems to open OK for awhile, but if I pause for any length of time, the next click is the same 1-4 minute pause.
Anyone else experiencing this?
I checked other sites at the same time and they all respond instantly to all clicks.
_________________
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!)
How many hours was this 'upgrade' supposed to take?
Dom
Around =00:00 / 0:00AMHow many hours was this 'upgrade' supposed to take?
Dom
@ teylyn
I too have experienced thisI've taken to writing my posts in NotePad, saving NotePad, copy/paste NotePad to the Forum. Long way around, more than frustrating, but not NEARLY as frustrating as losing it all. Let's hope they can get this fixed...soon.I'v written a post, with lots of descriptions and a train of thought, clearly structured and addressing several issues in the OP's question.
@arthurbr
Things appear to be MUCH improved over the last several days. Not perfect (but we weren't perfect before). I'd encourage you to give it a try...see what you think.
I am facing with the same problem what JBeaucaire said. I've already post it...which thread? who knows...
As linked, there is an International Standard for displaying Dates and Times.
The international standard does not help. It only makes things worse. What is 2012-01-04 when you look at it quickly? April 1, or Jan 4 ?
Reading time and date should be effortless. It's only effortless if you don't have to think about it. Fact is that different countries have different conventions. Hence all the regional settings and stuff. So that people can use a format they are familiar with and won't have to think about it.
Seems that vBulletin only supports ONE date and ONE time format. It can be changed, but it will be the same for all users.
It's just a habit. Someone get use to DD-MM-YYYY (= me), someone get use to MM-DD-YYYY (<> me) but for a documentation I force myself to use: YYYY-MM-DD (because of sorting). I stil didn't get use to it, but even that is more readable (= me) than MM-DD-YYYY to which I didn't found any logic. But someone else did. So I think there should be an option to use date format as you like (and give you less confussion as possible, as you've told in rest of the post).
Oops my bad. It was late in the night for me and i might not have checked properly....sorry zbor.
Snb - i havent joined the technical team....
There is no country in the world that uses the date format of year-day-month. That's why the International Standard uses year-month-day; it is the least ambiguous approach.
This would be an ideal solution. I'd like that too, but if the forum can't provide these options...
then we'll have to agree on a "standard".Seems that vBulletin only supports ONE date and ONE time format. It can be changed, but it will be the same for all users.
Last edited by ConneXionLost; 01-05-2012 at 03:49 AM.
Vai, for the umpteenth time in a week now, I'v written a post, with lots of descriptions and a train of thought, clearly structured and addressing several issues in the OP's question.
I submit it and get a Database error. No way to get my text back. It's gone
I've just about had it.
Do something about the forum reliability. This is an insult to anybody who contributes here.
Your full-mouthed, big fonted announcements that everything is running smoothly now, that the bugs have been fixed now are worth NOTHING!
Your Alexa ratings are dropping dramatically. Can you see why?
Last edited by teylyn; 01-05-2012 at 04:38 AM.
I can only, sadly, confirm Teylyns opinions.
For who is interested in the date format issue:
It can be solved using:
for who is interested in PHP conventions look hereHTML Code:
Last edited by snb; 01-05-2012 at 05:01 AM.
@JB
In interest of full disclosure...the practice as described that I use has also been in place for some time...well before the upgrade.
I have just about had it. I too have written code for people only to get a database error and lose everything.
Why is such a simple process being screwed up so badly? I love this forum, or should I say its members, as they have helped me so much, but at the current rate I am inclined to go else where.
I hope I am not out of line, but please get someone who knows what they are doing to get the site functional.
Yup. If it can't be done, it can't be done. Just wanted to see if it's an option. If not, some of us will just need to adapt.
@Simon Lloyd...I'll be happy to accommodate as I can...been feeling quite punky for the last several days and, as a result, have not been terribly active on the Forum. Today the Doc gave me some good drugs...perhaps that'll help me get back in the saddle.
(wrote this directly, without NotePad)
@teylyn: I have sometimes found that by selecting the "back page" option, I can get back to the post where I have been typing. You can then copy the text and paste it into Notepad or Word or whatever. At least, if you want to try to help the OP again later, you have your origiunal thoughts and structure. Of course, the next problem is finding the post to which you were replying
Clearly not ideal, but ...
Regards, TMS
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
@TMShucks: It's much easier just to answer questions elsewhere until the problems are fixed (if that ever happens).
Who thought black was a good colour for the Rep and Report Post buttons?
How is it possible that so many things can be screwed up so badly?
Dom
Last edited by Domski; 01-05-2012 at 05:38 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks