Weird SQL errors and peformance issues this week

84 Posts | Latest reply on 26/05/2010 10:01:16 by Brummie Jackie | Go to original / last post
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

Please can you respond in this forum topic if you receive an error message when browsing the forums which looks something like this...    ADODB.Field error ?' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /sites/bm/forum/posts.asp, line 0   Please copy the exact error that you get INCLUDING THE ADDRESS OF THE PAGE (Thats the URL in your browser, just copy/paste it into your reply here)                                                                                                                                                                             
anneka56's Profile
anneka56

In: Stockport
Posts: 2525
0% Karma0% Karma 0% Karma0% Karma

bloody hell Matt  can we have that  in  pleb language or blonde  at least  LOL                                                                                                                                                                             
Deleted User's Profile
Deleted User

In: NA
Posts: 6852
0% Karma0% Karma 0% Karma0% Karma

Hey I resemble that Anne ... I understood.Embarrassed


Mind you I am engaged to 'that geek' LOL                                                                                                                                                                             
Sandi's Profile
Sandi

In: Huddersfield, W
Posts: 17948
92% Karma92% Karma 92% Karma92% Karma

  Anneka that's probably the first time I've understood what Matt has typed lol                                                                                                                                                                               
anneka56's Profile
anneka56

In: Stockport
Posts: 2525
0% Karma0% Karma 0% Karma0% Karma

gone right over my head>>>>>>>>>>>>>>whoooooooooosh                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

lol dont worry about what the error says or means, leave that for me to work out, just let me know when/if you get it and what the address of the page is.   Even better if you could let me know what you was doing at the time (changing pages, posting a message, etc)                                                                                                                                                                             
anneka56's Profile
anneka56

In: Stockport
Posts: 2525
0% Karma0% Karma 0% Karma0% Karma

Does that mean if  i recognise one and send it on to you  i have  an 'ology in  pc geekdom? ;)                                                                                                                                                                             
anneka56's Profile
anneka56

In: Stockport
Posts: 2525
0% Karma0% Karma 0% Karma0% Karma

all i can say  is don't hold your breath   LOL                                                                                                                                                                             
Sandi's Profile
Sandi

In: Huddersfield, W
Posts: 17948
92% Karma92% Karma 92% Karma92% Karma

Refresh                                                                                                                                                                             
6ypsy's Profile
6ypsy

In: Clay Cross
Posts: 430
10% Karma10% Karma 10% Karma10% Karma

Matt, have just got the following, of course I know exactly what it means but thought I'd post it in order to get your take on it Confused   Cheers   Microsoft OLE DB Provider for SQL Server error �' Timeout expired /sites/bm/forum/all_topics.asp, line 217                                                                                                                                                                             
Holmfirthgirl's Profile
Holmfirthgirl

In: Larkfield
Posts: 3156
0% Karma0% Karma 0% Karma0% Karma

Matt, I've also got the following - was in the events pictures for NABD, trying to go through them Microsoft OLE DB Provider for SQL Server error ?e14' Incorrect syntax near '='. /sites/bm/events/picframe.asp, line 71 I know it's not exactly what you said - but have sent you a PM via help about it aswell.                                                                                                                                                                              
RustyKnight's Profile
RustyKnight

In: Newton Aycliffe
Posts: 2462
0% Karma0% Karma 0% Karma0% Karma

Microsoft OLE DB Provider for SQL Server error �'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied./sites/bm/forum/posts.asp, line 379Had this twice tonight just opening threads Matt, won't let me change the colour unfortunately LOL

                                                                                                                                                                             
46Rossi's Profile
46Rossi

In: Bridlington
Posts: 697
33% Karma33% Karma 33% Karma33% Karma

I had one of these but forgot to copy the page addy too - sorry

Microsoft OLE DB Provider for SQL Server error �' Transaction (Process ID 64) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /sites/bm/forum/active_topics.asp, line 117
                                                                                                                                                                             
Sandi's Profile
Sandi

In: Huddersfield, W
Posts: 17948
92% Karma92% Karma 92% Karma92% Karma

  That's a SQL error Rossi, not a BOF or EOF.   I've just had the same error message, twice.                                                                                                                                                                               
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

dammit, i've really no idea what's going on.   Let me tweak some things                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

Ok I'm really changing lots of settings which I know have just caused a couple of errors, but I fixed it quickly.   I'll be restarting the services which will take the site down for 10 seconds or so in about 5 minutes                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

I've changed this forum topic, I'm interested in any errors you're getting right now with SQL issues.   Please only post performance comments if you also copy the text from the bottom of the page which says "Page generated in... x seconds.   There are y users online now".                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

some huge changes made just now and I'd like to know how it works out.   Please let me know, thanks                                                                                                                                                                             
bandit lover's Profile
bandit lover

In: Birmingham
Posts: 7765
0% Karma0% Karma 0% Karma0% Karma

I keep being 'blown out', no change there then!!!   Explorer keeps rejecting Biker Match? even though I am logged in?                                                                                                                                                                              
Matt's Profile
Matt

In: Veldhoven
Posts: 8054
100% Karma100% Karma 100% Karma100% Karma

that was just for a moment cos i had to restart the services, took about 30 seconds to restart.                                                                                                                                                                             


Remove these advertisements                  Advertise Here
Biker Match is a UK social, events and dating website by bikers, for bikers.  All British motorcyclists are welcome to join our large and exciting community free of charge in search of ride-outs, motorcycling events & rallies, biker dating & relationships, motorcycle help, motorcycle forums, biking news, racing news, motorcycle classifieds or just to get to know other UK bikers.  Create your profile and upload your photos now completely free.
Website copyright 2002-2024 www.bikermatch.co.uk.

Page generated in 0.7188 seconds. There are 366 users online now.

Site tested and secured by Comodo HackerGuardian       Site tested and approved by McAfee SiteAdvisor      Site PCI DSS security approved      Site tested and secured by Comodo HackerProof       Site secured and validated using highest 2048bit encryption