/admin_resync_forum_post_count.asp overflow
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30849
Printed Date: 30 March 2026 at 1:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: /admin_resync_forum_post_count.asp overflow
Posted By: MaximeRoy77
Subject: /admin_resync_forum_post_count.asp overflow
Date Posted: 06 October 2013 at 8:10pm
|
/admin_resync_forum_post_count.asp Microsoft OLE DB Provider for SQL Server error '80040e57'
Arithmetic overflow error for data type smallint, value = 33598. /forum/functions/functions_common.asp, line 1025
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 07 October 2013 at 2:44pm
|
This points to an error in your database in the tblForum table where one of the data types is set to 'smallint' when it should be 'int'. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: MaximeRoy77
Date Posted: 07 October 2013 at 2:51pm
|
Yes ! I upgraded to 10.16 this week-end and since the upgrade the SYNC POSTS COUNT give me that error. I can't change the DATATYPE to INT since there is some related index, constraints,... link to field. ;-(
|
Posted By: WebWiz-Bruce
Date Posted: 07 October 2013 at 3:58pm
|
Has the database at some point been upsized from Access? ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: MaximeRoy77
Date Posted: 07 October 2013 at 4:01pm
|
No. I have a lot of posts and members. Always been SQL SERVER from 9.69 to 10.16 upgrade this week-end
|
Posted By: WebWiz-Bruce
Date Posted: 08 October 2013 at 2:52pm
|
I asked this as there should not be any constraints which are often added when upsizing from Access and have to be manually removed after the upsize. If you have support I would suggest opening a support ticket on this issue so that an developer can remotely have a look at the database to fix the issue. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: MaximeRoy77
Date Posted: 08 October 2013 at 2:54pm
| OK thanks. |