Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - cint overflow error in get_last_post
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

cint overflow error in get_last_post

 Post Reply Post Reply
Author
mysavings.com View Drop Down
Newbie
Newbie


Joined: 24 January 2008
Status: Offline
Points: 30
Post Options Post Options   Thanks (0) Thanks(0)   Quote mysavings.com Quote  Post ReplyReply Direct Link To This Post Topic: cint overflow error in get_last_post
    Posted: 15 August 2008 at 7:13pm
I recently upgraded to WWF 9.5 from WWF 8.  And all of a sudden I started getting this error.
 
/forum/get_last_post.asp?TID=33156

COM Error #: -2146828282 (800A0006)

Category: Microsoft VBScript runtime

File: //www.mysavings.com/forum/get_last_post.asp

Line, Column: 62, -1

Description: Overflow: 'CInt'

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 15 August 2008 at 7:33pm
This error has been fixed for the next release 9.51 which will hopefully be released before the end of next week, once testing is complete.

If you want to fix this issue sooner, just replace CInt with CLng in the code in the file get_last_post.asp.


Edited by WebWiz-Bruce - 15 August 2008 at 7:37pm
Back to Top
mysavings.com View Drop Down
Newbie
Newbie


Joined: 24 January 2008
Status: Offline
Points: 30
Post Options Post Options   Thanks (0) Thanks(0)   Quote mysavings.com Quote  Post ReplyReply Direct Link To This Post Posted: 15 August 2008 at 7:40pm
Thanks, I just did that right after I posted and it worked.  Are there any other quick fixes that I may want to do?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 15 August 2008 at 8:02pm
Version 9.50 is pretty stable the only other bugs are coursed by the latest myODBC 3.51.27 driver for the mySQL version, but this being fixed in the next release.

Server side paging for SQL Server 2005/2008 and mySQL will also be improved massively in the next release, which will see big improvements for busy and large forums.

Will also be releasing a database upgrade tool for SQL Server and mySQL versions which will update some of the indexs which will see further improvements in performance.
Back to Top
greatdane View Drop Down
Newbie
Newbie


Joined: 28 August 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote greatdane Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2008 at 5:32pm
Seem to be having issues with web wiz 9.50 using mySQL with ODBC driver version 3.51.26. 
 
I am getting the error when update/edit a post:  
 
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.51b-community-nt]Build WHERE -> insert_fields() failed.

/forum/edit_post.asp, line 650

What mySQL driver is stable for web wix version 9.50.   Do I upgrade to 9.51? If so, which release of the mySQL 3.51.?? driver should I use. 
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2008 at 5:36pm
Currently 9.50 works with myODBC 3.51.23 or below.

However, Web Wiz Forums 9.51 will support both the latest myODBC 3.51 driver as well as myODBC 5.1.

Web Wiz Forums 9.51 is presently being tested on several large production forums on our networt running both SQL Server and mySQL and will be released tomorrow.
Back to Top
greatdane View Drop Down
Newbie
Newbie


Joined: 28 August 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote greatdane Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2008 at 5:48pm
Thank you very much.  I wait for the upgrade.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.