Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › Geekzone › Geekzone SQL errors
taniwha

961 posts

Ultimate Geek

Trusted

#4082 17-May-2005 13:41
Send private message

Typing a forum post, and my login session must have expired. After posting and then i'm presented with this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.

/forums.asp, line 88

Create new topic
freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14784 17-May-2005 13:51
Send private message

Thanks for notifying - yes, this is the line where we send out the e-mail notification... I will have to enclose this around an error trap. Shouldn't be a problem unless you have a session expired in the meantime, but I have added an auto-login feature - unless you don't have the automatic login checkbox set...




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 



freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14786 17-May-2005 13:53
Send private message

Fixed. Will test later today on my staging server and move into the live server tonight.




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

taniwha

961 posts

Ultimate Geek

Trusted

#14787 17-May-2005 13:55
Send private message

didn't realise (or rather think) that this would appear on your front page.. sorry freitasm
next time i'll send email.



freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14792 17-May-2005 18:43
Send private message

Hope you get the e-mail notification too... Did it work?




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

editor
2 posts

Wannabe Geek


#14793 17-May-2005 18:44

Just me again, with another username, to test the e-mail SQL...

Cheers

taniwha

961 posts

Ultimate Geek

Trusted

#14794 17-May-2005 19:09
Send private message

even though my session had expired, the post was still posted....

which brings up the question - how can you post without a valid session?


i'm sure you're all over this glitch already :-)

 
 
 
 

Want to support Geekzone and browse the site without the ads? Subscribe to Geekzone now (monthly, annual and lifetime options).
freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14795 17-May-2005 19:21
Send private message

Interesting enough checking for a session is the first thing done in the script... It seems that IIS closed the session between the INSERT and the SENDMAIL. Because these are in the same script of course it shouldn't be the case, and this is something I will be looking at.




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

taniwha

961 posts

Ultimate Geek

Trusted

#14814 18-May-2005 09:48
Send private message

i assumed it hadn't posted, so posted again, and again..

then i cloned the window (opera rules!) and logged in again, and started a new session (i presume)

then i went back to the window with sql errors, and submitted the post again, and found that the post appeared 4 times.

i deleted all but one.

taniwha

961 posts

Ultimate Geek

Trusted

#14819 18-May-2005 17:58
Send private message

happened again
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.

/forums.asp, line 121

freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14820 18-May-2005 18:08
Send private message

Fixed... Same thing, another routine using the same piece of logic. It should be ok now for everyone.

I think it's something on this IIS server though, closing session. Some interesting news though: got a phone call from my hosting, who wants to talk about moving Geekzone to another server. Apparently our traffic is impacting other domains on the same machine now. No surprise, we're talking about a few million pages a month here...

Will work with them on this during the week.




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

taniwha

961 posts

Ultimate Geek

Trusted

#14821 18-May-2005 18:16
Send private message

didn't seem to involve any expired sessions this time.. ie i didn't need to login again, and i still haven't.

Maybe you should start adding features for subscribers only?
or collecting donations?

 
 
 
 

Shop now for Lego sets and other gifts (affiliate link).
freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14822 18-May-2005 18:16
Send private message

Also you are using Opera. I wonder if there's anything going between the browser and the server that cause a session to end?




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

freitasm
BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41030

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

#14823 18-May-2005 18:21
Send private message

taniwha: Maybe you should start adding features for subscribers only?
or collecting donations?
The problem is not the financial side.

Geekzone is quite a nice and rewarding work, that's why I decided to dedicate full time to it. As I posted in the blog before, I do Geekzone stuff after hours, but I am leaving my day job to work on this almost full time - with a couple of part-time contracts in between.

So, answering your comment - nope, no donations needed (thanks!), but a subscription service did cross my mind. I have decided to enhance Geekzone even more and try to keep it free though. Wait for some new features coming soon.




Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies 

 

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

 

taniwha

961 posts

Ultimate Geek

Trusted

#14824 18-May-2005 18:39
Send private message

another new product to anticipate :-)

i'm rather spoilt this month.

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.








RSS feeds
Main feed
Forums feed
Copyright
©2002-2026 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright