Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: CapriSkye on November 07, 2005, 03:33:54 AM

Title: Out of range value adjusted for column 'numTopics' at row 1
Post by: CapriSkye on November 07, 2005, 03:33:54 AM
I think this has to do with MySQL 5...
I've seen this post, but there are too many files to edit so I gave up.
http://www.simplemachines.org/community/index.php?topic=50865.0

This following error is not the same error as above topic.
Whenever I try to remove a board, or a category, I get the following error:

Out of range value adjusted for column 'numTopics' at row 1
File: D:\website\capriskye\forums\Sources\RemoveTopic.php
Line: 293


I've tried with everything I know but still can't get rid of that.
I also found couple places if somebody wants to read up about it.
http://www.openwin.org/mike/index.php/archives/2005/02/using-strict-mode-to-make-not-null-safe/
http://sourceforge.net/mailarchive/forum.php?thread_id=8881499&forum_id=31882
http://db4free.blogspot.com/2005/10/web-apps-ready-for-mysql-5.html
Title: Re: Out of range value adjusted for column 'numTopics' at row 1
Post by: Compuart on November 07, 2005, 12:57:57 PM
Try Admin -> 'Forum Maintenance' -> 'Recount all forum totals and statistics.'

I think that should solve the problem of not being able to delete boards and categories.
Title: Re: Out of range value adjusted for column 'numTopics' at row 1
Post by: CapriSkye on November 07, 2005, 01:06:02 PM
now i feel like an idiot...
thanks!! solved
Title: Re: Out of range value adjusted for column 'numTopics' at row 1
Post by: NavyGuy on November 28, 2005, 02:45:57 PM
Open up your MySQL configuration file and comment out the sql-mode line, it will disable the strict settings, which should make things work again :)