/admin_resync_forum_post_count.asp overflow

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
MaximeRoy77 Members Profile Find Members Posts Groupie Joined: 21 November 2010 Location: Québec, Canada Status: Offline Points: 54	Post Options Post Reply Quote MaximeRoy77 Report Post Thanks(0) Quote Reply Topic: /admin_resync_forum_post_count.asp overflow 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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'.
	Web Wiz Forums Hosting ASP.NET Web Hosting

MaximeRoy77 Members Profile Find Members Posts Groupie Joined: 21 November 2010 Location: Québec, Canada Status: Offline Points: 54	Post Options Post Reply Quote MaximeRoy77 Report Post Thanks(0) Quote Reply 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. ;-(

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 October 2013 at 3:58pm
	Has the database at some point been upsized from Access?
	Web Wiz Forums Hosting ASP.NET Web Hosting

MaximeRoy77 Members Profile Find Members Posts Groupie Joined: 21 November 2010 Location: Québec, Canada Status: Offline Points: 54	Post Options Post Reply Quote MaximeRoy77 Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

MaximeRoy77 Members Profile Find Members Posts Groupie Joined: 21 November 2010 Location: Québec, Canada Status: Offline Points: 54	Post Options Post Reply Quote MaximeRoy77 Report Post Thanks(0) Quote Reply Posted: 08 October 2013 at 2:54pm
	OK thanks.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.